It takes ZERO effort to now get searchable drop-down lists in Excel. Excel's data validation list now offers autocomplete by default. Empty cells are skipped too! This is all for desktop and online version. Check out this post to find out more.
Don't merge cells in Excel - Don't Copy Excel sheets without updating links - Don't hide rows and columns! There are better ways of doing these things. Find out 7 things you're doing wrong in Excel and how to do it correctly.
Get started with Power BI now by creating your first dashboard. Download the free files, follow along and in 20 minutes you'll have setup your interactive dashboard which you've published to the web!
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.
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.
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.
These are 3 easy ways to remove duplicates in your data to create a unique or distinct list of values in Microsoft Excel. It's a very common task for data cleaning and also a very common job interview question... BUT one of the methods returns a different result. Make sure you understand why.
Quickly learn how to create a checkbox in Excel. You can also easily create multiple checkboxes. It's important to learn how to use the outcome of the checkbox in formulas and conditional formatting - for example to get a strikethrough effect. Find out in this comprehensive tutorial.
Easily create ONE Pivot Table in Excel from data in multiple sheets. Sometimes you need to "merge" the data and sometimes you have to "append" data from multiple sheets for your Pivot Table. Don't use formulas! Instead use this method.
Excel Show Changes Feature lets you know who changed your data and formulas. You'll see the previous value below the current value. With Version History you can easily revert back to a previous version of your file.
