Featured 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
Top 5 Excel Interview Questions
Top 5 Excel Interview Questions Over the past three decades, Excel has become the de facto standard spreadsheet program for businesses and individuals around the world. Excel accounts for an estimated 800 million users which translates to approximately 80% of all spreadsheet users. When entering the business world, a user whose
Excel XLookup Explained
Excel XLOOKUP Explained (Goodbye VLOOKUP!) In this post, we will examine Excel’s BEST function for performing a lookup… We’re going to look at how the new (upcoming) XLOOKUP function solves common lookup problems typically solved by older functions like… LOOKUP VLOOKUP HLOOKUP INDEX/MATCH This will be just a glimpse of some
MAXIFS MINIFS with Multiple Criteria
Excel MAXIFS MINIFS (MAX MIN with Multiple Criteria) Finding the largest or smallest value in a set is one of the first tasks beginning Excel users discover. Just after the SUM function, the MAX and MIN functions quickly become one of the major players in our symphony of functions. But how
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
How to Create a Sales Funnel Chart in Excel (Not the “usual” Funnel)
How to Create a Sales Funnel Chart in Excel (Not the "usual" Funnel) Excel 2016 has a built-in sales funnel graph, but what it doesn't have is a funnel chart that looks like a funnel. In this tutorial I show you how you can tweak the existing funnel chart to make
Charts
Progress Circle using Excel Doughnut Chart
Progress Circle using Excel Doughnut Chart When displaying progress, it is common to represent the percentage complete with an advancing bar. To make the visual more interesting, we can connect the ends together and form a circle. This looks eerily like an Excel Doughnut chart.
Excel Fun – Mosaic Chart
GUESS what's HIDDEN in Excel? (Cool Trick) Who says Excel can’t be fun? We will show how you can bring some fun to your next meeting or lecture using only Excel and some creative uses of Excel features. We want to play a game where we slowly reveal portions of a
Project Plan in Excel with Gantt Chart
Project Plan in Excel with Gantt Chart 3 Views (Plan, Actual & Progress) in 1 View This article will show how to create a Gantt Chart in Excel that displays Actual and Planned task information in a single view. The chart will also display task percentage completed as a bar inside
Features
Switch Data in Columns to Rows in Excel (Unpivot in Power Query)
Switch Data in Columns to Rows Transpose or Unpivot (Some) Fields This will be another tutorial on transposing horizontal data into vertical data. But this technique has a twist. No, wait! TWO twists! Twist 1: we don’t want to change ALL the columns in our data; only certain columns. Twist 2:
Microsoft Excel Justify
The QUICKEST & EASIEST Way to Work with TEXT in Excel Justify Feature When creating a solution for a user, it’s a good idea to give the user an instruction sheet. This is not an issue in Word, but it can become a major headache to create in Excel. If
Excel Hyperlink
ALL YOU Need to Know About Excel HYPERLINKS (Function & Feature) Hyperlinks! They’re everywhere…even in Excel! “But Excel isn’t a Web browser. How can hyperlinks be of any value?” Here are the skills we will learn to take advantage of Excel hyperlinks: Linking to websites Jumping to key locations in a
VBA
Excel VBA GetOpenFileName to Browse and Select File
Dynamic User File Selection Using Excel VBA GetOpenFilename Method This post will demonstrate how we can allow a user to select a file using a traditional “open file”-type dialog box. This has tremendous advantages over hard-coded solutions where the filename and its location are statically defined in either VBA code... ...or
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
Excel List Box to Display & Print Multiple Sheets as ONE Print Job with VBA
Excel List Box to Display & Print Multiple Sheets as ONE Print Job with VBA This post will show you how to create an Excel macro that will allow you to print specific worksheets by selecting them form an automatically generated list. Our goal is to create an ActiveX list box
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
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.
OTHER NEWS
Top 5 Excel Interview Questions
Top 5 Excel Interview Questions Over the past three decades, Excel has become the de facto standard spreadsheet program for businesses and individuals around the world. Excel accounts for an estimated 800 million users which translates to approximately 80% of all spreadsheet users. When entering the business world, a user whose
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
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