1.
Creating
a Microsoft Excel Workbook
1.1.
Starting
Microsoft Excel
1.2.
Creating
a Workbook
1.3.
Saving
a Workbook
1.4.
The
Status Bar
1.5.
Adding
and Deleting Worksheets
1.6.
Closing
a Workbook
2.
The
Ribbon
2.1.
Tabs
2.2.
Groups
2.3.
Commands
3.
The
Backstage View (The File Menu)
3.1.
Introduction
to the Backstage View
3.2.
Opening
a Workbook
3.3.
New
Workbooks and Excel Templates
3.4.
Printing
Worksheets
3.5.
Getting
Help
3.6.
Adding
Your Name to Microsoft Excel
4.
The
Quick Access Toolbar
4.1.
Adding
Common Commands
4.2.
Adding
Additional Commands with the Customize Dialog Box
4.3.
Adding
Ribbon Commands or Groups
4.4.
Placement
5.
Entering
Data in Microsoft Excel Worksheets
5.1.
Entering
Text
5.2.
Using
AutoComplete
5.3.
Entering
Numbers and Dates
5.4.
Using
the Fill Handle
6.
Formatting
Microsoft Excel Worksheets
6.1.
Selecting
Ranges of Cells
6.2.
The
Font Group
6.3.
The
Alignment Group
6.4.
The
Number Group
7.
Using
Formulas in Microsoft Excel
7.1.
Math
Operators and the Order of Operations
7.2.
Entering
Formulas
7.3.
AutoSum
(and Other Common Auto-Formulas)
7.4.
Copying
Formulas and Functions
7.5.
Relative
and Absolute Cell References
8.
Working
with Rows and Columns
8.1.
Inserting
Rows and Columns
8.2.
Deleting
Rows and Columns
8.3.
Setting
Row Height and Column Width
8.4.
Hiding
and Unhiding Rows and Columns
8.5.
Freezing
Panes
9.
Editing
Worksheets
9.1.
Find
9.2.
Find
and Replace
9.3.
Using
the Clipboard
10.
Finalizing
Microsoft Excel Worksheets
10.1.
Setting
Margins
10.2.
Setting
Page Orientation
10.3.
Setting
the Print Area
10.4.
Print
Scaling (Fit Sheet on One Page)
10.5.
Headers
and Footers
11.
Microsoft
Excel 2013 New Features
11.1.
One
Workbook per Window Feature
11.2.
Using
Flash Fill
