Topics Found in Our 2003 Excel Series

A

• Absolute Cell References
•      ABS key (F4) [Beg., Ch. 15]
• Aligning Text [Beg., Ch. 2, 11]
• Aligning Values [Beg., Ch. 2]
• Application Window [Beg., Ch. 1]
• Area Charts [Beg., Ch. 16]
• Arrays
•      Selecting and Deleting an Array [Adv., Ch. 4]
•      Using a Function with an Array Formula [Adv., Ch. 4]
•      Using Arrays with Logical Operators [Adv., Ch. 4]
•      Using Range Names [Adv., Ch. 4]
•      Exercise: Calculating Quarterly Totals [Adv., Ch. 4]
• AutoCalculate [Beg., Ch. 8]
• AutoFill Options  [Int., Ch. 3]
• AVERAGE Function [Beg., Ch. 8]

B

• Bar Charts [Beg., Ch. 16]
• Borders
•      Drawing [Beg., Ch. 12]
•      Removing [Beg., Ch. 12]

C

• Calculations
•      Using Operators to Make Calculations [Beg., Ch. 3]
• Character Formats [Beg., Ch. 5]
• Chart Customization, Advanced
•      Changing Default Chart [Int., Ch. 16]
•      Creating a Combination Chart [Int., Ch. 16]
•      Creating an AutoFormat [Int., Ch. 16]
•      Deleting an AutoFormat [Int., Ch. 16]
•      Viewing Angle for 3-D Charts [Int., Ch. 16]
• Chart Formatting
•      Adding Labels to Data Points [Int., Ch. 15]
•      Adding Unattached Text [Int., Ch. 15]
•      Adjusting Category Labels [Int., Ch. 15]
•      Adjusting X-axis Scale [Int., Ch. 15]
•      Changing Text [Int., Ch. 14]
•      Changing X-Axis. [Int., Ch. 15]
•      Changing Y-axis Scale. [Int., Ch. 15]
•      Changing Y-Axis. [Int., Ch. 15]
•      Customization [Int., Ch. 15]
•      Customizing Axes. [Int., Ch. 15]
•      Customizing Data Points [Int., Ch. 15]
•      Formatting [Int., Ch. 14]
•      Formatting Data Points [Int., Ch. 15]
•      Formatting Items [Int., Ch. 14]
•      Formatting Legend [Int., Ch. 14]
•      Gridlines [Int., Ch. 15]
•      Hiding Axes [Int., Ch. 15]
•      Identifying and Selecting Chart Items [Int., Ch. 14]
•      Negative Values [Int., Ch. 15]
• Chart Wizard
•      Switching Data Series, Switching [Int., Ch. 13]
• Charts
•      Adding Data [Beg., Ch. 16]
•      Area Charts [Beg., Ch. 16]
•      Bar Charts [Beg., Ch. 16]
•      Changing Data [Beg., Ch. 16]
•      Chart Toolbar [Beg., Ch. 16]
•      Chart Types [Beg., Ch. 16]
•      Column Charts [Beg., Ch. 16]
•      Creating a Chart [Beg., Ch. 16]
•      Custom Chart Types [Beg., Ch. 16]
•      Doughnut Charts [Beg., Ch. 16]
•      Line Charts [Beg., Ch. 16]
•      Pie Charts [Beg., Ch. 16]
•      Printing [Beg., Ch. 16]
•      XY (Scatter) Chart s [Beg., Ch. 16]
•      Exercise: Creating a Chart [Beg., Ch. 16]
• Charts, Modifying and Embedding
•      Adding Titles. [Int., Ch. 12]
•      Copying [Int., Ch. 12]
•      Data Table Button. [Int., Ch. 12]
•      Deleting an Embedded [Int., Ch. 12]
•      Embedding [Int., Ch. 12]
•      Positioning Objects. [Int., Ch. 12]
•      Exercise: Creating an Embedded Chart. [Int., Ch. 13]
• Closing Workbooks [Beg., Ch. 3]
• Column Charts [Beg., Ch. 16]
• Column Widths
•      Changing Column Widths [Beg., Ch. 4]
•      Changing the Widths of All Columns [Beg., Ch. 4]
•      Changing the Widths of Several Columns [Beg., Ch. 4]
•      Individual Columns [Beg., Ch. 4]
•      When a Value is Too Long [Beg., Ch. 4]
•      When Text it is Too Long [Beg., Ch. 4]
•      Exercise: Creating a Profit & Loss Statement [Beg., Ch. 4]
• Columns
•      Deleting Columns  [Beg., Ch. 9]
•      Inserting Columns [Beg., Ch. 9]
• CONCATENATE Function [Adv., Ch. 12]
• Conditional Formatting [Adv., Ch. 1]
•      Adding Other Conditions [Adv., Ch. 1]
•      Another Helpful Function [Adv., Ch. 1]
•      Coloring Rows [Adv., Ch. 1]
•      EVEN Function for Colored Rows [Adv., Ch. 1]
•      MOD Function [Adv., Ch. 1]
•      ROW Function [Adv., Ch. 1]
• Copy Command  [Beg., Ch. 10]
• Cosmetic Changes [Beg., Ch. 11]
• COUNT Function [Beg., Ch. 8]
• Custom Lists [Int., Ch. 3]
• Cut Command  [Beg., Ch. 10]
• Cutting, Copying, and Pasting
•      Collecting and Pasting Multiple Items [Beg., Ch. 10]
•      Cutting and Copying Multiple Items [Beg., Ch. 10]

