|
Excel XP Foundation
Getting Started With Excel
Introduction
What Is Excel?
New Features In Excel 2003
Opening Excel
Exiting Excel
Help With Excel
Finding Help
The Office Assistant
The Help Task Pane
Beginning Excel
The Standard Toolbar
The Formatting Toolbar
Working With Excel Menus
Exploring Task Panes
Excel Short-Cut Keys
The Basics Of File Management
New Workbooks
How To Open Existing Workbooks
How To Save Workbooks
How To Close Workbooks
Excel File Types
Explore Your Workbook
Switching Worksheets
The Active Cell
Selecting Cells
Exploring A Worksheet
The Zoom Feature
Excel Basics
Working With Excel
Columns, Rows, Cells, And Ranges
Creating Worksheet Labels
Entering And Deleting Data
Printing Your Worksheet
Basic Excel Features
What Is AutoFill?
What Is AutoSum?
What Is AutoComplete
Working With Basic Formulas
Editing Tools
Using Autocorrect
Using Spell Check
Using Find And Replace
Documenting A Worksheet With Comments
Moving Your Data
Dragging And Dropping Cells
How To Cut, Copy, And Paste Cells
How To Cut, Copy, And Paste Multiple Cells And Items
How To Use Paste Special
How To Insert And Delete Cells, Rows, And Columns
Using Undo, Redo, And Repeat
Using Smart Tags And Option Buttons
What Are Smart Tags?
The Error Option Button
The AutoFill Option Button
The Paste Option Button
Working With Excel
Modifying Cells And Data
Changing The Size Of Rows Or Columns
Working With The Formatting Toolbar
Adjusting Cell Alignment
Rotating Text
Creating Custom Number And Date Formats
Cell Formatting
Conditional Formatting
What Is The Format Painter
What Is AutoFormat
Cell Merging And AutoFit
Find And Replace Formatting
Enhancing A Worksheet’s Appearance
Adding Patterns And Colors
Adding Borders
Adding Fill Effects
Working With Styles
Modifying Excel’s Toolbars
Hiding Toolbars
Showing Toolbars
Moving Toolbars
Customizing Toolbars
Working With Charts
Creating A Chart
Formatting A Chart
Manipulating A Chart
Enhancing A Chart With Drawing Tools
Enhancing Your Chart With Titles And Tables
Working With Charts And Data
Changing The Type Of Chart
Changing The Source Data
Creating 3-D Charts
Working With The Chart Axes And Data Series
Making Custom Charts
Workbook Management
Organizing Your Workbook
Inserting And Removing Worksheets
Renaming, Moving, And Color-Coding Worksheets
How To Split And Freeze A Window
Using Multiple Workbooks And Windows
Using A Watch Window
Creating A Custom View
Formatting Your Workbook
Using Headers And Footers
Inserting Page Numbers
Changing Margins And Orientation
Hiding Rows, Columns And Worksheets
Printing A Workbook
Choosing A Print Area
Setting Up Page Breaks
Choosing Paper Size And Changing Print Scale
Adding Print Titles And Gridlines
More Workbook Features
Linking Workbooks
Consolidating Workbooks
Combining Worksheets
Protecting Worksheets
Using Templates
Excel
XP
Intermediate
Working With Functions And
Formulas
Using Formulas In Excel
Understanding Relative And Absolute Cell References
The Basic Mathematical Operators
Using Formulas With Multiple Cell References
The Formula Auditing Bar
Fixing Formula Errors
Displaying And Printing Formulas
Exploring Excel Functions
What Are Functions?
Finding The Right Function
Some Useful And Simple Functions
Using Functions In Excel
Inserting Functions
Using Functions And AutoFill To Perform Difficult
Calculations
Using The If Function
Working With Nested Functions
Working With Names And Ranges
What Are Range Names?
Defining And Using Range Names
Selecting Nonadjacent Ranges
What Is Auto Calculate?
Working With Array Formulas
What Are Array Formulas
Using Basic Array Formulas
Using Functions With Array Formulas
Using The If Function In Array Formulas
Managing Lists
Working With Lists
What Is A List?
Creating Lists
Modifying Lists
What Is The Total Row?
Working With Records And Fields
What Are Records And Fields?
Adding Fields By Inserting Columns
Adding Records By Inserting Rows
Adding Records With A Data Form
Finding And Deleting Records
Working With Lists And Filters
Sorting A List
What Is An AutoFilter
Custom AutoFilters
Using An Advanced Filter
Copying Filtered Records
Using Excel As A Database
Filtering With Wild Card Characters
Validating Your Data
What Are Database Functions?
What Are Lookup Functions?
Working With Macros And
Controls
Creating Macros In Excel
What Is A Macro?
Creating A Macro
Playing A Macro
Assigning A Shortcut Key To Macro
Macros, Buttons, And Toolbars
Excel Form Controls
What Is A Form Control?
The Form Toolbar
Adding A Control To A Worksheet
Assigning A Macro To A Control
Using Form Controls
Using Excel With Other Programs
Using Excel In Word
Inserting Excel Data In Word
Modifying Excel Data After Insertion
Linking Excel Data In Word
Linking An Excel Chart In Word
Using Excel With Other Programs And Files
Using Outlook To Send Excel Data
Opening An Excel File In A Different Format
Importing Data From A Text File
Importing Data From A Database
Excel
XP
Advanced
Getting The Most Form Your Data
Outlining And Grouping Your Data
Using Automatic Outlining
Displaying And Collapsing Levels
Grouping Data Manually
Creating Subtotals
Pivot Tables
What Is A Pivot Table?
Creating A Pivot Table Frame
Specifying Data In A Pivot Table
Rearranging Pivot Table Data
More On Pivot Tables
Modifying Pivot Table Calculations
Formatting A Pivot Table
Refreshing A Pivot Table
Charting A Pivot Table
Creating A Pivot Table Based On Data From An External
Database
Exploring Scenarios
What Is A Scenario?
Creating A Scenario
Creating A Scenario Summary Report
Saving Multiple Scenarios
What If Analysis
Using A One And Two Input Data Table
Using Goal Seek
Using Solver
Excel And The Internet
Excel And Hyperlinks
Hyperlinks And The Internet
Inserting Hyperlinks
Modifying Hyperlinks
Using The Web Toolbar
Browsing Hyperlinks In Excel
Excel Workbooks As Web Pages
Interactive And Non-Interactive Web Pages
Saving A Workbook As A Web Page
Saving A Worksheet As A Web Page
Saving A Chart As A Web Page
Saving A Range As A Web Page
Getting Data From The Internet
Importing From An External Data Source
Creating A Web Query
Saving A Web Query
Refreshing A Web Query
Advanced Excel Tasks
Creating And Using Shared Workbooks
Sharing A Workbook
Requesting Reviews
Reviewing A Workbook
Tracking Changes
Merging And Revising A Shared Workbook
Visual Basic And Macros
Adding Code To Your Macro
Adding Comments To VBA Code
Declaring Variables
Prompting For User Input
Iteration Over A Range
Using If Then Else Statements
Advanced File Management
Identifying File Properties
Searching For Files
Protecting Personal Information
Creating Back Up Files
Changing Auto-Recovery Settings
Excel Security
Digital Signatures
Macro Security
Protecting Your Workbook With A Password
Custom And Advanced Features In Excel
Customizing Excel By Changing Options
Using Custom Auto-Fill Lists
What Is Text To Speech?
Using Detect And Repair
|
