Excel Data Analysis with Excel Pivot Tables, Excel Dashboard

Details

Description

Microsoft Excel - Excel Data Analysis and Excel Data Visualization with Excel Pivot Tables, Excel Pivot Charts and 2 Interactive Excel Dashboards.

Excel Charts and Excel Graphs are one of most
powerful features of Microsoft Excel which allows the users to represent
numerical data in Graphical Data Visualization format so that end user gets a better view
of the Information discussed.

In this course

You will learn the Excel Pivot Table and Excel Pivot Chart Function in detail and you will learn how to create Dynamic Excel Charts and Excel Graphs.

We will help you understand how to present your data Graphically on a Dynamic Chart, Graph or 3D Map, to make the information appear in a simplified manner.

You will learn the Top functions and Top formulas used to Pivot your data.

You will Learn to create a 2 Dynamic Sales Dashboard

You will learn how to design, style and format aspects of Excel 2016 are applied on charts, graphs and 3D maps.

You will use the dynamic graphical representation to display your complex data in an impressive way.

Learn to customize Layout, Axes, Grid lines, Spark lines, Trend lines and Error Bars.

This Course is structured in 8 Plus chapters and you will learn all the aspects of Pivot Function in depth .

We will go through, 20 Plus different Chart types used in Dynamic Excel Dashboards , Top formulas and Top Functions, Design and Style Elements and finally you will create a 2 Dynamic Excel Sales Dashboard.

So Lets the Show begin!

View full description Hide full description

Objectives

You will learn about Pivot Tables and Pivot Charts
You will learn to create 2 interactive Excel Dashboards
20 Plus different Excel Charts and Graphs used in Interactive Dashboards
You will learn how to Design, Format and Style Data Elements
You will learn 30 Plus top Microsoft Excel Formulas and Functions

Instructional level

Advanced

Requirements

This Course is created on Excel 2016, You can also use Excel 2010 and above
Basic Excel Knowledge
Interest to Learn and Upgrade Your Skillset
A Windows or a MAC PC where Microsoft Excel is Installed

Who should take this online course

If you are looking to improve your Microsoft Excel Skills

If you want to learn how to create Excel Charts, Formulas and Functions and Excel Shortcuts

If you want to learn foundation of how to create Excel Dynamic Dashboards

If you create Management Reports or MIS

Excel users who have basic skills but would like to become more proficient in data exploration and analysis

Anyone who works with Excel on a regular basis

Chapter 1: Excel Data Analysis using Pivot Tables, Pivot Charts & Dynamic Excel Dashboards
- 1 Introduction to this Data Analysis and Data Visualization Course. 03:41 min
  
  DescriptionFrom this tutorial you will get an overview of how this course is structured, what you will learn from this course & how you will benefit and apply the knowledge you have gained in real world scenarios
- 2 All Tutorial Files - Download Below 00:03 min
  1
  
  DescriptionDownload all Example Files from below for this tutorial.
Chapter 2: Data Source and Types in Excel 2016
- 1 What are the types of Data supported in Excel and What are their Sources ? 03:47 min
  
  DescriptionIn this Section we will do an overview of what are the data types supported by Microsoft Excel 2016, What are the sources of getting a data in Excel and we will do an example of getting data from a website and format the data.
Chapter 3: Create a normal Table and a Pivot Table, Learn the difference between both?
- 1 Create Excel Tables and Excel Pivot Tables and learn the difference between both 04:12 min
  
  DescriptionFrom this tutorial you will learn how to Create a Table, Format and Structure the Data, use the Pivot Function and different fields in Pivot Function and how to Customize the Pivot Fields to get meaningful results for your Excel Data.
Chapter 4: Format and Styles
- 1 Learn the Format and Styles used in Pivot Tables for data customization. 04:09 min
  
  DescriptionFrom this tutorial you will learn more about the Format and Style elements used in Excel Pivot Function. You will learn about Functions like Summarize Values By and how the Pivot Table Structure changes by placing values in different pivot Table fields. You will also learn about features Excel has to customize and Design your Pivot Table.