D

• Data Form [Adv., Ch. 3]
• Data Lists [Adv., Ch. 3]
•      Adding and Deleting Columns [Adv., Ch. 3]
•      Converting a Data List to a Range [Adv., Ch. 3]
•      Creating a Data List [Adv., Ch. 3]
•      Data Form [Adv., Ch. 3]
•      Filtering the Data List [Adv., Ch. 3]
•      New Rows with Auto-Copied Formulas [Adv., Ch. 3]
•      Sorting [Adv., Ch. 3]
•      Sorting and Filtering the Data List [Adv., Ch. 3]
•      Sorting on Multiple Fields [Adv., Ch. 3]
•      Total Row [Adv., Ch. 3]
• Data Tables [Adv., Ch. 6]
•      Creating a Chart Based on a Data Table [Adv., Ch. 6]
•      Data Tables with Multiple Formulas [Adv., Ch. 6]
•      Goal Seek vs Data Tables [Adv., Ch. 6]
•      Modifying a Data Table [Adv., Ch. 6]
•      Modifying Existing Input Cells [Adv., Ch. 6]
•      Modifying the Table’s Size [Adv., Ch. 6]
•      Setting Up the Data Table [Adv., Ch. 6]
•      Two Variable Data Tables [Adv., Ch. 6]
• Data Validation [Adv., Ch. 2]
• Database Functions [Adv., Ch. 7]
•      DAVERAGE Function [Adv., Ch. 7]
•      DSUM Function [Adv., Ch. 7]
•      Exercise: Calculating the Total Earnings [Adv., Ch. 7]
•      Exercise: Calculating the Total Earnings [Adv., Ch. 7]
•      Exercise: Rate Summary [Adv., Ch. 7]
•      Exercise: Rate Summary [Adv., Ch. 7]
• Databases
•      Creating Ranges [Int., Ch. 9]
•      Data Forms [Int., Ch. 9]
•      Filtering Data. [Int., Ch. 9]
•      Operators [Int., Ch. 9]
•      Sort Buttons [Int., Ch. 9]
•      Sorting a Selected Range [Int., Ch. 9]
•      Sorting Data [Int., Ch. 9]
•      Sorting Duplicates. [Int., Ch. 9]
•      Wildcard Characters [Int., Ch. 9]
• Date and Time Functions
•      Date and Time Functions and Formats. [Int., Ch. 7]
•      Date Calculations [Int., Ch. 7]
•      Date Formats [Int., Ch. 7]
•      Fixed Dates and Times [Int., Ch. 7]
•      NOW Function [Int., Ch. 7]
•      Time Formats [Int., Ch. 7]
• DAVERAGE Function [Adv., Ch. 7]
• Deleting [Beg., Ch. 2]
• Deleting
•      Deleting Columns  [Beg., Ch. 9]
•      Deleting Rows  [Beg., Ch. 9]
• Display Options
•      Hiding Columns and Rows [Int., Ch. 4]
•      Hiding Formulas [Int., Ch. 4]
• Document Protection [Int., Ch. 4]
• Document Window [Beg., Ch. 1]
• Doughnut Charts [Beg., Ch. 16]
• Drag and Drop Editing [Beg., Ch. 10]
• Drawing Borders [Beg., Ch. 12]
• DSUM Function [Adv., Ch. 7]

