Training for the Advertising, Marketing, Design,
Publishing, Printing, and Web Authoring Industries
414 258-1646

Home | Classes

Microsoft Excel (two day hands-on class)

Day 1: MacTraining Excel Basics

Creating a worksheet
*The Excel Window
*Selecting and Moving
*Typing and Editing
*Using Autofill
*Save/Save as...
*Renaming a worksheet

Using Formulas
*Using simple formulas
*Totalling Rows and Columns
*Copying Cells
*Moving Cells
*Showing Formulas

Formatting a Worksheet
*Font Formatting
*Alignment
*Column Width
*Number Formatting
*Cell Borders
*Patterns

Printing Options
*Page Options
*Margins
*Headers and Footers
*Print Preview
*Sheet Options

Graphing your Data
*Creating a Graph
*Changing a Graph
*Graphing non-adjacent areas of a Worksheet

Using Help

Day 2: MacTraining Intermed Excel

Advanced Functions
*SUM, AVERAGE, MIN,
and MAX functions
*NOW Function
*The IF Function
*Nested IF Functions

Multiple Worksheets
*Copying Documents Between Worksheets
*Using Formulas Between Sheets
*Grouping Worksheets

Using Large Worksheets
*Sorting
*Autofilters
*Subtotaling and Outlining
*Freezing Panes
*Print Titles

Text and Number Handling
*Text Handling
*Replacing Text
*Cell Comments
*Custom Number Formats

Naming Cells and Ranges
*Defining Names & using Names in Formulas
*Creating, Pasting and Applying Names

Linking and Consolidating Worksheets

Pivot Tables
*Creating amd Refreshing a Pivot Table
*Page Fields
*Viewing Source Information

Customizing
*Customizing Toolbars, Preferences
*Creating a Template

Optional: Recording, Running and Editing a Macro

There will be step by step instructions, plenty of pictures in the workbook, and some special tips, too. By the end of the class, you'll be able to create and present useful and elegant spreadsheet data.

$645 per person; 3-6 attending the same class: 25% discount

Call (414) 258-1646 today. Class limited to 6 students.

Prerequisite: Knowledge of your operating system, cut,copy, paste, save and print commands.

Top of page

Home | Classes