Chapter 5: 15 Pivot Table Functions used in Excel 2016
- 1 Topics You will Learn 00:48 min
  
  DescriptionWelcome Back from this tutorial you will learn the top functions used Excel 2016 Dashboard reporting like , Excel Summarize Values by Sum, Average and Count, Excel Show Values as Year to Date, Difference of , Variance and MAX and MIN, Excel Group Your Data, Excel function Insert Slicers for your structured data, Excel function Sum, True or False and If, Excel function And, Or, and Rank, Excel Function Round, If-Error and Average, Excel Function Left, Hyperlink, Max and Min. So Lets Continue Learning!
- 2 Excel 2016 Function : Summarize Values by Sum, Average and Count 05:19 min
  
  DescriptionFrom this tutorial you will learn one of the most powerful functions of Excel 2016, Summarize Values by Sum, Average, Count, Product, Max and Min. This function will help you in creating and summarizing large amount of data in your reports.
- 3 Show Values as Year to Date, Difference of , Variance and MAX and MIN 08:34 min
  
  DescriptionFrom this tutorial you will learn one of the most powerful function in Excel 2016 called Show Value As. You will Learn how to use function as Running Total In, % of Running Total In, Difference Of , % of Difference of , % OF Grand Total and Rank Large to Small and Rank Small to Large.
- 4 Excel 2016 Function - Group Your Data 11:45 min
  
  DescriptionFrom this tutorial you will learn , one of the most important function in Excel 2016 called Group Your Data. You will learn how to Group Your Data based on Date, Number and Text.
- 5 Excel 2016 Function - Insert Slicers for your structured data 04:35 min
  
  DescriptionFrom this tutorial you will learn how to filter your data using Slicers in Excel 2016. Slicers in Excel 2016 help to sort and filter data effectively and efficiently in click of a button.
- 6 Excel 2016 Function : SUM, TRUE or FALSE and IF 06:40 min
  
  DescriptionIn this tutorial you will learn about 3 powerful functions used in Excel 2016 called, SUM, TRUE or FALSE and IF. Sum function in Excel 2016 helps you calculate sum of a series of data. True or False and IF are Logical Functions which helps the user understand if a particular data series meet the criteria set or not.
- 7 Excel 2016 Function : AND, OR, and RANK 06:46 min
  
  DescriptionIn this tutorial you will learn about 3 powerful functions used in Excel 2016 called, AND, OR and RANK. All these 3 functions are Logical in nature with returns the result based on criteria set.
- 8 EXCEL 2016 Function : ROUND, IF ERROR and AVERAGE 05:09 min
  
  DescriptionIn this tutorial you will learn about 3 powerful functions used in Excel 2016 called, ROUND, IF-ERROR and AVERAGE.
- 9 EXCEL 2016 Function : LEFT, HYPERLINK and MAX or MIN 09:02 min
  
  DescriptionIn this tutorial you will learn about 3 powerful functions used in Excel 2016 called, LEFT, HYPERLINK, MAX and MIN. Excel 2016 Left function returns the result of value from the Left of the data series. Excel 2016 Hyperlink function helps you link your data to external sources like a website, SQL database, other excel sheet or data in a same worksheet. Excel 2016 MAX and MIN function helps you find the Maximum and Minimum value in a data series.
Chapter 6: 15 Top Formulas Used in Excel 2016
- 1 Topics You will Learn 00:41 min
  
  DescriptionWelcome Back from this tutorial you will learn the top formulas used Excel 2016 Dashboard reporting like , Excel Vlookup, Excel Hlookup, Excel Image Lookup using Match and Index Function, Excel Count-IF, Excel Concatenat, Excel Match, Excel Is-Logical, Excel Offset and Transpose, Excel Columns, Excel Rows and Excel Date and Time Formulas. So Lets Continue Learning!
- 2 Top Formulas Used in Excel 2016 : VLOOKUP and HLOOKUP 06:40 min
  
  DescriptionIn this tutorial you will learn 2 most commonly used Lookup functions in Excel 2016 called Vlookup or Vertical Lookup and HLookUp which is Horizontal Lookup, which helps your lookup values in a data series based on set criteria.
- 3 Top Formulas Used in Excel 2016 : IMAGE LOOKUP 04:40 min
  
  DescriptionIn this tutorial you will learn how to lookup images in Excel 2016 using two other function called INDEX and MATCH. When a data is selected you will get a corresponding image representing the data.
- 4 Top Formulas Used in Excel 2016 : COUNT IF, CONCATENATE and MATCH 08:40 min
  
  DescriptionMicrosoft Excel Countif function counts the number of cells in a range, that meets a given criteria. The Concatenate function allows you to combine text from different cells into one cell. The Match function searches for a specified item in a range of cells, and then returns the relative position of that item in the range.