E

• Edit Options [Int., Ch. 3]
• ENTER Key Behavior in a Range [Beg., Ch. 5]
• EVEN Function for Colored Rows [Adv., Ch. 1]
• Exercises
•      Applying Value Formats [Beg., Ch. 6]
•      Calculating Commissions [Beg., Ch. 15]
•      Calculating Percentages [Beg., Ch. 15]
•      Calculating Quarterly Totals [Adv., Ch. 4]
•      Calculating the Total Earnings [Adv., Ch. 7]
•      Chart 2 (Pivot Table) [Adv., Ch. 11]
•      Combining Three Applications of Excel [Int., Ch. 17]
•      Controlling Car Costs [Int., Ch. 6]
•      Creating a Balance Sheet [Beg., Ch. 12]
•      Creating a Balance Sheet [Beg., Ch. 12]
•      Creating a Bal. Summary (Pivot Tables) [Adv., Ch. 10]
•      Creating a Chart [Beg., Ch. 16]
•      Creating a Family Budget [Beg., Ch. 17]
•      Creating a Profit and Loss Statement [Beg., Ch. 4]
•      Creating a Workbook Using Functions [Beg., Ch. 8]
•      Creating an Embedded Chart. [Int., Ch. 13]
•      Filtering Data [Int., Ch. 10]
•      Integrating Excel’s Components [Int., Ch. 17]
•      Looking up Values in a Table of Orders [Int., Ch. 8]
•      Looking up Values in a Tax Table [Int., Ch. 8]
•      Range Names. [Int., Ch. 2]
•      Rate Summary [Adv., Ch. 7]

F

• File Menu Practice
•      Closing Workbooks [Beg., Ch. 3]
•      Opening Workbooks [Beg., Ch. 3]
•      Saving a Document [Beg., Ch. 3]
•      Switching Workbooks [Beg., Ch. 3]
•      Viewing a List of Open Workbooks [Beg., Ch. 3]
• Fill Command
•      Other Fill Handle Uses [Int., Ch. 3]
• Fill Handle [Beg., Ch. 7]
• Filtering Techniques, Advanced
•      AND Operator [Int., Ch. 10]
•      AutoFilter [Int., Ch. 10]
•      Combining AND and OR Operators [Int., Ch. 10]
•      Copying the Filter (Exercises) [Int., Ch. 10]
•      Logical Operators [Int., Ch. 10]
•      OR Operator. [Int., Ch. 10]
• Filtering the Data List [Adv., Ch. 3]
• Find and Replace
•      Find Command [Int., Ch. 5]
•      Find Entire Cells Only [Int., Ch. 5]
•      Finding and Replacing Formats. [Int., Ch. 5]
•      Formulas vs. Values. [Int., Ch. 5]
•      Match case [Int., Ch. 5]
•      Replace Command. [Int., Ch. 5]
•      Wildcard Characters [Int., Ch. 5]
• Font Tab [Beg., Ch. 11]
• Footers [Beg., Ch. 13]
• Formatting
•      Automatic Cell Formatting [Beg., Ch. 6]
•      Clearing Formats [Beg., Ch. 6]
•      Currency Format [Beg., Ch. 6]
•      Custom Formats [Beg., Ch. 6]
•      Formatting Empty Cells [Beg., Ch. 6]
•      General Format [Beg., Ch. 6]
•      Number Format [Beg., Ch. 6]
•      Number Format Buttons [Beg., Ch. 6]
•      Exercise: Applying Value Formats [Beg., Ch. 6]
• Formulas [Beg., Ch. 2]
• Formulas
•      Formulas, Copying [Beg., Ch. 7]
•      Formulas, Pointing and Copying [Beg., Ch. 7]
• Formulas, Entering [Beg., Ch. 2]
• Functions
•      AutoCalculate [Beg., Ch. 8]
•      AVERAGE Function [Beg., Ch. 8]
•      COUNT Function [Beg., Ch. 8]
•      MAX Function [Beg., Ch. 8]
•      MIN Function [Beg., Ch. 8]
•      SUM Function [Beg., Ch. 8]
•      SUM Function [Beg., Ch. 8]
•      Using Functions to Create Formulas [Beg., Ch. 8]

