1. Basics

• Creating a New Workbook
• Navigating in Excel
• Moving the Cell Pointer
• Using Excel Menus
• Using Excel Toolbars: Hiding, Displaying, and Moving Toolbars
• Entering Values in a Worksheet and Selecting a Cell Range
• Previewing and Printing a Worksheet
• Getting Help from the Office Assistant
• Saving a Workbook & Re-opening a saved workbook

2. Worksheet Formatting

• Creating Headers, Footers, and Page Numbers Adjusting Page Margins and Orientation
• Adding Print Titles and Gridlines, rows to repeat at top of each page Formatting Fonts & Values
• Adjusting Row Height and Column Width Changing Cell Alignment
• Adding Borders
• Applying Colours and Patterns Using the Format Painter Using AutoFormat
• Merging Cells, Rotating Text, and using AutoFit Using AutoFill

3. Workbook Management

• Switching Between Sheets in a Workbook
• Inserting and Deleting Worksheets
• Renaming and Moving Worksheets
• Protecting a Workbook
• Hiding Columns, Rows and Sheets
• Splitting and Freezing a Window
• Inserting Page Breaks

4. 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
• Using the Paste Special Command
• Inserting and Deleting Cells, Rows, and Columns
• Using Undo, Redo, and Repeat
• Checking Your Spelling
• Finding and Replacing Information
• Inserting Cell Comments

5. Applying Formulas in Excel

• Creating a basic Formula
• Calculating Value Totals with AutoSum Editing & Copying Formulas
• Fixing Errors in Your Formulas
• Formulas with Several Operators and Cell Ranges

6. Working With Forms Menu

• Sorting, Subtotalling & Filtering Data
• Copy & Paste Filtered Records
• Using Data Validation

7. Creating & 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

8. Data Analysis & Pivot Tables

• 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
• Different types of look ups in Excel.

9. Automating Tasks with Macros

• Recording a Macro
• Playing a Macro and Assigning a Macro a Shortcut Key
• Adding a Macro to a Toolbar
• Simple VB Script Programs.