While there is hundreds of formulas on excel if you work in any of these roles, you
really only need to know about 10 formulas to cover most of your tasks. So let 's
take a look at those coming in at number 10. We 've got the if error formula and
here 's the scenario for it. You can download this excel file for free in the video
description. we use the concatenate function which is this one over here or there
is a faster way to go about it which is just using the ampere signs. got the
breakdown by city and country what we want to do here is merge them together. next
up. We have the sequence formula which allows you to add a sequence of numbers so
over here. Let 's suppose that we 're running a few tests. The next step would be
to visualize them and a good way to do that is using chart templates like the ones
Hubspot. The sponsor of this video is kindly providing us using the link in the
description below to download these completely free templates from Hubspot to level
up your excel game. the templates can have either one column of data or multiple
charts depending on your needs..
find the sum of those sales so we 'll go equals Some ifs hit the top key there and
the sum range to us is all of the sales control shift down comma. the name Amazon
is actually replicated many times, but with different endings. for our purposes. We
would want them all together as they 're all amazon for this we're gon na use the
some Ifs formula again. excel formulas can be used to help students learn more
about financial formulas. the formula is a combination of two formulas, the index
and the match so let 's look at an example as you can see over here. We 've got the
sales breakdown by country and by month specifically we want to find out the sales
in the country of Austria in the month of April so we 'll go to equals. And
subscribe and I 'll catch. You in the next one?
really only need to know about 10 formulas to cover most of your tasks. So let 's
take a look at those coming in at number 10. We 've got the if error formula and
here 's the scenario for it. You can download this excel file for free in the video
description. we use the concatenate function which is this one over here or there
is a faster way to go about it which is just using the ampere signs. got the
breakdown by city and country what we want to do here is merge them together. next
up. We have the sequence formula which allows you to add a sequence of numbers so
over here. Let 's suppose that we 're running a few tests. The next step would be
to visualize them and a good way to do that is using chart templates like the ones
Hubspot. The sponsor of this video is kindly providing us using the link in the
description below to download these completely free templates from Hubspot to level
up your excel game. the templates can have either one column of data or multiple
charts depending on your needs..
find the sum of those sales so we 'll go equals Some ifs hit the top key there and
the sum range to us is all of the sales control shift down comma. the name Amazon
is actually replicated many times, but with different endings. for our purposes. We
would want them all together as they 're all amazon for this we're gon na use the
some Ifs formula again. excel formulas can be used to help students learn more
about financial formulas. the formula is a combination of two formulas, the index
and the match so let 's look at an example as you can see over here. We 've got the
sales breakdown by country and by month specifically we want to find out the sales
in the country of Austria in the month of April so we 'll go to equals. And
subscribe and I 'll catch. You in the next one?
