Home

• Word Game in Excel

  April 24, 2022

• 3D Objects

  December 24, 2021

• Rounding with a twist

  December 13, 2021

• S curve

  November 25, 2021

• Zen Mode

  October 17, 2021

• DSUM gymnastics

  August 8, 2021

• CELL Function Adventure

  July 29, 2021

• Flirting with Volatility

  July 4, 2021

• Calculate Hours from Messy Text using Power Query

  May 30, 2021

• Calculate Hours from Messy Text

  May 29, 2021

• aggregating text part 2

  April 8, 2021

• Discover Data Types templates

  February 7, 2021

• review of 2020 posts

  January 23, 2021

• whack-a-merged-cell

  November 23, 2020

• Robert Gascon’s Shortest Formula Challenge

  October 14, 2020

• Aggregating Text

  August 29, 2020

• awkward-data/power-query-solution

  August 3, 2020

• Awkward Data

  July 26, 2020

• Add color to letters inside a cell

  April 26, 2020

• Calculate Wind Chill in Excel

  April 21, 2020

• arithmetic progression

  March 31, 2020

• Worksheet_Change Keep All Time Min Max Numbers

  March 22, 2020

• Flatten the Curve

  March 18, 2020

• Old School Helper Columns

  March 6, 2020

• Kevin’s Formula Challenge

  February 9, 2020

• Wayne Gretzky’s Goals

  January 25, 2020

• Power Query Challenge – What Did They Order from the Menu?

  January 25, 2020

• use vba to name checkboxes

  January 18, 2020

• review of 2019 posts

  December 31, 2019

• UDF Rollover Jordan Goldmeier

  December 22, 2019

• mmult function

  December 2, 2019

• Advanced Conditional Formatting

  November 17, 2019

• Excel Beer Game

  October 17, 2019

• Standard Deviation in Excel

  October 8, 2019

• Learn VBA UDF

  September 28, 2019

• Chess FEN viewer

  August 23, 2019

• Humidex Formula in Excel

  August 10, 2019

• Excel ChessGames Viewer

  August 6, 2019

• Auditing & Editing M code (Power Query)

  July 16, 2019

• All Combinations Using Power Query

  July 13, 2019

• Sum Cells in Overlapping Ranges

  July 8, 2019

• Subtotal helper column

  May 31, 2019

• How many unique List 1 names found in List 2?

  May 29, 2019

• Power Query solution: partial match count with a condition

  May 17, 2019

• 3 Newly Added Charts in Excel 2019 You Must Learn to Create

  April 30, 2019

• Partial Match Count with a Condition

  April 22, 2019

• Sorted Data Validation List

  April 16, 2019

• Weighted Average

  April 9, 2019

• Countifs confirms Vlookup

  April 9, 2019

• CAGR in Microsoft Excel

  April 3, 2019

• Extract Largest Number (Power Query & Flash Fill solutions)

  March 26, 2019

• unstacking-data-with-chandeep/

  March 21, 2019

• Largest Number Inside Alphanumeric String

  March 3, 2019

• Valentine’s Day in Microsoft Excel

  February 12, 2019

• Why and How to Unpivot Data

  February 8, 2019

• Rearranging Data

  February 3, 2019

• Dynamic Ranges Using Index Function

  January 22, 2019

• What is this formula doing?

  January 13, 2019

• False Friends in Excel

  January 4, 2019

• Excel Running Template

  December 21, 2018

• Harvard CEO Ranking

  December 17, 2018

• The Learning Curve in Excel

  December 14, 2018

• Excel Sorting Challenge

  November 28, 2018

• Concatenate Values to Create a Key

  November 4, 2018

• Dynamic Charts

  October 21, 2018

• Let Excel’s Solver do the heavy math!

  September 28, 2018

• Using Microsoft Excel for your hockey pool

  September 23, 2018

• Creating Mondrian Art in Excel

  September 12, 2018

• Allocating costs

  August 21, 2018

