Excel - Excel Essentials and Formulas

Getting Started with Excel

• Navigate the Excel User Interface
• Use Excel Commands
• Create and Save a Basic Workbook
• Enter and Edit Cell Data
• Fill Cells with Series of Data (AutoFill and Flash Fill)
• Use Excel Help

Performing Calculations

• Create Worksheet Formulas
• Insert Functions and use Autocomplete
• Reuse Formulas and Functions
• Create an Absolute Reference

Modifying a Worksheet

• Insert, Delete, and Adjust Cells, Columns, and Rows
• Move and Copy Data between Cells
• Search for and Replace Data
• Use Spellcheck and Proofing

Formatting a Worksheet

• Apply Text Formats
• Apply Number Formats
• Align Cell Contents
• Apply and Copy Cell Styles
• Apply Basic Conditional Formatting

Printing Workbooks

• Preview and Print a Workbook
• Controlling Page Layout
• Adding Headers and Footers
• Set Print Titles and Print Ranges

Managing Workbooks

• Manage Worksheets
• Insert and Delete Worksheets
• Manage Workbook and Worksheet Views
• Manage Workbook Properties