Instructor for this course
more
Enrolled:
109
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

22 Reviews (51 ratings)Reviews

5
Anonymous Author
Ver;y helpful tips that can easily be incorporated into your work.
4
Anonymous Author
Fairly basic, but good info
5
Anonymous Author
Easy to follow, some good for error proof
5
Member's Profile
Helpful Excel tips
5
Anonymous Author
Very good.
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
David does a great job of talking about the Excel trick and then showing how it works.
5
Member's Profile
Great course! Very informative and helpful.
4
Member's Profile
Great instructor. Good tips. Easy to follow.
3
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.
5
Anonymous Author
Very good tips for anyone who creates Excel workbooks.
5
Anonymous Author
I enjoyed this course and took away some new techniques and information.
5
Anonymous Author
Great tips! Thank you!
4
Member's Profile
I learned a few tips and tricks that will be helpful that I didn't know.
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.
4
Anonymous Author
Really enjoy this instructor's courses.
5
Anonymous Author
Watching the keystrokes helped
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
I learned several things I did not know.
5
Member's Profile
Another excellent course from David Ringstrom.
5
Anonymous Author
I loved the fast pace of this course.
5
Member's Profile
Nice course. 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