0502 Go To (Special) - Formulas Without Errors

Advanced Excel Crash Course Section 5: Special Cell Selections
2 minutes
Share the link to this page
Copied
  Completed
You need to have access to the item to view this lesson.
One-time Fee
$99.99
List Price:  $139.99
You save:  $40
€88.54
List Price:  €123.96
You save:  €35.42
£74.62
List Price:  £104.48
You save:  £29.85
CA$138.77
List Price:  CA$194.29
You save:  CA$55.51
A$155.83
List Price:  A$218.18
You save:  A$62.34
S$129.18
List Price:  S$180.87
You save:  S$51.68
HK$782.49
List Price:  HK$1,095.52
You save:  HK$313.03
CHF 82.69
List Price:  CHF 115.76
You save:  CHF 33.07
NOK kr1,020.55
List Price:  NOK kr1,428.81
You save:  NOK kr408.26
DKK kr660.52
List Price:  DKK kr924.76
You save:  DKK kr264.23
NZ$169.49
List Price:  NZ$237.29
You save:  NZ$67.80
د.إ367.25
List Price:  د.إ514.17
You save:  د.إ146.91
৳12,191.39
List Price:  ৳17,068.44
You save:  ৳4,877.04
₹8,599.01
List Price:  ₹12,038.95
You save:  ₹3,439.94
RM427.45
List Price:  RM598.45
You save:  RM171
₦159,360.06
List Price:  ₦223,110.46
You save:  ₦63,750.40
₨28,213.35
List Price:  ₨39,499.82
You save:  ₨11,286.47
฿3,287.02
List Price:  ฿4,601.96
You save:  ฿1,314.94
₺3,891.77
List Price:  ₺5,448.63
You save:  ₺1,556.86
B$564.58
List Price:  B$790.43
You save:  B$225.85
R1,803.38
List Price:  R2,524.81
You save:  R721.42
Лв173.05
List Price:  Лв242.27
You save:  Лв69.22
₩138,417.38
List Price:  ₩193,789.87
You save:  ₩55,372.48
₪357.93
List Price:  ₪501.12
You save:  ₪143.18
₱5,568.09
List Price:  ₱7,795.55
You save:  ₱2,227.46
¥14,364.18
List Price:  ¥20,110.43
You save:  ¥5,746.25
MX$1,939.88
List Price:  MX$2,715.91
You save:  MX$776.03
QR364.92
List Price:  QR510.90
You save:  QR145.98
P1,343.51
List Price:  P1,880.97
You save:  P537.46
KSh12,928.70
List Price:  KSh18,100.70
You save:  KSh5,172
E£4,991.56
List Price:  E£6,988.38
You save:  E£1,996.82
ብር13,476.99
List Price:  ብር18,868.32
You save:  ብር5,391.33
Kz91,186.39
List Price:  Kz127,664.59
You save:  Kz36,478.20
CLP$94,330.18
List Price:  CLP$132,066.03
You save:  CLP$37,735.84
CN¥720.53
List Price:  CN¥1,008.78
You save:  CN¥288.24
RD$5,900.25
List Price:  RD$8,260.58
You save:  RD$2,360.33
DA13,269.72
List Price:  DA18,578.14
You save:  DA5,308.41
FJ$226.79
List Price:  FJ$317.51
You save:  FJ$90.72
Q768.32
List Price:  Q1,075.69
You save:  Q307.36
GY$21,001.93
List Price:  GY$29,403.54
You save:  GY$8,401.61
ISK kr12,803.71
List Price:  ISK kr17,925.71
You save:  ISK kr5,122
DH923.09
List Price:  DH1,292.37
You save:  DH369.27
L1,736.39
List Price:  L2,431.02
You save:  L694.62
ден5,445.22
List Price:  ден7,623.53
You save:  ден2,178.30
MOP$807.12
List Price:  MOP$1,130
You save:  MOP$322.88
N$1,788.35
List Price:  N$2,503.77
You save:  N$715.41
C$3,683.70
List Price:  C$5,157.32
You save:  C$1,473.62
रु13,690.21
List Price:  रु19,166.85
You save:  रु5,476.63
S/369
List Price:  S/516.62
You save:  S/147.61
K410.30
List Price:  K574.43
You save:  K164.13
SAR375.05
List Price:  SAR525.09
You save:  SAR150.03
ZK2,722.55
List Price:  ZK3,811.68
You save:  ZK1,089.13
L448.20
List Price:  L627.50
You save:  L179.29
Kč2,206.07
List Price:  Kč3,088.59
You save:  Kč882.51
Ft35,695.51
List Price:  Ft49,975.14
You save:  Ft14,279.63
SEK kr961.92
List Price:  SEK kr1,346.73
You save:  SEK kr384.81
ARS$114,539.05
List Price:  ARS$160,359.25
You save:  ARS$45,820.20
Bs691.61
List Price:  Bs968.29
You save:  Bs276.67
COP$418,458.68
List Price:  COP$585,858.89
You save:  COP$167,400.21
₡50,740
List Price:  ₡71,038.04
You save:  ₡20,298.03
L2,605.39
List Price:  L3,647.65
You save:  L1,042.26
₲799,483.18
List Price:  ₲1,119,308.43
You save:  ₲319,825.25
$U4,159.03
List Price:  $U5,822.81
You save:  $U1,663.78
zł375.87
List Price:  zł526.23
You save:  zł150.36
Already have an account? Log In

Transcript

Hi. In this video, let me give you a task. On the left hand side lies a data table. And you will notice a lot of blank cells numbers thrown across the entire region. Some of these cell may contain a formula, which is something like this when I write equals 10, plus any number divided by any number, or any kind of formula, which is throwing a result in a numeric form. Now, this could be an Excel sheet which your colleague would have worked upon six months back, and when you're taking a handover, you want to find out what last minute adjustments happened while he was working.

So I want to find out which cells are those. If you were to do this using traditional method, you'd have to double click on each and every cell to find that out, isn't it? Now, if you know the right technique, this happens in less than 10 seconds. Let's see. If I choose the data, I press Ctrl G Click on the button thing special. Next, I target the ones which says formula which are carrying numbers formula, which are doing number as an answer.

As I press Ok, I see one of those cells. In fact, two of those cells are getting highlighted. Now just to hold on to their presence, I'm going to color them so home, and here goes the color. Now, both these cells if I double click upon them, one contains 10 plus something, the other contains 766 into 98%. Imagine if you were to find this in a really large data, it would have been something like finding a needle in a haystack. This could also be used beneficially if you are belonging to the domain of forensic audit.

A lot of times you get data from the client staff and you want to vet this and you want to do a sanity check whether the data is containing any internal adjustments and if so, then you can go back to the client and ask for the reason. So this was Ctrl G formula with numbers

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.