Spreadsheets
Microsoft Excel 2007
Excel 2007 New Features - CCE 0098
You have worked with Microsoft Office Excel 2003, the software for improving the management, presentation and distribution of your spreadsheets. Now you need to be aware of the latest release of this software, Microsoft Office Excel 2007. In this four hour course you will learn all the new and enhanced features of this software.
Excel 2007 Level I - CCE 0111
Learn the basics of creating and using spreadsheets. Build a simple worksheet, establish ranges, use formulas, copy and move data and print the sheet.
Excel 2007 Level II - CCE 0112
This course focuses on developing the skill to work with large worksheets using 3-D referencing (linking) through cell referencing and range names. Learn to work with conditional formatting and custom formats as well as managing data and files.
Excel 2007 Level III - CCE 0113
This course teaches the use of charts, graphs and spreadsheets and database capabilities. Topics include chart development, drawing objects, sorting data, working with filters and pivots tables.
Excel 2007 Level IV - CCE 0114
Increase your skills in using spreadsheet formulas with this advanced course on financial formulas. Learn how to reduce keystrokes used in repetitive tasks to a two-keystroke abbreviation by using macros. Effective organization and manipulation of data are keys to successfully using spreadsheets.
Microsoft Excel 2003
Mastering Excel 2003 - CCE 0008
This course is designed for the person that wants to be proficient. Learn all concepts of Excel from beginners through advanced levels. This comprehensive class is 40 hours.
Excel 2003 Level I - TIS 0263
Learn the following basic workbook skills: ranges and simple formulas, working with columns and rows, page setup, formatting numbers, text and cells. Experience with Microsoft Windows is required. Version 2003
Excel 2003 Level II - TIS 0264
Level 2 Excel continues your Experience with Excel. You will learn about automatic formatting and styles, working with data series, conditional and custom formats, using large worksheets, working with multiple spreadsheets, outlines, using paste special, working with labels in formulas, and using multiple workbooks. Experience with Level 1 Excel topics is required. Version 2003
Excel 2003 Level III - TIS 0269
Enhance the look of your worksheets by creating, editing and modifying charts; drawing objects; using additional effects and objects; using auto shapes; working with databases, data forms, and advanced filters; using HTML files, and importing and exporting data. Prior Experience with Excel topics is required. Version 2003
Excel 2003 Level IV - CCE 0018
Topics in this Excel 2003 advanced course include using advanced functions, range names, lookup and logical functions, data tables, recording, and editing macros, custom toolbars, and worksheet protection. Prior Experience with Excel is necessary. $95 Excel 2003 Level V - CCE 0019 Increase your Excel 2003 knowledge in setting excel preferences and using templates and adding valuable comments. Tasks include working with pivot tables, using solver, scenarios and goal seeking. Learn how to share workbooks, consolidate your worksheets and work with the data map.
Excel 2003 Level V - CCE 0019
Increase your Excel 2003 knowledge in setting excel preferences and using templates and adding valuable comments. Tasks include working with pivot tables, using solver, scenarios and goal seeking. Learn how to share workbooks, consolidate your worksheets and work with the data map.
Excel Charting - CCE 0074
This course begins by explaining Excel’s built-in charting basics and goes on to help you master trendlines, AutoShapes, and dozens of other capabilities. You will produce polished, professional charts that command attention. Additionally you will learn the process of filtering your data to gain immediate access to information you require.
Excel VBA - CCE 0009
This training covers VBA programming using Excel 2002 and covers the following topics: using the Visual Basic editor; programming basics; controlling program flow; working with custom dialog boxes; and debugging and error-handling.
Also see the Essential Assistant in Special Topics.
