Microsoft Excel Masterclass - Beginner to Advanced Level
| Course Modules |
| Day-1: Overview of the Course |
| MODULE 1 |
| 1.1 Introduction |
| 1.2 Overview |
| MODULE 2 |
| 2.1 Combine what you can enter in a cell |
| 2.2 Relative and Absolute Cell Referencing |
| 2.3 Entering Formula |
| 2.4 Order of Operations |
| 2.5 Date Serial Numbers |
| MODULE 3 |
| 3.1 Copy and Drag |
| 3.2 Working with rows and columns |
| 3.3 Working with sheets |
| Day-2: Functions and Formatting Technique |
| MODULE 4 |
| 4.1 Functions |
| 4.2 SUM Function |
| 4.3 Copy and Drag Formula |
| 4.4 More Basic Functions |
| 4.5 Named Ranges |
| 4.6 Names Constants and Formula |
| 4.7 Shortcuts |
| 4.8 More Shortcuts |
| MODULE 5 |
| 5.1 Formatting Font |
| 5.2 Formatting Alignment |
| 5.3 Formatting Borders |
| 5.4 Formatting Numbers |
| 5.5 Conditional Formatting Pre-Configured |
| 5.6 Conditional Formatting with Formula |
| 5.7 Conditional Formatting Dialogue Box Formula Trick |
| MODULE 6 |
| 6.1 Icons Shapes and Formatting |
| 6.2 Printing Page Layout |
| 6.3 Printing Headers Footers |
| Day-3:Data Analysis Technique |
| MODULE 7 |
| 7.1 Data Sort |
| 7.2 Filtering |
| 7.3 Tables |
| 7.4 Text to Columns |
| 7.5 Flash Fill |
| 7.6 Data Validation |
| 7.7 Group and Outline |
| 7.8 Freeze Panes |
| MODULE 8 |
| 8.1 Relative and Absolute Referencing |
| 8.2 VLOOKUP |
| 8.3 Index Match |
| 8.4 IF |
| 8.5 Nested If |
| 8.6 Countif Countifs |
| 8.7 SUMIF SUMIFS |
| 8.8 LEN |
| 8.9 RIGHT LEFT MID |
| 8.10 SEARCH |
| 8.11 Common Error Types |
| 8.12 IFERROR |
| Day-4: Data Visualization through Charts |
| MODULE 9 |
| 9.1 Chart Basics |
| 9.2 Chart Series and Column Charts |
| 9.3 Bar Charts |
| 9.4 Pie Charts |
| 9.5 Composite Charts |
| 9.6 Waterfall Charts |
| 9.5 Charts Management |
| 4.8 Practical case analysis |
| MODULE 10 |
| 10.1 Pivot Tables |
| 10.2 Setting up a Pivot Table |
| 10.3 Pivot Table Field Settings |
| 10.4 Pivot Table Calculated Fields |
| 10.5 Pivot Table Groupings |
| 10.6 Pivot Table Slicers and Timelines |
| 10.7 Dashboards |
| Day-5: Macro and VBA |
| MODULE 11 |
| 11.1 What is a macro? |
| 11.2 Recording a Macro |
| 11.3 Practical case analysis |
| MODULE 12 |
| 12.1 Introduction to VBE |
| 12.2 Object Model |
| 12.3 Module Worksheets Classes |
| 12.4 Variables and Constants |
| DIM |
| SUB |
| END WITH |
| 12.8 Practical case analysis |
