Learn how to troubleshoot errors using the tracing tool. Author Jen McBee demonstrates how to use trace precedents and trace dependents to determine where the error in your formula occurs.
- [Narrator] Being able to identify…and troubleshoot errors in Excel…is not only an important skill to have,…but is something that you might see…on the MOS Expert exam.…We're going to be talking about a couple…of the common errors that we see in Excel,…mainly the divide by zero error message.…This is telling us that a cell…that is referenced is either empty…or it has a zero value.…You may also come across an error message called Name…and this tells us that we have an invalid…or inconsistent name within our formula.…
You may also see the Value error message.…This tells us that we have referenced…a text value in a mathematical formula.…The fourth error message that is very common in Excel…is the Reference error message.…This tells us that a cell that we've referenced…in a formula has been deleted.…We're going to take a look at all…of the options available to us in…the formula auditing group, but I want to be sure…and focus on trace precedents and dependents.…
We can use trace precedents to show us cells…that are referred to by a formula in another cell.…
The course begins with an overview of the certification program and its costs. Next, Jennifer walks through all of the certification objectives, including hands-on experience with downloadable sample documents, so you can practice as you go. She wraps up with a full-length practice test that emulates exam 77-427, together with solutions to each of the exam challenges.
- Reviewing the exam format and learning objectives
- Tracking, retaining, and displaying all changes
- Identifying and troubleshooting errors with tracing
- Applying custom formats and layouts
- Applying advanced conditional formatting
- Using functions to format cells and apply advanced filters
- Preparing a workbook for internationalization
- Creating advanced formulas
- Using the LOOKUP and TRANSPOSE functions
- Using functions to serialize dates and times
- Creating advanced charts and tables
Skill Level Advanced
1. Microsoft Office Specialist (MOS) Expert Exam Overview
2. Manage and Share Workbooks
Manage comments2m 57s
3. Apply Custom Formats and Layouts
4. Create Advanced Formulas
5. Create Advanced Charts and Tables
6. Full-Length MOS Expert Sample Exam for Excel 2013
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.