• Ken Puls Power Query Challenge #2

  August 14, 2018

• Learning Power Query (Get & Transform)

  August 7, 2018

• free data from Data.world MOMA artists

  July 31, 2018

• formula or vba to add spaces?

  July 25, 2018

• Normalize Data using Excel Get & Transform

  July 19, 2018

• Data Disaster: non normalized data

  July 15, 2018

• Excel-Picture-Link

  July 5, 2018

• Paste Formula Into Excel’s Name Box

  June 18, 2018

• 2018 World Cup and Excel !

  June 15, 2018

• Overlap of Binning and Rounding in Excel

  June 9, 2018

• Dependent Drop Down List in Excel

  June 5, 2018

• Don’t break the chain

  June 3, 2018

• Stack Groups of 3 Numbers in Excel

  May 17, 2018

• Retrieve 1st Code for Selected City When Description is not blank

  May 16, 2018

• Excel Error “You can’t enter an array formula over merged cells”

  May 14, 2018

• Variable Sized Groups Within Each Column

  May 7, 2018

• Excel data concept taught backwards

  May 1, 2018

• NYT Lack of Cat Research article leads to Spanish study

  April 18, 2018

• Excel Pivot Tables Analyze Taco Data!

  April 12, 2018

• Create Your First Pivot Table in 5 Minutes

  March 18, 2018

• Mr Excel & excelisfun Trick 141: Lookup 3 Items in 3 tables

  March 14, 2018

• The Einstellung Effect in Excel?

  March 11, 2018

• Women Who Excel

  March 8, 2018

• YouTube Video Transcript Template

  March 6, 2018

• Who Won the 2018 Winter Olympics?

  February 27, 2018

• Rouge National Urban Park

  February 21, 2018

• Dynamic Hyperlinks in Excel to HockeyDB

  February 17, 2018

• Chandoo’s Sequence Number Puzzle

  February 13, 2018

• Rank within Groups in Excel

  February 8, 2018

• Video 00173 Dynamically Combine Data From Excel Tables

  February 1, 2018

• Video 00174 Ranking Values into Tiers in Excel

  January 29, 2018

• Change Text to Sentence Case

  January 26, 2018

• An off switch! What an excellent idea!

  January 21, 2018

• Video 00172 Unique Values for Data Validation Drop Down

  January 17, 2018

• Video 00158 Keyword Data Validation List

  January 13, 2018

• Becoming a Microsoft Excel master!

  January 11, 2018

• Stand-up comedy about Spreadsheets

  January 7, 2018

• Video 00171 Create Christmas Lights Using Excel Sheets

  January 5, 2018

• Game Review: The Worksheet Saga

  December 29, 2017

• Who is the blame for Subway Delays?

  December 19, 2017

• Look for keywords inside of a column of text values

  November 22, 2017

• Compare Text Fonts in Excel using VBA

  November 16, 2017

• Video 00167 Sliding Formula Ranges

  November 8, 2017

• Video 00166 Count Groups Above or Below Targets

  November 7, 2017

• Toronto Indoor Ice Rinks

  September 25, 2017

• Video 00164 Excel Magic Trick 1452 Max Monthly Customer

  August 29, 2017

• Video 00165 Show Column Header for Matrix Value

  August 23, 2017

• Video 00163 Creating a Weighted Random Dataset in Excel

  July 27, 2017

• 2016 Rio Olympics Women’s Marathon

  July 1, 2017

• I SEE “XLFN” !?!? WHAT IS HAPPENING?

  June 26, 2017

• Video 00162 Excel Formula Calculates Value of Chess Pieces

  June 26, 2017

• What is the easiest way to calculate grades in Excel?

  June 19, 2017

• Video 00161 Extract Matrix Non Blanks Into 1 Column

  June 17, 2017

• Reverse Partial Match Lookup to Filter for a List

  June 11, 2017

• Video 00160 Sum Values From Qualifying Mini Tables

  May 26, 2017

