You'll learn 3 of them in this video! Learn Excel Array formulas by going through the example While I solve this problem, I also explain how array formulas work in Excel. They can be difficult to get the hang of. This video shows you how
Do you want to create formulas that "move" with your raw data set? That's when you need to use Excel's OFFSET function. OFFSET is a great formula whenever you have dynamic ranges involved. Some examples are: Calculating the average of the last three months when
Are you currently using the SUMPRODUCT formula in your Excel files? I wouldn't be surprised if you say "No". Many know of it, but hesitate to use it. Or they don't think it's the right formula for the task at hand. Chances are it is.
Default legends are too much work. Not for you, because they are there by default but they can be a lot of work for your readers. They need to think more than they should about which color or texture belongs to which category. Do
In most cases when you start to work at a new company, you take over the existing Excel workbooks of your predecessor and continue to update and expand on these. Normally, these Excel files are quite large and contain many tabs and it’s not
This is a question I often get when implementing new reports or dashboards. Where to do it? Purchase a dashboard solution to sit on top of the BI solution or simply use Excel for it? Use Excel to track KPIs (Key Performance Indicators) or
Are you tired of dealing with slow Excel files? Then follow these steps to speed them up! You can click and download the document. To become confident and advanced in Excel at your own pace, check out my latest online course: Advanced Excel: Top 10 Tips
I believe Excel is meant to handle a lot of data and a lot of complicated calculations without getting slow. What makes it slow - in majority of the cases - is poorly designed spreadsheets. First of all let’s have a look at what makes