COURSE CONTENT
_edited.jpg)
BASIC LEVEL COURSE CONTENT
1.Inroduction to Excel
2.Data Entry, Changes and Delete
3.Selecting and Navigating Data
4.Use of Fill Handle and View options
5.Formulas and It's Practical Use
6.Usage of Functions
7.Cell Reference Concept
8.Calculations across Multiple Sheets
9.Font Format and Border Styles
10.Format Painter & Alignment Tool
11.Number and Cell Format
12.Styles & Themes
13.Graphics
14.Find & Replace and Conditional Formatting
15.Filtering and Sorting
16.Print Preview & Page Layout Tools
_edited.jpg)
INTERMEDIATE LEVEL COURSE CONTENT
1.About Charts
2.Multiple Sheets & 3D Formulas
3.Linking Workbooks & Consolidate Tool
4.Combine Text & Text Case
5.Extracting Text & Find Function
6.Date Calculations
7.About Named Ranges
8.Editing & deleting Named Ranges
9.Count Functions
10..Sparkline & Trendline
11.Table & Table Tool Options
12.Automation with Tables
13.Sub Total & Convert to Range Options
ADVANCED LEVEL COURSE CONTENT
1.Pivot Tables
2.Pivot Tables Options
3.Pivot Charts & Slicers
4.Data Validation
5.Data Validation using Formulas
6.Advanced Conditional Formatting
7.Logical IF, AND & OR Functions
8.Error Handling Functions
9.Lookup Functions CHOOSE & V LOOKUP
10.Lookup Functions INDEX & MATCH
11.How to Record Macro
12.How to Run Macro
