EXCEL 2003 -- WHAT YOU WILL LEARN:
- EXCEL BASIC
- EXCEL INTERMEDIATE
- EXCEL ADVANCED
- EXCEL POWER USER
- EXCEL PROGRAMMING VBA
- Basic Spreadsheet Terminology
- Excel window and its components
- How to enter and edit data (labels, values and formulas)
- How to modify a worksheet (moving and copying data and formulas)
- How to use Absolute Cell references
- Working with "ranges"
- Using functions (AutoSum, Average, Minimum, Maximum, etc...)
- Formatting worksheets (cells, columns, rows, numbers, etc...)
- How to print a worksheet (or part of a worksheet)
- The basics of creating charts and graphs
- >and much more ...
- Working with large worksheets
- How to work with multiple worksheets and workbooks
- How to customize Excel to fit your style and needs
- Advanced formatting (working with boarders, shading, special numbers, etc...)
- List management (examine lists, sort by lists, and advanced filtering)
- Advanced charting (formatting options, combined charts, graphic elements)
- Documenting and auditing (worksheet/workbook protection, comments, audit trails)
- How to use templates and how to create them
- and more ...
- Working with advanced formulas (using names, decision-functions, nested functions, etc...)
- Lookups and data tables (using MATCH and INDEX, creating Data Tables)
- Advanced list management (creating subtotals, data validation, data forms)
- How to work with PivotTables and PivotCharts
- How to Export and Import in different formats (text files, XML, etc...)
- How to use analytical options (Goal Seek/Solve, ToolPak, scenarios)
- How to work with macros (create and run macros, work with VBA code)
- and more ...
(Extended class -- not included in package price)
- How to use advanced formulas, functions, and arrays
- Using advanced editing and formatting commands and features
- Advanced graphics (create customer charts, working with pictures)
- Analyzing and sharing information (using add-ins, solver models/reports, embedding/linking)
- Advanced customization (custom lists, modifying default settings, automating Excel)
-
(Extended class -- not included in package price)
- What is Visual Basic for Applications (or VBA)
- What is Object Oriented Programming
- Programming Basics (data types, variables, scopes, events, procedures and properties)
- Control structure (decision structures and loops)
- Custom dialog boxes (create user forms and use events)
- Debugging and error-handling