Excel IFS Function

The IF function is one of the most popular functions in Excel. But what about the IFS function? Does it really make writing nested IF functions easier? Let's find out.

Excel Filled Map Chart Using Power Query

Go from raw data to a filled map chart in Excel. Power Query will help summarize the data and make the whole process dynamic. Use Excel filled maps to create an impressive visualization for your reports.

Power Query Preview

What can Excel Power Query do for you? It can help you in more ways than you think. Not only can you import big data from different locations, but you can also replace complex formulas with a few clicks.

Pivot Tables in 10 Minutes

Learn how to use Excel Pivot Tables to quickly summarize your data and create meaningful reports. In 10 minutes we cover everything you need to know about Pivot Tables.

PQ Text Transformations

Discover the Easiest way to transform text in Excel. Separate words, split cells by delimiter, extract text after space, extract numbers from text and a lot more.

Excel Hidden Dashboard Tips

You can spend a lot of time on design and formatting when you create dashboards in Excel. Discover 4 hidden tips that will make the process a lot easier.

Excel Multiple Match Results Simple

If you don't have the Filter function in Excel, you need to check out this easy formula approach to get multiple match results in Excel. Download the workbook and use the version that fits your example best.

Power Query Combine Files from Folder

Learn the easiest way to combine multiple Excel files into one Workbook. With Power Query you can import files directly from a folder and append them into one table or Pivot Table. It just takes a few clicks.

OneNote Tips and Features

Learn how to use OneNote effectively so you can get the most out of it. OneNote is a great tool to stay organized but it has a lot of hidden features. Read the article to find out more.

Excel Top N with FILTER function

Create an Excel report with the top values and categories. What makes this impressive is that you will allow the user to define how many records are returned, such as the Top 5, Top 10, or any number they choose.