Tech & IT
Business
Coding & Developer
Finance & Accounting
Academics
Office Applications
Art & Design
Marketing
Health & Wellness
Sounds & Music
Lifestyle
Photography
This plan includes
- Instant access to 11,000+ online courses
- Play & Pause Course Videos
HD Video Recorded Lectures- Learn on Mobile/PC/Tablet
- Quizzes and Real Projects
- Lifetime Course Certificate
- Instructor Chat Support
- Cancel Plan Anytime
This plan includes
- Instant access to 11,000+ online courses
- Play & Pause Course Videos
- HD Video Recorded Lectures
- Learn on Mobile/PC/Tablet
- Quizzes and Real Projects
- Lifetime Course Certificate
- Instructor Chat Support
- Cancel Plan Anytime
What you'll learn?
- 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
Course Overview
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
Pre-requisites
- Basic Knowledge of Excel
- Access to Microsoft Excel version 2010 or newer
Target Audience
- 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
Curriculum 65 Lectures 05:14:25
-
Section 1 : Getting Started
- Lecture 2 :
- Introduction
-
Section 2 : Starting with MS Excel Pivot Table
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- Lecture 1 :
- Conclusion of the Course
Our learners work at
Frequently Asked Questions
-
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.
-
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?
Instructor
110985 Course Views
2 Courses
