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

Featured Tutorials

  • Over 100 Free Excel tutorials

Over 200 Free Excel Tutorials in 1 Place

Over 200 Excel Tutorials in ONE Place The links in this file are updated on a quarterly basis. 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.

Formulas

Excel IFS Function

The IF function is one of the most popular functions in Excel. But what about the IFS function? Does it really make writing nested IF functions easier? Let's find out.

Excel Multiple Match Results Simple

If you don't have the Filter function in Excel, you need to check out this easy formula approach to get multiple match results in Excel. Download the workbook and use the version that fits your example best.

Excel Dependent Drop Down Lists on Every Row

Create multiple dependent drop-down lists in Excel that you can copy to every row. You'll also learn how to exclude the blank cells on the bottom to make sure each list is restricted to the number of categories available.

More

Dashboards

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.

Excel Calendar with Holidays and Appointments

Excel Calendar with Holidays and Appointments This week’s post is a special post because it comes directly from the super-brain of one of our XelPlus community members, Adam Weaver. Adam holds both a PMP certification (Project Management Professional) and an RMP certification (Risk Management Professional) working for Williams, a natural gas

More

Charts

Excel Filled Map Chart Using Power Query

Go from raw data to a filled map chart in Excel. Power Query will help summarize the data and make the whole process dynamic. Use Excel filled maps to create an impressive visualization for your reports.

Power Query Preview

What can Excel Power Query do for you? It can help you in more ways than you think. Not only can you import big data from different locations, but you can also replace complex formulas with a few clicks.

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.

More

Features

Pivot Tables in 10 Minutes

Learn how to use Excel Pivot Tables to quickly summarize your data and create meaningful reports. In 10 minutes we cover everything you need to know about Pivot Tables.

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.

OneNote Tips and Features

Learn how to use OneNote effectively so you can get the most out of it. OneNote is a great tool to stay organized but it has a lot of hidden features. Read the article to find out more.

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 Top N with FILTER function

Create an Excel report with the top values and categories. What makes this impressive is that you will allow the user to define how many records are returned, such as the Top 5, Top 10, or any number they choose.

Multiple Searchable Drop-Down Lists in Excel

Learn to create a simple searchable drop-down list in Excel on multiple rows. Searchable lists make it easier to find an item from a large data validation list. We finally get to make this with simple formulas.

Excel FILTER Function

Excel's New Dynamic Array FILTER Function The FILTER function can be thought of as the new power lookup function; in many cases replacing the traditional VLOOKUP and INDEX/MATCH functions when searching for data in a table. Situations you will benefit from when using the FILTER function include: Cases when you need

More

POWERPOINT

PowerPoint Roadmaps

It’s one thing to have to sit through a boring presentation.  It’s quite another to give a boring presentation. The solution is a simple roadmap. Discover how you can add road-maps to your presentations.

PowerPoint Merge Shapes Feature

PowerPoint Merge Shapes Feature This post will highlight one of the most useful, yet underutilized tools in PowerPoint when it comes to bringing your slides to the next level. The Merge Shapes Tool We are often advised not to get too fancy with our slides when working in a professional setting. 

Use PowerPoint SLIDE ZOOM the RIGHT WAY

Use PowerPoint SLIDE ZOOM the RIGHT WAY Imagine walking into a meeting and seeing that the speaker is about to embark on a PowerPoint journey.  The first thought you may have is, “Oh, no!  Not another PowerPoint slideshow. I’d rather watch a slideshow of my grandparents vacation photos.” This common reaction

More

Accounting & Finance

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. 

Calculating Returns for a Rental Property

Properly calculate returns on your rental property investment. This free Excel ROI calculator, makes it easy for you. In fact, you can use it to calculate the returns on any type of investment.

Cash Flow Statement

The Cash Flow Statement The Cash Flow statement is one of the three main financial statements, but it is often overshadowed by its companion statements – the Income Statement and Balance Sheet. The Income Statement provides information on Revenue and Profit over a certain period of time The Balance Sheet gives

More

OTHER NEWS

OneNote Tips and Features

Learn how to use OneNote effectively so you can get the most out of it. OneNote is a great tool to stay organized but it has a lot of hidden features. Read the article to find out more.

Windows 10 Top Tips & Tricks

Uncover Windows 10 most useful features in this summarized article. Some of these are what I consider hidden features of Windows 10. Super simple to use BUT not easy to find!

Practical Excel Dashboard (Excel Hash 2019)

A Dashboard with 4 Strange Features (Excel Hash 2019) Welcome back to another edition of Excel Hash! Last year (that’s right, I said “last year”), myself and several other prominent Excel MVP online personalities participated in a challenge where we are given four Excel features and asked to create a solution

More

POWER QUERY

Excel Filled Map Chart Using Power Query

Go from raw data to a filled map chart in Excel. Power Query will help summarize the data and make the whole process dynamic. Use Excel filled maps to create an impressive visualization for your reports.

PQ Text Transformations

Discover the Easiest way to transform text in Excel. Separate words, split cells by delimiter, extract text after space, extract numbers from text and a lot more.

Power Query Combine Files from Folder

Learn the easiest way to combine multiple Excel files into one Workbook. With Power Query you can import files directly from a folder and append them into one table or Pivot Table. It just takes a few clicks.

More
All Tutorials