Formulas
Dashboards
Charts
Features
VBA
DYNAMIC ARRAYS
POWERPOINT
OTHER NEWS

Featured Tutorials

  • Over 100 Free Excel tutorials

More than 100 Free Excel Tutorials in 1 Place

Over 100 Excel Tutorials in ONE Place The links in this file are updated on a monthly 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 Dynamic Arrays Filter Function

LOOKUP ALL values b/w two dates (Excel Dynamic Arrays Filter Function to return many match results) Extracting records from a data set that matches defined criteria is a skill most users acquire early in their learning.  This usually takes the form of applying a filter to the data. But there are

Excel IF Function with PARTIAL Text Match (IF with Wildcards)

Excel IF Function with PARTIAL Text Match (IF with Wildcards) How can we look for an approximate match using wildcards with Excel’s IF Function? =IF(YouTu* THEN…) Can you use wildcards in the logical test portion of the IF Function? It seems like this would be an easy “Yes”, but sadly, it’s

Convert Numbers to Words

Excel Formula to Convert Numbers to Words One of the most asked for Excel features is the ability to turn a number into words. Because many people need this ability, and Excel does not currently possess such a feature, the old saying “Necessity is the mother of invention” took over.  One

More

Dashboards

Reset Dependent Drop-down in Excel

Reset Dependent Drop-down in Excel (with a tiny bit of VBA) Learn how to reset a dependent drop-down list in Excel with a little bit of VBA. The problem we get with dependent data validation lists is that when you change the value of the first data validation, the value for the

Excel Dependent Combo Box Solves an Annoying Problem

This Excel Dependent Combo Box Solves an Annoying Problem (you've probably had this) In this tutorial you'll learn a lot about combo box drop-down lists in Excel: 1. How to create a combo box drop-down list 2. How to create a dependent Combo Box drop-down. 3. How to restrict the combo

More

Charts

CHOOSE the RIGHT Chart Animation in PowerPoint

CHOOSE the RIGHT Chart Animation in PowerPoint Have you ever been tasked with presenting a chart or a graph in a meeting? If you are using PowerPoint during the presentation, the way you setup the PowerPoint slide matters. Let’s look and a normal (otherwise known as “boring and confusing”) slide and

Excel Data Entry Form

SUPER EASY Excel Data Entry Form (NO VBA) In this post we will look at creating data entry forms in Excel. The best part is… NO VBA! Suppose you need to input data into an Excel table and you want to make the experience as pleasant as possible.  Or, you need

Charting Survey Results in Excel

Charting Survey Results in Excel (Visualize Employee Satisfaction results) This post spotlights a practical way to visualize survey results in Excel, particularly surveys that follow a “like/hurt” format.  Surveys, like employee surveys, that provide a range of choices between “Strongly Disagree” to “Strongly Agree”, or simpler surveys that provide “Disagree-Neutral-Agree” options.

More

Features

Unprotect Cells by Color

Lock Cells & Protect Worksheet EVEN by Cell Color! This post will demonstrate how to lock and unlock cells.  That doesn’t sound like much to read about, but there’s a twist. We’re going to look at the basics of cell protection, which can be a very useful feature in everyday Excel

Excel Data Entry Form

SUPER EASY Excel Data Entry Form (NO VBA) In this post we will look at creating data entry forms in Excel. The best part is… NO VBA! Suppose you need to input data into an Excel table and you want to make the experience as pleasant as possible.  Or, you need

Why you SHOULD be USING Custom Number Formatting

Why you SHOULD be USING Custom Number Formatting in Excel Let’s see a few Excel Custom Number Formatting tips that will not only save you time, but also help you avoid common spreadsheet mistakes. First, we’ll see the formatting in action and how it helps tell our story in the most

More

VBA

Sum Cells by Color

Sum Cells by Color In this VBA tutorial we will look at a way to sum cells based on their background color. Unfortunately, Excel does not possess a function that will provide this functionality. So how will we get this to work? Good question. We will write and build our OWN

3 Methods to Unhide All Sheets in Excel (& how to hide)

3 Methods to Unhide All Sheets in Excel (& how to hide) How can you unhide all Excel sheets at once? Hiding many worksheets at once is easy in Excel.  Click on a sheet, hold down the control or the shift key, click on the other sheets you'd like to hide,

More

DYNAMIC ARRAYS

Excel Dynamic Arrays Filter Function

LOOKUP ALL values b/w two dates (Excel Dynamic Arrays Filter Function to return many match results) Extracting records from a data set that matches defined criteria is a skill most users acquire early in their learning.  This usually takes the form of applying a filter to the data. But there are

Searchable Drop Down List in Excel (Very Easy with Dynamic Arrays)

Searchable Drop Down List in Excel (Very Easy with Dynamic Arrays) “Does Excel have a feature to allow a Data Validation list to be searchable?” This is a common question asked on this site and most any Excel training venue. What do we mean by a searchable Data Validation list?  Let’s

Excel Dynamic Arrays – Excel will never be the same

Excel Dynamic Arrays - New Functions and Calculation Methods Dynamic Array formulas are new to Excel Office 365. Microsoft has listened to our requests and designed a set of functions that will completely change the way we use Excel. After this, everything will change! You'll be using simple Excel formulas for

More

POWERPOINT

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

CHOOSE the RIGHT Chart Animation in PowerPoint

CHOOSE the RIGHT Chart Animation in PowerPoint Have you ever been tasked with presenting a chart or a graph in a meeting? If you are using PowerPoint during the presentation, the way you setup the PowerPoint slide matters. Let’s look and a normal (otherwise known as “boring and confusing”) slide and

3 PowerPoint HACKS for INSTANT Improvement

3 PowerPoint HACKS for INSTANT Improvement (incl. Morph between Shapes) This post will introduce you to three PowerPoint techniques that you can use to impress your colleagues and boss.  They will think you spent HOURS honing and crafting your presentation… …but you won’t. This will be our little secret.

More

OTHER NEWS

Excel Dynamic Arrays – Excel will never be the same

Excel Dynamic Arrays - New Functions and Calculation Methods Dynamic Array formulas are new to Excel Office 365. Microsoft has listened to our requests and designed a set of functions that will completely change the way we use Excel. After this, everything will change! You'll be using simple Excel formulas for

  • #ExcelHash challenge Excel

First Excel Hash Challenge between 6 MVPs

What is #ExcelHash? It's the Iron Chef Tournament between 6 Excel MVP YouTubers. If you're serious about learning Excel, you've probably come across their videos: Mike Girvin from Excel is Fun; Bill Jelen from MrExcel; Mynda Treacy from MyOnlineTrainingHub; Jon Acampora from Excel Campus; Oz from Excel on Fire and myself: Leila Gharani. On September

Excel Power Query, Power Pivot & Power BI Resources

Excel Power Query, Power Pivot & Power BI Resources Some useful resources that will make you a data analysis pro A popular question from readers is: "Do you have any Power Query or Power Pivot courses?" I don't. At least not yet. But let me share with you my list of

More
All Tutorials
Share This