Formulas
Dashboards
Charts
Features
VBA
OTHER NEWS

Formulas

Quick Excel Trick to Unstack Data from One Column to Multiple Columns

Quick Excel Trick to Unstack Data from one Column to Multiple Columns In this Excel tutorial, we'll take a look at the easiest method of unstacking data. The great thing about this method is that it's dynamic, so if your source data changes, the stacked version updates automatically.

Count Day of Week Between Dates in Excel (How many Fridays?)

Count Day of Week Between Dates in Excel (How many Fridays?) How can you figure out how many Friday's are included between two days? For example, if our start date is December 3, 2018 and our end date is December 22, 2018 the answer should be 3. What do you think? 

Excel SUM based on Partial Text Match (SUMIFS with wildcards)

Excel SUM based on Partial Text Match (SUMIFS with Wildcards) Learn how to SUM values in Excel based on a partial text match. This is great for cases when you need to sum a column based on "criteria contains" a specific value or text. For these cases you can use Excel's SUMIF

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

  • infographic template excel male female

Creative Infographics in Excel

Creative infographics in Excel(Male, Female icons) Using fillable icons on charts is a good way to visualize data. In this example, the male and female icons will be used. To do this:Set up the data tableInsert a clustered column chartInsert icons into the chartFormat the chart axisOverlap the seriesFormat the chart area

  • excel Step chart made easy

How to create a Step Chart in Excel

This tutorial is a Step by Step approach to creating a Step Chart in Excel from Scratch. You can also download the template from the link below. What is a Step Chart? A Step Chart is great for visualizing variables that change on an irregular basis. It can be used to visualize inventory or

More

Features

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,

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

  • Excel Conditional number format based on another cell

Change the Number Format of a Cell Based on a Condition in Excel

Change the Number Format of a Cell Based on a Condition Quickly learn how to change the number format of a cell based on the value of another cell. In this example, I show you how you can format a cell so its number format switches between currency and no currency.

More

VBA

Data types, DIM & SET (Learn to use them correctly)

Data Types, DIM & SET (Learn to use them correctly) “Data types for variables.  Why are they important?  Why do we need them?” These are very good questions. To be honest, you can write perfectly acceptable programs and procedures without using data types.  The reason programmers don’t do this is because

Loop Through Cells Inside the Used Range (For Each Collection Loop)

Excel VBA: Loop through cells inside the used range (For Each Collection Loop) In this video we count the number of cells that contain formulas on our worksheet. We do this with Excel VBA with the help of the For Each Collection loop. This allows us to loop through each cell

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

More

OTHER NEWS

  • 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,

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

More
All Tutorials
Share This