Intermediate Microsoft Excel

1. Advanced Formulas and Functions

• Nested Functions

• Lookup Functions: VLOOKUP, HLOOKUP, INDEX, MATCH

• Logical Functions: IF, AND, OR

• Text Functions: CONCATENATE, TEXTJOIN, MID, LEFT, RIGHT

• Date and Time Functions: DATE, DATEDIF, NETWORKDAYS

2. Data Management Techniques

• Sorting and Filtering Data

• Using Tables for Data Organization

• Data Validation Techniques

• Conditional Formatting

3. Charts and Visualizations

• Creating Different Types of Charts

• Customizing Chart Elements

• Using Sparklines for Data Visualization

• Dynamic Charts with Named Ranges

4. PivotTables and PivotCharts

• Creating PivotTables

• Using Slicers for Filtering

• Analyzing Data with PivotCharts

• Grouping Data in PivotTables

5. Advanced Data Analysis Tools

• Using What-If Analysis: Goal Seek, Data Tables

• Scenario Manager

• Solver Add-in for Optimization Problems

6. Collaboration and Sharing

• Sharing Workbooks

• Tracking Changes and Comments

• Protecting Worksheets and Workbooks

• Using Excel Online for Collaboration