New Reporting Features in Excel 2013
4.2 (6 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
768 students enrolled
Wishlisted Wishlist

Please confirm that you want to add New Reporting Features in Excel 2013 to your Wishlist.

Add to Wishlist

New Reporting Features in Excel 2013

Create great looking dashboards with the new reporting (and a few other) features in Excel 2013.
4.2 (6 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
768 students enrolled
Created by Matthew Bernath
Last updated 7/2017
English
Price: Free
Includes:
  • 33 mins on-demand video
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Visualise data in Excel using new charts and graphs only available in Excel 2013 and upwards
View Curriculum
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 is the target audience?
  • Anyone who wants to visualise data, create charts or graphs in Excel
Students Who Viewed This Course Also Viewed
Curriculum For This Course
+
Introduction
1 Lecture 08:13

An introduction to the course and brief content overview.

Introduction
08:13
+
New Excel Functions & Reporting Features
6 Lectures 12:30
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
1 Lecture 08:17
New PivotTable Features & Add-Ins
08:17
+
Sneak Peak: Excel 2016
1 Lecture 04:10

The Forecast Example workbook available in Microsoft Excel shows the different ways to forecast data.

Sneak Peak: Excel 2016
04:10

New Features in Excel 2013 Quiz
4 questions
About the Instructor
Matthew Bernath
4.2 Average rating
6 Reviews
768 Students
1 Course
Entrepreneur | Engineer | CFA® charterholder

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.