| More

Microsoft Excel 2008 Training

microsoft excel 2008 training

     
Microsoft Excel 2008 for Mac Training CDs
 
Single User License
$149.00
     
Multi-User Non-Concurrent License:    
Multi-User Non-Concurrent License
$299.00
     

Microsoft Excel 2008 is part of the Microsoft Office 2008 for Mac suite of productivity business applications. A complete redesign from previous versions makes it necessary for both new and experienced users to get some form of training. The programs in the 2008 version of MS Office use the Open Document XML format making it easier to share information with Windows users. Your Excel files created on the Mac are completely compatible with the Excel 2007 version that your Windows-based colleagues use. But before you can begin creating spreadsheets and charts, you'll need to get familiar with the program.

One of the best products you'll find is the self-paced Microsoft Excel 2008 CBT. You'll get a firsthand look at Excel in action and see it demonstrated by a certified instructor without having to take time off from work to attend workshops and classes.

The Microsoft Excel 2008 training CD accomplishes this through the inclusion of full motion Microsoft Excel 2008 training videos. These videos feature an Excel expert who gives you a complete tour of the interface and teaches you how to use the features and functions that power the popular spreadsheet program.

With its new Elements Gallery, Excel has a new look. Some of your old favorite tools will be readily accessible while others will be hard to find. By exploring Excel via the self-paced Microsoft Excel 2008 CBT, you'll know where to find the tools and you'll discover new features along the way.

The Microsoft Excel 2008 training CD comes packed with interactive content, simulations, hands-on activities, and demonstrations. The entire course takes place on your computer according to your needs. You set the pace and can learn Excel as quickly or slowly as you need. Watch the Microsoft Excel 2008 training videos as many times as you want without the pressure to keep up with a rigid training schedule.

Many Excel users never bother to learn what the application is capable of and how to use those capabilities to maximum effect. With a good training program, you can master your spreadsheets. Make sure you know how to get the most out of Excel by selecting the Microsoft Excel 2008 training CD.

Microsoft Excel 2008 for Mac Training Video CBT Features:
   
   
Outline:
   
  Microsoft Excel 2008 Basic

1.0 Exploring Excel
1.1 Exploring the Excel Program Window
1.2 The Office Button
1.3 The Quick Access Toolbar
1.4 Displaying Tabs
1.5 Using Worksheets and Workbooks
1.6 Entering Data in Excel
1.7 Deleting and Replacing Entries
1.8 Saving
1.9 Opening and Closing Workbooks
1.10 Exiting from Excel

2.0 Viewing, and Printing Worksheets
2.1 Views of Excel
2.2 Selecting
2.3 Working with Cut, Copy, and Paste
2.4 Clearing Cell Contents and Formats
2.5 Working with AutoFill
2.6 Printing

3.0 Using Formulas and Functions
3.1 Formula Basics
3.2 Creating Formulas
3.3 Formula Cell References
3.4 Moving and Copying Formulas
3.5 Showing Formulas

4.0 Formatting Worksheet Data
4.1 Formatting Numbers
4.2 Aligning (vertical, rotating)
4.3 Indenting
4.4 Merging and Splitting Cells
4.5 Borders and Fill Colors
4.6 Using AutoCorrect
4.7 Spell Check

5.0 Changing Columns Rows and Cells
5.1 Inserting and Deleting
5.2 Changing Columns and Row Sizes
5.3 Hiding

6.0 Creating Charts
6.1 Creating Column and Bar Charts
6.2 Creating Pie Charts
6.3 Editing Charts
6.4 Changing Chart Types
6.5 Deleting Charts


Microsoft Excel 2008 Advanced

1.0 Using Templates
1.1 Creating Templates
1.2 Customizing Templates

2.0 Worksheet Techniques
2.1 Freezing Columns and Rows
2.2 Page Layout View
2.3 Copying and Moving Sheets
2.4 Headers and Footers
2.5 Continuing Titles
2.6 Page Breaks
2.7 Inserting and Deleting sheets
2.8 Changing the Default Number

3.0 Using Tables and Outlines
3.1 Creating a Table
3.2 Sorting Data
3.3 Filtering Data
3.4 Using Outlines
3.5 Displaying Subtotals

4.0 Advanced Formulas and Functions
4.1 Linking Formulas
4.2 Using Ranges
4.3 Using Names
4.4 If Function
4.5 PMT Function
4.6 Hlookup
4.7 Vlookup

5.0 Protection
5.1 Protecting Workbooks
5.2 Protecting Worksheets

6.0 PivotTables and PivotCharts

7.0 Data Validation

   

 

Related CBT Training Courses:    
     
Dreamweaver CS3 Dreamweaver MX 2004 Flash CS3
Flash MX 2004 InDesign CS2 Illustrator CS3
Illustrator CS2 PhotoShop CS3 PhotoShop CS2
Office 2007 Training Microsoft Vista Training Word 2007
Excel 2007 CBT Outlook 2007 PowerPoint 2007
Publisher 2007 CBT InfoPath 2007 OneNote 2007
Final Cut Pro 6 Microsoft Office 2008 for Mac Excel 2008
Word 2008 PowerPoint 2008 Entourage 2008
Mac OS X Leopard Client Mac OS X Leopard Server Outlook 2003
PowerPoint 2003 Access 2003 CBT Visio 2003
Microsoft XP Training Office 2003 CBT