You will learn

After the course you will be able to:

• Build complicated formulas by using dynamic ranges
• Import, adjust, compare, merge and make calculations from pretty much all data sources using Power Queries
• Finding desired data using the advanced filter
• Building worksheet models or templates by using user friendly controls
• Automate actions using recorded macros

We will teach you a number of advanced functions for managing dynamic ranges, for example, if you have some lookup values and have formulas to find the desired values in one or more ranges.

In addition, we look at Power Queries, which are a powerful tool for importing data from virtually any data source. You can manipulate your data in many ways, for example by splitting, linking or merging them.

You will learn the Data table tool and Scenarios for data analysis as well as the Solver, which allows Excel to calculate a wide range of values based on given criteria. The Solver can make thousands of calculations to find a possible solution.

We look at tools using advanced criteria ranges, fx some Database Functions for calculating totals or averages and the Advanced filter. The Advanced Filter is unknown to most people, but is an intelligent way of filtering a list based on many criteria. And the criteria can be saved.

If you want to build spreadsheet models with multiple users, you can with advantage inserting Controls to allow users to choose from predefined buttons than manually entering values.

We also look at recording Macros for automating routine tasks.

Before the course

• The opportunity to speak with one of our instructors about finding the right course for you.

During the course

• Teaching by the most experienced instructor team in our cozy and fully updated classrooms located in the center of Copenhagen.
• A course that consists of a both theory and practical exercises. We know the importance of having practical exercises and hands-on is always in focus during the courses.
• A course material you can use as an encyclopedia after the course and downloads of course exercises.
• All meals, which includes breakfast, fresh coffee, tea, fruit, soft drinks, lunch in an Italian restaurant on Gråbrødretorv, cake, candy and off cause Wi-Fi to your devices.
• A course certificate as a proof of your new skills.

After the course

• Access to our free hotline service, which means that you up to a year after the completing of the course can contact us if you have questions regarding subjects from the course.
• We have a unique satisfaction guarantee in order to ensure you the complete benefit from the course.

Relaterede kurser

Kursus før dette kursus: Excel Experienced (conducted in English)

Kursus efter dette kursus: Excel Basic VBA Programming (conducted in English)