Description
Mastering Microsoft Excel 2003 & 2002
DESCRIPTION:
Mastering Excel 2003 is a must-have simulation for the beginner, as well as a handy reference tool for the professional Excel user.
The step-by-step narration guides you through a myriad of Excel 2003 functions, and helps you apply them? directly and immediately? to your own real-world projects.
FEATURES:
Master Microsoft Excel 2003 Immediately
Follow Step-by-Step Narrated Instructions
Learn Special Problems Solving and Techniques
Work with Dynamic Simulations, Not Sequential Static Displays
Up to 20X Faster than Learning from a Book
Build Your Own Lessons for Classroom or Individual use
Training Time: Approximately 36 Hours
Lesson List:
Lesson 1: File and Edit
Lesson 2: View and Insert Menu
Lesson 3: Common Formatting
Lesson 4: Data Management
Lesson 5: Chart, Tables and List
Lesson 6: Using Tools
Lesson 7: Building Formula
Lesson 8: Working with XMLs
Lesson 9: Develop Macros
Lesson 10: Windows and Help Menu
Lesson 11: Understanding VBA
Tips & Tricks:
1: Conditional Formula
2: Group Formula
3: Employee Time Stamp
4: Using AutoFilter
5: Generate Random Number
6: Dynamic Chart
7: Data link/Security Between Workbooks
8: Web Queries
9: Commercial Rental Calculator
- If Excel 2003 is currently installed on your computer, you may use it to practice along with Mastering Excel 2003. However, no actual Excel 2003 program is needed to run the dynamic simulations on this CD!
MINIMUM SYSTEM REQUIREMENTS:
Windows:
Operating System: Windows 98 or Later
Processor: Pentium 133 Mhz or higher
Memory: 32MB
Hard Drive: 10MB
24X CD-ROM
Mac:
Operating SystemL OS 8 or Later
Processor: G3 or higher
Memory: 32MB
Hard Drive: 20MB
24X CD-ROM
PACKAGING:
Retail DVD Case