Microsoft Excel Virtual Training Using the Microsoft helpdesk

These systems are more than just virtual training systems. Due to easy accessibility via the Intranet, employees will use them as a help facility as well, giving them Microsoft Excel Desktop training on the fly. Allowing you to empower your business to leverage Microsoft software with confidence.

Microsoft helpdesk covers virtual training in Microsoft Excel XP and Microsoft Excel 2004

The Microsoft Excel helpdesk covers the following:

• Opening Microsoft Excel
• The Workbook environment
• Modifying the toolbar settings
• Workbook Properties
• Page Setup
• Understanding the Open dialog box
• Excel Help
• Managing the Task pane
• Working with multiple worksheets
  
  • Renaming worksheets
  • Insert and delete worksheets
  • Moving and copying worksheets
    
• Adjusting column width and row height
  
  • Hiding and unhiding rows and columns
  • Inserting columns and rows
  • Deleteing rows and columns
  • Merging cells
    
• Entering and correcting data
  
  • Changing the font and size of text
  • Change the color of text
  • Bold, underline and italicize text
  • Other underlining options
  • Other font options
  • Aligning text in a cell
  • Inserting symbols
  • Undo and Redo
  • Cut, copy and paste
  • Using the Paste Special function
  • Pasting a hyperlink
  • Moving data
  • The Autofill feature
  • Inserting comments
  • The AutoFormat feature
  • AutoCorrect options and settings
  • Checking spelling in a worksheet
  • Find and Replace text in a workbook
  • Inserting Hyperlinks
  • External Hyperlinks
    
• Entering Numbers
  
  • Formatting number styles
  • Dates and Times
  • Labels and Values
    
• Adding borders to cells
  
  • Filling cells
  • Applying a color background
  • Insert a picture background
    
• Page Break view
  
  • Previewing your work for printing
  • Printing your workbook
  • Printing one worksheet
    
• Saving a file for the first time
• Closing your workbook
  
  • Opening a new workbook
  • Opening an existing workbook
    
• Sorting Data
  
  • Multi-level sorting
    
• Filtering Data
• Recording Macros
  
  • Running a macro
    
• Linking cells in different workbooks
  
  • Modyfying linked workbooks
  • Using Workspaces
    
• Creating Graphics
• Moving and sizing graphics
• Grouping Graphics
  
  • Adding text to graphics
  • Using AutoShapes
  • Enhance objects
  • Inserting pictures using Clip Art
  • Insert a picture from a file
  • Using WordArt
    
• Using formulas to calculate values
  
  • Error Messages in a spreadsheet
  • The Error #####
  • The #VALUE! Error
  • The error #DIV/0!
  • The #NAME? Error
  • The error #N/A
  • The error #REF!
  • The #NUM! error
  • The error #NULL!
  • Using the Subtotal function
  • The Outline function
  • Outline symbols
  • Absolute cell referencing
  • The IF Function
  • The PMT function
  • The RATE function
  • Auditing features
  • The VLOOKUP function
  • The HLOOKUP function
    
• Creating Pivot Tables
  
  • Adding and deleting fields in Pivot tables
  • Grouping and summarizing data in a pivot table
  • Interactive Pivot Tables
    
• Creating a chart
  
  • Formatting your chart area
  • Modifying chart data
    
• Diagrams
  
  • Insert objects
    
• Protecting your worksheet
• Freeze Panes
• Creating a Template
• Speech
  
  • Speech Options
  • Voice Training
  • Dictation and Voice commands
  • Handwriting
    
• E-mail your workbook
• Exit Excel
  

If you would like more detailed information or require a demontration please contact us at (click here)