Formulas
Dashboards
POWER QUERY
Charts
Features
VBA
DYNAMIC ARRAYS
GOOGLE SHEETS
POWERPOINT
Accounting & Finance
OTHER NEWS

Featured Tutorials

  • Over 100 Free Excel tutorials

Free Excel Tutorials

Over 200 Excel Tutorials in ONE Place The links in this file are regularly updated. Check back to get the latest file. On my YouTube channel, I often get questions like: "Do you have a video on *specific* topic?" or "How can I do *this* Excel task?" Actually, a lot of the videos on my channel are from you. Get the Full

Formulas

Excel Functions for Accounting

Make sure you know these Excel functions if you work in Accounting, Finance or you are a Data Analyst. They'll make your work life a LOT easier and they work in all Excel versions (such as AGGREGATE, TRIM, ROUND & more)

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.

Excel STOCKHISTORY Function

The StockHistory Function in Excel allows you to easily pull historical stock data in Excel with a single formula. You can get daily, weekly or monthly data. Find out how to use this together with sparklines to visualize the trend of different stocks in one view.

More

Dashboards

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!

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.

Understanding and Creating Barcodes in Excel

Find out how you can generate UPC barcodes in Excel that work! I tested it with a scanner and the Excel barcodes could be scanned. The solution uses a combination of Excel VBA, formulas and conditional formatting.

More

POWER QUERY

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.

Import PDF to Excel

Learn to properly convert PDF files to Excel without losing any formatting. With this method you can even refresh your Excel result to grab the latest data from your PDF file.

Power Query – Time Calculations

Working with time in Excel - for example calculating hours worked or summing or subtracting time can get tricky with Excel formulas. Did you know you can do this with a click of a few buttons? Let me show you how Power Query can easily do these for you.

More

Charts

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.

Excel Conditional Bar Charts

Properly show the variance to previous period using conditionally formatted bar charts. There is a simple trick to getting the negative bars in a different color to positive bars. You'll also discover a bonus trick to conditionally format any bars based on a logic.

More

Features

Learn Excel for Beginners

Learn the basics of using Microsoft Excel. How a spreadsheet is setup, and how you can enter data in Excel. Learn useful Excel shortcuts. Understand how the menu bar (the Excel Ribbon) works and where to find different features. This basic tutorial is for all versions of Excel.

Excel Stock Data

Get the latest stock data in Excel with Excel Data Types. You don't have to worry about the right formula. Everything gets written for you automatically. In this tutorial I show you how to set up your own stock portfolio in Excel from scratch.

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

VBA

Excel VBA Progress Bar

A progress bar is a great addition for Excel macros that take long to run. It gives your project a more professional touch. It's also quite easy to add. You can create your progress bar once and reuse it in your Excel vba projects.

Understanding and Creating Barcodes in Excel

Find out how you can generate UPC barcodes in Excel that work! I tested it with a scanner and the Excel barcodes could be scanned. The solution uses a combination of Excel VBA, formulas and conditional formatting.

Excel Get External Links

Get ALL External Links with THIS Simple Excel Trick (as NEVER seen before!) A terrific feature of Excel is the ability to pull data from external sources, like other Excel files. But with any benefit, there comes a cost.  In this case, keeping track of the links and where the links

More

DYNAMIC ARRAYS

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.

Excel Functions Office 365

This is the list of the most useful Excel Functions you need to know in 2021. There are the new functions available in Excel for Microsoft 365 and also on Excel for the web (available for free).

Yearly Calendar in Excel with Formula

Use this simple formula to create a dynamic yearly calendar in Excel (It works for Google Sheets as well). All you need to update is the year and you will automatically get the calendar for that year.

More

GOOGLE SHEETS

Top 10 Tips for Google Sheets

This is the list of my favorite tips and functions in Google Sheets. If you're new to Google Sheets, this list will give you an overview of the potential of Sheets. If you're advanced, you'll probably find some new features and functions you didn't know about.

Google Sheets QUERY Function

The Query function in Google Sheets is one of the most powerful functions in Google Sheets. It's easy to learn if you follow the rules laid out in this tutorial. You'll be able to solve any data analysis problem that comes your way.

Google Sheets IMPORTRANGE Function

Learn how to use IMPORTRANGE in Google Sheets. This function is great when you'd like to import data from other spreadsheets. You can also use it together with QUERY to import and append data from multiple sheets.

More

POWERPOINT

5 PowerPoint Tips

In this post I share 5 PowerPoint tips and tricks you wished you knew sooner (At least I did!). These apply for PowerPoint business presentations as well as for students and teachers.

PowerPoint Slide Design Tips

How do you create professional looking PowerPoint slides? It comes down to small things. Most of which we don't notice when we watch presentations we love. I've broken it down into 5 tips which you can apply to your PowerPoint slides.

PowerPoint Hacks

Do you know these 5 PowerPoint hacks? With these you can get your PowerPoint presentation done a lot faster. Not only that, but your presentation will also look more professional.

More

Accounting & Finance

Excel Functions for Accounting

Make sure you know these Excel functions if you work in Accounting, Finance or you are a Data Analyst. They'll make your work life a LOT easier and they work in all Excel versions (such as AGGREGATE, TRIM, ROUND & more)

Financial Leverage explained

In finance, leverage (or gearing) is about using debt (other people's money) rather than equity (your own money) for the purchase of an asset. This tutorial explains when this can be good for your business and when it can ruin your business.

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

OTHER NEWS

Convert PDF to Word

In this PDF to Word tutorial, I show you how to easily convert an Adobe PDF file to a Microsoft Word file. All you need is Microsoft Word (2013 or later) in a Desktop version. You can edit the outcome in Word and then save again as PDF.

  • Microsoft Power Automate

Power Automate with examples

Learn how to use Microsoft's Power Automate with examples. With Power Automate you get to automate boring and repetitive tasks across applications. We take a look at two examples: Bulk PDF creation and a Planner to Outlook automation.

Email strategy to manage your inbox with Outlook Tips

Manage your inbox so you can be more productive and less stressed! I'll share email management techniques that help you get organized. You'll also learn time management techniques to instantly put more time in your day and easily manage your Outlook Inbox.

More
All Tutorials