1: Excel Essentials
Starting Excel 2016
What is a Worksheet?
What is a Workbook?
Identifying Parts of the Screen
Identifying the ribbon Components
Getting Help
Using Selection Techniques
Selecting a Range of Cells
Selecting Nonadjacent Cells and Ranges
Selecting an Entire Worksheet
Entering Data
Entering Text Data into a Cell
Entering Values
Entering Data into a Range
Quickly Adjusting a Column Width
Finishing a Workbook
Saving a Named Workbook
Saving the Workbook in HTML Format
Printing a Worksheet
Closing a Workbook and Exiting from Excel
2: Formatting Text & Printing a Document
Opening a Workbook
Creating a New Workbook
Opening a Recently Used Workbook
Creating Simple Formulas
Creating a Formula by Pointing
Using Functions
Using the AutoSum Button
Using the Formula Palette
Editing Data on the Worksheet
Editing the Data in a Cell
Editing a Formula
Clearing the Contents from a Cell or Range
Using Undo and Redo
3: Managing the Worksheet
Navigating in a Worksheet
Using the Scroll Bars and Boxes
Changing Worksheets
Using Go To
Changing the Worksheet Structure
Deleting Cells, Rows, and Columns
Performing a Simple Sort
Creating and Using Named Ranges
Automatically Naming Ranges
Navigating with Named Ranges
Using Range Names in Formulas
Pasting a List of Named Ranges
Deleting and Editing Range Names
Creating Named Constants
4: Formatting the Worksheet
Moving and Copying Data
Copying Data
Copying Data with AutoFill
Creating a Series with AutoFill
Defining Relative, Mixed, and Absolute References
Copying Formulas
Changing the Appearance of Data
Changing Row Height
Applying Fonts
Adding Enhancements
Aligning Data in Cells
Merging and Centering Cells
Rotating and Indenting Text
Adding Borders and Shading
Using Drawing Tools
Creating Graphic Objects
Editing a Graphic Object
Creating and Editing 3-D Objects
Using Other Drawing Tool
