Creating a Microsoft Excel Workbook
o Starting Microsoft Excel
o Creating a Workbook
o Saving a Workbook
o The Status Bar
o Adding and Deleting Worksheets
o Copying and Moving Worksheets
o Changing the Order of Worksheets
o Splitting the Worksheet Window
o Closing a Workbook
The Ribbon
o Tabs
o Groups
o Commands
The Backstage View (The File Menu)
o Introduction to the Backstage View
o Opening a Workbook
o New Workbooks and Excel Templates
o Printing Worksheets
o Adding Your Name to Microsoft Excel
o Managing Workbook Versions
The Quick Access Toolbar
o Adding Common Commands
o Adding Additional Commands with the Customize Dialog Box
o Adding Ribbon Commands or Groups
o Placement
Entering Data in Microsoft Excel Worksheets
o Entering Text
o Expand Data across Columns
o Adding and Deleting Cells
o Adding an Outline
o Adding a Hyperlink
o Add WordArt to a Worksheet
o Using AutoComplete
o Entering Numbers and Dates
o Using the Fill Handle
Formatting Microsoft Excel Worksheets
o Selecting Ranges of Cells
o Hiding Worksheets
o Adding Color to Worksheet Tabs
o Adding Themes to Workbooks
o Adding a Watermark
o The Font Group
o The Alignment Group
o The Number Group
Using Formulas in Microsoft Excel
o Math Operators and the Order of Operations
o Entering Formulas
o AutoSum (and Other Common Auto-Formulas)
o Copying Formulas and Functions
o Relative, Absolute, and Mixed Cell References
Working with Rows and Columns
o Inserting Rows and Columns
o Deleting Rows and Columns
o Transposing Rows and Columns
o Setting Row Height and Column Width
o Hiding and Unhiding Rows and Columns
o Freezing Panes
Editing Worksheets
o Find
o Find and Replace
o Using the Clipboard
o Managing Comments
Finalizing Microsoft Excel Worksheets
o Setting Margins
o Setting Page Orientation
o Setting the Print Area
o Print Scaling (Fit Sheet on One Page)
o Printing Headings on Each Page/Repeating Headers and Footers
o Headers and Footers
Microsoft Excel 2013 New Features
o One Workbook Per Window Feature
o Using Flash Fill
