Instructor for this course
more
Enrolled:
116
Duration: 1 Hour
Level: Advanced
Access This Course: Instant Access to Course Library

The course covers design techniques and simple ways to monitor the status of locked and unlocked worksheet cells. How-to Excel expert David H. Ringstrom, CPA, will demonstrate the numerous techniques he uses to improve the integrity of spreadsheets that he builds for himself and others.

You learn how to:

  • Use a simple design technique that greatly improves the integrity of Excel's SUM function.
  • Use the TEXT function to create report titles that update themselves.
  • Compare and contrast IFNA, IFERROR, and ISERROR, and see which versions of Excel support each of these worksheet functions.
  • Discover techniques that automatically provide fall-back positions in the event that you need to see an earlier version of your spreadsheet.

Course Collections

This course is included in the following Course Collections:

Learning Objectives

  • Use Conditional Formatting to identify which cells are unlocked within a protected worksheet
  • Utilize range names for faster formula writing
  • Use Excel's TEXT function to recreate self-updating notes and report titles

24 Reviews (54 ratings)Reviews

5
Member's Profile
Very helpful course. Mr. Ringstrom covered a lot of ground in a short amount of time. The supporting materials will come in handy when trying to put these techniques into action.
5
Anonymous Author
Great content and examples. I always come away from David's courses with new ways of working that I can implement immediately. His presentation method is very effective.
4
Anonymous Author
Fun and informative. Moves a little fast, but that does force you to pay attention! Definitely geared towards leaners with more than Basic Excel skills.
Anonymous Author
very informative course with lots of useful tips! The sound quality however was poor in areas. Also the slides were a little hard to follow.
4
Anonymous Author
David does a great job of talking about the Excel trick and then showing how it works.
5
Anonymous Author
I enjoyed this course and took away some new techniques and information.
4
Member's Profile
I learned a few tips and tricks that will be helpful that I didn't know.
5
Anonymous Author
Ver;y helpful tips that can easily be incorporated into your work.
5
Anonymous Author
Very good tips for anyone who creates Excel workbooks.
5
Member's Profile
Another excellent course from David Ringstrom.
4
Member's Profile
Great instructor. Good tips. Easy to follow.
5
Member's Profile
Great course! Very informative and helpful.
5
Anonymous Author
Easy to follow, some good for error proof
5
Anonymous Author
I learned several things I did not know.
4
Anonymous Author
Really enjoy this instructor's courses.
5
Anonymous Author
I loved the fast pace of this course.
5
Anonymous Author
Watching the keystrokes helped
4
Anonymous Author
Fairly basic, but good info
5
Anonymous Author
Great tips! Thank you!
5
Member's Profile
Nice course. Thanks!
5
Member's Profile
Helpful Excel tips
5
Anonymous Author
Very good.
5
Anonymous Author
i liked it
5
Anonymous Author
Thanks!

Prerequisites

Prerequisite: 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 ext. 106, or send an e-mail to .
Course Syllabus
INTRODUCTION AND OVERVIEW
Minimizing Errors
  8:13Workbook Clutter; Blank Rows; Title Rows; Smarter SUM formulas
  8:32Embedding Constants; Handling Formula Errors
  8:09Self-Updating Notes
  6:16Identifying Unlocked Cells
  5:16Very Hidden Worksheets
Conclusion
  6:07Back-Ups and Fallback Positions
  1:25Closing Remarks
Continuous Play
  51:16Excel Efficiency: Minimizing Worksheet Errors
SUPPORTING MATERIALS
  PDFSlides: Excel Efficiency: Minimizing Errors
  PDFExcel Efficiency: Minimizing Errors Glossary/Index
  xlsExcel Efficiency Minimizing Errors-Excel 2003
  xlsxExcel Efficiency Minimizing Errors-Excel 2007-2013
REVIEW & TEST
  quizREVIEW QUESTIONS
 examFINAL EXAM