Data Analysis with Excel - Master Pivot Tables

Learn how to get useful insights using excel pivot tables apply it to find business solutions.

0.0

Course in English

30 days Money Back Guarantee
Certificate of Completion
More than 5 hours of content
Additional Material
Lifetime
access

Teacher: EdSolver Learning

Details

Description

Excel Pivot Tables is one of the most essential tool for all the data analysts and business intelligence executives. With the help of pivot tables in excel, you can fetch very crucial insights from your large databases of business.

Though we are going to teach you pivot table tools throughout this course, our main focus is on to teaching you how to analyze any given datasets easily and how to find valuable insights for business growth.

Whether you are a beginner excel learner, want to advance your excel skill or you want to add it in your resume to grab a better job, you are at the right place. This course is designed in a way that it covers all the minute details about excel pivot tables and also focuses on its practical implementation in work environment. This course will help you in application of these tools during your job. You will be able to select the right analysis tool for right purpose.

Enroll now and start your journey towards becoming a successful Data Analyst / Business Analyst / Excel Expert.

View full description Hide full description

Objectives

Learn data analytics using excel
Learn various pivot table tools

Instructional level

Multilevel

Requirements

Basic Knowledge of using Microsoft Excel

Who should take this online course

Beginner Data Analytics learners

Excel learners interested in Pivot Tables functions

Data analysis learners without coding knowledge

Chapter 1: Introduction to the Course
- 1 Course Overview 03:13 min
Chapter 2: Data Analysis and Excel
- 1 Concept - Data Analysis 04:56 min
- 2 Various Roles in Analytics 05:00 min
- 3 Tools for Data Analysis 06:05 min
Chapter 3: Basics of Excel Pivot Tables
- 1 Excel Tabs Overview 03:36 min
- 2 Use of Pivot Tables 02:39 min
- 3 Pivot Tables Tools 02:40 min
- 4 Sample Dataset 04:10 min
  1
Chapter 4: Creating Pivot Tables
- 1 Insert Pivot Tables 05:48 min
- 2 Pivot Table Fields 03:05 min
- 3 Table Rows 02:49 min
- 4 Table Columns 02:14 min
- 5 Table Values 02:22 min
- 6 Table Filters 02:10 min
Chapter 5: Pivot Table Design
- 1 Quick Layout Changes 04:54 min
- 2 Pivot Table Styles 04:38 min
- 3 Show or Hide Totals 02:48 min
Chapter 6: Summarizing Value Fields
- 1 Field Setting Options 06:53 min
- 2 Options to Summarize Data 06:20 min
- 3 Lesson 3 04:07 min
Chapter 7: Basic Calculations for Numeric Fields
- 1 Calculations Related to Totals 08:33 min
- 2 Calculations Related to Difference 10:35 min
- 3 Running Total 08:15 min
- 4 Ranking 04:28 min
Chapter 8: Calculated Fields and Items
- 1 Insert Calculated Field 07:58 min
- 2 Modify Calculated Fields 05:58 min
- 3 Insert Calculated Items 09:10 min
Chapter 9: Basic Pivot Filters
- 1 Filter and Sorting 08:27 min
- 2 Multiple Filters 03:49 min
- 3 Report Filter Pages 05:47 min
Chapter 10: Advanced Filters
- 1 Date Filters 12:04 min
- 2 Value Filters 09:00 min
- 3 Label Filters 08:26 min
Chapter 11: Slicers for Pivot Tables
- 1 Slicers vs Filters 06:47 min
- 2 Slicers in Action 06:15 min
- 3 Customizing Slicers 07:50 min
Chapter 12: Date Timelines
- 1 Using Date Timelines 03:34 min
- 2 Multi-level Timelines 05:35 min
- 3 Customizing Your Date Timelines 03:47 min
Chapter 13: Grouping Data
- 1 Grouping and Ungrouping Items 07:23 min
- 2 Grouping Date Fields 04:11 min
- 3 Create Value Bins 04:25 min
Chapter 14: Connecting Multiple Tables
- 1 Create a Data Model 08:26 min
- 2 Setting up Data Relationships 05:54 min
- 3 Managing Filter Connections 07:37 min
Chapter 15: Pivot Charts
- 1 Simple Charts vs Pivot Charts 04:25 min
- 2 Use Various Chart Elements 06:48 min
- 3 Format Pivot Charts 05:14 min
- 4 Charts for Diffrent Scenarios 10:43 min
Chapter 16: Conditional Formatting for Visualization
- 1 Value Based Highlighters 07:19 min
- 2 Data Visualizers 03:37 min
Chapter 17: Case 1 - Forex Rates Analysis
- 1 Case - Forex Rates Analysis 01:47 min
  1
- 2 Finding Data and Trends 07:36 min
- 3 Change in Forex Rates 07:23 min
Chapter 18: Case 2 - Customer Review Analysis
- 1 Case - Customer Review Analysis 01:30 min
  1
- 2 Maximum Ratings Received 08:14 min
- 3 Ratings for Custom Categories 06:45 min
- 4 Customer Recommendations 04:08 min
Chapter 19: Case 3 - Titanic Survival Analysis
- 1 Case - Titanic Survival Analysis 02:09 min
  1
- 2 Survival Chances 09:32 min
- 3 Worth of Tickets 04:03 min
Chapter 20: Summary
- 1 Course Summay 01:44 min

The Teachlr

EdSolver Learning

Owner

We provide training courses in to graduates, post-graduates and working professionals. We have a team of experts to provide YOU industry-demand skills in following areas. Data Analytics Computer Software and Systems Financial Management Business Management Enterprise Solutions Digital Marketing Creative Designs And much more...... Give yourself a wonderful experience of learning with the best education community. EdSolver Learning.