Formatting Using Formulas More on Formulas Filtering and Sorting Pivot Tables

Start Excel Creating a File in Excel Saving a File Open a Workbook Finding a Work Book Switching between WorkBooks Email a Workbook Edit or Delete Data Move or Copy Data Finding Data Spelling Check in Excel Inserting Rows or Columns Deleting Rows or Columns Hiding Columns Naming Cells Undo Zooming In or Out Splitting Worksheets Entering a Formula Entering Functions Adding Numbers Copying a Formula Inserting a Worksheet Switching between Worksheets Renaming a Worksheet Moving a Worksheet

Changing Column Width or Row Height Font Face and Size Bold Italic or Underline Colors Cell Alignment More on Cell Formatting Number Formats Data Formats Adding Borders Copy Formatting Clear Formatting Autoformat in Excel

Print Preview Print Page Orientation More Print Options Changing Margins Page Breaks Specifying Number of Pages Add Page Labels Adding a Header or Footer

Creating a List Filtering Data in a list Sorting Data in a list Adding Subtotals to a List Macros

Creating a Chart Part I Creating a Chart Part II Changing Chart Type Moving Resizing or Deleting A chart Adding Data to a Chart Printing a Chart