Learn Advanced Formulas and Data Analysis in Microsoft Excel

Learn Advanced Formulas and Data Analysis in Microsoft Excel

The Microsoft Excel course exposes students to all available tools, commands, and Functions in the application. The training is carefully structured to take care of the learning needs of students, who are really yearning to know how to use Excel to carry out tasks in their workplaces. The course is also prepared to help regular users of the application, who want to upgrade their knowledge and upskill.

The Intermediate topics capture the most frequently used command for day to day tasks. The Advanced level is also to help students learn the most advanced formulas, functions, and Tools. The advanced Excel training course builds on the intermediate course and is designed specifically for spreadsheet users who are already proficient and looking to take their skills to an advanced level.

The advanced excel tutorial will help you start a career in the area of data and financial analysis especially in the following fields; investment banking, private equity, corporate development, and equity research. By watching the instructor build all the formulas and functions right on your screen, you can easily pause, replay, and repeat exercises until you have mastered them.

Microsoft Excel Intermediate to Advanced Level Tools

Url: View Details

What you will learn

• Working with SUM, COUNT, MAX and MIN Functions
• Understand the POWER of SUMIF, SUMIFS, COUNTIF, COUNTIFS, VLOOKUP, INDEX & MATCH for Data and Financial Analysis
• Understand the Power of Data Analysis using Microsoft Excel Master how to use PIVOT TABLE and PIVOT CHART to create Dynamic Reports and Charts

Rating: 4.55

Level: Expert Level

Duration: 12.5 hours

Instructor: Abraham Eninla