ExecuTrain West - Microsoft Excel

Microsoft Excel

This is one of the most useful tools to create budgets, lists, and perform mathematical operations. Advanced formulas and Visual Basic capabilities provide the extendable capabilities needed.

The following classes are available

Excel 2003 101: All About Worksheets
This class is for new or self-taught Excel users who want to learn to create and modify a spreadsheet, enter text and values into cells, create formulas and functions, use Autofill, format, insert and delete columns and rows, printing and saving documents. Even if you have used Excel for awhile, or are a self-taught user, you will learn a variety of short cuts and time-saving tricks to enhance your spreadsheet use!
Available dates and detailed description

Excel 2003 102: Formulas, Functions & More
The primary focus of this class is to use formulas and functions with large worksheets. We will cover how to create a formula using "if" statements, "ISError", "Or", "And", and many more formula creation techniques. We will cover function such as "Vlookup", "Hlookup", "Round", "FV", "PMT" and many more. You will expand your knowledge of the management of larger spreadsheets, working with range names, and techniques to manipulate large worksheets. The end result will be the ability to create large budgets, lists, and information needed to manipulate Excel.

Excel 2003 103: Databases, Pivot & Data Tables
Students will learn how to sort and manage data in lists; filter and query data, use database functions, and import and export information and documents. Participants also will learn the basics about Pivot Tables, creating and formatting them. Discover the use of data series and data tables in this class.

Excel 2003 104: Macros & Analytical Tools
This class teaches experienced Microsoft Excel users how to create and edit macros, use custom toolbars and buttons, and create their own macro buttons. Participants will learn how to use worksheet templates, use scenarios to make projections about data, and use Goal Seek and Solver. Students will also learn how to use auditing tools.

Excel 2003 105: Visual Basic Programming
This course is designed to give experienced Excel users proficiency in creating procedures that run in response to specific events, creating user forms to accept or display data, validating the data entry in user forms, and debugging and handling errors in code.
Available dates and detailed description

Excel 2003: Pivot Tables Data Crunching
This course will help students organize and analyze data. You will be able to create basic pivot tables, increase your productivity, and produce reports. This will also help output complex pivot reports with drill-down capabilities and build a dynamic pivot table reporting system.
Available dates and detailed description

Excel VBA Forms
In this course students will learn how to enhance their macros by creating User Defined Forms. Because Microsoft uses the same VBA editor for both 2003 and 2007, this course is appropriate for both versions.
Available dates and detailed description

Excel 2007 101: All About Worksheets
This class is for new Excel users who want to learn to create and modify a spreadsheet, enter text and values into cells, create formulas and functions, use Autofill, format, insert and delete columns and rows, and to format, print and save documents. Even if you have used Excel on some level or are a self-taught user, you will learn a variety of short cuts and time saving tricks to enhance your spreadsheet use.
Available dates and detailed description

Excel 2007 102: Formulas, Functions, & More
The primary focus of this class is to use formulas, functions with large worksheets. We will cover how to create a formula using "if" statements, "ISError", "Or", "And" and many more formula creation techniques. We will cover functions such as "Vlookup", "Hlookup", "Round", "FV", "PMT" and many more. You will expand your knowledge of the management of larger spreadsheets, working with range names, and techniques to manipulate large worksheets. The end result will be the ability to create large budgets, lists, and information you need to manipulate Excel.
Available dates and detailed description

Excel 2007 103: Databases, Pivot & Data Tables
Students will learn how to sort and manage data in lists; filter and query data, use database functions and import and export information and documents. Participants also will learn the basics about Pivot Tables, creating and formatting them. Discover the use of data series and data tables in this class.

Excel 2007 104: Macros & Analytical Tools
This class teaches experienced Microsoft Excel users how to create and edit macros, use custom toolbars and buttons, and create new macro buttons. Students will learn how to use worksheet templates, use scenarios to make projections about data, and use Goal Seek and Solver. Students will also learn how to use auditing tools.
Available dates and detailed description

Excel 2007: Formulas & Functions - Webinar
In this 2-hr Webinar, you will learn about many of the functions and formulas available in Excel. This course will give users the necessary tools to make useful and accurate analysis of data for reporting and data manipulation. It is designed for any student who works with and analyzes large amounts of data.
Available dates and detailed description

Excel 2007: Graphics & Charting - Webinar
This two-hour webinar will teach the student how to create and modify a chart. Charts are visual representations of your data, and, as the old adage states, “A picture is worth a thousand words”. Add a chart to your worksheet and save yourself from having to use those thousand words to explain your worksheet data. Excel provides standard and custom charts types that can be used to describe your data more effectively.
Available dates and detailed description

Excel 2007: Macros - Webinar
This two-hour webinar teaches Microsoft Excel users how to create and edit macros, use custom toolbars and buttons, and create their own macro buttons. This class will cover different techniques to develop macros and look at various ways to create the same macro. It will also touch on the Visual Basic editor, (the stored format of macros), to make basic changes to parameters. Students will have a better understanding of macros upon completion of this training session.
Available dates and detailed description

Excel 2007: Pivot Tables - Webinar
This two-hour Webinar will help students organize and analyze data using, Pivot tables and Pivot Charts. Pivot tables allow you to summarize and organize large databases into manageable and understandable reports. After the pivot table is created, it will be necessary to modify it to obtain the desired formatting and adjustments. This will also show how to manipulate complex pivot reports with drill-down capabilities, and build a dynamic pivot table reporting system.
Available dates and detailed description

Migrating to Excel 2007
This 90-minute ExecuTrain Express course is designed for current Excel users who are migrating to Excel 2007. Class participants will learn how to take advantage of Excel 2007’s improved charting engine and its brand-new Page Layout view. Participants will also learn how to use Excel 2007’s powerful Conditional Formating feature, which applies special formatting to cells when certain conditions are met. Students should take this class, which focuses specifically on Excel's new features, after taking the Migrating to Office 2007 course.
Available dates and detailed description