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 AWS Certified Developer - Associate CompTIA Security+
Photoshop Graphic Design Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Personal Transformation Meditation Life Purpose Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native 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
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Data Science
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
2021-01-08 13:09:04
30-Day Money-Back Guarantee

This course includes:

  • 42 mins on-demand video
  • 11 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Assignments
Office Productivity Microsoft Excel

Excel: Excel for Beginners

Master Data analysis using Excel Pivot Tables and Charts
Rating: 4.3 out of 54.3 (4 ratings)
1,168 students
Created by Prashanth Chidambaram
Published 11/2020
English
English
30-Day Money-Back Guarantee

What you'll learn

  • Build your data analysis skills from scratch
  • Master pivot tables, with real world examples that you will not find in any other course or textbook
  • Hands-on practice exercises where you will learn how to construct pivot tables as well as charts
  • Test your skills by practising along-with instructor and becoming a pro by the end of the course!

Requirements

  • Basic experience with Excel (Formula, Charts etc.)
  • MS Office 2013 or later (best set up for Windows OS)

Description

Using Pivots in Excel: Master Data analysis using Pivots in Excel and gain one of employer's most requested skills in 2020!

This course is for everyone who is either completely new, or a beginner with pivots in excel. In this course, you'll learn the basics of Excel, how to work with raw data and  carry out data analysis quickly using pivots.

This course does not require any prior knowledge of Excel pivots. You should be comfortable working with data and prior knowledge of Excel may prove in handy to understand some of the tools and funtionalities taught in this course.

This course is excellent to kickstart your path to becoming proficient in Excel, you'll learn all the basics to get you started and applying at your job right away!

With the "Data Analysis with Excel Pivots" course you will learn how to use Excel pivots from scratch and start solving several real world problems

Excel Pivot tables are absolute essential for anyone working with large and complex datasets!

Pivots allow you to quickly cut through the noise and deep dive into the datasets. Be it analyzing YoY growth rates, looking at market share trends, product profitability and so on - pivots allow to process large datasets and derive insights quickly

You'll be learning when, how and why to use excel pivot tables as well as charts as part of your day to day analysis. You'll be learning the following-

a. Understanding raw data structures

b. Building basic pivot tables choosing relevant rows, column and values

c. Using calculated fields

d. Using sort, filter and grouping tools within pivots

e. Summarize pivot table values by sum, average, count etc.

e. Modifying Pivot tables - titles, table formatting

f. Display outputs through pivot charts

Whether you're looking to explore Excel Pivot Tables for the first time, or are looking to brush up your skills with hands- on exercises. You have come to the right place.

In the bonus section, you would be exposed to slicer tools that let's you filter multiple pivots and draw insights on multiple parameters at once.

This course is compatible on Excel 2010 or later.

Who this course is for:

  • Anyone who works on a regular basis on Excel and has not explored pivots
  • Anyone looking to pursue a long-term career as a data analyst, data scientist, or researcher etc.

Course content

3 sections • 11 lectures • 41m total length

  • Preview01:25
  • Preview02:35
  • Preview05:56
  • Applying Pivots in Excel - Question 2
    05:13
  • Testing your skills in Pivots so far!
    4 questions

  • Applying Pivots in Excel - Question 3
    03:34
  • Applying Pivots in Excel - Question 4
    02:54
  • Applying Pivots in Excel - Question 5
    03:50
  • Applying Pivots in Excel - Question 6
    06:50
  • Recap of concepts covered so far!
    5 questions
  • Applying Pivots in Excel - Question 7
    02:44
  • Applying Pivots in Excel - Question 8
    02:44
  • Assignment: Building your own Pivot Table
    2 questions

  • Preview04:04

Instructor

Prashanth Chidambaram
Educator
Prashanth Chidambaram
  • 4.3 Instructor Rating
  • 22 Reviews
  • 4,913 Students
  • 4 Courses

Prashanth Chidambaram has a Bachelors in Chemical Engineering , MBA in Finance and Operations as well as an Associate's Degree in Piano.

Currently he works as an analyst with Mckinsey and Company and has worked on projects spanning network design and optimization, inventory planning, demand forecasting and has helped clients accelerate their digital journey.

As an educator, he runs an education services firm that provides music lessons to K-12 as well as pre-school students.

Feel free to contact him for more information on online classes, guidance, as well as for new courses.

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