151 Water St. Augusta, ME 04330   207-623-2700   info@capcomp.com

Introduction

COURSE DESCRIPTION

This ILT Series course teaches the basic functions and features of Excel 2010. After an introduction to spreadsheet terminology and Excel’s window components, students will learn how to use the Help system and navigate worksheets and workbooks. Then they will enter and edit text, values, formulas, and pictures, and they will save
workbooks in various formats. Students will also move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. This course also covers simple functions, basic formatting techniques, and printing. Finally, students will create and modify charts, and learn how to manage large workbooks. Students will also work with basic charts, working with large and multiple worksheets and formatting with graphics, SmartArt graphics and screenshots.

PREREQUISITES

Familiarity to PC and Windows; student should process skills such as how to power on and off a computer, use of a mouse, familiar with all drives on computer, know how to start programs, move and close windows, use menus and toolbars, how to open and save files and be able to work with folders.

Lesson 1

Getting Started

Spreadsheet Terminology

The Excel Environment

Getting Help

Navigating a Worksheet

Lesson 4

Functions

Entering Functions

AutoSum

Other Common Functions

Lesson 7

Charts

Chart Basics

Formatting Charts

Lesson 2

Entering and Editing Data

Entering and Editing Text and Values

Entering and Editing Formulas

Working with Pictures

Saving and Updating Workbooks

Lesson 5

Formatting

Text Formatting

Row and Column Formatting

Number Formatting

Conditional Formatting

Additional Formatting Options

Lesson 8

Managing Large Workbooks

Viewing Large Worksheets

Printing Large Worksheets

Working with Multiple Worksheets

Lesson 3

Modifying a Worksheet

Moving and Copying Data

Moving and Copying Formulas

Absolute and Relative References

Inserting and Deleting Ranges, Rows, and Columns

Lesson 6

Printing

Preparing to Print

Page Setup Options

Printing Worksheets

Lesson 9

Graphics and Screenshots

Conditional formatting with graphics

SmartArt graphics

Screenshots

 

Intermediate

COURSE DESCRIPTION

This ILT Series course builds on the skills and concepts taught in Excel 2010: Basic. Students will learn how to use multiple worksheets and workbooks efficiently, and they will start working with more advanced formatting options including styles, themes, and backgrounds. They will also learn how to create outlines and subtotals, how to create and apply cell names, and how to work with tables. Students will save workbooks as Web pages, insert and edit hyperlinks, and learn to share workbooks by email. This course also covers advanced charting techniques, documenting and auditing features, changing application settings, using built-in templates and managing templates. Students will also learn to work with PivotTables, rearranging and formatting PivotTables and using PivotCharts.

PREREQUISITES

To ensure successful completion of this course, we recommend that you first complete the Microsoft Excel Introduction class.

Lesson 1

Using multiple worksheets & workbooks

Using Multiple Workbooks

Linking Worksheets with 3-D Formulas

Linking Workbooks

Managing Workbooks

Lesson 5

Tables

Sorting and Filtering Data

Advanced Filtering

Working with Tables

Lesson 8

Documenting and Auditing

Auditing Features

Comments in Cells and Workbooks

Protection

Workgroup Collaboration

Lesson 2

Advanced Formatting

Using Special Number Formats

Using Functions to Format Text

Working with Styles

Working with Themes

Other Advanced Formatting

Lesson 6

Web and Sharing Features

Saving Workbooks as Web Pages

Using Hyperlinks

Sharing Workbooks

Lesson 9

Templates and Settings

Changing application settings

Using built-in Template

Creating and Managing Templates

Lesson 3

Outlining and Subtotals

Outlining and Consolidating Data

Creating Subtotals

Lesson 7

Advanced Charting

Chart Formatting Options

Combination Charts

Graphical Elements

Lesson 10

PivotTables and PivotCharts

Working with PivotTables

Rearranging PivotTables

Formatting PivotTables

Using PivotCharts

Lesson 4

Cell and Range Names

Creating and Using Names

Managing Names

 

Advanced

COURSE DESCRIPTION

This ILT Series course builds on the skills and concepts taught in Excel 2010: Intermediate. Students will work with logical and statistical functions, as well as lookup functions and data tables such as, MATCH, and INDEX..They will learn advanced data management, data validation and database functions. Students will learn about exporting and importing text files, XML data and getting external data, also about the analytical features of Excel (such as Goal Seek and Solver), Analysis ToolPak and scenarios. Finally they will learn running and recording macros, working with VBA code and creating functions.

PREREQUISITES

To ensure successful completion of this course, we recommend that you first complete the Microsoft Excel Introduction and Intermediate class.

Lesson 1

Logical and Statistical

Functions

Logical Functions

Math and Statistical Functions

Lesson 4

Advanced Data Management

Validating Cell Entries

Exploring Database Functions

 

Lesson 6

Analytical Tools

Goal Seek and Solver

The Analysis ToolPak

Scenarios

Lesson 2

Financial and Data Functions

Financial Functions

Date and Time Functions

Array Formulas

Displaying and Printing Formulas

Lesson 5

Exporting and Importing

Exporting and Importing Text Files

Exporting and Importing XML Data

Getting External Data

Lesson 7

Macros and Custom Functions

Running and Recording a Macro

Working with VBA Code

Creating Functions

Lesson 3

Lookups and Data Tables

Using Lookup Functions

Using MATCH and INDEX

Creating Data Tables