Course ID: E5TUCS

Excel: 5 Tips for Understanding a Complicated Spreadsheet

Assuming responsibility for spreadsheets developed by someone else is a common occurrence for any professional. Figuring out a spreadsheet can be a tedious process – make it easier with these 5 tips.


LEARNING OBJECTIVES
  • Incorporate basic macros into workbooks to simplify review tasks
  • Perform basic formula review by quickly toggling between formula and display mode
  • Easily manage multiple sheets and workbook links

MAJOR TOPICS
  • Streamline the tedious process of navigating and understanding someone else’s workbook
  • Strategies to manage this process are reviewed and as well as the most common pain points when reviewing spreadsheet models
  • Incorporating macros (macro code will be provided), workbook formulas and links review, and managing a workbook with extensive worksheets

DESIGNED FOR
Any business professional responsible for managing and working with spreadsheets prepared by others

FIELD OF STUDY
Information Technology

PREREQUISITES
Comfortable working with and navigating Excel. Skills in topics mentioned are not required

COURSE PRODUCER
Business Learning Institute

CPE CREDITS
2.0

LEVEL
Intermediate

This course is available for your group as:

Group Live
 

Let's Roll!

To learn more or customize this course for your group, complete this form and a BLI team member will get back with you shortly.


Or, contact BLI: 888-481-3500 or learn@blionline.org