• World Happiness Report

  May 25, 2017

• Video 00159 Create unique and sorted text list

  May 8, 2017

• Video 00156 One Complex Formula or Helper Formulas?

  March 14, 2017

• Unstacking Data with Oz du Soleil

  December 6, 2016

• Video 00153 All Possible Pairs from List of Names

  October 4, 2016

• Liam Bastick from sumproduct.com

  October 1, 2016

• How Many Unique Visitors To Site Each Day?

  September 10, 2016

• Extracting Data That Could Be Anywhere In Any Sheet

  August 7, 2016

• Re-arrange, Rotate, Transpose, Twist, Cascade the data!

  July 30, 2016

• Video 00151 Custom Formats, VBA, and Nerds!

  July 24, 2016

• Otis Can’t Find a Date!

  July 18, 2016

• Video 00150 Sequential Keyword Search Dog Chases Squirrel

  June 26, 2016

• Video 00149 Alphabetize Challenge (Oz001)

  June 8, 2016

• Video 00147 Conditionally Add Checkboxes using VBA

  June 6, 2016

• Video 00148 Insert Rows & Cascade Numbers

  May 14, 2016

• Hiding in Plain Site

  February 28, 2016

• Formulas or VBA to create military code?

  February 24, 2016

• Retro 1980 Games & Correlation

  February 11, 2016

• BradEdgar_8 Search Techniques to Find Best Excel Content

  February 2, 2016

• Index of Ignorance

  January 25, 2016

• National Electronic Injury Surveillance System (NEISS)

  January 20, 2016

• Video 00142 Horizontal list to Vertical list (layered transpose)

  January 17, 2016

• Video 00141 Formula Auditing Maestro

  January 14, 2016

• The Dangers of Binning in Excel

  December 12, 2015

• IFERROR post from www.MBAexcel.com

  November 30, 2015

• 00127 All Combinations No Formulas No VBA

  November 24, 2015

• Learn Microsoft Excel with Twitter!

  November 18, 2015

• 12 Different Binning Solutions & Ideas

  October 28, 2015

• True Vlookup Tragedy

  October 21, 2015

• Video 00139 Beyond 3D Formulas

  October 14, 2015

• ModelOff Comes to Toronto – Friday Night Drinks

  September 29, 2015

• Mr Excel (Bill Jelen) Power Excel Seminars

  September 28, 2015

• Video 00122 Normalizing Exported Data

  September 23, 2015

• Video 00135 Cali Data Cleanup

  September 21, 2015

• Trump Excel: Get the List of File Names from a Folder in Excel

  September 15, 2015

• Video 00137 Vlookup_Returns Multiple Values

  September 14, 2015

• Why I Enjoy Watching excel.tv

  May 4, 2015

• How Can I Improve My Excel Skills?

  April 26, 2015

• Video 00121_Crazy String Manipulation!

  February 8, 2015

• Video 00120 Is the solution benefit worth the cost

  February 2, 2015

• My Favorite Excel Tips From Other Sites Part 2.

  February 2, 2015

• Video 00119 Excel Helps to Determine the Closest Super Bowls

  January 26, 2015

• Video 00114_Cleanup Data From Internet

  January 8, 2015

• Free Excel Template: Birthday and Anniversary Tracker

  January 6, 2015

• My Favorite Excel Tips From Other Sites Part 1.

  January 6, 2015

• Free Excel Template: Small Business Outsourcing Template

  June 24, 2014

• Array Formula Examples

  June 8, 2014

• Free Excel Template: Gantt Chart_Planned vs Actual

  May 24, 2014

• Video 00081 Count and find different types of Excel errors

  February 9, 2014

• Video 00073 Helping Dean Pelton with his menu in Excel

  January 13, 2014

• Video 00070 Use array formula to solve an algebra equation

  January 8, 2014

• Video 00069 Are my Excel formulas dragged down far enough?

  January 6, 2014

