EXCEL TUTORIALS

Formulas
Dashboards
POWER QUERY
Charts
Features
VBA
DYNAMIC ARRAYS

Formulas

Excel Generate Random Numbers

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.

Excel Calculate Ratios

Easily calculate the ratio of two numbers in Excel with Excel formulas. Ratios are a common way to compare amounts. To calculate ratios you need to calculate the highest common factor. You can easily do this with the GCD function.

Excel Formulas and Functions

Learn how to use Formulas and Functions in Excel. I'll show you an Excel trick that will make it easier to find Excel functions and use them correctly. You'll learn how to use SUM, COUNT, COUNTA, AVERAGE, MAX, MIN and also more complex functions like AVERAGEIFS.

More

Dashboards

How to Use Checkboxes in Excel

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.

Excel Dashboards with Radio Buttons

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: How to control the results based on the radio button selection.

Excel LAMBDA Function Explained

With the new Excel Lambda function you can create your own custom functions that you can reuse. The best thing about Excel Lambdas is you can create a function that loops through many cells. You can do this with ZERO coding!

More

POWER QUERY

Create a Pivot Table from Multiple Sheets

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.

Import Outlook to Excel with Power Query

Learn how to easily export your Outlook emails into Excel. No VBA or Add-ins are necessary. I'll show you how to create a connection to any Outlook folder (or your full inbox) so you can easily import your Outlook data to Excel.

Excel Pivot Tables from Multiple Sheets

This is a simple but advanced Pivot Table technique in Excel. If you'd like to create a Pivot Table based on multiple sheets or tables, you can easily do that by defining the relationship between the tables from the data tab. It just takes one click.

More

Charts

Excel Job Interview Questions by Position

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.

Professional Excel Column Chart

Learn how to create a Professional Clustered Column chart in Excel. This Excel chart is not any column chart. It has overlapping bars. It's a column chart with an overlay. Using an existing chart, we will recreate it step-by-step.

Excel Histogram Chart

Histogram charts are easy to make in Excel. It might not be straightforward though how to adjust the bin numbers. It's really easy once you know. Check out this quick tutorial.

More

Features

How to Use Checkboxes in Excel

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.

Create a Pivot Table from Multiple Sheets

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.

Show Changes in Excel

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.

More

VBA

Office Scripts – Macros on the Web

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.

Excel VBA vs Office Scripts

What's the difference between Excel VBA macros and Office Scripts? Do you need to switch from VBA to Office Scripts? Find out in this detailed article. I show examples of what you can achieve with VBA and the current status of Office Scripts and explain what each is for.

Learn Excel Macros

Learn Excel Macros in 10 Minutes If you find yourself repeatedly performing the same steps in the same order in Excel, your brain should immediately declare, “I should automate this with an Excel macro!”. Think of the common, repetitive tasks you perform in Excel, like: Formatting downloaded data Creating a report Combining

More

DYNAMIC ARRAYS

Excel Generate Random Numbers

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.

Excel Dashboards with Radio Buttons

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: How to control the results based on the radio button selection.

Excel SPILL Error

What is the Excel Spill error and how can you fix it? Sometimes it's obvious but sometimes it's not clear why you get this error. Find out why and how to fix it in this article.

More