Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ Microsoft AZ-900
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Personal Transformation Life Purpose Meditation CBT Emotional Intelligence
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Vue JS
Google Flutter Android Development iOS Development React Native Swift Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
Microsoft Power BI SQL Tableau Business Analysis Data Modeling Business Intelligence MySQL Data Analysis Blockchain
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Business Plan Startup Online Business Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Office Productivity Microsoft Excel

Mastering Pivot Tables To Analyze Business Data in Excel

How to Use the Power of Excel Pivot Tables to Analyze Business Data Quickly for Better Business Decisions
Rating: 4.0 out of 54.0 (8 ratings)
48 students
Created by Vinai Prakash
Published 8/2014
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Master Pivot Tables for analyzing data and converting it into actionable information
  • Find simple ways to look the the same data in different ways & gather insights

Requirements

  • Basic Knowledgo Excel. Familiar with Excel Version 2007, 2010, 2013, Excel 2016 or Office 365

Description

This course is designed for people familiar with Excel and who want to learn how to analyze data within Excel. We will use the in-built Pivot Table tool, and show how to use the tool, and how to go beyond the basics, to more advanced functionality to analyze data, performing complex calculations, and be able to turn data into actionable information easily.

It is meant for the data warriors to learn the Advanced Excel techniques of Pivot Tables to make sense of huge amount of data in Excel, and be able to create simple management reports which compare data as Percentages, perform year or year, quarter on quarter comparisons etc.

Who this course is for:

  • Beginners to Pivot Tables
  • People who know pivot tables, but want to take their knowledge further and use advanced features of Pivot Tables

Course content

4 sections • 9 lectures • 1h 24m total length

  • Preview04:48

  • Preview14:57
  • Preview10:22
  • Preview09:31

  • Adding SubTotals in a Pivot Table
    06:20
  • Preview06:20
  • Filtering Pivot Data in Unique Ways
    13:22

  • Adding New Calculations with Calculated Fields
    08:06
  • Analyze Data with Percentages
    10:15

Instructor

Vinai Prakash
Founder, ExcelChamp.Net
Vinai Prakash
  • 4.1 Instructor Rating
  • 12 Reviews
  • 61 Students
  • 2 Courses

Vinai Prakash is the founder of ExcelChamp.Net, and an avid Microsoft Excel user with over 30 years of experience in data ware housing, business intelligence, data analysis.

He loves to share his Excel knowledge to people all around the world in Excel workshops, in Excel dashboard trainings in Singapore, Middle East, etc.

Vinai is a sought after trainer for Project Management & IT training. He lives in Singapore with his wife, and 2 lovely boys. 

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.