Microsoft Excel Outline
Chapter One: The Fundamentals
- Starting Excel
- What's New in Excel?
- Understanding the Excel Program Screen
- Using Menus
- Using Toolbars and Creating a New Workbook
- Hiding, Displaying, and Moving Toolbars
- Filling Out Dialog Boxes
- Keystroke and Right Mouse Button Shortcuts
- Opening a Workbook
- Saving a Workbook
- Moving the Cell Pointer
- Navigating a Worksheet
- Entering Labels in a Worksheet
- Entering Values in a Worksheet and Selecting a Cell Range
- Calculating Value Totals with AutoSum
- Entering Formulas
- Using AutoFill
- Previewing and Printing a Worksheet
- Getting Help from the Office Assistant
- Changing the Office Assistant and Using the "What's This" Button
- Closing a Workbook and Exiting Excel
- Chapter One Review
|
Beginning
|
Chapter Two: Editing a Workbook
- Entering Date Values and using AutoComplete
- Editing, Clearing, and Replacing Cell Contents
- Cutting, Copying, and Pasting Cells
- Moving and Copying Cells with Drag and Drop
- Collecting and Pasting Multiple Items
- Working with Absolute and Relative Cell References
- Using the Paste Special Command
- Inserting and Deleting Cells, Rows, and Columns
- Using Undo, Redo, and Repeat
- Checking Your Spelling
- Finding and Replacing Information
- Advanced Printing Options
- File Management
- Inserting Cell Comments
- Chapter Two Review
|
Beginning
|
Chapter Three: Formatting a Worksheet
- Formatting Fonts with the Formatting Toolbar
- Formatting Values
- Adjusting Row Height and Column Width
- Changing Cell Alignment
- Adding Borders
- Applying Colors and Patterns
- Using the Format Painter
- Using AutoFormat
- Creating a Custom Number Format
- Creating, Applying, and Modifying a Style
- Formatting Cells with Conditional Formatting
- Merging Cells, Rotating Text, and using AutoFit
- Chapter Three Review
|
Intermediate
|
Chapter Four: Creating and Working with Charts
- Creating a Chart
- Moving and Resizing a Chart
- Formatting and Editing Objects in a Chart
- Changing a Chart's Source Data
- Changing a Chart Type and Working with Pie Charts
- Adding Titles, Gridlines, and a Data Table
- Formatting a Data Series and Chart Axis
- Annotating a Chart
- Working with 3-D Charts
- Selecting and Saving a Custom Chart
- Using Fill Effects
- Mapping Data
- Modifying a Map
- Chapter Four Review
|
Intermediate
|
Chapter Five: Managing Your Workbooks
- Switching Between Sheets in a Workbook
- Inserting and Deleting Worksheets
- Renaming and Moving Worksheets
- Working with Several Workbooks and Windows
- Splitting and Freezing a Window
- Referencing External Data
- Creating Headers, Footers, and Page Numbers
- Specifying a Print Area and Controlling Page Breaks
- Adjusting Page Margins and Orientation
- Adding Print Titles and Gridlines
- Changing the Paper Size and Print Scale
- Protecting a Worksheet
- Hiding Columns, Rows and Sheets
- Viewing a Worksheet and Saving a Custom View
- Working with Templates
- Consolidating Worksheets
- Chapter Five Review
|
Intermediate
|
Chapter Six: More Functions and Formulas
- Formulas with Several Operators and Cell Ranges
- Using the Formula Palette to Enter and Edit Formulas
- Creating and Using Range Names
- Selecting Nonadjacent Ranges and Using AutoCalculate
- Using the IF Function to Create Conditional Formulas
- Using the PMT Function
- Displaying and Printing Formulas
- Fixing Errors in Your Formulas
- Mathematical Functions (Reference)
- Financial Functions (Reference)
- Date and Time Functions (Reference)
- Statistical Functions (Reference)
- Database Functions (Reference)
- Chapter Six Review
|
Intermediate
|
Chapter Seven: Working with Lists
- Creating a List
- Using the Data Form to Add Records
- Finding Records
- Deleting Records
- Sorting a List
- Filtering a List with the AutoFilter
- Creating a Custom AutoFilter
- Filtering a List with an Advanced Filter
- Copying Filtered Records
- Using Data Validation
- Chapter Seven Review
|
Advanced
|
Chapter Eight: Automating Tasks with Macros
- Recording a Macro
- Playing a Macro and Assigning a Macro a Shortcut Key
- Adding a Macro to a Toolbar
- Editing a Macro's Visual Basic Code
- Inserting Code in an Existing Macro
- Declaring Variables and Adding Remarks to VBA Code
- Prompting for User Input
- Using the If-Then-Else Statement
- Chapter Eight Review
|
Advanced
|
Chapter Nine: Working with Other Programs
- Inserting an Excel Worksheet into a Word Document
- Modifying an Inserted Excel Worksheet
- Inserting a Linked Excel Chart in a Word Document
- Inserting a Graphic into a Worksheet
- Opening and Saving Files in Different Formats
- Chapter Nine Review
|
Advanced
|
Chapter Ten: Using Excel with the Internet
- Adding Hyperlinks to a Worksheet
- Browsing Hyperlinks and using the Web Toolbar
- Saving a Workbook as a Non-Interactive Web Page
- Saving a Workbook as an Interactive Web Page
- Using Queries to Retrieve Information from the Web
- Chapter Ten Review
|
Advanced
|
Chapter Eleven: Data Analysis and PivotTables
- Creating a PivotTable
- Specifying the Data a PivotTable Analyzes
- Changing a PivotTable's Calculation
- Selecting What Appears in a PivotTable
- Grouping Dates in a PivotTable
- Updating a PivotTable
- Formatting and Charting a PivotTable
- Creating Subtotals
- Using Database Functions
- Using Lookup Functions
- Grouping and Outlining a Worksheet
- Chapter Eleven Review
|
Advanced
|
Chapter Twelve: What-If Analysis
- Defining a Scenario
- Creating a Scenario Summery Report
- Using a One and Two-Input Data Table
- Understanding Goal Seek
- Using Solver
- Chapter Twelve Review
|
Advanced
|
Chapter Thirteen: Advanced Topics
- Creating and Using Custom Toolbars
- Creating a Custom AutoFill List
- Changing Excel's Options
- Password Protecting a Workbook
- File Properties and Finding a File
- Sharing a Workbook and Tracking Changes
- Merging and Revising a Shared Workbook
- Using Detect and Repair
- Chapter Thirteen Review
|
Advanced
|