G

• Getting Started
•      Exiting Excel [Beg., Ch. 1]
•      Starting Excel [Beg., Ch. 1]
•      Using Excel [Beg., Ch. 1]
• Goal Seek
•      Break Even Analysis [Adv., Ch. 5]
•      Goal Seek to Change Multiple Cells [Adv., Ch. 5]

H

• Headers [Beg., Ch. 13]
• Horizontal Lookup [Int., Ch. 8]

I

• If Function
•      Conditional (IF) Tests. [Int., Ch. 6]
•      Exercise: Controlling Car Costs [Int., Ch. 6]
• Importing Information
•      Importing From a Text File [Adv., Ch. 8]
•      Importing Information [Adv., Ch. 8]
•      Operation [Adv., Ch. 8]
•      Transpose [Adv., Ch. 8]
•      Values Options [Adv., Ch. 8]
• Index and Match
•      Combining MATCH and INDEX [Adv., Ch. 12]
•      CONCATENATE Function [Adv., Ch. 12]
•      INDEX Function [Adv., Ch. 12]
•      MATCH Function [Adv., Ch. 12]
• Insert Function
•      Insert Function Command [Int., Ch. 7]
• Inserting
•      Inserting Columns [Beg., Ch. 9]
•      Inserting Rows  [Beg., Ch. 9]
•      Inserting Text [Beg., Ch. 2]
• Introduction to Macros
•      Absolute and Relative References [Adv., Ch. 13]
•      Assigning a Shortcut Key [Adv., Ch. 13]
•      Creating a Header Macro [Adv., Ch. 13]
•      Creating a Macro with the Recorder [Adv., Ch. 13]
•      Creating a Main Macro [Adv., Ch. 13]
•      Creating a Print Macro [Adv., Ch. 13]
•      Editing Macros [Adv., Ch. 13]
•      Running a Macro [Adv., Ch. 13]
•      Using the Recorder to Make Edits [Adv., Ch. 13]
•      Viewing the Macro Code [Adv., Ch. 13]

J

K

L

• Line Charts [Beg., Ch. 16]
• Linking Workbooks
•      Indicating Links in the Source Workbook [Adv., Ch. 9]
•      Indicating Links in the Target Workbook [Adv., Ch. 9]
• List Validation [Adv., Ch. 2]
• Lookup Functions
•      Horizontal Lookup [Int., Ch. 8]
•      Vertical Lookup [Int., Ch. 8]
•      Exercise: Looking up Values in a Tax Table [Int., Ch. 8]
•      Exercise: Looking up Values in a Table of Orders [Int., Ch. 8]

M

• Macros, Introduction [Adv., Ch. 13]
• MATCH Function [Adv., Ch. 12]
• MAX Function [Beg., Ch. 8]
• Menu Bar [Beg., Ch. 1]
• MIN Function [Beg., Ch. 8]
• MOD Function [Adv., Ch. 1]
• Multiple Windows of a Workbook [Beg., Ch. 14]

N

