Microsoft Excel Training

Master Excel from basic spreadsheets to advanced data analysis and automation

Level 1

Basic Excel

Perfect for beginners or those needing a refresher on Excel fundamentals. Learn the essential skills to create, format, and manage spreadsheets effectively.

Getting Started

  • Understanding the Excel interface and ribbon
  • Creating and saving workbooks
  • Navigating worksheets and cells
  • Entering and editing data
  • Using AutoFill and Flash Fill

Formatting & Organization

  • Cell formatting (fonts, colors, borders)
  • Number formatting (currency, dates, percentages)
  • Column and row adjustments
  • Merging cells and text alignment
  • Using styles and themes

Basic Formulas

  • Understanding cell references
  • Basic arithmetic operations
  • SUM, AVERAGE, COUNT functions
  • MIN and MAX functions
  • Copying formulas and relative references

Printing & Sharing

  • Page setup and print preview
  • Setting print areas
  • Headers and footers
  • Saving as PDF
  • Basic chart creation
Level 2

Intermediate Excel

Build on your Excel foundation with advanced formulas, data analysis tools, and professional spreadsheet management techniques.

Advanced Formulas

  • IF, AND, OR logical functions
  • VLOOKUP and HLOOKUP
  • SUMIF, COUNTIF, AVERAGEIF
  • Text functions (CONCATENATE, LEFT, RIGHT, MID)
  • Date and time functions
  • Absolute and mixed cell references

Data Management

  • Sorting and filtering data
  • Advanced filtering techniques
  • Data validation and drop-down lists
  • Removing duplicates
  • Text to columns
  • Conditional formatting

Tables & PivotTables

  • Creating and formatting Excel tables
  • Table formulas and structured references
  • Introduction to PivotTables
  • Grouping and summarizing data
  • PivotTable calculations
  • PivotCharts

Charts & Visualization

  • Advanced chart types
  • Customizing chart elements
  • Combination charts
  • Sparklines
  • Data bars and icon sets
  • Chart templates
Level 3

Advanced Excel

Master Excel's most powerful features including advanced data analysis, automation with macros, and complex formula techniques for professional-level spreadsheet management.

Power Functions

  • INDEX and MATCH functions
  • XLOOKUP (Excel 365)
  • Array formulas and dynamic arrays
  • SUMIFS, COUNTIFS, AVERAGEIFS
  • Nested IF statements and IFS function
  • INDIRECT and OFFSET functions

Data Analysis Tools

  • What-If Analysis (Goal Seek, Scenario Manager)
  • Data Tables for sensitivity analysis
  • Solver for optimization
  • Power Query for data transformation
  • Power Pivot for data modeling
  • Statistical analysis functions

Macros & Automation

  • Recording and running macros
  • Editing macros in VBA
  • Creating custom functions
  • Form controls and ActiveX controls
  • Automating repetitive tasks
  • Macro security and best practices

Advanced Features

  • Workbook protection and security
  • Linking workbooks and consolidation
  • Advanced PivotTable techniques
  • Slicers and timelines
  • Custom number formats
  • Collaboration and sharing features

Ready to Master Excel?

Contact us today to discuss your Excel training needs and get a customized quote

Request a QuoteContact Us
Talk with Us