Training Course on Intermediate Excel

Course Outline

Module 1: Advanced Formulas and Functions

• Nested functions and complex formulas
• Lookup functions (VLOOKUP, HLOOKUP, INDEX, MATCH)
• Logical functions (IF, AND, OR, NOT)
• Text functions and data manipulation
• Date and time functions
• Mathematical and statistical functions

Module 2: Data Consolidation and Management

• Consolidating data from multiple worksheets
• Linking worksheets and workbooks
• Importing and exporting data
• Data validation and error checking
• Sorting and filtering advanced techniques

Module 3: Charts and Visualization

• Creating advanced charts and graphs
• Customizing chart elements and formatting
• Combination charts and trend analysis
• Dynamic charts and interactive dashboards
• Sparklines and data visualization techniques

Module 4: What-If Analysis Tools

• Goal Seek for finding target values
• Solver for optimization problems
• Scenario Manager for multiple scenarios
• Data Tables for sensitivity analysis
• Forecasting and trend analysis

Module 5: Macros and VBA Automation

• Recording and editing macros
• Introduction to VBA programming
• Creating custom functions and procedures
• Automating repetitive tasks
• User forms and interactive interfaces

Module 6: PivotTables and Power Pivots

• Creating and customizing PivotTables
• Power Pivot and data modeling
• DAX formulas and calculated fields
• Advanced PivotTable techniques
• Interactive dashboards with slicers

More Details

Additional course-related details and resources will be provided here.