1. Advanced Formulas and Functions

• Logical Functions: IF, AND, OR, XOR
• Lookup & Reference Functions: VLOOKUP, HLOOKUP, INDEX, MATCH, XLOOKUP, OFFSET
• Text Functions: CONCATENATE, TEXT, LEFT, RIGHT, MID, FIND, REPLACE
• Date and Time Functions: DATE, DATEDIF, NETWORKDAYS, YEARFRAC
• Array Functions: SUMPRODUCT, TRANSPOSE

2. Data Analysis and Pivot Tables

• Creating and modifying PivotTables to summarize large datasets.
• PivotChart creation.
• Grouping data in PivotTables.
• Slicers and Filters for better data visualization.

3. Data Visualization

• Advanced charting: Combo charts, Sparklines, Waterfall charts, and Trendlines.
• Conditional formatting for dynamic data representation.
• Using Power View and Power Map for advanced visualizations.

4. Data Validation and Protection

• Data validation rules: Dropdowns, restricting data entry, etc.
• Protecting worksheets and workbooks with passwords.
• Tracking changes and using comments.

5. Advanced Data Tools

• Using Power Query for importing, transforming, and cleaning data from multiple sources.
• Power Pivot for working with large datasets and creating Data Models.
• Working with What-If Analysis tools: Goal Seek, Solver, and Scenario Manager.

6. Macros and VBA (Visual Basic for Applications)

• Introduction to recording and editing macros.
• Basic VBA programming: creating custom functions, loops, and automation scripts.
• Writing simple VBA codes for task automation.

7. Advanced Charting and Graphs

• Creating interactive charts.
• Customizing charts with advanced options like trendlines, secondary axes, and error bars.
• Creating dashboards using charts and tables.

8. Data Consolidation and Cross-Sheet References

• Consolidating data from multiple sheets and workbooks.
• Using advanced techniques for referencing data across different sheets.

9. Advanced Filtering and Sorting

• Applying complex filters: Advanced Filter, Custom Filter, and Filter by color.
• Sorting data based on multiple criteria and custom order.

10. Financial and Statistical Analysis

• Working with financial functions: NPV, IRR, PMT, FV, etc.
• Statistical analysis using functions like AVERAGEIFS, COUNTIFS, and standard deviation.
• Forecasting and regression analysis.

11. Collaborating and Sharing Workbooks

• Sharing and collaborating in real-time using Excel Online.
• Tracking and comparing changes.
• Using comments and notes effectively.