What's New in Excel 2010

Upgrader's Guide to Excel 2010
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!)

Most companies upgraded from Excel 2003 directly to Excel 2010. That means you are encountering the Ribbon for the first time. While you will eventually get used to the ribbon, it seems like the confusion from the Ribbon makes it hard to learn all of the great new features in Excel 2010. This course will quickly get you up to speed with:
  • Secrets in the new interface
  • Faster multi-threaded calculation
  • Over 40 new functions including AGGREGATE, IFERROR, and the plural SUMIFS
  • Remove duplicates
  • Sort by Color, Filter by Color
  • New pivot table calculations like Rank, Percent of Parent Item
  • Slicers for ad-hoc pivot table reports
  • Tiny charts with Sparklines
  • Power Pivot
  • Creating a web app by building it in Excel 2010 first.

Course Objectives

  • Deal with the ribbon and new interface
  • Learn amazing pivot table improvements
  • Learn calculation improvements in Excel 2010

Who Is This For?

  • Anyone who recently upgraded to Excel 2010
  • Accountants
  • Finance
  • I.T.
  • Marketing
  • Admin Professionals

Course Outline

Chapter 1: Introduction

  • Lesson 1
    1-Intro
    01:02
  • Lesson 2
    Interface Changes
    14:40

Chapter 2: Calculation Changes in Excel 2010

  • Lesson 3
    Formulas in Excel 2010
    08:28

Chapter 3: Data Analysis Tools in Excel 2010

  • Lesson 4
    Data Analysis
    03:15
  • Lesson 5
    Pivot Tables
    06:04
  • Lesson 6
    Publish your workbook to a …
    04:14
  • Lesson 7
    Mash up data with Power Pivot
    04:30

Chapter 4: Charting & Visualizations

  • Lesson 8
    Making Things Look Good
    09:26
  • Lesson 9
    Diagrams & Charts
    13:21

Chapter 5: Conclusion

  • Lesson 10
    Conclusion
    01:03

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