Excel for Power User

Course Details

Modules : 6
Projects : 10
Eligibility : HSC/SSC
Learning Mode : Online / Classroom

Enroll Now

INTRODUCTION

The course is designed for those who have been using excel for their work activities, and want to become smart in using excel functions without any code or programming language.

CURRICULUM

Curriculum

Introduction: This is the first segment of the course. In this section, you will get familiar with the course material. First, you will get to know what the Excel for Power User Course is all about! Then, the instructor will take you through a brief overview of analysing data to make business decisions.
Function: In this section, you will learn about four functions. First, you will learn the future value function. Second, you will learn the PMT function. Third, you will understand quick analysis. And lastly, you will learn the rate function.
Pivot Tables: If you have been working in excel, you would already know how valuable pivot tables are. In this section, you will first learn about the pivot tables. Then the instructor will teach you how to create custom groups in pivot table. After that you will learn how to set conditional formatting in great detail.
Evaluate: The most important thing of this section is that it would teach you how to do troubleshooting and how to enhance professional workbooks. In this section, you will also learn about name range and data set. Finally, you will get to understand the key performance indicator (KPI) in excel.
Date Format and Time Format: In this section, first you will get an overview of the analysis of data with function. Then you will learn about the date and time format. This Excel for Power User Course covers everything; all you need to do is to pay attention and practise on your own as much as you can.
Statement and VLookup: There are many working professionals who have learned the VLookup the hard way. But if you’re yet to learn VLookup, this section will get you covered. In this section, you will learn three important things. First, you will learn about ‘nested if statement’ in excel. Then, you will go through ‘count ifs and sum ifs’ in excel. Finally, you will learn VLookup.
Future Value Function: This section is all about future value function. First, you will learn about what future value is. Then, you will go through a ‘what if’ analysis. Then you would learn how to create scenario in excel. Finally, you will learn about creating goal seek in excel and the instructor will also teach you how to use solver tool in excel.
Business Information: Many companies use excel to keep track of business information and to periodically look at important factors of business. In this segment, you will learn about the business information and what it actually means. Then you will learn to create a dashboard of sales, how you can create hyperlinks for sales, and you will also learn the profit and loss of sales.
Database information: In this segment, you will start learning how to formulate the design from database information. Then you will learn working with data table in power excel. You will also get to understand how to add new column in data table and how to use excel function in the same. Finally, you will also learn to work with data filtering and data subtotal group and ungroup.
Data Comparison and Filter: In this short segment, you will learn about data comparison in power excel. You will also learn about data filter and data slicer.
Pivot Chart and Power View: This is the last segment of the course. In this segment, you will first learn about pivot chart and power view in power excel. Finally, you will learn about working with excel macros and the instructor will also take you through an example of macros.

TARGET AUDIENCE

Students of commerce: As students, you have an advantage. If you can learn this Power excel training right away, your employability will increase a lot more. And if you would be put in a position where you need to work on excel all day, every day, you would be ready for it quite early. This power excel training is recommended especially for commerce students; but even students from other disciplines can do the course as well.
Working professionals who need to use excel every day: If you’re someone who needs to work on excel day in and day out, this power excel course would be the best course you would ever do. You will not only learn the advanced functions; you will also know how to use pivot table, how to use VLookup, and you would also learn to use database information, future value function etc.
Entrepreneurs who have just started out: In the beginning of an entrepreneur’s journey, you need to do all by yourself. You need to take care of the finance, pitch your idea to VCs and also maintain the spread-sheet. This power excel training can turn out to be a valuable resource for you.