Featured 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.
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.
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.
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.
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!
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
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.
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.
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.
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!
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.
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.