Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
66 Videos (4h 35m)
    • About this Class

      1:56
    • Be a Great Student! (NEW 2/17)

      0:53
    • Dashboards: Design Principles and 10 Golden Rules (NEW 2/17)

      3:49
    • Building an Effective Data Model (NEW 2/17)

      2:51
    • Select Data and Create a Chart with various ways

      9:31
    • Choosing a Chart Type, Chart Templates and Live Preview

      3:39
    • How to select the right Chart for your Data?

      4:12
    • Three ways to resize a Chart and move it to any location

      4:06
    • Change the Layout or Style of a Chart

      2:14
    • Getting to Know the Elements of a Chart

      3:33
    • Quick Layouts and learn to modify all the elements of a chart

      2:59
    • Chart Titles and how to link them with a cell

      4:29
    • How to link data with the graph and how to fill the gaps of a chart

      3:44
    • Learn Chart Axes in depth and add a Secondary Axis

      5:56
    • How to use dynamic labels, titles and make your chart interactive

      3:11
    • Displaying Data - Custom Axis Labels and Gridlines

      5:30
    • How to use Statistics with Line Chart - choose the best trendline

      5:10
    • Updating and adding new data in Chart with keyboard and mouse

      2:59
    • Add new Data to an existing Chart, from different worksheets

      2:31
    • Linking charts with Word and Powerpoint

      1:46
    • Printing a chart and the page break feature

      2:14
    • Use Pictures in Chart and how to create a Pictograph

      3:23
    • Unlinking a Chart and saving it as a picture - Static charts

      1:29
    • Excel’s Camera Tool and how we can use it

      1:34
    • Using Shapes and Effects to make prettier Charts

      2:21
    • Using Text and Wordart fancy Styles in a Chart

      3:25
    • What Are Sparklines

      6:16
    • In cell charting techniques using REPT function

      4:36
    • Create Data Bars with Conditional Formatting

      4:12
    • COLUMN CHART ~ the most widely used chart type

      2:55
    • DOUGHNUT CHART ~ a pie chart displaying more than one data series

      1:50
    • SCATTER (XY) CHART ~ ideal for scientific, statistical or engineering data

      3:06
    • LINE CHART ~ show me the trend!

      3:15
    • PIE CHART~ show proportions to a whole

      6:20
    • BAR CHART ~ and the main difference with Column Chart

      1:33
    • AREA CHART ~ useful for time periods

      2:11
    • STOCK CHART ~ ideal for stocks or temperatures

      5:58
    • BUBBLE CHART ~ a combination of Scatter and Area Chart

      1:21
    • (NEW 3/2017) BURN DOWN CHART

      5:43
    • CASE STUDY ~ Create a line chart with KPI Bands and track conversion rate

      6:50
    • RADAR (OR SPIDER) & SURFACE CHART

      2:02
    • COMBO CHART ~ a combination of different chart types

      3:26
    • GANTT CHART ~ for project management applications

      5:23
    • SPEEDOMETER - GAUGE CHART ~ learn how to create and use them in Dashboards

      10:54
    • PARETO CHART ~ the 80-20 chart - for business analysis

      4:12
    • WATERFALL - BRIDGE CHART ~ Use them and make awesome sales analysis

      8:11
    • BULLET CHART ~ a variation of a thermometer chart

      6:03
    • THERMOMETER CHART ~ Ideal for Measuring Performance

      4:24
    • HISTOGRAM ~ with Frequency Distribution

      4:36
    • VLOOKUP Function and Data Validation Case Study

      6:13
    • Dynamic Chart with Tables

      2:43
    • Dynamic Chart with Data Filters

      3:13
    • Dynamic Chart with OFFSET Function

      4:58
    • Dynamic Chart with INDEX function

      4:44
    • Dynamic Chart with Form Controls: Scroll Bar

      8:31
    • The Anatomy of a Pivot Table JULY15

      2:20
    • How to Create a Pivot Chart Using Different Methods JULY15

      3:12
    • Changing The Format Of A Pivot Chart And The Role Of Field Buttons

      4:47
    • Create a Dashboard using pivot tables and pivot charts - PART3

      7:45
    • Modifying Pivot Chart and Use Slicers to Filter Data JULY15

      3:43
    • Dashboards Design Principles and 10 golden rules

      3:32
    • Create a Dashboard using Sparklines

      6:14
    • Create a Dashboard using pivot tables and pivot charts - PART1

      6:10
    • Create a Dashboard using pivot tables and pivot charts - PART2

      7:06
    • 10 Top Excel Shortcuts by Mellon Training

      2:01
    • CASE STUDY ~ Analyze Facebook Ad Reports with Excel Pivot Tables and Charts

      3:33