IF Only…

If only this is x, then it’s y.  Things always have conditions – you can have this on the condition that / if you do that.  That’s essentially what IF statements mean.  There are many IF statements – IFERROR, SUMIF/S, COUNTIF/S, AVERAGEIF/S… (all which I’ll cover in future posts).  IF statements are so useful for … More IF Only…

10 Things You Can Do With Excel

Excel can be used for a multitude of things.  From the simplest to the more advanced. Below are 10 Things You Can Do With Excel (in no particular order):   1.       Budgeting & Forecasting 2.       Financials, e.g. Profit & Loss Statement 3.       Dashboards / Reporting 4.       Analysis – sales, product, variance 5.       Dynamic data (data … More 10 Things You Can Do With Excel