In this course you will learn how to: format text and cells, align cell contents, use Find and Select tools, and apply conditional formatting.

Customize general, language, formula, proofing, and saving options Use Excel's version control features Customize the ribbon and the Quick Access toolbar Customize the functionality of Excel by enabling add-ins Customize advanced and Trust Center options

Tracing cells Error checking Evaluating formulas and using the Watch Window Data List Outlines

Use text functions Use logical functions Use lookup functions Use date functions Use financial functions

Format worksheet tabs Manage worksheets Manage the view of worksheets and workbooks

Create and format tables Modify tables Use table references

How to access and use Excel Online Features that differ between Excel Online and the Excel desktop application

Define the basic page layout for a workbook Refine the page layout and apply print options

Use the Quick Analysis tool Add sparklines Perform What-If analysis Load and use the Analysis ToolPak