MS Excel Course Content
Course Duration
- 60 Hours
- 5 sessions/week
Tools Covered
- MS Excel
Learning Mode
- Online Live Classes
- One on one Interactive session
We provide
- Special sessions for doubt solving
- Sessions recordings (on request)
- Sessions documents (on request)Â
- Assignments Mock interview
- Live Projects
Full Course Syllabus
1.About MS Excel
- Workbook window
- Create & Open Workbooks
- Office button
- Ribbons & Tabs
- Features of tabs
- Quick Access Toolbar
- Mini Toolbar
- Title, Help, Zoom, View
3.Excel Calculations
- Addition
- Sigma Addition
- Substraction
- Calculate Average
- Sigma Average
5.Excel Formula
- Create Formula
- Fill handle in formula
- Relative references
- Absokute references
- Instruction for typing
- Quick excel functions
7.Advanced Excel
- Macros
- sumif
- vlookup
- Pivot table
- ISNA
- Find & Remove Duplicates
- Create Drop Down List
- Merge cells in excel
2. Excel Worksheet
- Worksheet, Row, Column
- Moving on Worksheet
- Enter Data
- Select Data
- Delete Data
- Move Data
- Copy Paste Data
- Spell Check
- Insert Symbols
4.Excel Fill Handle
- Fill Handle
- Fill Handle with text
- Text with numbers
- Â Fill handle with dates
6.Excel IF
- If Function
- If with calculations
- Excel COUNTIF
- Advance If