Day One - Excel Basic
Getting To Know Excel
- Introducing Excel
- Working with an Existing Data List
- Zeroing In on Data in a List
- Creating a Workbook
- Checking and Correcting Data
Setting Up a Workbook
- Making Workbooks Easier to Work With
- Making Data Easier to Read
- Adding a Graphic to a Document
Performing Calculations on Data
- Naming Groups of Data
- Creating Formulas to Calculate Values
- Finding and Correcting Errors in Calculations
Changing Document Appearance
- Changing the Appearance of Data
- Applying an Existing Format to Data
- Making Numbers Easier to Read
- Changing Data's Appearance Based on Its Value
- Making Printout Easier to Follow
- Positioning Data on a Printout
Focusing on Specific Data Using Filters
- Limiting the Data That Appears on the Screen
- Performing Calculations on Filtered Data
- Defining a Valid Set of Values for a Rang of Cells
|