Self Study, Tutorial Video on CD - DVD. Tutor Julia Kelly guides you using step-by-step examples. Learn directly from your own desk high quality training videos at an affordable price. It works on both PC and Mac, this course is ideal for Beginners and Advanced users
These Microsoft Excel tutorials cover everything that the user needs to carry out a multitude of tasks using this spreadsheet application. Author Julia Kelly uses a step by step approach and practical examples to ensure that even the complete novice can follow, understand and then execute what as been taught, due to the unique format in which these tutorials are presented knowledge retention is extremely high and even the most complex tasks can be accomplished very quickly.Releated topics : Microsoft Excel 2007 Tutorials . Watch our free Microsoft Excel 2002 Tutorial Videos by clicking the blue lesson links below.
Microsoft Excel 2002 Tutorial CD / DVD
Create the best self-paced learning environmentright on your own desktop.
Professionally created, comprehensive video based training that's easy to follow. At an unbelievable price.
Learn for FREE - NOW. To help you evaluate this training CD / DVD the first 3 chapters are available for free, click on any of the links below for a FREE DEMO.
Problems Playing the Demos?
Benefits
- Professional Tuition from an Expert
- Free Certificate with Each Tutorial
- Works on PC or Mac
Just Released This Week
Logic Pro 9 Tutorial Video »
Topics Covered on this Training Video Include:
Introduction
Introduction
- About Excel
- Open/ Save/Close Workbooks
- What’s Inside the Workbook
- Menus and Toolbars
- What’s on a Worksheet
- Getting Assistance from Excel
- Select and Navigate Cells
- Enter Data
- Edit and Delete Data
- Undo and Redo
- Cut/Copy/Paste
- About the Office Clipboard
- Drag and Drop
- AutoFill
- More Ways to Enter Repetitive Data
- AutoCorrect
- Use a Data Entry Form
- Validate Data During Entry
- Resize Rows and Columns
- Insert and Delete Rows/Columns/Cells
- Rename Worksheets
- Move and Copy Worksheets
- Insert and Delete Worksheets
- Freeze and Split a Worksheet
- Open Multiple Windows
We hope you enjoyed the free videos above. To watch all this course including the
chapters below please purchase the CD.
Simple Calculations
$149.95
- Calculate Without a Formula
- Use AutoSum to Write Formulas
- Formula Structure
- Create Formulas
- Edit Formulas
- AutoFill Formulas
- Relative and Absolute References
- Functions
- Use the Function Wizard
- Name Cells and Ranges
- Use Names in Formulas
- AVERAGE/MAX/MIN
- SUMIF and COUNTIF
- VLOOKUP
- PMT
- NOW/ TODAY/CONCATENATE
- IF and Nested Functions
- Sort Data
- Filter Data with AutoFilter
- AND and OR Filters
- Calculate Filtered Records
- PivotTables
- Consolidate Data
- Subtotal a Worksheet
- Text Formatting
- Align and Wrap Text
- Number Formats
- Date and Time Formats
- Custom Formats
- Borders and Shading
- Conditional Formatting
- Format Painter
- Styles
- AutoFormat a Table
- Transpose Tables and Merge Cells
- Format Several Worksheets Identically
- Save a File as a Template
- About Charts
- Create a Chart
- Resize and Relocate a Chart
- The Chart Toolbar
- Chart Options
- Legends/Titles/Axes
- Series Orientation and Order
- Create 3-D Charts
- Explode a Pie Chart
- Add Data Labels and a Data Table
- Trendlines
- Secondary Axes
- Format Chart Elements
- See a Print Preview
- Create Page Headers and Footers
- Set the Print Area
- Print a Selection
- Centering/ Margins/Gridlines
- Print on a Specific Number of Pages
- Print Multiple Worksheets/Copy/Collate Pages
- Print Row and Column Labels on Every Page
- Print Charts
- Share Data Between Workbooks
- Copying/Linking/Embedding Data
- Share Data with Other Programs
- Share a Workbook with Other Users
- Hide Worksheets
- Protect Cells
- Protect Worksheets and Workbooks
- Use Goal Seek to Find Answers
- Use Scenarios to Compare Alternatives
- Locate Worksheet Errors and Invalid Data
- Customize Your Toolbars
- Create a Custom Toolbar
- Automate with Macros
- Record a Macro
- Edit a Macro
- Assign a Macro to a Toolbar Button
- Create a Hyperlink to Open Another File
- Insert a Picture
- Move/Resize/Crop
- Draw Shapes and Lines
- Draw AutoShapes and Assign Macros
- Arrange and Group Drawing Objects
- Use Drawn Objects in Charts
- Create Text Boxes
- Create Worksheet Comments
About this Microsoft Excel 2002 Training CD
| Title : | Microsoft Excel 2002 |
|---|---|
| Tutor : | Julia Kelly
Other tutorials by Julia Kelly |
| Videos : | 109 Lessons- Video run time: 6 Hours |
| Delivery time: | Only 3 working days |
| Compatibility: | Vista, 2000, XP, Windows 7, Mac OS, OSX |
| Released | 2003 |
| Price Australia / New Zealand & Asia | AUD $149.95 (+ $10.00 Shipping ) |
840 In Stock
Purchase Orders from Schools, Colleges, Government and Military Accepted
Multi User Network Version Available
This training is also available in Multi User format for Schools and Corporate users.
10 Multi User $695
10 Multi User $695 Why use this method of video training?
- Learn Microsoft Excel 2002 from an accredited expert in days.
- Ideal for beginners, these easy to follow videos offer visual clarity.
- Master a full application from basics to advanced for a fraction of the cost of classroom based training, and faster than with a manual.
- Unique teaching method that offers accelerated learning and high retention.
- Used by many large companies, schools, universities,
click to see some of our customers. - Learn from your own desk at a speed that suits you.
- It's cost effective tuition from leading expert tutors.
- Learn at your own pace; training can be stopped, rewound or fast forwarded as required.
- These High Quality Tutorial Videos are on CD / DVD or Online and PC / Mac Compatible. It's Simply the best tuition at an affordable price
Want to hear what our customers say about our products?
Associated Tutorials:
MCAS | Microsoft PowerPoint 2007 | Microsoft Publisher 2007 | Microsoft Excel - Statistics | Excel 2003 | Visual Basic for Excel | Microsoft Excel Automation | Advanced QuickBooks 2008
Microsoft Excel 2002 Related Training Videos:
Free Certificate. Prove Your Credentials
We now offer all customers a free certificate to verify they have undertaken a training course, the unique certification number allows third parties to check the authenticity of your certificate online. After your purchase you can download your free certificate without delay.
Instant Online Access all the Training Videos for only $30.00
Unlimited Accesss to 60,000 Training Video only $30.
Not sure which training CD titles to purchase? Why not join our Online University and have unlimited access to all our tutorial videos for one low price of $30 per month.
Not sure which training CD titles to purchase? Why not join our Online University and have unlimited access to all our tutorial videos for one low price of $30 per month.
No contract , No minimum period, and no commitment on your part.
You can have access to every title we list on this site for just $30 per month. When you sign up, you get instant access with absolutely no restrictions or limits. Log on from any location and learn as much as you like.
When you're finished, cancelling is easy. Just click the cancel button - that's it, no questions - you're in total control.