- 5 Top Formulas Used in Excel 2016 : SUM IF, FIND and SEARCH 07:00 min
  
  DescriptionExcel SUMIF function is a worksheet function that adds all numbers in a range of cells based on one criteria The Excel FIND function returns the position (as a number) of one text string inside another. When the text is not found, FIND returns a VALUE error. The search is NOT case-sensitive. The SEARCH function is a built-in function in Excel that is categorized as a String/Text Function. Get the location of text in a string. To check if a cell contains specific text, you can use the SEARCH function
- 6 Top Formulas Used in Excel 2016 : IS LOGICAL 03:44 min
  
  DescriptionThe Microsoft Excel ISLOGICAL function can be used to check for a logical value (ie: TRUE or FALSE). The ISLOGICAL function is a built-in function in Excel that is categorized as an Information Function. It can be used as a worksheet function (WS) in Excel.
- 7 Top Formulas Used in Excel 2016 : OFFSET AND TRANSPOSE 10:30 min
  
  DescriptionThe OFFSET function in Excel returns a cell or range of cells that has a specified number of rows and columns from a cell or range of cells. Sometimes you need to switch or rotate cells. You can do this by copying, pasting, and using the Transpose option. But doing that creates duplicated data. If you don't want that, you can type a formula instead using the TRANSPOSE function.
- 8 Top Formulas Used in Excel 2016 : COLUMNS, ROWS and DATE AND TIME 05:27 min
  
  DescriptionThe Excel COLUMN function returns the column number for a reference.Excel ROW function returns the row number for a reference. Date and Time formula provides the current date and current time of the day.
Chapter 7: Learn 20 Plus Charts used in Excel Dashboards - Detailed Overview with Examples
- 1 Now learn about 20 different Charts and Graphs types used in Excel 2016 Reports 02:35 min
  
  DescriptionWelcome back, in this tutorial you will learn about 20 plus Excel Charts and Excel Graphs used in Dynamic Excel Dashboards. Topics Covered include. Excel 2016 Column Chart,Excel 2016 Bar Chart, Excel 2016 Histogram Chart,Excel 2016 Pareto Chart,Excel 2016 Area Chart,Excel 2016 Line Chart, Excel 2016 Pie, Doghnut & Race Tracks, Scatter Chart, Bubble Chart, Tree Maps Chart, Excel 2016 Box and Whisker Chart, Excel 2016 Sunburst Chart, Excel 2016 Water Fall Chart, Excel 2016 Funnel Chart, Excel 2016 Radar Chart, Excel 2016 Stock Chart, Excel 2016 3D Maps, Excel 2016 Combo Chart, Excel 2016 Dynamic Map Charts and Excel 2016 Dynamic Info chart with Drop down. All the above charts are used in creating Excel 2016 Dynamic Dashboards.
- 2 Column Chart 04:32 min
  
  DescriptionIn this tutorial you will learn about how to create Excel 2016 Column Chart.
- 3 Bar Chart 04:44 min
  
  DescriptionIn this tutorial you will learn about how to create Excel 2016 Bar Chart.
- 4 Histogram 07:05 min
  
  DescriptionIn this tutorial you will learn about how to create Excel 2016 Histogram Chart.
- 5 Pareto Chart 05:37 min
  
  DescriptionIn this tutorial you will learn about how to create Excel 2016 Pareto Chart.
- 6 Area Charts 03:40 min
  
  DescriptionIn this tutorial you will learn about how to create Excel 2016 Area Chart.
- 7 Line Charts 05:58 min
  
  DescriptionIn this tutorial you will learn about how to create Excel 2016 Line Chart.
- 8 Pie, Doghnut & Race Tracks 10:03 min
  
  DescriptionIn this tutorial you will learn about how to create Excel 2016 Pie, Doughnut and Race Track Chart.
- 9 Scatter Charts 03:42 min
  
  DescriptionIn this tutorial you will learn about how to create Excel 2016 Scatter Chart.
- 10 Bubble Charts 04:49 min
  
  DescriptionIn this tutorial you will learn about how to create Excel 2016 Bubble Chart.
- 11 Tree Maps Charts 02:48 min
  
  DescriptionIn this tutorial you will learn about how to create Excel 2016 Tree Map Chart.
