Advanced Excel
Categories: Microsoft Excel
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
 
Course Dates
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...  
1-19 of 19
Tip: Click column names to sort. Click start dates to see scheduled days
LocationDistance (approx)Course Start DateNo. DaysWeb price ex.VATCourse Status 
Newcastle Upon Tyne283 miles Mon 26 Jan 09 1£195      CLICK TO ENQUIRE
    CLICK TO BOOK
Newcastle Upon Tyne283 miles Tue 10 Feb 09 1£195      CLICK TO ENQUIRE
    CLICK TO BOOK
Newcastle Upon Tyne283 miles Tue 10 Mar 09 1£195      CLICK TO ENQUIRE
    CLICK TO BOOK
Newcastle Upon Tyne283 miles Thu 26 Mar 09 1£195      CLICK TO ENQUIRE
    CLICK TO BOOK
Newcastle Upon Tyne283 miles Wed 01 Apr 09 1£195      CLICK TO ENQUIRE
    CLICK TO BOOK
Newcastle Upon Tyne283 miles Wed 15 Apr 09 1£195      CLICK TO ENQUIRE
    CLICK TO BOOK
Newcastle Upon Tyne283 miles Mon 27 Apr 09 1£195      CLICK TO ENQUIRE
    CLICK TO BOOK
Newcastle Upon Tyne283 miles Fri 15 May 09 1£195      CLICK TO ENQUIRE
    CLICK TO BOOK
Newcastle Upon Tyne283 miles Wed 27 May 09 1£195      CLICK TO ENQUIRE
    CLICK TO BOOK
Newcastle Upon Tyne283 miles Thu 11 Jun 09 1£195      CLICK TO ENQUIRE
    CLICK TO BOOK
Newcastle Upon Tyne283 miles Thu 09 Jul 09 1£195      CLICK TO ENQUIRE
    CLICK TO BOOK
Newcastle Upon Tyne283 miles Wed 22 Jul 09 1£195      CLICK TO ENQUIRE
    CLICK TO BOOK
Newcastle Upon Tyne283 miles Wed 05 Aug 09 1£195      CLICK TO ENQUIRE
    CLICK TO BOOK
Newcastle Upon Tyne283 miles Mon 17 Aug 09 1£195      CLICK TO ENQUIRE
    CLICK TO BOOK
Newcastle Upon Tyne283 miles Mon 31 Aug 09 1£195      CLICK TO ENQUIRE
    CLICK TO BOOK
Newcastle Upon Tyne283 miles Thu 17 Sep 09 1£195      CLICK TO ENQUIRE
    CLICK TO BOOK
Newcastle Upon Tyne283 miles Mon 28 Sep 09 1£195      CLICK TO ENQUIRE
    CLICK TO BOOK
Newcastle Upon Tyne283 miles Fri 20 Nov 09 1£195      CLICK TO ENQUIRE
    CLICK TO BOOK
Newcastle Upon Tyne283 miles Tue 01 Dec 09 1£195      CLICK TO ENQUIRE
    CLICK TO BOOK
Tools
 
Key Details
Duration1 day
 
£195
per delegate