Microsoft Excel 2003 Class 3
| Duration: | 1 day |
| Prerequisite: | Excel Intermediate or equivalent experience. |
| Course Materials: | Course manual with CD containing exercises, 144 pages |
| Prices: | $195 for 1 student (one-on-one training) $160 each for 2 to 3 students $130 each for 4 to 6 students $130 for the first 6 students, $100 for each additional student |
| Description: | Students learn advanced functions, table arrays, and database features. Students also learn how to group and subtotal list data and manipulate list data using Pivot Tables. Students learn how to design the "perfect" worksheet containing formatting, formulas, and validation features and save it as a template so all the hard work can be recreated in seconds. They also learn to automate tasks by creating and using macros. |
Advanced Functions, Table Arrays, and Database Features
- Using Named Ranges, Cells, and Constants
- Named Ranges
- Naming Cells as Bookmarks
- Naming Constant Values
- Using Lookup and Reference Functions
- The Lookup Functions
- The Reference Functions
- Using Database Functions and Features
- Excel’s Database Features
- The Database Functions
- Reviewing Other Functions
- Array-Entered Formulas
- Constructing Array-Entered Formulas
- Using Array-Entered Formulas
Advanced Data Organization and Display
- Summarizing Data
- Using Outlining When Data Is Already Subtotaled
- Creating Subtotals and Outlines at the Same Time
- Consolidating Data
- Linking Data
- Creating Simple Links to External Data
- Using Linked Data in Formulas
- Dealing with Broken Links
- Using Pivotal Reports
- Manipulating Data Layout with a PivotTable Report
- Producing a Pivot Chart
- Using Advanced Formatting Techniques
- Controlling Data Display with Custom Formats
- Controlling Data Display Using Conditional Formatting
Advanced Template Design and Workbook Security
- Designing Templates
- Understanding Templates and How They Work
- Editing Existing Templates
- Creating Your Own Templates
- Organizing Your Templates
- Workbook Security and Protection
- The Importance of Workbook Properties
- Worksheet and Workbook Protection
- File Protection
- Macro Security
Data In and Data Out
- Introduction to Converters
- Data In
- Opening Different File Types in Excel
- Bringing Data into Excel Using Alternative Methods
- Data Out
- Moving and Copying Data Out of a Worksheet
- Saving and Editing Excel Files in Different Formats
- Importing and Inserting Excel Worksheets into Other
- File Types
- Saving Workbook Structure Using XML
Working with Macros
- Working with Macros in One Workbook
- Recording New Macros
- Editing Macros
- Copying Macros
- Assigning Macros to Command Buttons
- Working with Macros in All Workbooks
- Creating a Personal Macro Workbook to Store
- Global Macros
- Assigning Macros to Toolbars and Menus
Customizing Excel and Setting Defaults
- Customizing Toolbars and Menus
- Setting Toolbar and Menu Options
- Creating New Toolbars and Adding Buttons
- Editing Toolbar Buttons and Menu Items
- Working with Excel’s Options Dialog Box
- Excel’s View Options
- Excel’s Calculation Options
- Excel’s Edit Options
- Excel’s General Options
- Excel’s Transition Options
- Excel’s Chart Options
- Excel’s Color Options
- Excel’s International Options
- Excel’s Save Options
- Excel’s Error Checking Options
- Excel’s Spelling Options
- Excel’s Security Options
- Creating Default Workbooks and Worksheets
- Changing Your Default Workbook
- Changing Your Default Worksheet
- Restoring Excel’s Default Workbook and Worksheet