Excel school training courses in Chicago, IL (public, in-house or online)

In this class you’ll learn to simplify your work in Excel by automating many of the repetitive tasks that are part of spreadsheet development. You’ll apply the Visual Basic for Applications (VBA) programming language to simplify many of the tasks you learned in Excel Introduction and Excel Intermediate.
Our classes are all instructor-led, hands-on learning. Each student has their own computer and is given a student manual with practice files to take home. A free repeat, within six m...

Full archival course description>>

Students will work with advanced formulas, learning functions such as VLOOKUP, HLOOKUP, MATCH, IF, SUMIF, ROUND , PMT, IFERROR, COUNTIF and INDEX. In addition, students will learn about data validation and database functions such as DSUM, DCOUNT, and DAVERAGE, and creating formulas with dates. They will how to import and export XML data, and how to query external databases. Finally, students will learn about the analytical features of Excel (such as Goal Seek and Solver) and running and recordin...

Full archival course description>>

You Will Learn How To

Summarize data with Excel by incorporating formulas, formatting, and charts and graphs
Efficiently navigate and manipulate multiple spreadsheets in a workbook
Optimize your worksheets using templates, graphs and formulas
Design simple-to-complex formulas by nesting Excel functions
Present data visually using Excel tables and charts
Import, fine-tune and share Excel data in your workgroup

Course Benefits

In today’s workplace, Mi...

Full archival course description>>

In this course, students create and edit basic Microsoft® Office Excel® 2007 worksheets and workbooks. (Second Edition)

At Course Completion:
Upon successful completion of this course, students will be able to: - Explore the Microsoft® Office Excel® 2007 environment and create a basic worksheet. - Perform calculations. - Modify a worksheet. - Format a worksheet. - Print workbook contents. - Manage large workbooks.

Outline :
Lesson 1: Creating a Basic Worksheet
Explore ...

Full archival course description>>

Program Fundamentals

Starting Excel 2010

What’s New in Excel 2010

Understanding the Excel Program Screen

Giving Commands

Using Command Shortcuts

Creating a New Workbook

Opening a Workbook

Previewing and Printing a Worksheet

Saving a Workbook

Closing a Workbook

Using Help

Exiting Excel



Getting Started with Worksheets

Navigating a Worksheet

Entering Labels and Values
Full archival course description>>