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

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

Add to Wishlist

Excel Spreadsheet Auditing Part 2

This course continues the auditing discussion David Ringstrom, CPA, started in Part 1 of this series.
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.
1 student enrolled
Last updated 6/2017
English
Current price: $10 Original price: $50 Discount: 80% off
5 hours left at this price!
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?
  • Identify the keyboard shortcut that launches Excel's Visual Basic Editor.
  • Recognize the hidden formula tracing capability that turning off Allow Editing Directly in Cells enables.
  • Discover the location of the menu command that allows you to select all cells that contain formulas in a worksheet.
View Curriculum
Requirements
  • No advanced preparation or prerequisites are needed for this course. However, it is recommended to take the other courses in the series prior to completing this one.
  • Although each course may be taken individually, this is part 2 of 2. ​
Description

In this session, Excel expert David Ringstrom, CPA, continues the auditing discussion he started in Part 1 of this series.  You see how retrofitting existing spreadsheets with range names can transform the auditing process. You learn to determine at a glance if a spreadsheet contains links to other documents, as well as explore nuances surrounding cell comments, plus much more.

In this presentation, David demonstrates techniques in Excel 2016, but where applicable, he notes any differences in Excel 2013, 2010, or 2007. His webcasts 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:

• Find and select all formulas within a worksheet with just a couple of mouse clicks.

• Use the N function to annotate formulas within the formula bar when a cell comment won’t suffice.

• Learn how range names can minimize errors, save time in Excel, serve as navigation aids, and store information in hidden locations.

• Go beyond simply adding cell comments: easily hide, display, and locate all cells that contain comments.

• Audit all named cells in a workbook with ease by way of the INDIRECT function in all versions of Excel and the FORMULATEXT function in Excel 2013 and later.

• Track down the ripple effect of errors in spreadsheets with Excel’s Trace Error command.

• Go behind the scenes in a workbook to check for worksheets that can’t be viewed or hidden from Excel’s primary user interface.

• Print a list of all cell comments on a worksheet or print visible comments.

• See how to view two worksheets from within the same workbook at the same time.

• Simplify formula auditing by way of the Apply Names feature.


Although each course may be taken individually, this is part 2 of 2.  

1. Excel Spreadsheet Auditing Part 1

2. Excel Spreadsheet Auditing Part 2


Who is the target audience?
  • Anyone interested in Excel.
  • Anyone interested in Macros.
Compare to Other Excel Courses
Curriculum For This Course
9 Lectures
01:42:46
+
Introduction
6 Lectures 01:42:41

Apply Range Names to Formulas; Auditing Named Cells; Error Checking Command
10:51

Confirming If a File Has Links; Cell Comments; Printing Cell Comments
10:20

Allowing Editing Directly in Cells and N Function
09:16

Enabling Track Changes; Spreadsheet Edits; Reviewing Edits; Unhide Very Hidden W
09:49

Excel Efficiency: Spreadsheet Auditing Part 2 Continuous Play
51:19
+
Supporting Materials
3 Lectures 00:05
Slides: Excel Efficiency: Spreadsheet Auditing Part 2
00:01

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

Excel Efficiency - Spreadsheet Auditing Part 2 Examples
00:02
+
REVIEW AND TEST
0 Lectures 00:00

Review Questions: Excel Efficiency: Spreadsheet Auditing Part 2

REVIEW QUESTIONS
3 questions

Final Exam: Excel Efficiency: Spreadsheet Auditing Part 2

FINAL EXAM
5 questions
About the Instructor
Illumeo Learning
4.4 Average rating
326 Reviews
1,368 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
91 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 )