Instructor for this course
more

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.

Learning Objectives

  • 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.

22 Reviews (66 ratings)Reviews

4
Anonymous Author
I've taken several excel courses from David Ringstrom and they are always informative. In this one, I was hoping to be able to use the slides as a reference, but they are just too busy to follow compared with earlier courses. Still good material, though.
5
Member's Profile
I really liked the section on "Watch". I've used Excel since the first version, and never used Watch. This will be a big time saver. I agree about the possibility of Grouping errors - you may want to remind students about autorecover..
5
Anonymous Author
Good tips for auditing/printing large spreadsheets. Except for the Indirect function, all other tips for me were the first time to know about.
5
Member's Profile
Good tips for working with Excel files that have a large # of tabs. Note has nothing to do with working with large data sets.
5
Member's Profile
David shares some really good tips on managing those sprawling excel workbooks we all struggle with. Well worth your hour.
4
Anonymous Author
we need more knowledge on excel sheet numbering and printing overview the presenter did a great job
4
Member's Profile
the class is easy to follow. I like how it is broken up so I can do it in between meetins.
5
Anonymous Author
I love the Custom Views functionality. I only wished I had learned about it years ago.
4
Anonymous Author
Includes several things which I had not used. Will be very useful in my workbooks.
5
Anonymous Author
Quick intro to some useful excel features with which I was not familiar.
4
Anonymous Author
Decent course to have - refreshes concepts given in previous lessons
5
Member's Profile
new functions of excel that i didn't know much about.
4
Anonymous Author
David very knowledgeable with excel enhancements.
5
Anonymous Author
I was glad to find out about these functions!
5
Member's Profile
Great course! Very informative and helpful.
4
Anonymous Author
Useful and understandable information
5
Member's Profile
This is a good course
4
Anonymous Author
Good Information
5
Member's Profile
Great! thanks
5
Anonymous Author
Very good.
5
Member's Profile
Thanks!
5
Member's Profile
awesome

Prerequisites

Course Complexity: Advanced

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
Large Spreadsheets
  12:07Watch Window - Group-Ungroup
  8:28Custom Views
  10:10Printing Large Worksheets
  8:46INDIRECT Function
  8:47Performance Improvement Tips
CONCLUSION
  1:00Closing Comments
Continuous Play
  53:54Excel Efficiency: Large Spreadsheets
SUPPORTING MATERIALS
  PDFSlides: Large Spreadsheets
  PDFLarge Spreadsheets Glossary/Index
  XLSExcel Efficiency Large Spreadsheets-Excel 2003
  XLSXExcel Efficiency Large Spreadsheets-Excel 2007-2013
REVIEW & TEST
  quizREVIEW QUESTIONS
 examFINAL EXAM