Instructor for this course
more

In this course Excel expert David H. Ringstrom, CPA focuses on what he considers to be the 10 best new features in Excel 2013, along with his three most disliked features. Each feature discussed in this course is not available in Excel 2010 or earlier, so you learn how to take advantage of the new capabilities. This course is helpful if you are already using Excel 2013, or it can help you determine if you should move from an earlier version to the latest version.

Topics covered:

  • Explore the new Recommended Charts feature in Excel 2013.
  • Compare user interface changes in Excel 2013 that vastly simplify chart-related tasks.
  • Discover the new Recommended Pivot Tables feature in Excel 2013.
  • Understand how to use the Slicers feature in Excel 2013 to streamline analyzing data within tables.
  • Capitalize on new features in Excel 2013 that empower anyone to quickly analyze data.
  • Discover the Flash Fill feature in Excel 2013, as well as alternatives to use in earlier versions of Excel.
  • Discover how to disable worksheet animation in Excel 2013.
  • Cut through the tangles introduced by Excel 2013's revamped File menu.
  • Overcome annoyances in Excel 2013 by making simple adjustments to Excel's options.

This course helps you determine whether the new functionality of Excel 2013 is worth the effort and cost of upgrading, and you learn about how a number of new Excel features work in practice.

Learning Objectives

  • Explore how to streamline data analysis by way of the Recommended Pivot Tables and Recommended Charts features 
  • Recognize how to disable worksheet animation and other annoying aspects of Excel 2013
  • Discover how to use IFNA and FORMULATEXT worksheet functions.

21 Reviews (66 ratings)Reviews

5
Anonymous Author
Good info I finally know why when I click the X to exit a file - it completely logs me out of Excel - If you only have 1 workbook open you are SOL if you click the X
4
Anonymous Author
This course does a nice job of highlighting the new features in Excel 2013, as well as providing cautions of the not so helpful changes.
5
Member's Profile
Excellent Excel course!!! David Ringstrom is one of my favorite webinar leaders. I wish I had just half of his knowledge on Excel.
5
Member's Profile
Good course. As always, Mr. Ringstrom covers a lot of ground and teaches some interesting Excel techniques.
5
Member's Profile
Fast, lots of info but easy to understand. Downloads are very useful. Always something new to learn .
4
Anonymous Author
welld done, great pointers for trouble shooting and utilizing excel's more recent adjustments
4
Anonymous Author
Flash fill example was very good. I hope there's a similar course fro Excel 2016.
5
Member's Profile
This is a good review of some new features that users might not be aware of.
5
Anonymous Author
Great class! The handouts are the icing on the cake!
2
Anonymous Author
not as good as some of the other Excel classes
4
Anonymous Author
Good overview of updates in the 2013 version
4
Anonymous Author
a lot of good information, very helpful tips
5
Member's Profile
Good to learn new features of Excel 2013.
5
Member's Profile
Great course! Very informative.
5
Member's Profile
Great overview of the subject.
5
Member's Profile
Love the overview.
5
Anonymous Author
Nicely done course
5
Member's Profile
Good examples.
5
Member's Profile
Good Course
5
Anonymous Author
nice class
5
Member's Profile
good!

Prerequisites

Course Complexity: Intermediate

Prerequisite: Basic proficiency with Excel

 

Advanced Preparation: None

 

Education Provider Information

Company:
Illumeo, Inc., 75 East Santa Clara St., Suite 1215, San Jose, CA 95113
Contact:
For more information regarding this course, including complaint and cancellation policies, please contact our offices at (408) 400- 3993 or send an e-mail to .
Course Syllabus
INTRODUCTION AND OVERVIEW
Best/Worst of Excel 2013
  9:17IFNA and FORMULATEXT Functions
  11:16Easier Charts
  9:59Pivot Table and Table Related Features
  9:02Quick Analysis and Flash Fill
  9:22The 3 Worst Features
Conclusion
  1:19Closing Comments
Continuous Play
  53:10Excel Efficiency: The Best and Worst Features of Excel 2013
SUPPORTING MATERIALS
  PDFSlides: Excel Efficiency: Best/Worst of Excel 2013
  PDFExcel Efficiency: Best/Worst of Excel 2013 Glossary/Index
  XLSXArticles and Study Guide
REVIEW & TEST
  quizREVIEW QUESTIONS
 examFINAL EXAM