Excel 2003 - Level 2

DESCRIPTION
This course takes the beginner into more of the time saving features of Excel, exploring many different types of built in functions. It also introduces Excel as a possible database application. You look at graphically representing your data as well as improving its appeal with graphics.

PREREQUISITES
You need to be comfortable with Excel basics, including using sum functions and typical navigation around a spreadsheet.


VIEWING WORKSHEETS

• Customising View Options
  
• Displaying And Customising Toolbars
  
• Hiding Workbooks And Worksheets
  
• Freezing Panes
  
• Grouping And Ungrouping Worksheets
  

MORE FORMATTING TECHNIQUES

• Using Styles
  
• Conditional Formatting
  
• Using The Format Painter
  
• Using Guidelines
  
• Hiding And Displaying Cells
  

MORE FORMULAS AND FUNCTIONS

• Using The Series Command
  
• Using The Insert Function Wizard
  
• Using The Excel Function Categories
  
  • Most Recently Used Functions
    
  • Financial Functions
    
  • Date & Time Functions
    
  • Math & Trig Functions
    
  • Statistical Functions
    
  • Lookup & Reference Functions
    
  • Database Functions
    
  • Text Functions
    
  • Logical Functions
    
  • Information Functions
    
  • Correcting Formulas
    
• Using The Formula Error Checker
  
• Using The Formula Auditing Toolbar
  
• Using The Watch Window
  

DATABASE AND LIST MANAGEMENT

• Using Databases
  
• Creating And Editing A Database
  
• Sorting A Database
  
• Using Autofilters
  
• Advanced Filters
  
• Working With Filtered Data
  
• Using Data Forms
  

CHARTS

• Chart Wizard
  
• Chart Toolbar
  
• Working With Charts
  
• Formatting The Chart
  

DRAWING AND PICTURE OBJECTS

• Drawing Toolbar
  
• Working With Autoshapes
  
• Creating Text Boxes
  
• Adding Pictures
  
• Layering Objects
  
• Grouping And Ungrouping Objects
  

EXCEL 2003 AND OTHER APPLICATIONS

• Converting Files From Other Applications
  
• Copying Data From Another Application
  
• Embedding And Linking Objects
  
• Hyperlinks
  
• Managing Links