Left Blocks Image | Learnfly Right Blocks Image | Learnfly
All in One Offer! | Access Unlimited Courses in any category starting at just $29. Offer Ends in:

Learnfly | Menu Trigger Icons Browse Library

  • Business Solutions
  • Become an Instructor
  • 0
    Shopping Cart
    Learnfly | Empty Cart Icons

    Your Cart is empty. Keep shopping to find a course!

    Browse Courses
Free
1 days left at this price!

This plan includes

  • Limited free courses access
  • Play & Pause Course Videos
  • Video Recorded Lectures
  • Learn on Mobile/PC/Tablet
  • Quizzes and Real Projects
  • Lifetime Course Certificate
  • Email & Chat Support
Get Unlimited Learning Access
$29
1 days left at this price!
30-Day Money-Back Guarantee

This plan includes

  • Access to 11,000+ Courses
  • Ads free experience Courses
  • Play & Pause Course Videos
  • Learnfly HD IconsHD Video Recorded Lectures
  • Learn on Mobile/PC/Tablet
  • Quizzes and Real Projects
  • Lifetime Course Certificate
  • Instructor Direct Support
  • Email & Chat Support
  • Cancel Anytime
$29
$29
$29
  • Become an Expert in Data Analysis with Pivot tables and Charts
  • Complete Analysis with Pivot Tables with Real time Scenarios
  • Excel 2019 Pivot tables and Pivot Charts
  • How to Write formulas in Pivot Tables

In the LEARNFLY this is the Best Excel Course for Pivot Tables & Pivot Charts Created by Microsoft Certified Trainer.

 

FULL COURSE DESCRIPTION:

Excel Pivot Tables are an absolutely essential tool for anyone working with data in Excel.

Pivots allow you to quickly explore and analyze raw data in Excel, revealing powerful insights and trends. In other words, they give you answers. Whether you're exploring product sales, analyzing which marketing tactics drove the strongest conversion rates. Excel Pivot Tables provide fast, accurate and intuitive solutions to even the most complicated analytics questions.

This course gives you a deep, 100% comprehensive understanding of Excel Pivot Tables and Excel Pivot Charts. I'll show you when, why, and how to use Excel Pivot Tables, introduce advanced sorting, filtering, and calculation tools, and guide you through interactive, hands-on demos and Excel exercises every step of the way.

__________

We'll start by covering everything you need to know to get up and running with Excel Pivot Tables, including:

  • Raw data structure in Excel

  • Pivot Table layouts & styles

  • Design & formatting options

  • Sorting, filtering, & grouping tools

  • Calculated fields, items & values

  • Pivot Charts, slicers & timelines

  • Interactive Excel dashboards

  • Writing formulas in Excel

NOTE: Full course includes downloadable resources and Excel project files, homework and course quizzes, lifetime access and a 30-day money-back guarantee. Most lectures compatible with Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019 or Office 365.

 

What you’ll learn in this Course?

  • Take your data analysis skills from ZERO to PRO with Excel Pivot Tables

  • Learn how to use Pivot Tables and Pivot Charts to streamline and absolutely revolutionize your workflow in Excel

  • Master unique Pivot Table tips, tools and case studies that you won't find in ANY other course, guaranteed

  • Best Pivot table Course by Certified Trainer

  • Get LIFETIME access to project files, quizzes, homework exercises

  • Test your skills with multiple Examples

Are there any course requirements or prerequisites?

  • Microsoft Excel 2010, Excel 2013, Excel 2016, Excel 2019 or Office 365

  • Basic experience with Excel functionality (charts & formulas a plus!)

