COURSE OUTLINE

  1. Opening Microsoft Excel
  2. The Workbook environment
  3. Modifying the toolbar settings
    • Workbook Properties
    • Page Setup
    • Managing the Task pane
  4. Understanding the Open dialog box
    • Working with multiple worksheets
    • Renaming worksheets
    • Insert and delete worksheets
    • Moving and copying worksheets
  5. Adjusting column width and row height
    • Hiding and showing rows and columns
    • Inserting columns and rows
    • Deleting rows and columns
    • Merging cells
  6. Entering and correcting data
    • Changing the font and size of text
    • Change the color of text
    • Bold, underline and italicize text
    • Other underlining options
    • Other font options
    • Aligning text in a cell
    • Inserting symbols
    • Undo and Redo
    • Cut, copy and paste
    • Using the clipboard
    • Using the Paste Special function
    • Pasting a hyperlink
    • Moving data
    • The AutoFill feature
    • The AutoFormat feature
    • AutoCorrect options and settings
    • Checking spelling in a worksheet
    • Find and Replace text in a workbook
    • Inserting Hyperlinks
    • External Hyperlinks
    • Entering Numbers
    • Formatting number styles
    • Dates and Times
    • Labels and Values
    • Conditional Formatting
    • Inserting Comments
    • Working with multiple comments
  7. Adding borders to cells
    • Filling cells
    • Applying a color background
    • Insert a picture background
  8. Page Break view
    • Previewing your work for printing
    • Printing your workbook
    • Printing one worksheet
  9. Saving a file for the first time
  10. Closing your workbook
    • Opening a new workbook
    • Opening an existing workbook
  11. Sorting Data
    • Multi-level sorting
    • Filtering Data
  12. Recording Macros
    • Running a macro
  13. Linking cells in different workbooks
    • Modifying linked workbooks
    • Using Workspaces
  14. Creating Graphics
    • Moving and sizing graphics
    • Grouping Graphics
    • Adding text to graphics
    • Using AutoShapes
    • Enhance objects
    • Format Painter
    • Inserting pictures using Clip Art
    • Insert a picture from a file
    • Using WordArt
    • Enhance WordArt
  15. Using formulas to calculate values
    • Error Messages in a spreadsheet
    • The Error #####
    • The #VALUE! Error
    • The error #DIV/0!
    • The #NAME? Error
    • The error #N/A
    • The error #REF!
    • The #NUM! error
    • The error #NULL!
    • Using the Subtotal function
    • The Outline function
    • Outline symbols
    • Absolute cell referencing
    • The IF Function
    • The PMT function
    • The RATE function
    • Auditing features
    • The VLOOKUP function
    • The HLOOKUP function
  16. Creating Pivot Tables
    • Adding and deleting fields in Pivot tables
    • Grouping and summarizing data in a pivot table
    • Interactive Pivot Tables
  17. Creating a chart
    • Formatting your chart area
    • Modifying chart data
  18. Diagrams
    • Insert objects
  19. Creating Lists
  20. Protecting your worksheet
  21. Freeze Panes
    • Comparing workbooks side by side
    • Creating a Template
  22. Speech
    • Speech Options
    • Voice Training
    • Dictation and Voice commands
    • Handwriting
  23. E-mail your workbook
  24. The Research Function
  25. Excel Help
  26. Exit Excel