Download Free Audio of Okay. So we're going to cover the top 50 formul... - Woord

Read Aloud the Text Content

This audio was created by Woord's Text to Speech service by content creators from all around the world.


Text Content or SSML code:

Okay. So we're going to cover the top 50 formulas that's used in Excel. And here are some points that could help you on making the most of the lessons regarding our Excel formulas. So first and foremost, there's no need to memorize this formulas. This is a good thing because the essence of these formulas is you just need to understand what are they used for? Because if you go for the goal of just understanding this one's, there's no need to memorize them, you can just type in an Excel, you can see in the demo later if you need to use a specific formula, it will tell you on what do you need to like pass the values for that specific formula. So it's like there's always a cheat sheet in Excel. If you type it in, it will just show you the usage or how can you utilize this formula. But the important thing is to understand the essence. Like what is the purpose of this formula? Where can you apply this formula? So there's no real need to memorize? What's the first parameter, what's the second parameter and all that. You just type it in. You can see it in Excel. But the important thing is as you go through the examples, understand on what can you use that specific formula for. And number three, formula parameters can be practically anything. So if you use the formulas later, you can either put in the absolute value, meaning a specific value in your formula, or you can also reference a cell that contains your value and it can also be active. There's a lot that combinations that you could do. You can even place in formulas output as a parameter to another formula. You'll see in our examples later. And regarding the Excel version, Excel 2010, 2013, 2016 anything like the versions in Excel would work fine. Like if you use any of this, this is the beauty with Excel formulas because you could think of them as backward compatible and also future proof in a way. Because once they introduce a specific formula for that version, the succeeding versions would still support that specific formula. So what you're learning over here is really applicable to like your future Excel uses, which is really a good thing.