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 |