Here's why you should upgrade to Office 2021 if you're on 2019 or 2016 (and for some reason you can't upgrade to 365). You get life-changing Excel functions like XLOOKUP, UNIQUE, FILTER, SORT and a lot more. I cover what you get when you upgrade in this post.
With this trick you can easily combine and repeat blocks of values together in Excel. You don't need copy pasting or complicated formulas. Just a tiny bit of Power Query. This keeps your solution dynamic too.
It's super easy to setup an automation in Power Automate to get notified when someone submits their answers in a Microsoft Form. You can also add a condition, so you get an email or mobile notification only when a specific answer is submitted.
Find out how you can use the new Excel BYROW and BYCOL functions. These are called Lambda helper functions and they can help you save a lot of time if your analysis is based on a whole row or an entire column. Check out this practical example to find out more.
With Pivot Charts in Microsoft Excel you can add slicers to add interactive functionality to your dashboards. But what about adding even more interactivity? You could give the user the ability to change the relevant KPI in the chart from the slicer.
You can easily add text to your cell values in Excel. You don't have to do this manually. You have 3 easy options to choose from. The 3rd one will surprise you. You can use it in many other circumstances as well.
Learn how to sum values based on multiple criteria in a single columns. You probably know that you can use SUMIFS to sum values based on criteria from multiple columns. But there is also an easy way you can sum values if your criteria is in the same column.
Learn to combine Office Scripts with Power Automate so you can run your macros without opening your files. You'll learn how to create a script, how to loop through each sheet in the script and how to setup Power Automate to apply the script to every file in a folder.
Learn how to calculate the difference between days in Excel and exclude any week days, weekends and holidays. It's easy to exclude weekends and holidays, but how do you exclude ANY weekday of your choice? Check out the complete blog post because there's a trick you can use.
Pivoting columns in Excel is a common task when cleaning and organizing data. Sometimes you have a complex scenario where you have multiple values when switching columns. You'll have to combine these multiple values into one cell. I'll show you 3 methods to get this done.