Logo Picture

Tel: 0330 333 9 230 (Local Land Line Call Rate)

excel advance

Excel Advanced

This comprehensive course in Excel teaches participants how to use the advanced features of Excel including, Functions, Multiple Functions, Advanced Filtering, Pivot Tables, Subtotaling, Protection. The course provides the necessary tools to be able to use Excel to a high standard in an ever changing business environment.

Who Should Attend

This course is designed for any delegates who have attended the Excel Intermediate course or have relevant business experience, and would like to learn how to improve their skills and use Excel to a very high standard.

Course content

  • Convert text case to upper, lower & proper

  • Merge text from seperate cells into one cell

  • Remove unwanted spaces

  • Count the number of entries in a range

  • Using the SUMIF & COUNTIF functions

  • Linking cells-paste links

  • Consolidating data

  • Simple IF statements

  • Nested and IF statements

  • Naming cell ranges

  • What are look up tables

  • Create a lookup table using V lookup

  • Formulae using absolute cell referencing

  • What is goal seeking

  • Using goal seeking to find results

  • Advanced formatting options

  • Conditional formatting -multiple conditions

  • Calculating with dates

  • Inserting a dynamic date

  • Using formulae to find day, month and year

  • Custom formatting times

  • Setting up data tables - best practice

  • Advanced sorting and filtering techniques

  • Creating and customising a pivot table

  • Subtotalling lists - subtotalling options

  • Amending, refreshing and grouping pivot tables

  • Controlling data entry in a specified range

  • Creating input messages and error alerts

  • Scenarios - changing circumstances

  • Viewing and amending a scenario

  • Creating a scenario summary

  • Hiding rows, colums and worksheets

  • Password protecting a workbook/worksheet

  • Password protecting cells and ranges

  • What is a Macro - Creating a macro

  • Running, deleting and editing an existing macro

  • Viewing all formulae on a spreadsheet

  • Tracing precedents - tracing dependants

  •  

excel advance2 Booking Form Online Enquiry

Duration: 1 day course

Venues: At your own offices or our luxury training venues in Cardiff, Newport(Nr Celtic Manor), Bristol or Swindon (Please state your choice of venue when booking)

ONSITE TRAINING

 FROM

£650  + VAT

 

CLICK ON THE BUTTONS BELOW TO VIEW  COURSE DATES AT YOUR CHOSEN LOCATION

Bristol Newport & Cardiff Swindon

PRICES FROM

£199 + VAT

PER

DELEGATE