Coverage -
Topics that I can cover would include
Basics -
1. Data Modelling for Business Cases
2. Understanding the 4 Parts of Excel Cells
3. Formatting The Cell from the old way to the new way
4. Use of the Table Object and the advantage / limitation
5. Data Validation
6. Named Ranges
7. Working with Data - Custom / Advanced Sorting, Grouping, Advanced Filtering
8. Working with Visual Objects like Shapes, Smart Art, Icons - Dynamically
9. Working with Form Controls
Shaping Data -
1. Working with Formulas, and debugging Complex Formulas
2. Arrays in Excel and how they are now referenced
3. Logical Formulas - And, Or, Not, Let, Lambda and more
4. Conditional Formulas - If, Ifs, Iferror, Switch and more
5. Lookup Formulas - VLookup, HLookup, Lookup, Index, Match, Indirect, Choose, Offset, XLookup and more
6. Power Formulas - D-Formulas, Sumif, Countif, Sumifs, Countifs and more
7. Old Array Formulas (Ctrl + Shift + Enter) - Trend, Growth, Transpose, Multiplying Arrays, Adding Arrays
8. New Array Formulas - Unique, Filter, HStack, VStack, and more
9. Text Formulas New and Old -
10. Math Formulas -
11. Financial Formulas -
Visualizing Data
A. Pivot Tables - Advanced Pivot Tables
1. The Parts of the Pivot Table and Formatting them and Reporting, in-depth
2. How to make the Pivot Table meaningful
3. Slicers and Timelines
4. Types of Grouping in Pivot Tables
5. Calculated Fields and Calculated Items
6. Pivot Charts and how to use them for quick analysis
B. Charts - Old and New Charts
1. The Charting Engine, types of Charts and situations for using specific types
2. Elements of Charts in Depth
3. Dynamic Data in Charts
4. How not to use Charts
Decision Making
1. Goal Seek
2. Scenario Manager
3. Solver
Macros in Excel
1. Basics of How to create them and execute them
2. Referencing Types
3. The code behind the Macro
4. Understand the Interface of the VBA Engine
5. Basic VBA -
a. Modules
b. Sub-Routines and Functions
c. Ranges and other Objects
d. Data Types
e. Variables
f. Input and Output
g. Arrays
h. Conditional Statements and Loops
Working with External Data
1. Importing and Connecting Data with Multiple Sources
2. Power Query and cleaning / shaping Data
3. Power Pivot & DAX for Reporting
Methodology after choosing what you want to learn -
1. I will teach one student at a time only. If it is a 1 Hour training, that student will be my only student for that hour.
2. I teach by giving example files to work with along with me (hands-on only).
3. For each concept, I will give some assignment to learn the concept better or the student could choose some task from their work-place. The time it takes them to complete that, is not counted in my class hours.
4. During the next session, I will check what they have done or are stuck with and help them through it. That way you pay only for me teaching you (100% attention) and only when I am with you while learning.