CONSULTEASE.COM

Sign In

Microsoft Excel - Pivot Table in Depth

Microsoft Excel - Pivot Table in Depth

Created by Anshuman Tandon,
 
Get instant access to this course
₹2,000 ₹1,000 * GST Extra
Buy this course

This Course Includes

  • 15+ Hours
  • No limitation on views
  • Hindi
  • Yes
  • No Exam

Questions? We're just a call away...
Have any questions about the course? Just reach out to us.

+91 9625740572shikha@consultease.com

Microsoft Excel - Pivot Table in Depth
Microsoft Excel - Pivot Table in Depth

 

About Microsoft Excel - Pivot Table in Depth

Are you a professional using Excel in your working??, If yes then It's time to change the way you are using Excel Pivot Table at your work place. If you're using Excel on a daily basis in your tasks, this is the course for you!



This course is going to transform the way you are using Excel Pivot Table by givng you advanced understanding of the Microsoft Excel Pivot Table, by which you will be able to solve complex problems in Excel very easily & here, problems not only means the difficulties you are facing but it includes complex calculations & reporting you have to do at your work place





Why this course is worth joining??

This course worth your attention, because in this course we are going to make those things possible in Excel which seems nearly impossible to you till now, also we will be solving complex problems live in this course by using Excel Pivot Table so that your vision of using Pivot Table will be changed, after that we will see how experts perform their work in Excel by using Pivot Table, I am going to teach you how to THINK & TRANSFORM Excel.



By the completion of the course you'll be able to:

1. Start using Advance Excel features to make Excel a tool of your journey towards success

2. Building complex reports using Excel Pivot Table for satisfying multiple conditions at a time

3. Easy build dynamic reports in Excel

4. Making your hours work get done in seconds using Advance Excel

5. Design your own Excel Formula to define your needs

6. Make useful & informative reports using Advance Excel features in seconds

7. Manipulate data using Excel Pivot Table

8. Automate your taks using Excel Pivot Table



Course Delivery:-

The delivery of the course will be via the online dashboard of Consult Ease. The user will be provided with a login id and password to access the dashboard. All the videos, resources, PDF, PPT’s, Excel Workbooks, and case studies will be uploaded there for quick access of participants. There will be unlimited access to resources and videos for one year.



Eligibility:-

Although there are no fixed eligibility criteria but deep desire to learn Excel is required. With this anyone with the basic knowledge of using Excel can join as we are going to focus each aspect of MS Excel useful for professionals engaged in Accounts & Audit only.



Salient features of Microsoft Excel - Advance Excel Course:-

1. Completely online, no bar on access. You can access it anytime and from anywhere

2. Everything is discussed with an example & detailed cases so that practical situations. Issues in its applicability faced by the industries and businesses are covered and discussed with solution

3. Working Files are shared so that it will be easy for the students to perform their practice

4. Every aspect is discussed with practical files & real life problems

5. A lot of tricks & cases are discussed so that way of using Excel can be changed



Assessment:-

The course ensures continuous assessment as and when the participant is watching the videos.

Practical problems & queries are discussed and the answers are explained in each session.

The Participant can do the self-assessment for every chapter.

Also variety of complex problems are shown & resolved so that people can apply them where they want


Course Schedule

Profile photo of Anshuman Tandon
1.1

Basics of Pivot Table

Expert - Anshuman Tandon

In this section we will start our journey to learn Excel - Pivot Table, we will see all the pre - requisites required to make a Pivot Table & f

In this section we will start our journey to learn Excel - Pivot Table, we will see all the pre - requisites required to make a Pivot Table & focus on each & every aspect of Pivot Table building

Read more
02 hour 32 min 26 sec
26 th Dec, 2021
Profile photo of Anshuman Tandon
2.1

Features of Pivot Table

Expert - Anshuman Tandon

In this sectioon, we will learn all the features available in Excel to work on Pivot Table. We will explore all the options & modules of Pivot

In this sectioon, we will learn all the features available in Excel to work on Pivot Table. We will explore all the options & modules of Pivot Table

Read more
02 hour 29 min 20 sec
02 nd Jan, 2022
Profile photo of Anshuman Tandon
3.1

Advance Pivot Table

Expert - Anshuman Tandon

After the above we will finally focus on aspects that will make us an advanced user of Pivot Table In this section , we will explore advance

After the above we will finally focus on aspects that will make us an advanced user of Pivot Table
In this section , we will explore advanced features of working with Pivot Table

Read more
02 hour 02 min 04 sec
09 th Jan, 2022
Profile photo of Anshuman Tandon
4.1

Pivot Table Tricks

Expert - Anshuman Tandon

After learning all the features we will finally focus on ways to use it in different manner So we will explore different ways of using Pivot

After learning all the features we will finally focus on ways to use it in different manner
So we will explore different ways of using Pivot Table

Read more
01 hour 34 min 15 sec
16 th Jan, 2022
Profile photo of Anshuman Tandon
5.1

Dashboards by using Pivot Table

Expert - Anshuman Tandon

When we will complete our ways, we will focus on analysing data by using Pivot table through reports & dashboards

When we will complete our ways, we will focus on analysing data by using Pivot table through reports & dashboards

Read more
01 hour 56 min 51 sec
30 th Jan, 2022

Experts/instructors panel

Course creator

Mr. Anshuman Tandon is an Excel Expert, he is the founder of Excel Man, an online platform to teach MS Office & Google softwares to all professionals, he had worked as a Tax Specialist at Masters India Pvt Ltd a GST Suvidha Provider, & had worked with concerns like Flipkart, Hindware, Maruti Suzuki, L&T & India Mart in dealing their GST related tasks & resolving their queries, he has also worked with over 180 MSMEs in dealing their day to day GST related queries & work all over India He has also worked in Jaypee Brothers Medical Publishers Pvt Ltd as a Senior Executive Finance a well-known medical publisher of India & dealt their top management reporting He is having a total of 10 years experience in MS office products & has expertise in all of them, he had taught MS Excel to over 2000 professionals in the past year Currently, he is working as a Manager - Taxation in Alde Medi Impex Ltd a well known Medicine Manufacturer in India

Get instant access to this course
₹2,000 ₹1,000 * GST Extra
Buy this course

This Course Includes

  • 15+ Hours
  • No limitation on views
  • Hindi
  • Yes
  • No Exam

Questions? We're just a call away...
Have any questions about the course? Just reach out to us.

+91 9625740572shikha@consultease.com

Easy to use Dashboard Interface

chat icon chat icon chat icon chat icon

Get your questions answered

Watch anytime, any number of times

Download all associated documents

Test your skills and get CE Certified


seosamba120x600

Other courses of your interest

Card image cap
Card image cap
Card image cap
Card image cap
Card image cap

sellerlabs300x600

Easy to use Dashboard Interface

chat icon chat icon chat icon chat icon

Get your questions answered

Watch anytime, any number of times

Download all associated documents

Test your skills and get CE Certified

Other courses of your interest

Card image cap
Card image cap
Card image cap
Card image cap
Card image cap

hostupon728x90