- 12 Box & Whisker Charts 04:52 min
  
  DescriptionIn this tutorial you will learn about how to create Excel 2016 Box & Whisker Chart.
- 13 Sunburst Charts 02:27 min
  
  DescriptionIn this tutorial you will learn about how to create Excel 2016 Sunburst Chart.
- 14 Waterfall Charts 02:40 min
  
  DescriptionIn this tutorial you will learn about how to create Excel 2016 Waterfall Chart.
- 15 Funnel Charts 04:30 min
  
  DescriptionIn this tutorial you will learn about how to create Excel 2016 Funnel Chart.
- 16 Radar Charts 03:35 min
  
  DescriptionIn this tutorial you will learn about how to create Excel 2016 Radar Chart.
- 17 Stock Charts 03:51 min
  
  DescriptionIn this tutorial you will learn about how to create Excel 2016 Stock Chart.
- 18 3D Maps 06:34 min
  
  DescriptionIn this tutorial you will learn about how to create Excel 2016 3D Maps.
- 19 Combo Chart 06:10 min
  
  DescriptionIn this tutorial you will learn about how to create Excel 2016 Column Chart.
- 20 Excel Info Charts 14:48 min
  
  DescriptionIn this tutorial you will learn about how to create Excel 2016 Info Chart.
- 21 Dynamic Map Chart 11:52 min
  
  DescriptionIn this tutorial you will learn about how to create Excel 2016 Dynamic Map Chart.
- 22 Design and Style Elements used in Excel Dashboards 05:38 min
  
  DescriptionFrom this tutorial you will learn about the various Design and Style Elements used in Excel Charts and Graphs. Topics covered include - Excel 2016 Data, Design, Style and Format elements used in Excel 2016. - Excel 2016 Layout and Axis, Grid lines, Spark line, Trend line, Error Bars
Chapter 8: Create a Pivot Chart to Pivot your Data graphically
- 1 Create Six Pivot Tables and use them to create Six Pivot Charts 03:55 min
  
  DescriptionIn this tutorial we will learn how to compare trends in Revenue, Sales, Commission, Regions, Showrooms etc., using Pivot Tables and Pivot Charts.
- 2 Learn to create a Pivot Chart using your Pivot Table. 06:09 min
  
  DescriptionIn this tutorial we will create 6 Excel Pivot Tables which we will use to create 6 Excel Pivot Charts. We will learn how to compare trends in Revenue, Sales, Commission, Regions, Showrooms etc., using Pivot Tables.
- 3 Create Six Pivot Charts using the Six Pivot Tables 06:32 min
  
  DescriptionIn this tutorial we will create 6 Pivot Charts using the 6 Pivot tables we had created in the last tutorial. We will learn how to compare trends in Revenue, Sales, Commission, Regions, Showrooms etc., using Pivot Charts.
Chapter 9: Create your first Dynamic and Interactive Excel Dashboard
- 1 Create Excel Pivot Tables from raw data used to create Dynamic Excel Dashboard 14:30 min
  
  DescriptionFrom this tutorial you will learn how to create a Dynamic Excel Dashboard using Excel Charts, Excel Slicers, Formulas and Excel Design and Style Elements
- 2 Create Excel Pivot Chart , Excel Slicers used to create Dynamic Excel Dashboard 16:34 min
Chapter 10: Create your second Dynamic and Interactive Excel Dashboard
- 1 Learn to create a powerful & dynamic Excel Sales dashboards - Part 1 09:02 min
- 2 Learn to create a powerful & dynamic Excel Sales dashboards - Part 2 13:35 min
- 3 Learn to create a powerful & dynamic Excel Sales dashboards - Part 3 15:57 min
Chapter 11: Course Summary - Congratulation for Learning a New Skill
- 1 An Overview of what you have learned from this course 00:51 min
- 2 Conclusion 00:03 min
  
  DescriptionThank You Note!

The Teachlr

SkillsOnDemand

Online Content Creator

Skills on Demand� is an Online Training Startup focused to provide�technical training in subject like Programming, Office Productivity and Visual Creativity. Whether you are trying to learn a new skill�from scratch or want to refresh your memory on something you have learned in the past, you have come to the right place. Join our classes to upgrade your skill set at the right pace and time convenient for you as we offer stress free E-Learning. Our courses can be watched 24/7 wherever you are

Reviews