Search Results

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.

It’s easy to calculate the difference between dates in Excel and exclude weekends and holidays. But how can you exclude ANY weekday of your choice? There is an Excel 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.

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.

Use the hidden Google Sheets FLATTEN function to get a unique list of values from multiple columns. You just have to combine it with UNIQUE and you’re done!

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 or conditional formatting – for example to get a strikethrough effect. Find out in this comprehensive tutorial.

In this article, I summarize the MOST COMMON Excel questions that are currently asked during interviews. This covers positions such as business or MIS analyst, Data Analyst, Financial Analyst or more senior positions. You’ll be surprised at the level of Excel that’s currently required for some of these positions.

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.

This tutorial shows you different methods to generate random numbers in Excel (including no repeats). You might need random numbers if you’re preparing test data. Or if you need to share your files with consultants and have to replace official values with random ones.

Quickly learn how to add option buttons (radio buttons) to your files to create interactive Excel Dashboards and dynamic charts. It’s really easy once you learn this one trick!

This example gets you started with Office Scripts in Excel. You’ll learn how to record a macro and how to modify the script to get a dynamic range. You’ll also learn where to find the Office Script and how to save it with your workbook.