Advanced Excel
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...  
Advanced Excel

Course Contents:

  • Customising a Toolbar
  • Using Solver
  • IF Statements
  • VlookUp and SUMIF
  • Using the Subtotals Feature
  • Protection
  • Recording Basic Macros
  • Creating a Style
  • Importing External Data (CSV)
  • Consolidating a Workbook
  • Creating Views
  • Using the Report Manager
  • Creating a Menu sheet
  • Using IF and Functions
  • Error Trapping
  • Validation
  • Drop Down Lists
  • More Functions
  • Database Functions
 
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...  
My Location
Results for location are highlighted in the table below. Click here to remove highlight
The course either has new dates in data loading, or is only run as a dedicated or In Company course.
Tools
 
Key Details
Duration1 day
 
£190
per delegate
 
 
Bookings Helpline: 01933 233884 (Monday to Thursday - 8:00am to 5:30pm and Friday 8:00am to 5:00pm).