Who this course is for:

  • ANYONE who works with Excel on a regular basis (even if you've never used a Pivot Table!)

  • Excel users who have basic skills but would like to become more proficient in data exploration and analysis

  • Students looking for a comprehensive, engaging, and highly interactive approach to training

  • Anyone looking to pursue a career in data analysis or business intelligence

  • Basic Knowledge of Excel
  • Access to Microsoft Excel version 2010 or newer
  • Data analysis and reporting professionals who work with Excel
  • Students who want to improve their skill set for MNC's
  • Excel knowledge workers looking to advance their skill set
  • Excel spreadsheet creators, maintainers, or users.
  • Anyone looking to pursue a career in data analysis or business intelligence
View More...
  • Section 1 : Getting Started 2 Lectures 00:12:09

    • Lecture 1 :
    • Lecture 2 :
    • Introduction
  • Section 2 : Starting with MS Excel Pivot Table 10 Lectures 00:41:23

    • Lecture 1 :
    • Why Excel Pivot Tables?
    • Lecture 2 :
    • How to Structure Source data for Analysis in Excel
    • Lecture 3 :
    • Creating Your First Excel Pivot Table
    • Lecture 4 :
    • Navigating the Pivot Table Field List
    • Lecture 5 :
    • Exploring Analyze & Design Tabs Options
    • Lecture 6 :
    • Selecting, Clearing, Moving & Copying Pivot Tables
    • Lecture 7 :
    • Refreshing & Updating Excel Pivot Tables
    • Lecture 8 :
    • Dealing with Dynamic Source Data in Pivots
    • Lecture 9 :
    • Removing & Reviving Data from Pivot Table Cache
    • Lecture 10 :
    • How Excel Pivot Tables Actually Works?
  • Section 3 : Formatting Data with Excel Pivot Tables 10 Lectures 00:32:40

    • Lecture 1 :
    • Changing the Excel Pivot Table Number Formats
    • Lecture 2 :
    • Formatting Empty Pivot Table Cells
    • Lecture 3 :
    • Configuring Excel Pivot Table Layouts & Styles
    • Lecture 4 :
    • Excel Pivot Table Tabular Form
    • Lecture 5 :
    • How to Create Custom Pivot Table Styles
    • Lecture 6 :
    • Customizing Pivot table Headers and Labels
    • Lecture 7 :
    • Applying Conditional formatting to Pivot Tables
    • Lecture 8 :
    • Adding Data Bars with Invisible Text in Pivot tables
    • Lecture 9 :
    • Applying Advanced Conditional Formatting to Pivot Tables
    • Lecture 10 :
    • Creating Pivot Table Using External Data Source
  • Section 4 : Sorting, Filtering & Grouping Data With Pivot Tables 9 Lectures 00:37:56

    • Lecture 1 :
    • Sorting Data With Excel Pivot Tables
    • Lecture 2 :
    • Fixing Incorrect Alphabetical Sorting in Pivot Tables
    • Lecture 3 :
    • Filtering data with pivot tables Labels and Values
    • Lecture 4 :
    • Excel Pivot table Label filter with WILDCARDS
    • Lecture 5 :
    • Enabling Multiple Pivot table Filters
    • Lecture 6 :
    • Grouping Data in the Pivot Tables
    • Lecture 7 :
    • Enabling & Disabling Automatic Date Grouping
    • Lecture 8 :
    • Filtering Data With PIVOT TABLE Slicers and Timelines
    • Lecture 9 :
    • Pivot table Report Filter Pages
  • Section 5 : Summarize Data with Pivot table Values 9 Lectures 00:30:04

    • Lecture 1 :
    • Aggregating & Summarizing Data with Pivot Tables
    • Lecture 2 :
    • Avoiding Pivot table 'Count of' Trap
    • Lecture 3 :
    • Defining Value Calculations with Pivot Table
    • Lecture 4 :
    • Calculating Pivot table Values: % of Column or Row
    • Lecture 5 :
    • Calculating Pivot Table Values : % of Parent
    • Lecture 6 :
    • Calculating Pivot Table Values: Difference from
    • Lecture 7 :
    • Calculating Pivot Table Values: Running Total in
    • Lecture 8 :
    • Calculating Pivot Table Values: Rank
    • Lecture 9 :
    • Calculating Pivot table Values: Index
  • Section 6 : Pivot Table Summarize Data With Calculated Fields 6 Lectures 00:35:56

    • Lecture 1 :
    • Recommended Pivot Tables and Sub Totals
    • Lecture 2 :
    • Calculated Fields with Pivot Tables
    • Lecture 3 :
    • Pivot table Calculations with Count Columns
    • Lecture 4 :
    • Pivot Table Calculations using Count Columns - Part 2
    • Lecture 5 :
    • Inserting Pivot Tables calculated Items
    • Lecture 6 :
    • Generating Solve Order & List Formulas Reports
  • Section 7 : Microsoft Excel Analysis With Complete Pivot Tables 4 Lectures 00:44:54

    • Lecture 1 :
    • Complete Pivot Tables in Excel
    • Lecture 2 :
    • Pivot Table Consolidation in Excel
    • Lecture 3 :
    • Slicers and Timeline in Excel Pivot Tables
    • Lecture 4 :
    • How to Write Formulas in Excel Pivot Tables
  • Section 8 : Visualizing & Analyzing Data with Excel Pivot Charts 11 Lectures 01:00:44

    • Lecture 1 :
    • Introduction to Excel Pivot Charts
    • Lecture 2 :
    • Designing Column Charts in Pivot Table
    • Lecture 3 :
    • Pie & Doughnut Charts in Pivot Table
    • Lecture 4 :
    • Clustered Bar Charts in Pivot Table
    • Lecture 5 :
    • Preventing Charts from Resizing with Cells
    • Lecture 6 :
    • Changing Pivot Chart Types & Swapping
    • Lecture 7 :
    • Stacked Area Chart in Pivot Table
    • Lecture 8 :
    • Customizing Pivot Chart Layouts & Styles
    • Lecture 9 :
    • Move Pivot Charts to New Excel worksheets & Other Places
    • Lecture 10 :
    • Applying Slicers and Timelines to Multiple Pivot Charts
    • Lecture 11 :
    • Building Dynamic Dashboards With Pivot Tables & Charts
  • Section 9 : MS-Excel 2019 VLOOKUP & HLOOKUP Functions 3 Lectures 00:17:03

    • Lecture 1 :
    • Excel 2019 Complete VLOOKUP Function
    • Lecture 2 :
    • Excel 2019 Complete HLOOKUP Function
    • Lecture 3 :
    • MS Excel 2019 Complete Shortcut Keys
  • Section 10 : Course Wrapping Up 1 Lectures 00:01:36

    • Lecture 1 :
    • Conclusion of the Course
  • Learnfly Google Logo
  • Learnfly Facebook Logo
  • Learnfly Apple Logo
  • Learnfly EA Logo
  • Learnfly Amazon Logo
  • Learnfly IBM Logo
  • Learnfly Microsoft Logo
  • Learnfly Reddit Logo
  • Learnfly Spotify Logo
  • Learnfly Uber Logo
  • Learnfly Youtube Logo
  • Learnfly Instagram Logo
  • How do i access the course after purchase?

    It's simple. When you sign up, you'll immediately have unlimited viewing of thousands of expert courses, paths to guide your learning, tools to measure your skills and hands-on resources like exercise files. There’s no limit on what you can learn and you can cancel at any time.
  • Are these video based online self-learning courses?

    Yes. All of the courses comes with online video based lectures created by certified instructors. Instructors have crafted these courses with a blend of high quality interactive videos, lectures, quizzes & real world projects to give you an indepth knowledge about the topic.
  • Can i play & pause the course as per my convenience?

    Yes absolutely & thats one of the advantage of self-paced courses. You can anytime pause or resume the course & come back & forth from one lecture to another lecture, play the videos mulitple times & so on.
  • How do i contact the instructor for any doubts or questions?

    Most of these courses have general questions & answers already covered within the course lectures. However, if you need any further help from the instructor, you can use the inbuilt Chat with Instructor option to send a message to an instructor & they will reply you within 24 hours. You can ask as many questions as you want.
  • Do i need a pc to access the course or can i do it on mobile & tablet as well?

    Brilliant question? Isn't it? You can access the courses on any device like PC, Mobile, Tablet & even on a smart tv. For mobile & a tablet you can download the Learnfly android or an iOS app. If mobile app is not available in your country, you can access the course directly by visting our website, its fully mobile friendly.
  • Do i get any certificate for the courses?

    Yes. Once you complete any course on our platform along with provided assessments by the instructor, you will be eligble to get certificate of course completion.
    Learnfly LMS Sample
  • For how long can i access my course on the platform?

    You require an active subscription to access courses on our platform. If your subscription is active, you can access any course on our platform with no restrictions.
  • Is there any free trial?

    Currently, we do not offer any free trial.
  • Can i cancel anytime?

    Yes, you can cancel your subscription at any time. Your subscription will auto-renew until you cancel, but why would you want to?
User Images | Learnfly

111953 Course Views

2 Courses

Corporate Training Skills: Corporate Trainer for Many Start Ups and MSME Companies. Certified with Highest Qualified Marks in MOS Certifications - Microsoft Certified Trainer (MCT) - Microsoft Office Master 2019 - Microsoft Office Expert 2019 - Microsoft Office Specialist 2016 - Microsoft Office Expert 2016 - Microsoft Office Master 2016 - Microsoft Python Certified Working Experience:- 10+ Years of experience in Advanced Excel Automation ,VBA Developer and Excel Corporate Training • Microsoft Certified Professional in Excel • Hands on experience in Building Desktop Automation using VBA / Excel macros • Coding development in VBA (Excel) (Procedures, Functions & Classes) • Exposure to Pivot table & charts, VLOOKUP & HLOOKUP and Nested formulas • Developed user heavy screens with complex reporting requirements • Good knowledge in creating and maintaining add ins for Excel • Ability to create COM-addin and Automation add ins for Excel when required • Experience with SQL Server, Oracle, or other databases • Expert Knowledge of Excel Object Model • Working Knowledge of SQL (Procedures & Functions)
View More...
  • Unmatched Variety and Value!
    Learnfly's monthly subscription offers unlimited access to a vast range of courses. Affordable pricing, compared to competitors, makes it the ultimate choice for continuous learning.
    Jessica M.

    4.7

    JM
  • Top-Notch Quality, Affordable Rates!
    High-quality courses with certified instructors make Learnfly stand out. The affordable pricing is a game-changer for those seeking premium education.
    Alex P.

    4.5

    AP
  • Certified Excellence Every Time!
    Learnfly's courses, taught by certified instructors, ensure top-notch learning experiences. The course completion certificates add significant value to one's skill set.
    Sarah R.

    4.3

    SR
  • Round-the-Clock Support!
    Learnfly goes the extra mile with 24/7 course support. Their dedication to helping students succeed is commendable.
    Ryan K.

    4.1

    RK
  • Learn Anywhere, Anytime!
    Whether on mobile, PC, or tablet, Learnfly's platform offers flexibility. Learning on the go has never been easier.
    Emily S.

    4.7

    ES
  • Job-Ready Skills!
    Learnfly's job-oriented courses equip learners with practical skills for the workplace. An investment in career growth!
    Jake M.

    4.2

    JM
  • Budget-Friendly Brilliance!
    Learnfly's pricing is a steal for the quality and variety of courses offered. Quality education without breaking the bank.
    Olivia T.

    4.5

    OT
  • Instructor Excellence Unleashed!
    Learn from the best with Learnfly's certified instructors. The platform ensures that knowledge is imparted by industry experts.
    Daniel L.

    4.0

    DL
  • Achievement Unlocked!
    Learnfly not only offers courses but also recognizes your efforts with course completion certificates. A sense of accomplishment with every course finished.
    Maya H.

    4.6

    MH
  • Learning Revolution!
    Learnfly's platform is a revolution in education. Access to unlimited courses at affordable rates is a game-changer.
    Ethan W.

    4.7

    EW
  • principles-of-data-cleaning

    Principles of Data Cleaning

    By : Phikolomzi Gugwana

    Lectures 25 Beginner 0:34:10
  • microsoft-power-bi-a-complete-hands-on-training

    Microsoft Power BI-A Complete Hands...

    By : Deepesh Vashistha

    Lectures 41 Beginner 3:35:28

Students learning on Learnfly works with Fortune 500 companies around the globe.

  • Learnfly | a-l-1a Icons
  • Learnfly | a-l-2a Icons
  • Learnfly | a-l-3a Icons
  • Learnfly | a-l-4a Icons
  • Learnfly | a-l-6a Icons
  • Learnfly | a-l-7a Icons
Sign Up & Start Learning
Learnfly | Sign Up Icons
Learnfly | Sign Up Icons
Learnfly | Sign Up Icons




By signing up, you agree to our Terms of Use and Privacy Policy
Reset Password
Enter your email address and we'll send you a link to reset your password.
Learnfly | Sign Up Icons