Reverse Engineering an Excel Workbook: How to Edit an Inherited Workbook
Price: $
Summary
If you've inherited an Excel workbook, you know the frustration of trying to figure out what the workbook's designer was thinking when they put it together. You may be experiencing the unhappy results of changing something over here and watching something break over there. Every improvement you try to make seems to create different problems. While it is tempting to just throw it out and start over, there may be some valuable information that will be lost forever. This program will help you navigate through a workbook to discover its underpinnings and inside workings.
- Discovering where formulas are and how they're working
- Tracing precedents and dependents to know what can and can't be deleted
- Uncovering conditional formatting schemes using tools, like Watch Windows and Track Changes
- Uncovering where things are going wrong & how to fix them.
Program Highlights
Excel Strategies to Uncover Formulas, Functions, Formatting & More
- Quick tips on showing what formulas are in use
- Reverse engineering precedents and dependents
- Essential tools & how to use them: Watch Windows, Track changes & more
- Finding, editing and duplicating conditional formatting
Creating Reference Files for Audit and Documentation
- Keys to successfully diagnosing where formulas are failing
- Correct workbook and worksheet cell references within formulas quickly
- Know exactly what you can and can't delete and keep the workbook functioning
- How to improve older workbooks to work with today's Excel functionality
About The Speaker
Melissa Esquibel is a technology consultant, coach, trainer and speaker.
- She is a consultant, frequent speaker and Microsoft Certified Trainer
- Since 1991, Ms. Esquibel has assisted a variety of companies and industries with Microsoft Office (Excel, Word, PowerPoint, Access, Outlook) all versions through 2010.
- Melissa has 25+ years experience in information technology with a background in training, technical writing and business risk analysis
Program Benefits
Discover how you can edit and improve the existing workbooks that you get sent within your company.
Credits
Credit Hours:
Field of Study:
Program Level:
Basic KnowledgePrerequisites:
NoneAdvance Prep:
Delivery Method:
Group Internet Based
Progressive Business Conferences is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website:
www.nasbaregistry.org
Purchase This On-Demand Webinar
Reverse Engineering an Excel Workbook: How to Edit an Inherited Workbook
Format: On-Demand WebinarPrice: $199 + applicable taxes Buy Now