• Video 00067 What you see may not be what you get

  January 6, 2014

• Video 00062 Learn Excel: Add Sporadic Totals

  January 6, 2014

• Video 00064 Solution_Customized and Sorted Data Validation List

  December 30, 2013

• Free Excel template: Class Student Grade Calculator v2.20

  December 1, 2013

• Video 00058 Filter Out Number (digits in any order)

  November 23, 2013

• Video 00057 Find the Monday before the oldest date

  November 21, 2013

• Free Excel template: Wedding Planner

  May 21, 2013

• Video 00047 Formulas_Add 20 minutes to TIME value

  April 21, 2013

• Free Excel template: SWOT planner

  April 17, 2013

• Video 00044 Array Formulas_Example2_EXACT LEFT_functions

  April 17, 2013

• Video 00043 Formulas_Array Formulas_Example1_LEN_function

  April 16, 2013

• Video 00042 Why would I need an array formula?

  April 11, 2013

• Video 00035 Solution_Dynamic array HYPERLINK

  April 8, 2013

• Video 00033 Solution_identify rows if any in same group meet condition_V2

  April 8, 2013

• Video 00032 Solution_identify rows if any in same group meet condition

  April 8, 2013

• Video 00037 Formulas_Adding numbers in Excel

  April 8, 2013

• Video 00031 DATA VALIDATION restrict values entered into a cell

  April 7, 2013

• Video 00030 Create a HYPERLINK in Microsoft Excel

  April 7, 2013

• Video 00029 OFFSET function with combo box

  April 7, 2013

• Video 00028 OFFSET function introduction

  April 7, 2013

• Video 00026 Financial Functions_FUTURE VALUE part 2

  April 7, 2013

• Video 00025 Financial Functions_FUTURE VALUE

  April 7, 2013

• Video 00019 Pivot Table: How to Group Dates

  April 7, 2013

• Video 00015 Pivot Table: How to use a PIVOT FILTER

  April 7, 2013

• Video 00020 Use a FILTER to hide rows

  April 7, 2013

• Video 00027 COUNT functions in Excel

  April 7, 2013

• Video 00024 Intro_Working with DATE and TIME_in Excel

  April 7, 2013

• Video 00023 TEXT TO COLUMNS to parse data

  April 6, 2013

• Video 00018 SORT_DATA in Excel

  April 6, 2013

• Video 00017 VLOOKUP Introduction Part2

  April 6, 2013

• Video 00016 VLOOKUP introduction

  April 6, 2013

• Video 00014 Pivot Table: Extend the data range

  April 6, 2013

• Video 00012 SUMPRODUCT_Part4 this OR that

  April 5, 2013

• Video 00011 SUMPRODUCT_Part3 How it really works!

  April 5, 2013

• Video 00010 SUMPRODUCT_Intro_Part2

  April 4, 2013

• Video 00009 FIND-and-SEARCH Excel functions

  April 4, 2013

• Video 00036 Intro_WORKING-WITH-SHEETS

  April 4, 2013

• Free Excel template: Multi Quote Budget

  February 25, 2013

• Video 00013 Pivot Table: Introduction

  February 18, 2013

• Video 00008 Features_Basic_FIND

  February 10, 2013

• Video 00007 Intro_HOW-TO-ENTER-DATA

  January 27, 2013

• Video 00006 Intro_NAVIGATION

  January 23, 2013

• Video 00002 SUMPRODUCT_function Part1

  January 22, 2013

• Video 00005 Intro_EXCEL-FORMULAS

  January 20, 2013

• Free Excel template: Bucket List template

  January 19, 2013

• Formulas the easy way!

  January 19, 2013

• Free Excel Template: Guest List Planner

  January 17, 2013

• Video 00004 Intro_Excel2010_WINDOW

  January 16, 2013

• Video 00003 Intro_Excel2010_RIBBON

  January 14, 2013

• Welcome to MySpreadSheetLab !

  January 12, 2013