giving people the skills to succeed  
search our website
Courses > IT Courses > Microsoft Excel XP Intermediate
 
   
 
Microsoft Excel XP Intermediate
 
Target Audience:  

Users who already have some experience of using Excel who need to create spreadsheets which include calculations, multiple sheets and charts.

 
   
Objectives:  

By the end of the course users will be able to create multiple sheet spreadsheets, use logical functions, sort, filter and subtotal data.  Users will also be able to present data in a graphical format.

 
   
Prerequisites:  

Users need to be able to design and create simple spreadsheets which include basic formulae and the use of AutoSum.  They should also be able to use simple formatting tools and use cut, copy and paste effectively.

 
   
 
       
     
  Duration: 1 Day
  Cost: £150 + VAT
     
 
  Course Date Location
     
Demand led
Call to request dates
     
     
         

Working with Toolbars

  • Customising Toolbars        
  • Creating a Custom Toolbar
 

Working with Multiple Worksheets

  • Moving Between Worksheets
  • Inserting, Deleting & Renaming Worksheets
  • Moving & Copying Worksheets
  • Using Group Editing
 

More Formulae & Functions

  • Creating IF Statements
  • Using Dates in Calculations
  • Calculating Percentages
  • Entering Formula Across Worksheets
 

Worksheet Customisation

  • Naming Cells and Ranges
  • Conditional Formatting
  • Creating a Custom Number Format
  • Password Protecting a Workbook
  • Protecting Sheets and Cells
  • Splitting a Worksheet into Panes
  • Freezing Worksheet Titles
  • Inserting a Page Break
 
   

Data Lists – Essential Skills

  • List Terminology
  • Sorting A List of Data        
  • Filtering Data Using AutoFilter
  • Using Automatic Subtotals
 

Charts –Essential Skills

  • Creating Charts & Graphs
  • Formatting Chart Objects
  • Modifying the Chart Layout
  • Adding & Removing Data Labels
  • Using Pie Charts
  • Previewing and Printing Charts