Guaranteed to be Good
All training experiences include a 7-day 100% money-back guarantee.
Reverse Engineering an Excel Workbook: How to Edit an Inherited Workbook
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.
Purchase this On-Demand Workshop
Reverse Engineering an Excel Workbook: How to Edit an Inherited Workbook
On-Demand $199 +
applicable taxes
more info
For the live training(s) you've selected:
You will receive access to the live event(s) which includes a copy of the speaker's presentation, real-time training with our expert instructor, and an interactive question & answer period. Two to three business days after each live training concludes, an email is sent to registrants which contains a link for unlimited access to the on-demand recording you can revisit & review.
You will receive access to the live event(s) which includes a copy of the speaker's presentation, real-time training with our expert instructor, and an interactive question & answer period. Two to three business days after each live training concludes, an email is sent to registrants which contains a link for unlimited access to the on-demand recording you can revisit & review.
For the on-demand training(s) you've selected:
You'll receive a link to access the recording(s) in your order confirmation email. On-demand recordings also include a copy of the speaker's presentation and the ability to submit your questions to the expert, for up to 7 days after viewing.
You'll receive a link to access the recording(s) in your order confirmation email. On-demand recordings also include a copy of the speaker's presentation and the ability to submit your questions to the expert, for up to 7 days after viewing.
3 Workshop
Bundle $300 +
applicable taxes
more info
Take advantage of our three workshop bundle to enhance your learning beyond the training you initially selected. Our workshop bundle allows you to select three workshops (Live or On-Demand) at a discounted price.
For the live training(s) you've selected:
You will receive access to the live event(s) which includes a copy of the speaker's presentation, real-time training with our expert instructor, and an interactive question & answer period. Two to three business days after each live training concludes, an email is sent to registrants which contains a link for unlimited access to the on-demand recording you can revisit & review.
You will receive access to the live event(s) which includes a copy of the speaker's presentation, real-time training with our expert instructor, and an interactive question & answer period. Two to three business days after each live training concludes, an email is sent to registrants which contains a link for unlimited access to the on-demand recording you can revisit & review.
For the on-demand training(s) you've selected:
You'll receive a link to access the recording(s) in your order confirmation email. On-demand recordings also include a copy of the speaker's presentation and the ability to submit your questions to the expert, for up to 7 days after viewing.
You'll receive a link to access the recording(s) in your order confirmation email. On-demand recordings also include a copy of the speaker's presentation and the ability to submit your questions to the expert, for up to 7 days after viewing.
One-year subscription (All Access Membership) $699 +
applicable taxes
more info
With this subscription, you will receive 1 year of unlimited access to our full library of on-demand trainings as well as priority access to trainings that are upcoming.
For the live training(s):
You will receive access to the live event(s) which includes a copy of the speaker's presentation, real-time training with our expert instructor, and an interactive question & answer period. Two to three business days after each live training concludes, an email is sent to registrants which contains a link for unlimited access to the on-demand recording you can revisit & review.
You will receive access to the live event(s) which includes a copy of the speaker's presentation, real-time training with our expert instructor, and an interactive question & answer period. Two to three business days after each live training concludes, an email is sent to registrants which contains a link for unlimited access to the on-demand recording you can revisit & review.
For the on-demand training(s):
You'll receive access to our full library of on-demand trainings along with the speaker's presentation and handouts for each event.
You'll receive access to our full library of on-demand trainings along with the speaker's presentation and handouts for each event.
Full-Team Pass
Simply share the invite link with your team so you can learn and grow together!
Yours Forever
The event recording and materials are yours to rewatch and share as you choose.
