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.
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.
Available dates and detailed description
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.
Available dates and detailed description
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.
Available dates and detailed description
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 2007: Level 1 - Worksheets, Formulas & Formatting
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: Level 2 - Advanced Functions, Charts & PivotTables
In this course, you will use Microsoft Excel 2007 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas. You will apply visual elements and advanced formulas to a worksheet to display data in various formats.
Available dates and detailed description
Excel 2007: Level 3 - Macros, Auditing & What-If Analysis
In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications.
Available dates and detailed description
Excel 2007: Virtual Training - Formulas & Functions
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.
Virtual classes are interactive training sessions delivered in real-time via the Web.
Available dates and detailed description
Excel 2007: Virtual Training - Graphics & Charting
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.
Virtual classes are interactive training sessions delivered in real-time via the Web.
Available dates and detailed description
Excel 2007: Virtual Training - Pivot Tables
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.
Virtual classes are interactive training sessions delivered in real-time via the Web.
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