EXCEL TUTORIALS
Formulas
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.
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
Excel Advanced Pivot Tables
These 10 advanced Excel Pivot Table tips are going to help you analyze your data faster. PivotTables are one of Excel's most important tools. Not everyone knows these Pivot Table tricks though. Make sure you do!
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.
VBA
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
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.
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.