- Instructor: proipastudies
In this modern era, where everything is getting digital. People must become digital with this basic computer course IPA studies is providing a basic start to the career of the modern world.
The computer has no limitations at this time, but to explore your area of interest you have to go through the basic course and calculate what exactly you have to work on and get more skilled. Also, we provide an Advance Excel course along with a Basic course that includes 200+ formulas and MIS reporting by which you can easily earn a handsome salary and make your career brighter.
In this basic course, you will learn Hardware, Software, Internet Applications, MS Paint, MS Excel, MS Word, MS PowerPoint, Advance Excel, and MIS Reporting.
This course will help you develop your skills and ability to work in many departments. IPA studies have been offering the Best Computer Courses to make your career.
MODULE : BASIC COMPUTER
- Introduction to computer: Types of Computer, Basic Computer Hardware & Software, Operating System, Trouble Shooting, Internet & Its Applications.
- MS Paint: Clipboard, Images Editing, Tools, Shapes, View tab
- MS Word: Formatting Text, Editing Images, Shapes & Charts, Hyperlink,
- Print and set-up, Watermark, Insert, Smart Art, Charts, Design
- MS Power point: Design, Transitions, Animation, Slide Show, Review Tab, Automatic PPT creation, PPT Enhancement Tools.
- MS Excel: Basic Excel Interface, Excel Cell, Name Range, Basic Formulae like SUM, AVERAGE, MAX, MIN, COUNT, Insert Formulae, Syntax, Charts
MODULE : ADVANCE EXCEL
- Basic Formulae like SUM, AVERAGE, MAX, MIN, COUNT, +,-, *, /, Custom &
- Conditional Formatting, Data Validation, Advance Formulae like
- Text Formulae: LEFT, RIGHT, MID, FIND, SEARCH, LEN, UPPER, LOWER, PROPER, REPLACE, SUBSITUTE, REPT, CONVERT, TRIM, TRUNC, CONCATENATE.
- Logical Formulae:IF, Nested IF, AND, OR, XOR, TRUE/FALSE.
- Date & Time Formulae: DATE, DAY, SECOND, MINUTE, HOUR, MONTH, YEAR, NOW, TODAY (), NETWORKDAY, NETWORKDAY.INTL
- Information Formulae: INFO, CELL, ERROR, TYPE, ISBLANK, ISERR, ISERROR, ISEVEN, ISODD, ISTEXT, ISNUMBER, ISNONTEXT, TYPE.
- Financial Function, Lookup formulas, References