Excel Course Contents:
1) One Day Training
Excel Quick Overview
Protection of workbook and worksheets
Auto fill, Custom lists, and Create series
Data linking
Formula and functions
Date
Referencing
Lookup
Pivot Table
Chart
Text functions
Keyboard shortcuts
Paste special
2) Two Days Training
Protection of workbook and worksheets
Auto fill, Custom lists, and Create series
Data linking
Formula and functions
Date
Referencing
Lookup
Pivot Table
Chart
Text functions
Keyboard shortcuts
Paste special
Sort and filter
Advance sort and filter
Conditional formatting
Drop down and validation
Logical functions
Financial functions
Depreciation
Macro introduction
3) VBA & Macro
Create & Record Macro
Macro Security
Visual Basic Editor
Macro Comments
Macro Errors
Debug Macros
Objects, Properties and Methods
Workbook and Worksheets
Application Object
Variables
String Manipulation
Two Days Workshop – Second Day Topics
Calculations
If-Then Statement
Cells
Loop
Logical Operators
Range and Events
Array
Function and Sub
Text Box, List Box, Combo Box
Check Box, Message Box
4) Excel Dashboard
Dynamic Dashboard with Pivot Table
Pivot Table Reports
Charts
Slicers
Chart connections
Dynamic Dashboard with Power Query
Power Pivot
Calculated Fields
Data Modal
Relationship
DAX formulas
Chart
Slicer
Chart connections
