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
Photoshop Graphic Design Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development 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 Big Data
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
30-Day Money-Back Guarantee

This course includes:

  • 1 hour on-demand video
  • 9 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
Business Business Analytics & Intelligence Excel

Data Analytics with Excel PivotTables

Step by Step, easy to comprehend guide on how to use Excel PivotTables with examples
Rating: 4.2 out of 54.2 (1,341 ratings)
63,908 students
Created by Navya Kannan, Learnsector LLP
Last updated 9/2016
English
English
30-Day Money-Back Guarantee

What you'll learn

  • Understand the importance of Data analytics in today's business.
  • Understand the types of Business analytics and real life examples of Business analytics
  • How to use Excel PivotTables to easily and effectively work on your reports and make your data visually more appealing.
  • You will learn the different features of PivotTables like Grouping, Calculated Field, Calculated Item, Slicers, PowerPivot and Charts

Requirements

  • All you need is a Microsoft Excel installed on your desktop.
  • With a basic know-how of Excel you are good to go ahead with this course

Description

About this course

This course will teach you how to do Data analytics with Excel PivotTables. With the help of this course, you will understand the concept, various scenarios, and types of Business analytics. Along with that, you will learn, how to use one of the strongest features of Microsoft Excel, which is the PivotTables. 

Target audience

Anyone with no knowledge to a basic knowledge of Microsoft Excel can take this course and get a thorough understanding of Excel PivotTables. 

Course Structure

In this short but effective course, you will understand why Data analytics is very important in today's business to make an effective business decision, and how Excel can help you with this. 

This course takes you through the details of Data analytics and with various examples, helps you understand various aspects where Data analytics plays a vital role. Then you will learn, how you can exploit the power of Excel PivotTable to make your data visually more appealing and easier to analyze. With a step by step guide and examples, this course is easy to comprehend and learn. 

 

Who this course is for:

  • This course is helpful for anyone who works on Excel reports as this will make reporting more efficient.
  • If you deal with business presentations, then you can make use of this powerful tool to make an impact

Course content

1 section • 8 lectures • 52m total length

  • Preview01:15
  • Preview08:25
  • Excel and PivotTables
    Preview04:12
  • Getting Started with PivotTable
    11:43
  • Grouping in PivotTable
    07:27
  • Custom calculation in PivotTable
    09:17
  • Slicer
    02:47
  • PowerPivot
    07:22

Instructors

Navya Kannan
Software Asset Management Specialist
Navya Kannan
  • 4.4 Instructor Rating
  • 2,603 Reviews
  • 213,329 Students
  • 3 Courses

Started career as IT Service Desk executive for over 2 years. Later moved on to work as Software Asset Management (SAM) Specialist. My role involved taking care of Software compliance across the company. After continuing in this role for closer to 3 years, I started working as a Risk Consultant with the Big 4s. My role was to conduct software publisher specific audits to check an organisation's compliance status. This activity required extensive reporting, mainly with the help of Microsoft Excel and other tools. 

Learnsector LLP
Learn to Win
Learnsector LLP
  • 4.3 Instructor Rating
  • 4,549 Reviews
  • 211,713 Students
  • 6 Courses

Learnsector, your one-stop solution for all your training needs. We're dedicated to giving you the best in class training in the space of Programming, Cyber Security, Cloud, Machine Learning, Analytics and Project Management.

Our exclusive training helps you to acquire relevant skill set mandatory to grab thriving opportunities.We train you intensively to implement your technical skills in real-world scenario.We help you stay up-to-date with latest technologies and requirements of IT organizations across the world.

  • 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.