# Excel Pivot Table: Grouping, Calcs, Slicer, Sparklines

## Online Support

### Start Learning Now

If you've never had a membership to Yodalearning.com, you'll get unlimited online course library access. Access comes with Unconditional 9 days money back guarantee.

### Unlimited Access

Choose exactly what you'd like to learn from our extensive library

### Expert Teachers

Learn from industry experts who are passionate about teaching

### Learn Anywhere

Switch between devices without losing your pace

### Sample Videos

Pivot table is easy to use technique of Excel. Professionals can benefit from the hidden tricks and Ninja hacks -

• Do's and Donts'
• Understanding logic of the four field areas.
• Perform mathematical calculations - Sum, Average, Count
• Perform percentage calculations - % of Row, Column, Grand total
• Grouping Dates into months and years
• Grouping Numbers into standard ranges such as 0-10, 11-20 etc.
• Grouping Text into clusters such as SBUs, Zonal regions
• Understanding new data visualisation features - Sparklines, Slicer, Charts
• Create 100s of customised reports in under 1 minute - using special hack
• 3 Project case studies - Sales data analysis, Closing Stock analysis, Salary & Performance analysis
• Essential settings
• Introduction to PowerQuery & it's practical application

We have 21 videos of duration 1.5 hrs in one sitting. Through practical examples, they start from the foundation and take you to the Ninja level application.

-------------------------------------------------------------------------------------------------------------------

Your Question - Why should I take this mini-course on Excel Pivot Table?
Our Response - Because we cover the following:

• WHEN should we use Pivot Table & what are the essential settings
• Mathematical calculations.
• Grouping & Clustering.
• Sparklines, Slicer, Charts shortcuts and Ninja hacks.

Example – Using Report Filter in Pivot Table to Generating 100s of reports in few seconds
------------------------------------------------------------------------------------------------------------------
Your Question – So will I learn LookUp, Match, Sort & Filter?
Our Response – No. This course covers Pivot Table Basics to Advanced techniques
------------------------------------------------------------------------------------------------------------------

“Excellent. I have completed all the videos in one day. I am very impressed by your style of explaining, language methods, and sample data. I am a senior Banker. I am very much interested to learn more tricks from you. I am regularly working on Excel at my Office. Wishing you all the best in your noble job of Excel Excellent Service.” by Gopalakrishnarao, Senior Banker, India
-------------------------------------------------------------------------------------------------------------------

Important information before you join:
• Video comes with Subtitles.
• I will give you my full support regarding any issues or suggestions related to the course.
Guided practice - over worksheets included for immediate practice
• Access to all videos 24 x 7 - learn online from anywhere
• A 9-day money back guarantee (we want you to be 100% satisfied)
-----------------------------------------------------------------------------------------------------------------

If you have read this far, next action is JOINING this course. Invest 1.5 hrs in one sitting for a benefit of lifetime Ninja status on Excel Pivot Table!

## Course Curriculum

Self Assessment Quiz
Available in days
days after you enroll
Available in days
days after you enroll
Pivot Table Zen Handbook
Available in days
days after you enroll

### Samples from our Ebook

Rishabh Pugalia
• Qualified Chartered Accountant
• Has worked for KPMG (Audit), J.P. Morgan (Investment Banking & Research), Futures First (STIR F&O)
• Four years of work experience in the area of Audit, Investment Banking & Proprietary trading
• Program Director & Training Instructor – Advanced Excel, Advanced PowerPoint, Financial Modeling
• 5.5 years of work experience in Corporate Training & Workshops
• Under him, Excel Next has trained more than 6,500 professionals across 14+ cities
• Successfully completed six-weeks Analyst training program of Adkins Matchett & Toy.

"Straight into the action and very easy to follow"

- Will Gamu

"This is an excellent course on Excel where the instructor takes time explaining how to implement shortcuts on the provided practice exercise files. Great presentation skills are applied by the presenter making the course quite interactive."

- Danish Jafri

## COURSE Q&A

- An accelerated, Practical approached Advanced Office Training Tutorials to teach you Skill needed to compete in competitive work environment.
- All Advanced tutorials case studies related to videos.
- A picture based Excel PDF handbook on Excel Tips, Functions & Techniques.
- Access to all video tutorials 24 x 7 - learn excel online from anywhere.
- A 9-day money-back guarantee (we want you to be 100% satisfied with our Office Training)
- You will also get support for doubt and assistance to implement your learning in real-life challenges.

You can enroll for this office training online by just a click on Enroll Now button Payments can be made using any of the following options and receipts of the same will be issued to the candidate automatically via email.
- Visa/Master Card credit and debit card
- PayPal

This is a self-paced, lean Office Training program with videos from basics to advanced tutorials. Watch the preview of videos tutorials to get a flavor the program's uniqueness and relevance. Online courses may not be your first preference. But I promise this – After watching 3 videos, this courses will give a tough fight to your usual classroom training.

Office Training library access comes with Unconditional 9 days money back guarantee.

This means you can try courses for yourself and if you don't agree that it adds value to your knowledge, then just send us an email to [email protected] and we'll cancel your subscription immediately.

No Questions asked, no hoops to jump through and no hard feelings...

So go ahead and click on the Enroll in Course button.

To know more please read our Refund Policy. If you just want to get to know the flavor of the course, you click on any one of the tutorials

- We are covered by YourStory | Inc42
- Recommended by MBAExcel.com | Excel Made Easy | WmfExcel | Excel Champs | Engineers Excel | Get Digital Help | AJP Excel | Deskbright
- Our Client list includes: Big Four (KPMG, PwC, EY), Tata Group (Our Corporate Training Company)
- We are among Top 35 Excel Resource Websites in the world

Simple – Our feedback form from each corporate clients give us a rating between 4.8 to 5 (5 being the highest). We will empower you with tips and tricks based on real issues faced by 1000s of students we teach. We created these advanced tutorials after so many years of research and hundreds of hours of training.

#### Still have more questions?

Call us on +91-8080042523 or Email us at [email protected]

### If you're not completely satisfied, let us know for a full refund. We want you to be 100% satisfied.

Professionals from these cities are learning with our online video tutorials to grow in their career.
Mumbai, New Delhi, Bengaluru, Hyderabad, Kolkata, Chennai, Pune, Ahmedabad, Navi Mumbai, Gurgaon, Ashburn, San Francisco, Noida, London, Dubai, Riyadh, Indore, Putney, Chandigarh, New York, Singapore, Jakarta, Jamshedpur, Moscow