Course outline

    1. Advanced Lookup Functions: INDEX and MATCH

    2. Array Formulas and Dynamic Arrays

    3. Logical Functions: IF, AND, OR, and XOR

    4. Error Handling: IFERROR and IS Functions

    5. Financial Functions: NPV, IRR, and PMT

    1. Advanced PivotTables: Slicers and Calculated Fields

    2. Power Query for Data Transformation

    3. Data Analysis ToolPak: Regression and ANOVA

    4. Descriptive Statistics and Frequency Distributions

    5. Forecasting and Trend Analysis

    1. Customizing and Combining Chart Types

    2. Interactive Charts with Form Controls

    3. Heat Maps and Geospatial Data Visualization

    4. Advanced Dashboard Techniques

    5. Power BI Integration and Reporting

    1. Introduction to VBA Programming

    2. Creating and Editing Macros

    3. User-Defined Functions (UDFs)

    4. Automating Tasks with Excel Add-Ins

    5. Excel Performance and Optimization Techniques

    1. Advanced Workbook Protection

    2. Excel Collaboration Best Practices

    3. Data Privacy and Compliance

    4. Integration with Microsoft 365 Suite

    5. Course Review and Final Assessment

About this course

  • Free
  • 25 lessons
  • 0 hours of video content

Discover your potential, starting today