Learn the basics of creating Excel spreadsheets: entering and editing data, navigating aworksheet, adjusting column width and row height, formatting cells, creating formulas and common functions, organizing large amounts of data, creating basic charts, adding headers and footers, and more. Learn keyboard shortcuts for basic techniques.

Learn intermediate-level Excel techniques, including sorting and filtering data, using conditional formatting, creating custom lists, working with multiple worksheets, creating subtotals, and more. Also learn useful functions to modify text, to make decisions withthe IF function, and to lookup data with VLOOKUP and HLOOKUP functions.

Learn how to organize data in Excel with tables: create data validation rules for consistent and proper data entry, use simple and multiple sorts, create custom sorts,and use simple and advanced filters to find subsets of data. Also, learn how to use the three What-If Analysis tools: scenarios, data tables, and Goal Seek. These features allow users to see how using different numbers will affect their results.

Learn how to use PivotTables, the powerful and popular Excel tool used to summarize data from an existing worksheet, and to create PivotCharts from PivotTables. Work with the important tools needed to create and enhance both.