Utilizing Large Spreadsheets in Excel
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 Utilizing Large Spreadsheets in Excel to your Wishlist.

Add to Wishlist

Utilizing Large Spreadsheets in Excel

This course explores the many nuances and best practices of working with large workbooks and worksheets in Excel.
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.
1 student enrolled
Last updated 7/2017
English
Current price: $12 Original price: $50 Discount: 76% off
3 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2 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?
  • Discover how to use the Watch Window feature to audit key formulas and navigate spreadsheets easily.
  • Discover how to use the Custom Views feature to transform how you print and manage large workbooks.
  • Identify refinements and features that can boost performance calculations in large workbooks.
View Curriculum
Requirements
  • Proficiency with Excel
Description

In this course Excel expert David Ringstrom, CPA, points out some of the nuances and best practices of working with large workbooks and worksheets in Microsoft Excel. You learn how to monitor and navigate to key cells and locations by way of the little-used Watch Window feature. The INDIRECT function will save you from manually editing formulas that reference a stack of worksheets, while Custom Views empower you to hide and unhide swaths of worksheets with ease. The course closes with pointers on how to improve calculation performance and pare down the file size of large workbooks.

Topics covered:

  • Use the Watch window to easily monitor the ramifications of even minor changes to your workbooks.
  • Learn the power--and the risks--of grouping worksheets.
  • Use Excel's Custom Views feature to hide and unhide multiple worksheets with ease.
  • Learn tricks to simplify printing information from large workbooks or worksheets.
  • Save time when aggregating data from multiple worksheets with Excel's INDIRECT function.
  • Learn techniques that let you reduce the file size of bloated Excel workbooks.

This course will make you even more of an Excel wizard and enable you to apply your skills to large workbooks and worksheets which others might not be able to deal with.

Who is the target audience?
  • Anyone interested in Excel for Business
Compare to Other Excel Courses
Curriculum For This Course
12 Lectures
01:47:13
+
Introduction
8 Lectures 01:47:09


Custom Views
08:27

Printing Large Worksheets
10:10

INDIRECT Function
08:46

Performance Improvement Tips
08:46

Closing Comments
00:59

Excel Efficiency: Large Spreadsheets Continuous Play
53:33
+
Supporting Materials
4 Lectures 00:04
Slides: Large Spreadsheets
00:00

Large Spreadsheets Glossary/Index
00:00

Excel Efficiency Large Spreadsheets-Excel 2003
00:01

Excel Efficiency Large Spreadsheets-Excel 2007-2013
00:01
+
Review and Test
0 Lectures 00:00
Review Questions
3 questions

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