Microsoft excel Training:

The Basics

Formatting a Worksheet

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

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 Colors and Patterns

Using the Format Painter

Using AutoFormat

Merging Cells, Rotating Text, and using AutoFit

Using AutoFill

Managing your workbooks

Editing a Workbook

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

Advanced Printing Options

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


Working with the Forms Menu

Creating a basic Formula

Calculating Value Totals with AutoSum

Editing & Copying Formulas

Fixing Errors in Your Formulas

Formulas with Several Operators and Cell Ranges

Sorting, Subtotaling & Filtering Data

Copy & Paste Filtered Records

Using Data Validation