What Our Clients Say. Coop testimonial.

Essex NHS testimonial.

Humberside Fire & Rescue testimonial.

Danwood testimonial.

May Gurney testimonial.

Leicester NHS testimonial.

Corus testimonial.

Eon testimonial.

Colin Guthrie testimonial.

Entre-prises testimonial.

Renaissance testimonial.

OAMPS testimonial.
our

Intermediate Excel has always been our most popular course, largely due to the fact that it teaches practical and relevant skills which can be immediately applied in any office environment.  Clients can see an immediate increase in employees’ effectiveness on spreadsheet tasks. So, to further enhance these skills, we’ve created a new 1 day course called Intermediate+. This new course is the natural follow up and will help your staff to become even more productive in 2018. Here is a brief overview of the syllabus:

Intermediate+ 1 Day Training Course

  • Named Ranges
    • Using named ranges to simplify functions
    • How named ranges make it easier to update your spreadsheets
  • Conditional Logic
    • Using the IF function to test data
    • Expanding the capability of the IF function by combining the AND & OR functions
    • How to create nested IF functions to create complex data testing scenarios
  • Maths & Statistical Functions
    • How to SUMIF, COUNTIF and AVERAGEIF to test and calculate data selectively
    • Using SUMIFS, COUNTIFS and AVERAGEIFS to calculate data with multiple conditions
  • Database Functions
    • Using DSUM, DAVERAGE and DCOUNT to run calculations on databases
  • Consolidating Data
    • Combining data from multiple worksheets and workbooks into a single location for easy reference
  • Working with Text Data
    • How to tidy text data easily using the TRIM function
    • Using the FIND and MID functions to extract and rearrange text data
  • Analysing Data with PivotTables
    • Building PivotTables
    • Formatting the PivotTable data
    • Filtering and analysing the PivotTable

For more details or to book and Intermediate+ Excel training course, please call 0800 2922842 or use visit the contact page to send us a message.

 

why contact

Checking...

Ouch! There was a server error.
Retry »

Sending message...

Quick Enquiry Form

Please complete the fields below for a quick response