HDTutorial
EN
Formula Auditing Tricks in Excel | Excel Formulas | Excel Tutorial | 2020[Update]

Playback starts YouTube’s embedded player (privacy-enhanced mode).

Formula Auditing Tricks in Excel | Excel Formulas | Excel Tutorial | 2020[Update]

40,097 views November 14, 2017 4:52

Watch on YouTube
ChannelYoda Learning - Excel, Excel VBA and Power BI

Chapters

Description from the creator

In this video, you will get the most amazing time-saving shortcut Tips on MS Excel Formula auditing.

👉 Join now our QnA Community - bit.ly/335Fic7

00:00 Introduction to Excel Formula for Auditing
00:16 Excel Formula Auditing
00:45 How to use Show formula function in Excel
01:05 Press Ctrl + ~ ( To Show Formula in Excel)
01:33 How to use Trace Precedents Function in Excel
02:00 How to use Trace Dependents Function in Excel
02:11 How to use Remove Arrows Function in Excel
03:08 Press Ctrl + [ (Go to Precedents Cell in Excel)
04:09 Press F5 + Enter (To Go back to original cell)
04:35 Ctrl + Shift + { (Trace All Precedents in Excel)

👉 Check out Excel tutorial Playlist - youtube.com/playlist?list=PLnVcHd3TXd2rVGtVDUT4…

Excel Formula for Auditing | Trace Precedents, Trace Dependents & Show Formula
#FormulaAuduting #Traceprecedents #Tracedeoendents

Let's Connect:

👉 Follow us on Instagram instagram.com/yodalearning/
👉 Follow our boards at in.pinterest.com/yodalearning/pins/

About this tutorial

Yoda Learning - Excel, Excel VBA and Power BI published this 4:52 video tutorial on November 14, 2017. It has been watched 40,097 times on YouTube.

Category
Education
Duration
4:52
Published
November 14, 2017
Views
40,097
Likes
412

Tags

Share

This tutorial in other languages