Office Productivity Microsoft Excel

New Reporting Features in Excel 2013

Create great looking dashboards with the new reporting (and a few other) features in Excel 2013.
Rating: 4.5 out of 5 (428 ratings)
10,046 students
Created by Matthew Bernath
Enroll now
New Reporting Features in Excel 2013
Rating: 4.5 out of 5 (428 ratings)
10,046 students
Buy now
Visualise data in Excel using new charts and graphs only available in Excel 2013 and upwards

Requirements

  • Excel 2013 or higher installed
Description

Create great looking dashboards with the new reporting (and a few other) features in Excel 2013.  This short course gives you an introduction to some of the new features, together with practice workbooks.  From PivotTables to Recommended Charts and Flash Fill, this course will quickly get you up to speed with some of the changes from previous versions of Excel.  A preview of the Forecast functionality in Excel 2016 is also shown.

This course is ideal for anyone upgrading from Excel 2010 (or lower) to Excel 2013 or Excel 2016.

Who this course is for:
  • Anyone who wants to visualise data, create charts or graphs in Excel
Course content
4 sections • 9 lectures • 33m total length
  • Introduction
    08:13
  • Using the Demo Workbook
    03:14
  • Chart Recommendations - Displaying your data correctly
    00:56
  • Flash Fill - Quickly Formatting Lots of Data
    03:30
  • Quick Analysis - Analysis Data Sets Quickly and Easily
    01:19
  • In Cell Charts
    03:17
  • Excel 2013 vs. 2016 Caveat
    00:14
  • New PivotTable Features & Add-Ins
    08:17
  • Sneak Peak: Excel 2016
    04:10
  • New Features in Excel 2013 Quiz
    4 questions

Instructor
Matthew Bernath
Entrepreneur | Engineer | CFA® charterholder
Matthew Bernath
  • 4.1 Instructor Rating
  • 1,280 Reviews
  • 21,630 Students
  • 4 Courses

Matthew is an entrepreneur, engineer, CFA® charterholder, trainer and Excel addict with a love for finance, data science, process optimisation, data visualisation and building businesses.

As a qualified engineer, Matthew has consulted to five of the largest South African banks and numerous corporates and parastatals on a number of technology, dashboard, strategy, risk, training, financial modelling and process re-engineering engagements. He has provided Excel and Financial Modelling training to four of the largest banks in South Africa, and runs regular, highly rated in-house and public Excel, VBA, Financial Modelling and Dashboards training courses. With practical insight and a broad client base, Matthew has never been rated less than 5 out of 5 for subject matter expertise.