|
The strength of How To Gurus training lies in the thoroughness and clarity of its content and the unique teaching style of the instructor.
Each set comes shrink wrapped in its own DVD -style retail case.
This is the NEW video training from Training Guru George Peirson. Tens of thousands have already benefited from Mr. Peirson's professional training sets.
This isn't a redo of an old title, but a completely new look with new original demonstrations for this powerful software.
Mr Peirson has authored over 30 multimedia training titles. His articles have appeared in numerous publications including:
|
Our DVD is filled with 7 hours of video tutorial training.
83 individual video lessons.
Covers every topic that you need to know.
Includes all working files and examples.
We also have a CD version available,
just request the CD version when you make your payment.
Note: These are Computer DVDs and will not play on a TV style DVD player
Note: this training is for Windows and does not come with the actual Excel program
Complete List of Videos
Microsoft Excel XP - 2003
|
Part 1
Excel Overview
1. How to use this Training
2. Overview
3. What's New in Office XP
4. What's New in XP 1
5. What's New in XP 2
6. What's New in XP 3
7. What’s New in 2003 1
8. What’s New in 2003 2
The Excel Workspace
9. The Workspace
10. The Office Assistant
11. Customize
12. Properties
Document Basics
13. Open & New
14. Data
15. Formulas
16. Charts
17. Cel Formatting
18. Pictures
19. Saving
20. Printing |
Microsoft Excel XP - 2003
|
Part 2
The Menus
1. File
2. 2003 File Menu
3. Edit
4. View
5. 2003 View Menu
6. Insert
7. Format
8. Tools
9. 2003 Tools Menu
10. Data
11. 2003 Data Menu
12. Window & Help
13. 2003 Window Menu
14. 2003 Help Menu
Formulas & Functions
15. Formulas
16. References
17. Insert Function Wizard
18. Formula Auditing
19. Functions
20. Dates
21. Text
22. Information
Layout & Formatting
23. Cells & Rows
24. Moving & Copying
25. Sheets
26. Comments
27. Cell Attributes
28. Borders & Shading
29. Numeric Formats
30. Hiding & UnHiding |
Microsoft Excel XP - 2003
|
Part 3
Cell Referencing
1. Relative & Absolute
2. Mixed Referencing
3. 3D Referencing
4. R1C1 Style
Printing
5. Page Setup
6. Header & Footer
7. Print Preview
8. Printing Controls
Worksheets & Workbooks
9. Splitting & Freezing
10. Troubleshooting
11. Templates
12. Smart Tags
13. Workbooks
14. Multi-Sheet Workbooks
15. Comments
16. Collaboration
17. 2003 Shared Workspace
Auditing & Advanced Functions
18. Tracking Changes
19. Cell Relationships
20. Error Correction
21. Circular References
22. Conditional Formulas
23. Calculation Operators
24. Order Precedence
25. Nested Functions
Common Formulas
26. Look Up Values
27. Multiplication Table
28. Convert Measurements
29. Text & Other Functions
30. Date & Time Entry
31. Formatting Dates
32. Convert Times
33. Insert Julian Dates |
| |
Minimum System Requirements |
| |
Pentium class CPU at least 500MHz minimum |
| |
128 MB of RAM (256 MB for Win NT 4.0 or 2000) |
| |
DVD-ROM drive, at least 4x recommended. Able to read DVD-R format |
| |
Windows 98, ME, NT, 2000 or XP |
| |
SVGA monitor at least 16 bit color & 1024x768 resolution |
| |
Sound card with speakers or headphones |
| |
The Faster your system, the better the demos will run | |
|
