CREATING A BASIC WORKSHEET
- Explore the User Interface and the Ribbon
- Navigate and Select in Excel
- Obtain Help
- Enter Data and Save a Workbook
- Customize the Quick Access Toolbar
PERFORMING CALCULATIONS
- Create Basic Formulas
- Calculate with Functions
- Relative and Absolute Cell References
- Copy Formulas and Functions
MODIFYING A WORKSHEET
- Manipulate Data
- Insert and Delete Cells, Columns, and Rows
- Search for Data in a Worksheet
- Spell Check a Worksheet
|
FORMATTING A WORKSHEET
- Modify Fonts
- Add Borders and Color to Cells
- Change Column Width and Row Height
- Apply Number Formats
- Position Cell Contents
- Apply Cell Styles
PRINTING WORKBOOK CONTENTS
- Print Workbook Contents Using Default Print Options
- Set Print Options
- Set Page Breaks
MANAGING LARGE WORKBOOKS
- Format Worksheet Tabs
- Manage Worksheets in a Workbook
- Manage the View of Large Worksheets
|