• Navigating Through a Workbook [Beg., Ch. 14]
• Navigation Commands
•      CTRL/HOME [Beg., Ch. 14]
•      END and CTRL Keys [Beg., Ch. 14]
•      Go To Command [Beg., Ch. 14]
•      Moving Around in a Multi-Sheet Workbook [Beg., Ch. 14]
•      PAGE DOWN and PAGE UP Keys [Beg., Ch. 14]

O

• Opening Workbooks [Beg., Ch. 3]
• Operators
•      Addition [Beg., Ch. 3]
•      Division [Beg., Ch. 3]
•      Multiplication [Beg., Ch. 3]
•      Subtraction [Beg., Ch. 3]
• Order of Operations [Beg., Ch. 8]
• Overwriting [Beg., Ch. 2]

P

• Panes
•      Freezing Panes [Beg., Ch. 14]
• Paste Command
•      Insert Paste Command [Beg., Ch. 10]
•      Paste [Beg., Ch. 10]
• Paste Special
•      Other Paste Special Commands [Adv., Ch. 8]
•      Paste Special Command [Adv., Ch. 8]
• Percentages
•      Calculating a Sales Tax [Beg., Ch. 15]
•      Exercise: Calculating Percentages [Beg., Ch. 15]
•      Exercise: Calculating Commissions [Beg., Ch. 15]
• Pie Charts [Beg., Ch. 16]
• Pivot Charts [Adv., Ch. 11]
•      Creating the PivotChart [Adv., Ch. 11]
•      Formatting PivotTable Values [Adv., Ch. 11]
•      Modifying a PivotChart [Adv., Ch. 11]
•      Exercise: Chart 2 [Adv., Ch. 11]
• Pivot Tables [Adv., Ch. 10]
•      Choosing and Placing the DATA Fields [Adv., Ch. 10]
•      Choosing the PAGE Field [Adv., Ch. 10]
•      Choosing the ROW Fields [Adv., Ch. 10]
•      Creating a Calculated Field [Adv., Ch. 10]
•      Creating a Pivot Table [Adv., Ch. 10]
•      Creating the Pivot Table [Adv., Ch. 10]
•      Formatting a Pivot Table [Adv., Ch. 10]
•      Exercise: Creating a Balance Summary [Adv., Ch. 10]
• Pointer [Beg., Ch. 1]
• Pointing and Copying to Create Formulas [Beg., Ch. 7]
• Print Preview
•      Navigating  [Beg., Ch. 13]
• Printing a Workbook
•      Footers [Beg., Ch. 13]
•      Header, Custom [Beg., Ch. 13]
•      Headers [Beg., Ch. 13]
•      Page Breaks, Setting [Beg., Ch. 13]
•      Print area, Removing [Beg., Ch. 13]
•      Print Options [Beg., Ch. 13]
•      Print Titles  [Beg., Ch. 13]
•      Printing Part of a Workbook [Beg., Ch. 13]

Q

R

• Range Names with Arrays [Adv., Ch. 4]
• Range Names
•      Apply Names Command [Int., Ch. 2]
•      Create Command [Int., Ch. 2]
•      Defining Range Names [Int., Ch. 2]
•      Deleting Range Names [Int., Ch. 2]
•      Exercise: Range Names. [Int., Ch. 2]
•      Increasing the Range [Int., Ch. 2]
•      Listing Range Names [Int., Ch. 2]
•      Paste Name Command [Int., Ch. 2]
•      Range Name with a Function [Int., Ch. 2]
•      Range Names in Formulas [Int., Ch. 2]
• Ranges
•      Aligning Cells in a Range [Beg., Ch. 5]
•      Centering Text Across Several Cells [Beg., Ch. 5]
•      Erasing Ranges [Beg., Ch. 5]
•      Formatting Ranges [Beg., Ch. 5]
•      Selecting Non-Adjacent Ranges [Beg., Ch. 5]
•      Selecting Ranges [Beg., Ch. 5]
•      Shading Ranges [Beg., Ch. 12]
•      SHIFT/Click Method [Beg., Ch. 5]
• Redo Commands [Beg., Ch. 10]
• Replacing Text by Highlighting [Beg., Ch. 2]
• Review Exercise [Beg., Ch. 17]
• Rows
•      Changing Row Height [Beg., Ch. 11]
•      Deleting Rows  [Beg., Ch. 9]
•      Inserting Rows  [Beg., Ch. 9]

