Advanced Excel Training Course

Master Excel's advanced features and take your skills to the next level

Average rating: 4,5 / 5 (132 votes)

On this course you will learn to use Excel's advanced features, such as:

  • Master Excel's powerful lookup functions (vlookup & hlookup)
  • Learn to report & analyze with Excel's PivotTables
  • Take your problem solving skills to the next level with logical functions (if, or & and)
  • Learn to record macros - let macros perform your time consuming routines
  • Handle super useful text functions (concatenate, substitute, left, right, search..)
  • Get data from another workbook or worksheet
  • Learn tips and tricks which will help with your everyday work with Excel

This Advanced Excel Course is for Excel 2007/2010/2013/2016/365 (PC/Windows) & Excel 2011/2016 for Mac

Duration: 1 day (9-16)
Language: English
Location: Brussels and Belgium wide

Price: 395 € / person
For 1-12 persons per day. Groups of 4-12 participants: 1199 € / group.

All prices excluding VAT 24%, possible travel costs outside Brussels and other additional costs. Companies based in EU may be exempted from VAT. 

Contact us now and book your
Advanced Excel Course

"Exactly what I needed! Awesome, thank you!! Small group was absolutely the best. Calm, pleasant and skilled instructor. Good tips!"

- Feedback from our Microsoft Excel Advanced Course

Detailed Course Program for Excel Advanced Training

On this one day advanced Excel training course you will learn how to use the advanced features and tools in Excel. Learn to use these tools in your daily work confidently as our hands-on approach will give you plenty of experience during the day. 

Learn to use the search functions

  • Using lookup functions (vlookup, hlookup)
  • Understanding exact match and close match
  • Preventing error messages (iferror)
  • Getting data from different sheets and workbooks

Master functions and learn how to combine them

  • Logical functions (if, or, and)
  • Financial functions (payment, fv)
  • What-if-analysis: Goal seek and scenarios
  • Super useful text functions (concatenate, substitute, left, right, len, search)

Efficient reporting with PivotTables

  • Creating a Pivot-table from worksheet
  • Value field settings
  • Displaying number of cases from numeric & nominal data
  • Displaying percentages
  • Displaying running totals
  • How to use report filters and focus on selected areas

Other useful features and tools

  • Dividing text to columns
  • Clean up tables: remove duplicates & empty rows quickly
  • Calculating the VAT the right way
  • Conditional formatting
  • Protecting the sheet or parts of the sheet
  • Linking data between Office applications
  • Recording macros and attaching macro to a button

Book for a group of 4-12 people with 1199 € / group

All prices excluding VAT 24%, possible travel costs outside Brussels and other additional costs. Companies based in EU may be exempted from VAT.

Terms & Conditions

Conditions: Minimum number of participants is 3 persons on each course. If the course you are enrolling in does not reach the minimum number of participants it will be cancelled or postponed. We will inform enrolled participants in case there are not enough participants on a course.

Cancellations and substitutes: a) Cancellations confirmed more than 21 days prior to the date of the course are fully refundable and free of charge. Cancellations are to be made in writing to info@talentwire.eu. 

b) Cancellations made within 21 days of the date of the course may not be cancelled without incurring course charges fully.

c) Substitutes may be made at any time free of charge. TalentWire should be informed of any changes.

Pricing and invoicing: Payment for each course is to be received no later than 14 days prior to the course start date. We will send an invoice after your booking has been confirmed. Inform us of any special arrangements you require for your invoices.

All prices are as stated and are exclusive of VAT which will where appropriate be charged at the current rate.

×