Getting Started
Learn the Excel workspace, enter and edit data, create formulas, and save a workbook.
Microsoft Office Training
Microsoft Excel Lessons
Build spreadsheets, formulas, charts, and practical business workbooks.
Four-part learning path
Begin with Excel fundamentals, develop formula skills, analyze data, and finish by creating effective charts.
Advertisement
Excel Learning Path
Choose a Module
Work through the modules in order or open the lesson that matches the skill you need today.
1
Module 1
Getting Started
Build a strong foundation by learning the Excel workspace, worksheet formatting, moving and copying, and working with multiple worksheets.
Formatting
Format numbers, text, alignment, borders, fills, and worksheet cells for clarity and professionalism.
Moving and Copying
Move and copy data and formulas, use the fill handle, and understand how copied references change.
Multiple Worksheets
Insert, rename, copy, group, and link worksheets with cross-sheet and three-dimensional formulas.
2
Module 2
Formulas
Develop practical formula skills with common functions, references, logical tests, advanced functions, and financial calculations.
Basic Functions
Use SUM, AVERAGE, MAX, and MIN and navigate efficiently with the Name Box and Go To.
Absolute References
Keep selected cells, rows, or columns fixed when formulas are copied by using absolute and mixed references.
IF Functions
Create IF and nested IF formulas that return different results when logical conditions are true or false.
Beyond Basic Functions
Use PMT, VLOOKUP, SUMIF, named ranges, and related formulas in practical business worksheets.
Loan Amortization
Calculate a loan payment and build a complete amortization schedule with Excel formulas and the PMT function.
3
Module 3
Data Analysis
Organize, summarize, explore, and protect worksheet data with filters, subtotals, PivotTables, Goal Seek, and other helpful features.
Filtering
Prepare and sort Excel data so records can be viewed and analyzed by selected criteria.
Subtotals
Create automatic group totals and counts, use outline levels, and remove subtotal calculations.
Pivot Tables
Create PivotTables, arrange fields, change summary calculations, format values, and filter with slicers.
Goal Seek
Use Goal Seek and the FV function to determine the input required to reach a financial target.
Helpful Features
Use outlines, notes, worksheet protection, data validation, Freeze Panes, and Paste Special Transpose.
4
Module 4
Charts
Turn worksheet values into clear visual reports and then enhance those charts with advanced series, annotations, combo charts, and sparklines.
Creating Graphs
Create and modify column, line, stacked-column, and pie charts, and add labels and trendlines.
Beyond Basic Charts
Add data series, build combo charts, use a secondary axis, annotate charts, add images, and create sparklines.
Additional Excel Resource
Printing and Page Setup
The printing lesson remains available as a supplemental topic while the four core modules focus on the learning path above.
Printing and Page Setup Features
Prepare worksheets for printing with page layout, print areas, titles, headers, footers, and related controls.
Advertisement