Continuing Education

Continuing Education

SEARCH FOR A CLASS:

Spreadsheets Online Classes

Introduction to Microsoft Excel 2003
Discover dozens of shortcuts and tricks for setting up fully formatted worksheets quickly and efficiently. Learn the secrets behind writing powerful formulas, using functions, sorting and analyzing data, creating custom charts, creating 3-dimensional workbooks, building links, and creating macros and custom toolbar buttons.

Intermediate Microsoft Excel 2003
Learn how to work faster and more productively by using many of Excel 2003's powerful features, such as the PivotTable, Solver, and AutoFilter. Build worksheets with decision-making capabilities, and learn to use advanced graphing techniques.

Advanced Microsoft Excel 2003
Maximize your investment in Microsoft Excel by learning advanced techniques that most users don't even know exist. In this practical, hands-on course, you'll learn how to use scenarios and data tables to quickly perform multiple what-if analyses. You'll discover a variety of advanced pivot table techniques, like creating calculated fields and calculated items. You'll be able to use validation to protect the integrity of your worksheets from other, less experienced users. You'll become adept at consolidating and importing data, and you'll master the art of conditional formatting to highlight duplicate entries and other common worksheet problems. Impress your coworkers by learning how to add functional and eye-catching controls to any worksheet, and find out how to nest one function inside another to accomplish just about anything Excel has to offer.

Introduction to Microsoft Excel 2007
Work with numbers? Then you need to learn Excel 2007. In this unique six-week online workshop, you'll discover dozens of shortcuts and tricks for setting up fully formatted worksheets quickly and efficiently. You'll also learn the secrets behind writing powerful mathematical formulas, using the function wizard to quickly and automatically calculate statistics, loan payments, future value, and more. You'll also learn the best ways to sort and analyze data, create custom charts and graphs, create 3-dimensional workbooks, build links between files, endow your worksheets with decision-making capabilities, and automate oft-repeated tasks with macros and buttons.