Formulas
Dashboards
Charts
Features
DYNAMIC ARRAYS
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 RANK without Skipping Numbers (Top 3 Report with Duplicates)

Excel RANK without Skipping Numbers (Top 3 Report with Duplicates) Let's look at Excel’s ranked function.  How can you rank your values in descending or ascending order and how can you rank duplicate values without skipping numbers in the sequence?es. Let's look

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.

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

3 Handy Excel Chart Tips You Might Have Missed

3 Handy Excel Chart Tips You Might Have Missed This post will focus on three little-known chart features that will save you time when creating reports include charts. Let’s see how many you know versus how many are new to you. Two

  • 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

More

Features

Learning Excel Custom Number Formatting

Learning Custom Number Formatting – One of Excel’s Magical Mystery Tours Typing data in Excel can have the same result as typing a letter on a typewriter – what you see is what you get – commonly referred to as “WYSIWYG”. Unlike an old Remington typewriter, Excel can chameleon a cell

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,

Better Excel Presentations: Increase Font Size of Formula Bar

Better Excel Presentations: Increase Font Size of Formula Bar Imagine the following scenario:  You’re in the audience of a presentation and the speaker is displaying a spreadsheet on a television or projector screen.  The screen is full of facts, figures, and formulas. Sitting in the back of the room, you ask,

More

VBA

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,

How to use the Message Box in Excel VBA

How to use the Message Box in Excel VBA (syntax you'll need for MsgBox) In this tutorial you'll quickly learn the correct syntax to create a VBA message box (also referred to as a pop-up dialogue box) in Excel. I first show you how to create a message box that displays

Excel 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

More

DYNAMIC ARRAYS

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

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