Category: Spreadsheets

Cost: $285

Course Summary:

New Version! Learn the basic functions and features of Excel. Use the Help system and navigate worksheets and workbooks. Enter and edit text, values, formulas, and pictures, and save workbooks in various formats. Move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. Learn simple functions, basic formatting techniques, and printing. Create and modify charts, and learn how to manage large workbooks.

Prerequisite: Intro to Windows or equivalent.

Next Course of AACTTion: Excel - Part II (Save 10% when registering for both)

Course Topics: Excel - Part I

Microsoft Excel 2010 - Part One

CLASS DATES

MS Excel Part I - Course Topics

Getting started

• Spreadsheet terminology
• The Excel environment
• Getting help
• Navigating a worksheet

 

Entering and editing data

• Entering and editing text and values
• Entering and editing formulas
• Working with pictures
• Saving and updating workbooks

 

Modifying a worksheet

• Moving and copying data
• Moving and copying formulas
• Absolute and relative references
• Inserting and deleting ranges, rows, and columns

 

Functions

• Entering functions
• AutoSum
• Other common functions

 

Formatting

• Text formatting
• Row and column formatting
• Number formatting
• Conditional formatting
• Additional formatting options

 

Printing

• Preparing to print
• Page Setup options
• Printing worksheets

 

Charts

• Chart basics
• Formatting charts

 

Managing Large Workbooks

• Viewing large worksheets
• Printing large worksheets
• Working with multiple worksheets

 

Back to Course Top

Back to Top of Page

 

MS Excel Part II - Course Topics

Using multiple Worksheets and Workbooks

• Using multiple workbooks
• Linking worksheets with 3-D formulas
• Linking workbooks
• Managing workbooks

 

Advanced Formatting

• Using special number formats
• Using functions to format text
• Working with styles
• Working with themes
• Other advanced formatting

 

Outlining and Subtotals

• Outlining and consolidating data
• Creating subtotals

 

Cell and Range Names

• Creating and using names
• Managing names

 

Tables

• Sorting and filtering data
• Advanced filtering
• Working with tables

 

Web and Sharing Features

• Saving workbooks as Web pages
• Using hyperlinks
• Sharing workbooks

 

Advanced Charting

• Chart formatting options
• Combination charts
• Graphic elements

 

Documenting and Auditing

• Auditing features
• Comments in cells and workbooks
• Protection
• Workgroup collaboration

 

Templates and Settings

• Application settings
• Built-in templates
• Creating and managing templates

Back to Course Top

Back to Top of Page

 

MS Excel Part III - Course Topics

Advanced Functions

• Logical functions
• Math and statistical functions
• Financial functions
• Displaying and printing formulas

 

Lookups and Data Tables

• Using lookup functions
• Using MATCH and INDEX
• Creating data tables

 

Advanced Data Management

• Validating cell entries
• Exploring database functions

 

PivotTables and PivotCharts

• Working with PivotTables
• Rearranging PivotTables
• Formatting PivotTables
• PivotCharts

 

Exporting and Importing

• Exporting and importing text files
• Exporting and importing XML data
• Querying external databases

 

Analytical Tools

• Goal Seek and Solver
• The Analysis ToolPak
• Scenarios
• Views

 

Macros and Custom Functions

• Running and recording a macro
• Working with VBA code
• Creating functions

 

Conditional Formatting and SmartArt Graphics

• Conditional formatting with graphics
• SmartArt graphics

 

Back to Course Top

Back to Top of Page

Excel for Win Part I	Excel for Win Part II	Excel for Win Part III
Excel for Mac (click here)

Category: Spreadsheets

Cost: $285

Course Summary:

New Version! Learn how to use multiple worksheets and workbooks efficiently, and start working with more advanced formatting options including styles, themes, and backgrounds. Create outlines and subtotals, create and apply cell names, and work with tables. Save workbooks as Web pages, insert and edit hyperlinks, and share workbooks by email. This course also covers advanced charting techniques, use of trendlines and sparklines, worksheet auditing and protection, file sharing and merging, and workbook templates.

Prerequisite: Excel Part I or equivalent.

Next Course of AACTTion: Excel - Part III (Save 15% when registering for all 3 parts)

Course Topics: Excel - Part II

Microsoft Excel 2010 - Part Two

CLASS DATES

Category: Spreadsheets

Cost: $295

Course Summary:

New Version! Work with advanced formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. Learn about data validation and database functions such as DSUM. Work with PivotTables and PivotCharts, import and export data, and query external databases. Learn about the analytical features of Excel (such as Goal Seek and Solver), running and recording macros, and sharing Excel data via the Web.

Prerequisite: Excel Part II or equivalent.

Next Course of AACTTion: Any Course

Course Topics: Excel - Part III

Microsoft Excel 2010 - Part Three

CLASS DATES