Instructor for this course
more

In this follow up to Excel Efficiency: Tips & Tricks I Excel expert David Ringstrom, CPA shares more of his favorite Excel tricks. This course is designed to help you use Excel more effectively. In this session David teaches primarily from Excel 2010, but covers differences in Excel 2003, 2007, and 2013 where applicable.

Topics Covered:

  • Discover techniques that automatically provide fall-back positions in the event that you need to see an earlier version of your spreadsheet.
  • Discover how to quickly access folders and workbooks, whether on your computer or on a network     
  • Discover how to disable worksheet animation in Excel 2013.
  • Learn the risks--and rewards--of double-clicking on the fill handle in Excel.
  • See steps to take if you can't open a damaged workbook.
  • Embed frequently used lists, such as employees, departments, or key customers into Excel's interface for use with any spreadsheet.

Course Series

This course is included in the following series:

2 CoursesTips and Tricks for Excel Efficiency

  • Excel Efficiency: Tips and Tricks I
  • Excel Efficiency: Tips and Tricks II

Learning Objectives

  • Discover how to overcome annoying user-interface aspects of Excel 2013
  • Utilize Excel's Text Box feature instead of merging cells to store paragraphs of text
  • Tally numbers faster and more efficently with Excel's SUBTOTAL function

43 Reviews (161 ratings)Reviews

5
Member's Profile
Repairing worksheets is good to know, likewise the automatic save .xlk file option. Handy tips on data series and custom series
5
Anonymous Author
I've taken several excel courses from David Ringstrom and they are always informative. In this one, I was hoping to be able to use the slides as a reference, but they are just too busy to follow compared with earlier courses. Still good material, though.
5
Member's Profile
These are some excellent tips and tricks. I will go right away and turn off the annoying "clipboard" that constantly appears in my way. It is an hour well spent because I pick up something helpful in each of Mr. Ringstrom's courses.
5
Anonymous Author
I liked learning about how useful and efficient the subtotal and double-click feature when applying formats. I've been using excel for many years and did not know of these useful features. Great course!
4
Member's Profile
Showed me some new tricks that I can use in my daily role. Some were reminders, but it never hurts to be reminded of the things that you used at one point and have thrown in the back of your mind.
4
Anonymous Author
Great course. Even though I use Excel constantly, I found the course worthwhile as I got reminders of things I had forgotten and/or learned some tips to make me more efficient.
Anonymous Author
This course provided some very useful tips. I found the slides were not that easy to follow however I did like the supporting file that allows you to try each of the tricks.
5
Member's Profile
This was a great course that efficiently covered a number of helpful tips. It was easy to follow. I recommend this and any other course by this instructor.
4
Anonymous Author
The subtotal function was the best followed by fill cell. Good to know these short cuts when working extensively with Excel
4
Member's Profile
Strange how much you think you knew about excel - until you start watching these courses. Good content & tips/ tricks.
5
Anonymous Author
Excellent course with lots of great tip and tricks that I can see myself using on a regular basis.
5
Anonymous Author
Nicely created class. Loved the fill series tip of hitting ctrl first to copy same data down.
4
Anonymous Author
I founds the course very helpful and will ensure to apply the tricks I learnded, thank you.
Anonymous Author
Pieces were lengthy. Too much wasted time formatted. First one in series was more useful.
5
Anonymous Author
Great class, love getting tips and tricks. Great teacher look forward to more classes!
5
Anonymous Author
Another great course for someone that is just getting their feet wet within Excel
5
Member's Profile
The subtotal and custom list features will be big time savers and a huge help!
4
Anonymous Author
I liked the course. The presenter shares lots of tricks I didn't know about.
4
Member's Profile
pretty awesome tips and tricks. very useful. good presentation and speaker.
4
Member's Profile
I always learn a few new tricks when watching one of David's presentations.
5
Member's Profile
Excel tips and trick are so useful in every day setting while using excel.
5
Member's Profile
Nice! learned a lot of tricks today. This course is very helpful. Thanks!
4
Anonymous Author
Solid course - I picked up a few tips and tricks, thanks!
5
Anonymous Author
Subtotal function useful to know. Good content overall.
5
Anonymous Author
Lots of things to make people more efficient in Excel.
5
Anonymous Author
There is always some tip that I did not know before.
5
Member's Profile
More good tips for useful features in Excel
4
Anonymous Author
Difference between subtotal and sum.
4
Anonymous Author
Good course and powerpoint slides
5
Anonymous Author
Lots of good useful Excel tips!
3
Anonymous Author
Some good short-cuts for Excel.
4
Anonymous Author
Great tips that are very useful
5
Member's Profile
This is a great course
5
Anonymous Author
Effective presentation
5
Anonymous Author
Easy to follow along.
5
Anonymous Author
Useful Information.
5
Member's Profile
the shortcuts
4
Member's Profile
Informative.
5
Member's Profile
Great stuff!
4
Member's Profile
Good course!
4
Anonymous Author
great course
5
Anonymous Author
Very Useful
5
Anonymous Author
Good stuff!

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
Tips and Tricks
  6:08Tweaking Excel 2013's User Interface
  9:09Double-Click Tricks
  7:19Paste Options; Repair Workbook; Text Box Feature
  12:33Series and Custom Lists
  7:41SUBTOTAL Function
Conclusion
  1:40Book recommendation; Closing Comments
Continuous Play
  52:28Excel Efficiency: Tips and Tricks II
SUPPORTING MATERIALS
  PDFSlides: Excel Efficiency: Tips and Tricks II
  PDFExcel Efficiency: Tips and Tricks II Glossary/Index
  xlsExcel Efficiency Tips and Tricks II-Excel 2003
  xlsxExcel Efficiency Tips and Tricks II-Excel 2007-2013
REVIEW & TEST
  quizREVIEW QUESTIONS
 examFINAL EXAM