top of page

Suggested agenda for a 15-session Microsoft Excel training program. This program covers basic, intermediate, and advanced Excel skills over one-hour sessions.

​

Session 1-3: Basic Excel Skills (3 hours)

  • Session 1: Introduction to Excel

    • Overview of Excel interface

    • Navigating worksheets and cells

    • Entering and formatting data

  • Session 2: Basic Formulas and Functions

    • Understanding cell references

    • Introduction to basic formulas (SUM, AVERAGE, COUNT)

    • AutoFill feature

  • Session 3: Data Management in Excel

    • Sorting and filtering data

    • Data validation and drop-down lists

    • Introduction to tables and conditional formatting

​

Session 4-7: Intermediate Excel Skills (4 hours)

  • Session 4: Advanced Formulas and Functions

    • Logical functions (IF, AND, OR)

    • Lookup functions (VLOOKUP, HLOOKUP, INDEX-MATCH)

  • Session 5: Data Analysis Tools

    • Pivot tables: Creating and customizing

    • Pivot charts: Visualizing data

    • Introduction to Power Query for data import and transformation

  • Session 6: Working with Templates and Data Visualization

    • Creating and using templates

    • Introduction to advanced chart types (combo charts, sparklines)

    • Chart customization and best practices

  • Session 7: Collaboration and Sharing

    • Protecting worksheets and workbooks

    • Comments and collaboration tools

    • Sharing workbooks and setting permissions

​

Session 8-12: Advanced Excel Skills (5 hours)

  • Session 8: Advanced Data Analysis Tools

    • Advanced PivotTable techniques (slicers, calculated fields/items)

    • Introduction to Power Pivot for data modeling

  • Session 9: Advanced Data Analysis Techniques

    • Statistical functions (AVERAGEIF, COUNTIF, etc.)

    • Advanced filtering options

  • Session 10: Advanced Data Modeling with Power Query

    • Merging queries and data sources

    • Transformations and data cleansing techniques

  • Session 11: Advanced Functions and Formulas

    • Array formulas and functions

    • Text functions and data cleansing techniques

  • Session 12: Excel Efficiency Tips and Tricks

    • Keyboard shortcuts for efficiency

    • Useful tips for working faster in Excel

    • Review and Q&A session

​

  • Session 13-15: Practical Applications and Advanced Topics (3 hours)

  • Session 13: Data Visualization and Dashboards

    • Creating interactive dashboards

    • Advanced chart interactivity

    • Using slicers and timelines

  • Session 14: Data Analysis in Excel

    • Advanced data analysis techniques

    • Sensitivity analysis and scenario manager

    • Forecasting and trend analysis

  • Session 15: Excel in Business

    • Financial modeling in Excel

    • Integrating Excel with other Microsoft Office applications

    • Best practices for data analysis and reporting in business contexts

​

Note: The content and pace will be customized based on your exact needs and expertise levels. Practical exercises and real-world examples will enhance the learning experience.

Microsoft Excel

  • LinkedIn
bottom of page