Excel Intermediate/Advanced

General · Administration · Classroom ·

Target Audience

To get the most out of this course, you must have a basic knowledge of Excel and use the program regularly in a professional context. You want to further expand your skills and learn to work more efficiently.

Objectives

Excel is one of the most important tools in any business environment. Almost all white-collar workers or self-employed people (from administrative staff to managers and entrepreneurs) sooner or later encounter this powerful Microsoft spreadsheet program.

This course is aimed at Excel users who already work with Excel regularly and want to refresh and expand their knowledge and skills. You will also learn practical techniques to work more efficiently with Excel. So we take your Excel skills to the next level and ensure that you can use the programme more smoothly and save time. The aim is to achieve results immediately after the lessons.

During the training we focus on 3 major components: complex functions and formulas, working with data lists and (pivot) tables.

Course content

• Data lists, sorting, filtering
• Working with (multiple) worksheets
• Sorting and filtering data
• Working with subtotals
• Database functions
• Conditional formatting
• Working efficiently with pivot tables (setup, formatting, applications, adjustments, slicers…)
• Working efficiently with functions (.As, Number.as, Vertical search, Select, Index, Date/Time, Nested…)
• Data validation
• Target search (Solver)
• Sparklines