Advanced Techniques in Modern Excel

Advanced Techniques in Modern Excel

This course looks at how to take full advantage of the features of modern Excel versions.

Working with the features of Excel 365 or Excel 2021 and above.

The new Dynamic Array feature is used to its fullest.

The aim is to provide the learners with a suite of techniques that can be used to build powerful solutions for general data processing tasks. Solutions that are easy to maintain and update.

Along the way, we will look at the basic and intermediate operations of Pivot tables and Excel charts.

Students will learn:

How modern Excel deals with a collection of values, both as input and output of formulas.

How to make full use of Excel tables in new versions.

How to use Existing Excel functions in new ways with modern features.

How to create - interactive and dynamic single-cell lookup formulas, interactive charts using modern features, and efficient validation dropdowns.

Nuances of Excel Tables and the new and powerful FILTER function.

We will also look at scenarios for the correct usage of the FILTER function.

Dynamic and Static named ranges will be used, and we will see examples of how the features built into modern Excel allow us to avoid Dynamic named ranges but still perform the same tasks.

Lookups , Dropdowns and Charts in Excel 365 or Excel 2021 and above.

Url: View Details

What you will learn

• Take full advantage of features Modern excel-Excel 365/2021 and above.
• Concepts - Dynamic arrays, Spill ranges, ,Boolean arrays, Dynamic and static named ranges, nuances of FILTER function and Excel tables to use them effectively.
• Formulas - Dynamic formulas with Tables & Dynamic array functions.

Rating: 0

Level: Intermediate Level

Duration: 2.5 hours

Instructor: Abacus Harish Krishnan