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 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).
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!
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
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!
Excel Conditional Formatting with Formula
Discover how to properly conditionally format rows in Excel with a Formula. This way you can highlight entire rows or format values based on another cell. Using the formula feature in conditional formatting is tricky. I share the secret to getting it right every time.
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
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.
Google Sheets Multiple Dependent Dropdown Lists
There is a trick you can use to create multiple dependent drop-down lists on the same sheet in Google sheets. It's simple trick that doesn't involve Apps Script. Check out the full article.
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
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!
Time Value of Money
Time Value of Money “A dollar today is worth more than a dollar tomorrow.” It’s a saying that is true for any business as well as your own personal finances. It’s a simple principle that has a fancy name…Time Value of Money. Take this example: You’re selling a product for $10,000.
OTHER NEWS
How to Use Microsoft Teams
This free training is your complete guide to Microsoft Teams. You'll learn how to hold online meetings, schedule meetings, use channels, chat and upload files. Bookmark it for future reference.
Outlook Reply Templates
Easily create template replies in Outlook by saving your common responses. You can save it with all the formatting you want. Let me show you how.
Electronic Signatures
In this tutorial I'll show you 3 free options you can use to create and insert your electronic signature in a PDF document, WORD or any other document of your choice. This makes it easy to sign pdf or other documents really fast.