What's New in Excel 2013

Upgrader's Guide to Excel 2013
Course Created by Bill Jelen
Host of MrExcel.com website. Microsoft MVP in Excel for 10 years. Author of 43 books about Microsoft Excel and a frequent speaker at accounting conferences.

  •   Lifetime access to all lessons!
  •   30 days money back guarantee!
  •   Accessible via iPhone, iPad and Android (soon!)

There are over a dozen great features added to Excel 2013, but no one at Microsoft bothers to explain anything beyond Flash Fill. This course will run through everything new in Excel 2013, including:
Clean data with Flash Fill. Use the Quick Analysis pane. Why do I have to sign in to Excel? One benefit of saving files in the cloud. The new recommended Pivot Tables tool. Using timelines in pivot tables. Charting improvements. Dual Monitor Support. New Calculation Functions. Slicers on regular tables. Animations. Apps for Excel. Tweet your workbooks.
I will also introduce the Pro Plus add-ins; Power Pivot, Power View, and Power Map.

Course Objectives

  • Understand new features in Excel 2010
  • Learn Charting Improvements
  • Interacting with a Workbook in the Cloud
  • Clean Data with Flash Fill

Who Is This For?

  • Anyone upgrading to Excel 2013
  • Accountants
  • Finance
  • Financial Analysts
  • SQL Server Pros who want to learn Power Pivot

Course Outline

Chapter 1: Introduction

  • Lesson 1
    01-Intro
    01:04

Chapter 2: What's New in Excel 2013

  • Lesson 2
    Slot Machine Animation
    02:40
  • Lesson 3
    Support for Dual Monitors
    06:25
  • Lesson 4
    Charting Improvements
    06:09
  • Lesson 5
    Clean Data with Flash Fill
    04:54
  • Lesson 6
    Slicers on Regular Tables
    03:08
  • Lesson 7
    New Calculation Functions
    16:25
  • Lesson 8
    Pivot Table Improvements
    04:32
  • Lesson 9
    Apps for Excel
    01:47
  • Lesson 10
    Why Sign in to Office
    03:52

Chapter 3: What's New in Excel 2013 Pro Plus

  • Lesson 11
    Caution: How to Buy Pro Plus
    01:54
  • Lesson 12
    Power Pivot
    02:16
  • Lesson 13
    Power View for Interactive …
    03:55
  • Lesson 14
    Power Map
    03:05
  • Lesson 15
    Spreadsheet Inquire
    02:25
  • Lesson 16
    Conclusion
    01:02

  •   Lifetime access to all lessons!
  •   30 days money back guarantee!
  •   Accessible via iPhone, iPad and Android (soon!)