Contents
- Exporting & Importing Data
- Creating Charts & Customization
- Advanced Charting
- Working with Advanced Filters & Sorting
- Conditional Formatting
- Data Validation & Subtotal
- Consolidation Worksheets
- Auditing Tools, Tracking & Reviews
- Working with Tables
- Creating Pivot Table, Charts, Slicing
- Database Functions
- Advanced IF Functions
- Lookup Functions
- What IF Analysis with One, Two Variable Data Tables
- What IF Analysis with Scenario and Goal Seeking
- Sharing Workbooks, Protecting Worksheets and Level of Security using Recording & Editing Macro
- Practical Interactive with VBA Macro Programming
Orientation
Entry Requirements
Those who are interested in having an in-depth knowledge in Microsoft® Excel®.
Duration
1 Month
Medium
English / Sinhala
