Getting started with Excel. Introducing Excel ; Entering and editing worksheet data ; Essential worksheet operations ; Working with cells and ranges ; Introducing tables ; Worksheet formatting ; Understanding Excel files ; Using and creating templates ; Printing your work
Working with formulas and functions. Introducing formulas and functions ; Creating formulas that manipulate text ; Working with dates and times ; Creating formulas that count and sum ; Creating formulas that look up values ; Creating formulas for financial applications ; Miscellaneous calculations ; Introducing array formulas ; Performing magic with array formulas
Creating charts and graphics. Getting started making charts ; Learning advanced charting ; Visualizing data using conditional formatting ; Creating sparkline graphics ; Enhancing your work with pictures and drawings
Using advanced Excel features. Customizing the Excel user interface ; Using custom number formulas ; Using data validation ; Creating and using worksheet outlines ; Linking and consolidating worksheets ; Excel and the Internet ; Protecting your work ; Making your worksheets error free
Analyzing data with Excel. Importing and cleaning data ; Introducing pivot tables ; Analyzing data with pivot tables ; Performing spreadsheet what-if analysis ; Analyzing data using goal seeking and solver ; Analyzing data with the analysis toolpak
Programming Excel with VBA. Introducing visual basic for applications ; Creating custom worksheet functions ; Creating userforms ; Using userform controls in a worksheet ; Working with Excel events ; VBA examples ; Creating custom Excel add-ins.