In House - Webinar

Microsoft Excel Advanced

For the experienced Excel user, this live practical Microsoft Excel Advanced webinar will provide a workshop day with flexible content to cover advanced subjects, including those detailed below.

Trainer:
Glyn Brooks

Duration:
1 Day
Max delegates:
8

Course price:
£1200 + VAT

Course Introduction

For the experienced Excel user, this live practical Microsoft Excel Advanced webinar will provide a workshop day with flexible content to cover advanced subjects, including those detailed below.

Course Objectives

  • Full understanding of IF, OR, AND
  • Date Functions and Principles
  • Gain an understanding of Macros and Visual Basic for Applications

Course Content

  • Recap of Intermediate knowledge
  • Advanced Filters and Subtotals
  • Pivot Tables and Pivot Charts
  • VLOOKUP and HLOOKUP
  • INDEX and MATCH
  • Importing Data
  • Text Functions SEARCH, LEFT, RIGHT, MID, LEN
  • More Text Functions PROPER, UPPER, LOWER, ABS
  • Other Useful Functions RAND, INT, CAR
  • Data Validation and Data Input Control
  • Using OR/AND with the IF Function
  • Error Trapping with ISERROR, IFERROR and IFNA
  • Date Functions DATE, DAY, MONTH, YEAR, NOW, TODAY, WEEKDAY
  • Basic Macros
  • Creating Advanced Macros Using Visual Basic for Applications
In House Course registration form

Enquire today

Please let us know how you would like us to contact you below:
Privacy consent

Please read our privacy policy

Open dates

Course name Topic Environment Duration Price Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun
Microsoft Excel Advanced
Microsoft Office Skills
Webinar
1 Day
£250 + VAT
Scroll to Top