Excel-III (Advanced)

The Excel-III (Advanced) course at OptionTrain.com provides a course to level up your Excel knowledge with a focus on advanced functions and data processing. Get to know how to use array functions, database functions, and financial functions to make complex calculations easy. Submerge yourself into Power Query to load and clean data from different sources. Learn how to work with PivotTables and enhance them with additional features and dynamic charts. Learn about VBA (Visual Basic for Applications) for automation and coding. Explore Power Pivot for more complex data manipulation. At the end of this course, you will be fully prepared to handle challenging data problems and get the most out of Excel. Come and take your Excel skills to the next level. "This program does not require approval under the Ontario Career Colleges Act, 2005."

Data Transformation

Power Query

Advanced PivotTables

Data Visualization

VBA Programming

Course Objectives

Master advanced Excel functions and formulas.

Transform and cleanse data using Power Query.

Automate tasks and processes with VBA macros.

Work with variables and data types.

Analyze data with Power Pivot.

Learn financial and logical functions.

Create advanced PivotTables and PivotCharts.

Develop interactive dashboards and reports.

Implement user-defined functions.

Solidify skills through practical exercises.

Student Journey throughout the course

The student journey through our Excel-III program is a continuation of the foundation laid in the Excel-II program. You will explore the details of advanced functions and learn how to harness the capabilities of array and database functions, financial calculations, and complex IF functions. You will use Power Query to transform and join data in a very efficient manner. The course helps you learn how to create exciting PivotTables, charts, and dashboards that bring your data to life. You will also learn how to create, modify and debug VBA programs and even learn about macros. The program concludes with a discussion of Power Pivot and DAX functions to enable you to carry out complex analyses. Throughout, practical exercises are used to give a pragmatic feel to the course and to ensure that you leave the course as a competent Excel-III user.