Minimizing Excel Errors
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
0 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Minimizing Excel Errors to your Wishlist.

Add to Wishlist

Minimizing Excel Errors

This course covers design techniques and simple ways to improve the integrity of Excel spreadsheets.
New
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
0 students enrolled
Last updated 7/2017
English
Current price: $12 Original price: $50 Discount: 76% off
4 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • 4 Articles
  • 4 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion

Training 5 or more people?

Get your team access to Udemy's top 2,000 courses anytime, anywhere.

Try Udemy for Business
What Will I Learn?
  • 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.
View Curriculum
Requirements
  • Proficiency with Excel.
Description

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.
Who is the target audience?
  • Anyone interested in Excel.
Compare to Other Excel Courses
Curriculum For This Course
13 Lectures
01:42:38
+
Introduction
9 Lectures 01:42:33


Embedding Constants; Handling Formula Errors
08:32

Self-Updating Notes
08:08

Identifying Unlocked Cells
06:15

Very Hidden Worksheets
05:16

Back-Ups and Fallback Positions
06:07

Closing Remarks
01:25

Excel Efficiency: Minimizing Worksheet Errors Continuous Play
51:15
+
Supporting Materials
4 Lectures 00:05
Slides: Excel Efficiency: Minimizing Errors
00:01

Excel Efficiency: Minimizing Errors Glossary/Index
00:01

Excel Efficiency Minimizing Errors-Excel 2003
00:01

Excel Efficiency Minimizing Errors-Excel 2007-2013
00:01
+
Review and Test
0 Lectures 00:00

Review Questions: Excel Efficiency: Minimizing Worksheet Errors

Review Questions
3 questions

Final Exam: Excel Efficiency: Minimizing Worksheet Errors

Final Exam
5 questions
About the Instructor
Illumeo Learning
4.4 Average rating
326 Reviews
1,389 Students
242 Courses
Condensed and Efficient Courses for Busy Professionals

Illumeo, incorporated in 2009, is revolutionizing the hide-bound world of corporate learning. Illumeo works with corporate professionals and organizations of all sizes to build the skills and capabilities that help everyone be an expert at their job.

Based in Silicon Valley, CA, Illumeo serves thousands of corporations and corporate professionals across Finance, Accounting, Human Resources, Sales and Marketing. The platform offers assessments, industry-benchmarked competency analyses, hundreds of expert-developed courses, collaborative tools, and the ability for companies to self-publish internal courses that promote institutional knowledge retention and dissemination.

Illumeo is the place for expertise management and we are dedicated to the proposition that everyone can be an expert at their job.

David Ringstrom (Illumeo)
4.3 Average rating
15 Reviews
94 Students
14 Courses

David H. Ringstrom is a CPA and owner of Accounting Advisors, Inc., an Atlanta-based spreadsheet and database consulting firm that he started in 1991. David teaches 180 live webinars annually on Microsoft Excel, along with occasionally speaking at conferences. He is the co-author of Idiot's Guides: Introductory Accounting, and has served as the technical editor for over 30 books on accounting software. Some of his hundreds of freelance articles on spreadsheets have been published internationally. 

Experience

President : Accounting Advisors, Inc. - [1991-12 to Current]
David offers spreadsheet, database, and accounting software consulting services nationwide. He focuses on streamlining complex business processes via a combination of training, tools, and custom programming. 

Education

Bachelor of Business Administration, Accounting : J. Mack Robinson College of Business (at Georgia State University )