Learn Excel Data Analysis with Pivot Charts & Pivot Table in Excel 2010, Excel 2013 & Excel 2016 now

Skills On Demand, Better Skills, Better Future

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
52 Videos (4h 35m)
    • Welcome to Excel 2016 Pivot Table and Pivot Chart Tutorial

      2:26
    • Data Source and Types in Excel 2016

      4:12
    • Create a normal Table and a Pivot Table, Learn the difference between both?

      4:09
    • Format and Styles

      0:48
    • Top Excel 2016 Functions

      0:48
    • Excel 2016 Function Summarize Values By

      5:19
    • Excel Function Show Value AS

      8:34
    • EXCEL 2016 FUNCTION ROUND IFERROR AVERAGE

      5:09
    • GROUP YOUR DATA Merged

      11:45
    • Excel 2016 INSERT SLICERS

      4:35
    • Excel 2016 Function SUM TRUE OR FALSE IF

      6:40
    • EXCEL 2016 FUNCTION AND OR RANK

      6:46
    • EXCEL FUNCTION LEFT HYPERLINK MAX AND MIN

      9:02
    • Excel 2016 Formula Columns Rows Date and Time

      5:27
    • Excel 2016 Formula ISLogical

      3:44
    • Top Excel 2016 Formulas

      0:41
    • Excel Formula Image Lookup

      4:40
    • Excel Formula Vlookup and Hlookup

      6:40
    • Excel Formula ISLogical

      3:44
    • Excel Formula CountIF Concate and Match

      8:40
    • Excel Formula Offset and Transpose

      10:30
    • Excel Formula SUMIF Find and Search

      7:00
    • Charts and Graphs

      2:35
    • Excel 2016 Combo Chart

      6:10
    • Excel 2016 Dynamic Chart with Dropdown

      6:14
    • Excel 2016 Dynamic Map Chart

      11:52
    • Excel 2016 Info Chart

      14:48
    • Excel 2016 Funnel Chart

      4:30
    • Excel 2016 Histogram Chart

      7:05
    • Excel 2016 Line Chart

      5:58
    • Excel 2016 Pareto Chart

      5:37
    • Excel 2016 Pie Doughnut and Race Tracks Chart

      10:03
    • Excel 2016 Radar Chart

      3:35
    • Excel 2016 Scatter Chart

      3:42
    • Excel 2016 Stock Chart

      3:51
    • Excel 2016 Sunburst Chart

      2:27
    • Excel 2016 Tree Map Chart

      2:48
    • Excel 2016 Waterfall Chart

      2:40
    • 3D Maps

      6:34
    • Area Chart

      3:40
    • Bar Chart

      4:44
    • Box and Whisker Chart

      4:52
    • Bubble Chart

      4:49
    • Column Chart

      4:32
    • Sunburst Chart

      2:27
    • Tree Map Chart

      2:48
    • Waterfall Chart

      2:40
    • Excel 2016 Design and Style Elements

      5:38
    • Excel 2016 Pivot Table an Overview

      6:09
    • Excel 2016 Pivot Chart and table an Overview

      3:55
    • Excel 2016 Pivot Chart an Overview

      6:32
    • Conclusion - Course Reload

      0:45

About This Class

Microsoft Excel - Learn Excel Formulas, Excel Functions, Excel Graphs, Excel Pivot Charts, Excel Pivot Tables and Design and Style Elements used to create impressive Excel graphical representation of data.

ee9c019e

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

In this course

You will learn the Excel Pivot Table and Pivot Chart Function in detail and you will learn how to create Dynamic Excel Charts and 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 functions and formulas used to Pivot your data.
  • 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 Excel Chart types used in Dynamic Excel Dashboards , Top Excel formulas and Top Excel Functions, Excel Design and Excel Style Elements.

So Lets the Show begin!

9

Students

--

Projects

0

Reviews (0)

Skills On Demand

Better Skills, Better Future

Skills on Demand  is an Online Training Startup focused to provide technical training in subject like Programming, Office Productivity and Visual Creativity.

Whether you’re trying to learn a new skill from scratch, or want to refresh your memory on something you’ve learned in the past, you’ve come to the right place.

Join our classes on Skillshare to upgrade your skill set at the right place, right time convenient for you as we offer stress f...

See full profile