Instructor-Led Virtual Training on CD from Makau Corp.
Microsoft Excel 2003
This course has been designed to get you up and going with Microsoft’s latest edition of Excel, the most popular spreadsheet application in the marketplace today, quickly, easily and painlessly. The instructor guides you through the use of everything from basic spreadsheet functions to very advanced techniques and functions ensuring your success and enhanced productivity.
Course Instructor: Dennis P. Taylor
Dennis P. Taylor has spent over 14 years presenting PC software training to individuals in classrooms and seminars, including employees at Amoco, IBM, and many other companies. He specializes in spreadsheet software and has co-authored several books for spreadsheets. Dennis brings a combination of in-depth knowledge and training experience to his spreadsheet training courses. Watch and Learn in minutes with Dennis.
Course Outline
Excel 2003: Level 1
Getting Started
- Starting Excel
- Workbooks and Worksheets
- Task Pane
- Menu Bar and Shortcut Menus
- Toolbars
- Navigation and Mouse Pointer
Entering Data
- Data Entry
- Auto-Fill Entry
- Erasing Data
- AutoComplete and Preselections
- Undo and Redo
Saving, Opening and Closing Files
- File Save and File Save As
- Opening a File
- Closing a File
- Creating a New Workbook
Entering Formulas
- Methods of Entering Formulas
- Repeating Formulas in Adjacent Fields
- Formula Operators
- Additional Formulas
Basic Excel Functions
- Totals and Averages
- Function Overview
Formatting
- Adjusting Column Widths and Row Heights
- Formatting Toolbar
- Numeric Formatting
Changing Worksheet Layout
- Inserting Columns, Rows and Cells
- Deleting Columns, Rows and Cells
- Moving Cells
- Copying Cells
Printing
- Using Print Preview and Page Setup
- Printing Controls
- Printing
Excel Help System
- Using Excel Online Help
- Using Excel Offline Help
Excel 2003: Level 2
Additional Formatting
- Cell Alignment and Orientation
- Borders
- Centering Text Across Columns
- Hiding and Unhiding Columns and Rows
Conditional Formatting
- Formatting Based on Values and Multiple Conditions
- Avoiding Overlapping Conditions
- Using a Formula to Control Formatting
Specialized Numeric Formatting
- Custom Category
- Special Category
Cell References
- Absolute References
- Mixed References
Range Names
- Naming and Using Range Names
- Additional Creation Methods
- Pasting a List of Range Names in a Worksheet
- Deleting Range Names
- Assigning a Name to a Value
Formula Auditing Techniques
- Using the Formula Auditing Toolbar
- Tracing Dependent Cells
- Tracing Precedent Cells
Cell Protection Techniques
- Locking/Unlocking Selected Cells
- Protecting/Unprotecting a Worksheet
Find and Replace
- Matching Entire Cells and Case Factors
- Formulas and Wildcard Characters
- Find and Replace by Format
Adjusting Worksheet Views
- Freeze/Unfreeze Panes
- Horizontal and Vertical Split Screens
Customizing Toolbars
- Adding and Removing Buttons
- Economizing Buttons and Resetting Toolbars
- Creating New Tool Bars
Excel 2003: Level 3
The "IF" Function
- "IF" Functions and Relational Operators
- Using Text in "IF" Functions
- Logical Operators ("AND" and "OR") with "IF" Functions
- Nested "IF" Functions
- Getting Table Data with "VLOOKUP" Function
Dates and Time
- Using Dates as Values
- Entering a Series of Dates
- Date/Time Techniques
Multi-Sheet Workbooks
- Renaming Sheets and Coloring Tabs
- Inserting and Deleting Sheets
- Moving, Copying and Grouping Sheets
- Formulas Across Multiple Sheets
Multiple Workbooks
- Opening and Displaying Multiple Workbooks
- Moving and Copying Sheets Across Workbooks
- Linking Formulas Across Workbooks
- Locating and Maintaining Links
Features and Settings
- Show/Hide Gridlines and Formulas
- Recently Used File List and New Workbook Settings
- Other Settings and Features
Overview of Charting
- Quick Chart Creation
- Chart Types
- Titles, Gridlines and Scaling
- Formatting Basics
- Printing and Copying Charts
Overview of Database Features
- Sorting Data
- Creating Subtotals
- Filtering
- Pivot Tables
Excel 2003 Level 4: Charts & Graphical Features
Creating a Chart
- Quick Chart Creation
- Chart Wizard
- Using the Chart Toolbar
- Copying, Moving and Re-shaping a Chart
- Changing a Chart's Location
Formatting a Chart
- Selecting Elements to Format
- Color Backgrounds and Fill Effects
- Controlling Text Size and Position
- Series Order and Column Options
Chart Content
- Titles and Data Labels
- Gridlines and Legends
- Scaling Column and Line Charts
- Add and Remove Data from a Chart
- Adding Trendlines
Specific Chart Types
- Line Charts
- Column Charts
- Pie Charts
- Combination Charts (Dual Axis)
Printing Charts
- Printing Chart from A separate Sheet
- Printing a Chart Located on a Worksheet
Annotating Charts and Worksheets
- Adding Text and Arrows
- Inserting, Displaying, Hiding and Editing Comments
- Printing Comments
Outlining and Custom Views
- Group and Outlining Capabilities
- Custom Views
Drawing Toolbar
- WordArt
- Shapes, Lines and Arrows
- Coloring Objects and Adding Text
- Clipart
- Applying 3-D and Shadow Effect
Excel 2003 Level 5: Database Features
Excel Databases
- List Attributes and Building Lists
Data Form
- Setting a Single Record with Formulas
- Adding Records to a Database
- Finding Records
Data Validation
- Establishing Data Entry Criteria
- Using Formulas and Lists to Restrict Data
- Using Data Validation on Existing Data
- Data Validation Exclusions
Data Sort
- Sorting from a Menu
- Sorting from the Toolbar
- Multiple-Key Sorting
- Sorting with Custom Lists
- Sorting Columns
Data Subtotals
- Single Level Subtotals
- Multiple Level Subtotals
Data Filter
- Criteria
- Multiple Column
- Creating Custom Filter
- Top Ten
- Copying Formatting and Sorting Data
- Using "SUBTOTAL" Function to Count Results
- Advanced Filter
Data Functions
- "SUMIF", "COUNTIF"
- Array Formulas
- Database Functions
MOS ELEMENTS
Excel 2003 Level 6:
MOS (Microsoft Office Specialist) Additional
Topics
Templates
- Saving a Skeleton Workbook as a Template
- Creating a New Workbook from a Template
- Editing a Template
Protection
- Workbook Protection
- File Password
- Macro Security
Sharing Workbooks
- Establishing Sharing
- Tracking Changes
- Merging Workbooks
Exporting Data From Excel
- Exporting to Access
- Exporting to Word
- Saving as a Text File
- Saving as a New Folder
Importing Data to Excel
- Importing Data Using the File Open Command
- Importing or Copying External Data
- Hyperlinks
- Tools Research
Excel and the Web
- Importing Web Data
- Saving Excel Data as a Webpage
Customizing Excel Environment
- Creating a New Menu
- Creating a Macro
- Running a Macro
- Editing a Macro
Excel 2003 Level 7: MOS Special Topics
Functions
- Statistical Functions
- Date and Time Functions
- Financial Functions
- Mathematical Functions
Formula Troubleshooting
- Formula Watch Window
- Evaluate Formula Feature
Data Analysis Tools
- Goal Seek
- Solver
- Scenarios
- Data Table
Consolidating Data
- Consolidate By Position
- Consolidate By Category
Managing a List
- Creating a List
- Adding Data to a List
- Adding Totals
File Properties
- File Properties
Workbook/Worksheet
- Worksheet Styles
- Autoformatting
- Showing Multiple Worksheets
- Comparing Workbooks
Excel 2003 Level 8: Tips & Tricks For Excel 2003
Tips, Tricks & Shortcuts
- Navigation Shortcuts
- Selection Shortcuts
- Data Entry Shortcuts
- Operational Shortcuts
- Formula and Functions Tips
- Numeric Formatting
- Data Expansion
- Drag & Drop
- Graphical Shortcuts