S

• Scenarios [Adv., Ch. 5]
•      Merging Scenarios from Other Worksheets [Adv., Ch. 5]
•      Scenario Summary [Adv., Ch. 5]
• Selecting
•      Selecting Ranges [Beg., Ch. 5]
•      SHIFT/Click Method [Beg., Ch. 5]
•      Selecting Non-Adjacent Ranges [Beg., Ch. 5]
• Shortcut Menus [Beg., Ch. 9]
• Smart Tags [Beg., Ch. 9]
• SmartTag [Int., Ch. 3]
• Sorting and Filtering the Data List [Adv., Ch. 3]
• Sorting Data [Int., Ch. 9]
• Sorting [Adv., Ch. 3]
• Status Bar [Beg., Ch. 1]
• Subtotals
•      Outline Feature [Int., Ch. 11]
•      Adding More [Int., Ch. 11]
•      Creating Multiple [Int., Ch. 11]
• SUM Function [Beg., Ch. 8]
• SUMIF Function [Int., Ch. 8]

T

• Task Pane [Beg., Ch. 1]
• Text that Contains Numbers [Beg., Ch. 2]
• Text
•      Aligning Text [Beg., Ch. 2, 11]
•      Character Formats [Beg., Ch. 5]

U

• Undo Commands [Beg., Ch. 10]

V

• Validation [Adv., Ch. 2]
•      Data Validation [Adv., Ch. 2]
•      Descriptive Error Messages [Adv., Ch. 2]
•      Extending Validation [Adv., Ch. 2]
•      Including ToolTips [Adv., Ch. 2]
•      Increasing the List [Adv., Ch. 2]
•      List Validation [Adv., Ch. 2]
•      Removing Validation [Adv., Ch. 2]
• Values
•      Aligning Values [Beg., Ch. 2]
• Vertical Alignment and Orientation [Beg., Ch. 11]
• Vertical Lookup [Int., Ch. 8]
• View Options [Int., Ch. 3]

W

• Window Elements [Beg., Ch. 1]
• Windows
•      Application Window [Beg., Ch. 1]
•      Document Window [Beg., Ch. 1]
• Workbook
•      Canceling an Entry [Beg., Ch. 2]
•      Cell, Changing the Contents [Beg., Ch. 2]
•      Closing Workbooks [Beg., Ch. 3]
•      Creating a Workbook [Beg., Ch. 2]
•      Editing Information [Beg., Ch. 2]
•      Erasing the Contents of a Cell [Beg., Ch. 2]
•      Formula, Typing [Beg., Ch. 2]
•      Modifying a Workbook [Beg., Ch. 9]
•      Opening Workbooks [Beg., Ch. 3]
• Workbook, Moving Around a [Beg., Ch. 14]
• Worksheet
•      Indicating the Active Cell [Beg., Ch. 1]
•      Moving Around a Worksheet [Beg., Ch. 1]
• Worksheets
•      Background Images. [Int., Ch. 1]
•      Changing Multiple Sheet Formatting [Int., Ch. 1]
•      Coloring Sheet Tabs [Int., Ch. 1]
•      Deleting Sheets [Int., Ch. 1]
•      Hiding and Unhiding Sheets [Int., Ch. 1]
•      Inserting, Moving, and Deleting Sheets [Int., Ch. 1]
•      Moving and Copying to Other Workbooks [Int., Ch. 1]
•      Moving and Copying Worksheets [Int., Ch. 1]
•      Multiple Worksheets [Int., Ch. 1]
•      Naming Sheet Tabs [Int., Ch. 1]
•      Referencing Other Sheets [Int., Ch. 1]
•      Selecting Multiple Sheets [Int., Ch. 1]
• Wrapping Text [Int., Ch. 3]

X

Y

Z