Advance Excel
In this course you are going to know about the Advance Excel, where you will learn about many advance tools.
Buy NowSkills you will get
Top Highly In Demand Skills that are taught in this course.
-
Personal Finance
Learn about personal finance and how to manage your returns.
-
Critical thinking & Problem solving ability
You will get the ability to solve the problem faced in practical life with the help of excel
-
Data Management
Learn various techniques like Data tables, data validation, data consolidation.
-
Financial Analysis
The ability to read and understand financial statements.
Course program:
All course - 5 ( 3.5 Hours )The Advanced Excel course will enable you to transform your basic excel skills to advanced level. By doing this you will be able to accelerate in your career by outperforming your peers in your organization. If you're a business professional, who uses (or will be using Microsoft Excel) on a daily basis, this is the course for you! The course will give you a deep understanding of the advanced Excel formulas and functions such as sumifs, countifs, nested if, index match, irr/xirr and pivot table analysis. The course is equally beneficial to everyone working across all streams and not focused on any particular industry.
-
Unit 1st
6 MinutesIntroduction
In this course first of all there is an introduction of the instructor Mr. Rahul Sachdeva. After that we have discussed why advanced excel is necessary and its applications. You will get to know the topics that are covered in this course and how this course is helpful for you.
Total Videos 2
-
Unit 2nd
1hr 8 MinutesIf functions of excel
This module shall enable learners to write advanced excel formulas containing if function. In this module we will discuss various real-time scenarios where nested if, sumifs, averageifs and iferror functions can be applied and their benefits.
Total Videos 3
-
Unit 3rd
40 MinutesVlookup (with its application) & Index match
In this module we will discuss the vlookup function and its three major limitations. You will also learn the use of Vlookups. This is important to understand the full potential of the next topic.
Total Videos 2
-
Unit 4th
48 MinutesPivot Table
This module will allow the learners to completely understand the concept and applicability of Pivot Tables in excel. On completing this module the user shall be able to apply pivot tables to his/her large data sets and perform further analysis. Using a pivot table saves a lot of time and increases efficiency and productivity at the workplace.
Total Videos 6
-
Unit 5th
54 MinutesCalculating various types of return
In this module we will cover a key advanced excel topic of calculating various types of return using excel. This is important to understand from the Personal Finance perspective. It is imperative for users across all streams (not just Finance) to learn this key module.
Total Videos 3
Limited Offer! Enroll Now!
Skills help you Outshine. Enroll Now to Get Started with your Learning Journey!
You can Choose Your Future Now with Eduvince!