Excel Spreadsheet Auditing Part 1
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.
5 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel Spreadsheet Auditing Part 1 to your Wishlist.

Add to Wishlist

Excel Spreadsheet Auditing Part 1

This course covers the basics of spreadsheet auditing techniques.
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.
5 students enrolled
Last updated 6/2017
English
Curiosity Sale
Current price: $10 Original price: $50 Discount: 80% off
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • 3 Articles
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Discover how to manage iterative calculations (also known as circular references) within Excel workbooks.
  • Identify the Show Formulas feature in Excel and recognize its functionality.
  • Discover the mouse action that enables you to move from one end of a tracing arrow in Excel to the other.
View Curriculum
Requirements
  • No advanced preparation or prerequisites are needed for this course.
Description

In this session, Excel expert David Ringstrom, CPA, shares some of his favorite spreadsheet auditing techniques. You see how to enhance Excel with the ability to instantly add a worksheet comment that displays the underlying formula within a worksheet cell. You also learn about the under-utilized Watch Window feature, tracing cell precedents and dependents, and explore the nuances of circular references in Excel. In this presentation, David demonstrates techniques in Excel 2016, but where applicable, he notes any differences in Excel 2013, 2010, or 2007. His courses are fast-paced, and attendees often are surprised at the amount of ground he covers in a session. David's detailed handouts, with numbered steps, serve as reference material you can utilize going forward. He also provides an Excel workbook that includes the examples he uses to demonstrate techniques during the presentation. 

Topics covered:

  • Use the Watch Window to easily monitor the ramifications of even minor changes to your workbooks.
  • Understand the difference between manual and automatic calculation modes in Excel.
  • Move through formulas in slow motion with the Evaluate Formula feature.
  • Verify sums and totals quickly by simply selecting cells with your mouse.
  • Discover how to use Excel’s Personal Macro Workbook.
  • Learn two ways to instantly display all formulas within a worksheet.
  • Learn the nuances of circular references in Microsoft Excel
  • See the pros and cons of using the F9 key within Excel’s formula bar to evaluate a portion of a formula.
  • Learn how to trace dependents and precedents, both with Excel features and keyboard shortcuts.
  • Enhance Excel by creating the ability to display the formula within any worksheet cell in a cell comment.
  • Learn techniques for accessing password-protected workbooks when the password is not known.
Who is the target audience?
  • Anyone interested in spreadsheet auditing techniques.
  • Anyone in Finance, Accounting, or related fields.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
9 Lectures
01:43:40
+
Course Videos
6 Lectures 01:43:35


Evaluate Formulas and F9 Key
10:23

Trace Dependents, Trace Precedents, and Circulure Refrences
09:11

More on Circulure Refrences and Recovering Lost Passwords
09:19

Excel Efficiency: Spreadsheet Auditing Part 1
51:46
+
Supporting Materials
3 Lectures 00:05
Slides: Excel Efficiency: Spreadsheet Auditing Part 1
00:01

Excel Efficiency: Spreadsheet Auditing Part 1 Glossary/Index
00:01

Excel Efficiency: Spreadsheet Auditing Part 1 Examples
00:01
+
REVIEW AND TEST
0 Lectures 00:00

REVIEW QUESTIONS: Excel Efficiency: Spreadsheet Auditing Part 1

REVIEW QUESTIONS
3 questions

Excel Efficiency: Spreadsheet Auditing Part 1

FINAL EXAM
5 questions
About the Instructor
Illumeo Learning
4.2 Average rating
66 Reviews
617 Students
165 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.0 Average rating
5 Reviews
49 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 )