Generated by All in One SEO v5.0.1.1, this is an llms.txt file, used by LLMs to index the site.

# My Spreadsheet Lab

The site is about Microsoft Excel.

## Sitemaps

- [XML Sitemap](https://myspreadsheetlab.com/sitemap.xml): Contains all public & indexable URLs for this website.

## Posts

- [Create a solution we can understand](https://myspreadsheetlab.com/create-a-solution-we-can-understand-2/) - Recently, a client asked me to create an Excel model that they could fully understand and modify if needed. That comment changed my thought process on how to solve it. Audit friendly model There are different types of Excel models. In some cases, the logic is very complex and there's no easy way to solve
- [How Does This Formula Work?](https://myspreadsheetlab.com/how-does-this-formula-work-2/) - Excel BI has some fun challenges. This one has several solutions but would the average Excel user understand them? AI Formula Help These solutions were created by advanced Excel users, but more and more, people will use AI to write formulas instead of asking a professional for help. So... How will beginning and intermediate Excel
- [Excel LAMBDA Function Explained with Examples](https://myspreadsheetlab.com/excel-lambda-function-explained-with-examples/) - Learning an incredibly useful yet complex function like Excel's LAMBDA requires the right mix of theory and examples (and a large coffee!). LAMBDA Theory You can use LAMBDA function with named ranges (ExcelJet), but in this post I'll review an examples using LAMBDA inside another function (ExcelisFun).Dave Brun's post and Mike Girvin's video give you
- [Unlock the power of regex in Excel](https://myspreadsheetlab.com/unlock-the-power-of-regex-in-excel/) - Regex is incredibly powerful and versatile. I'll share some resources, a challenge and several techniques that are helping me learn. What is Regex? Regex (aka Regular Expressions) finds, extracts, and validates text using patterns instead of exact words. It evolved from a mathematical concept into a practical tool for text processing. Why learn Regex? Q: Why
- [Segmenting Data in Microsoft Excel](https://myspreadsheetlab.com/segmenting-data-in-microsoft-excel-2/) - When modeling in Excel should we only use traditional functions or combine traditional and dynamic array functions? Let's use segmentation as an example. What is segmenting data? Data segmentation: dividing data into meaningful subgroups. Below, two columns of data from Hablando de Excel.Age: range B7:B106Value: range C7:C106 Requirement: Sum values per age group (group increment
- [Dynamic Arrays in Action](https://myspreadsheetlab.com/dynamic-arrays-in-action/) - I've seen some amazing videos showcasing the potential of dynamic array functions but seeing them used in a model is even more impressive! Advanced Excel for Financial Planning and Analysis (FP&A) I completed Carl Seidman's course recently. It was amazing! During the course I kept thinking: "Dynamic array functions will definitely change how we model
- [End User Friendly Solution](https://myspreadsheetlab.com/end-user-friendly-solution/) - Should our approach change when a non technical person has to maintain the solution moving forward. Excel BI Challenge Here's another Excel challenge from Excel (Vijay A. Verma) BI that I'll use as an example. Given the data at the top of the image, create the summary below that lists Name and Year for all
- [Formula Readability](https://myspreadsheetlab.com/formula-readability-2/) - We all know how easily things can get out of control when writing a complex formula. It may provide the correct answer, but will anyone understand it? A good definition from Copilot: The clarity, simplicity, and interpretability of a formula, enabling users to quickly understand its purpose, logic, and components without needing extensive explanation. NHL
- [Learn Power Query M code](https://myspreadsheetlab.com/learn-power-query-m-code/) - If you're intimated by M code, this post is for you. I'll explain techniques I use for understanding M code. M code? Power Query is a Microsoft ETL tool used in Excel and Power BI. M code is generated when we interact with the user interface to change our data. Challenge We need a good
- [Why and how do formulas spill?](https://myspreadsheetlab.com/why-and-how-do-formulas-spill/) - I used this post by Meganathan Elumalai to explore the transition from traditional formulas to spill formulas (formula results spill into multiple cells). Meganathan's requirements are clear: Meganathan used a table in column B for the source items. In this post I'll use a non table range (my Excel file includes both). Will it spill
- [Probability Distributions in Excel](https://myspreadsheetlab.com/probability-distributions-in-excel/) - Learning about probability distributions can be intimidating. So many new terms and concepts. I'll use everyday language and relatable examples. There are many types of probability distributions. We'll examine these three: Discrete Uniform Distribution: rolling a single six sided die Discrete Triangular Distribution: summing the face value of two dice Normal Distribution: height of a
- [The Learning Curve in Excel](https://myspreadsheetlab.com/the-learning-curve-in-excel/) - Create the learning curve in Microsoft Excel.
- [Standard Deviation in Excel](https://myspreadsheetlab.com/standard-deviation-in-excel-2/) - How tall is tall? How do we compare? Normal Distribution and Standard Deviation answer this. We'll review the concepts and use Excel to crunch the numbers.
- [How To Play Kakuro](https://myspreadsheetlab.com/how-to-play-kakuro/) - I enjoy Kakuro puzzles. They are challenging and rewarding. In this post I'll explain: how to play Kakuro strategies for solving Kakuro (including Magic Blocks!) functions used in the Excel file: VSTACK, LET, SEQUENCE (this IS an Excel blog!) How to Play Kakuro Concept Kakuro combines elements of a crossword puzzle and a sudoku puzzle.
- [Word Game in Excel](https://myspreadsheetlab.com/word-game/) - It's not exactly the same as Wordle but close enough :) Excel File 5 letter word game v4.41Download I added additional conditional formatting and data validation in version 5: 5 letter word game v5Download If you have issues with the macros watch this video from MrExcel. Challenge I kept thinking: Can I recreate Wordle in
- [3D Objects](https://myspreadsheetlab.com/3d-objects/) - I heard about 3D Objects from MrExcel. I've had fun combing a 3D model with VBA (it moves inside your spreadsheet!) 3D Objects They have few practical uses but are fun to play with. In MrExcel's words: Unless you are an engineer, I am not sure how 3D Models has a business use. But it
- [Rounding with a twist](https://myspreadsheetlab.com/rounding-with-a-twist/) - Earlier this week I saw an interesting rounding question on the famous MrExcel Forum. And there was a twist! Excel File Download the Excel file and follow along. MrExcel Forum - rounding question (LOG INT)Download Original Question Link Link to the original post on MrExcel's amazing AND free help forum. Description I created this Excel
- [Excel Beer Game](https://myspreadsheetlab.com/excel-beer-game/) - A fun way to learn more Excel VBA !
- [S curve](https://myspreadsheetlab.com/s-curve/) - I played around with two different S curve concepts using dynamic arrays. What is an S curve? Related to Excel I found two concepts. In the end, both create a line that resembles an S when plotted against time. Project management: tracks allocated costs over time. Estimate ahead of time or track as it happens.
- [Zen Mode](https://myspreadsheetlab.com/zen-mode/) - https://lichess.org/ has a Zen mode. Can I create a Zen mode in Excel to celebrate Spreadsheet Day? Zen Concept Distractions are bad in 3 minute blitz chess games. I use Zen mode to focus on the game. Excel has many great features but at times I hide them to focus on the data. Can
- [DSUM gymnastics](https://myspreadsheetlab.com/dsum-gymnastics/) - I explored ideas to make DSUM function's criteria argument as flexible as a gymnast. Is it a spreadsheet miracle? Maybe. (Spreadsheet Miracle: see bottom of post for info on artist Kim Murton) Excel Files I used two files: (1) using original data here and (2) cleaned up source data here. Why DSUM? It's
- [CELL Function Adventure](https://myspreadsheetlab.com/cell-function-adventure/) - You may never need this...but I did recently and it's just fun knowing that Excel can solve this! Download my Excel file here (demo data from data.world). Requirement Drop down list must contain column headers for columns that have currency datatype. If datatypes change the drop list should also change Last week I would
- [Humidex Formula in Excel](https://myspreadsheetlab.com/humidex-formula-in-excel/) - It was so hot last week that I researched how to calculate Humidex in Excel.
- [Flirting with Volatility](https://myspreadsheetlab.com/flirting-with-volatility/) - I had some questions and improvement ideas for my formula pixel face. I learned a lot playing around with this. Recap My curiosity got the best of me in 2019. Challenge: Can I make a pixel face move without VBA? (post) Can I display a message when the face intersects a cell with a
- [Calculate Hours from Messy Text using Power Query](https://myspreadsheetlab.com/calculate-hours-from-messy-text-using-power-query/) - Daniel Choi solved it using Power Query! Let's review his solutions. Download Daniel's Power Query solutions. Recap It's the same messy data & requirement found in my last post. Daniel's PQ Solutions He has two Power Query solutions. #1 requires writing some M code. #2 only uses the UI. I prefer #1! Why?
- [Calculate Hours from Messy Text](https://myspreadsheetlab.com/calculate-hours-from-messy-text/) - I need to calculate hours given data like this in each cell: "9-10, 10-11, 10-11, 12-13, 12-15+, 14-17+" Download my Excel file with solution. Messy Data Data exported to Excel looks like this: Task I need to calculate total hours in each cell. Cell A2 =
- [aggregating text part 2](https://myspreadsheetlab.com/aggregating-text-part-2/) - Haven't I done this before? It was almost identical except for two details. (Download my Excel file here) Task Previous Post Why didn't I remember that I'd solved this and created a post? Who knows but there are two important differences I'll review in this post:
- [Discover Data Types templates](https://myspreadsheetlab.com/discover-data-types-templates/) - I was working on a demo file about Excel's new Data Types but I found an incredible set of templates created by Elisabetta Caldesi! Data Type Templates Template link (Microsoft Tech Community). Full List of Elisabetta's Templates: Favorite movie list Periodic table Planets & Comets Stars & Constellations U.S. college decision helper Relocation helper BabyI was working on a demo file about Excel's new Data Types but I found an incredible set of templates created by Elisabetta Caldesi! Data Type Templates Template link (Microsoft Tech Community). Full List of Elisabetta's Templates: Favorite movie list Periodic table Planets & Comets Stars & Constellations U.S. college decision helper Relocation helper Baby
- [Calculate Wind Chill in Excel](https://myspreadsheetlab.com/calculate-wind-chill-in-excel/) - Calculate Wind Chill in Excel
- [review of 2020 posts](https://myspreadsheetlab.com/review-of-2020-posts/) - Let's forget 2020 but I will review my posts. Thanks Excel for helping me through the year. 2020 Excel Posts Such a difficult year but I did learn/practice a lot of things in Excel. Excel File Download it here (new version of file I used last year. It lists
- [Flatten the Curve](https://myspreadsheetlab.com/flatten-the-curve-3/) - Our actions can flatten the curve and slow down the spread of covid-19. See my demo in Excel and in Power BI. It's a good distration from the news.
- [Worksheet_Change Keep All Time Min Max Numbers](https://myspreadsheetlab.com/worksheet_change-keep-all-time-min-max-numbers/) - Have some fun with VBA. I play with some vba from Excel MVP Tom Urtis.
- [Kevin's Formula Challenge](https://myspreadsheetlab.com/kevins-formula-challenge01/) - Create acronyms using Excel formulas.
- [Power Query Challenge - What Did They Order from the Menu?](https://myspreadsheetlab.com/power-query-challenge-what-did-they-order-from-the-menu/) - Alan Murray (Computergaga) had an interesting challenge on YouTube. It's a classic case of "Analyze my awkward dataset!". He solved it using Power Query. Can it be solved using formulas? (read Alan's LinkedIn post) The Dataset Alan received the data in this layout: Each customer is allowed 1
- [whack-a-merged-cell](https://myspreadsheetlab.com/whack-a-merged-cell/) - Creating a game is a great way to practice VBA.
- [Old School Helper Columns](https://myspreadsheetlab.com/old-school-helper-columns/) - My solution is an old school helper column approach.
- [awkward-data/power-query-solution](https://myspreadsheetlab.com/awkward-data-power-query-solution/) - Power Query rearranges this awkward data-set
- [Robert Gascon's Shortest Formula Challenge](https://myspreadsheetlab.com/robert-gascons-shortest-formula-challenge/) - Shortest Formula Challenge: replace a series of formulas with a single formula.
- [Free Excel template: Wedding Planner](https://myspreadsheetlab.com/free-excel-template-wedding-planner/) - Free Microsoft Excel wedding planner template
- [I SEE "XLFN" !?!? WHAT IS HAPPENING?](https://myspreadsheetlab.com/i-see-xlfn-what-is-happening-2/) - Despite how amazing Excel is there are times when you'll find yourself shaking with fear! For example, have you ever seen anything as scary as this...
- [Aggregating Text](https://myspreadsheetlab.com/aggregating-text/) - Which solution is best?
- [Dynamic Charts](https://myspreadsheetlab.com/dynamic-charts-2/) - Dynamic charts automatically adjust when new data is added in Excel. I'll show you several ways to create dynamic charts and a few bonus tricks.
- [Awkward Data](https://myspreadsheetlab.com/awkward-data/) - Should we use complex formulas to answer questions or should we rearrange (normalize) the data?
- [Free Excel template: Bucket List template](https://myspreadsheetlab.com/free-excel-template-bucket-list-template/) - Bucket List template. This is a free Microsoft Excel template.
- [Add color to letters inside a cell](https://myspreadsheetlab.com/add-color-to-letters-inside-a-cell/) - Use VBA to color letters inside cells in Excel.
- [arithmetic progression](https://myspreadsheetlab.com/arithmetic-progression/) - Various methods to create sequences in Excel and Power BI
- [Wayne Gretzky's Goals](https://myspreadsheetlab.com/wayne-gretzkys-goals-2/) - Trivia questions related to Gretzky's 894 regular season goals. Also, can Ovechkin pass Gretzky's record?
- [use vba to name checkboxes](https://myspreadsheetlab.com/use-vba-to-name-checkboxes/) - Over the holidays I saw some vba code for checkboxes from the book 'More Excel Outside the Box' by Bob Umlas. (download my Excel file) Bob's Code This is Bob Umlas. He is an Excel god. Let's examine his vba code. It assigns checkbox status (checked or not) to column D
- [Toronto Indoor Ice Rinks](https://myspreadsheetlab.com/toronto-indoor-ice-rinks/) - I found this interesting data-set that lists Toronto's indoor ice rinks. I thought that it would be interesting to visualize the rink locations in Excel.
- [review of 2019 posts](https://myspreadsheetlab.com/review-of-2019-posts/) - I'll review the posts I wrote in 2019. But first, a challenge inspired by a Wall Street Journal article. Can I Recreate This in Excel? It's from Wall Street Journal post Why a New Decade Feels Momentous written by Eugenia Cheng, illustrated by Tomasz Walenta. There's no practical reason
- [Welcome to MySpreadSheetLab !](https://myspreadsheetlab.com/welcome-to-myspreadsheetlab/) - This is my personal blog about spreadsheets. I will be sharing spreadsheet templates and tips with you.
- [Learn VBA UDF](https://myspreadsheetlab.com/learn-vba-udf/) - Learn how a User Defined Function works in Excel!
- [UDF Rollover Jordan Goldmeier](https://myspreadsheetlab.com/udf-rollover-jordan-goldmeier/) - See how Jordan Goldmeier's UDF Rollover technique works.
- [Advanced Conditional Formatting](https://myspreadsheetlab.com/advanced-conditional-formatting/) - Let's explore an advanced way to use Conditional Formatting in Excel. We'll make a face move around without vba! Bonus: see how to interact with target cells!
- [mmult function](https://myspreadsheetlab.com/mmult-function/) - MMULT function is incredibly powerful and yet mysterious to most. Let's explore this complex function.
- [00127 All Combinations No Formulas No VBA](https://myspreadsheetlab.com/00127-all-combinations-no-formulas-no-vba/) - Get all combinations of your text field values using a simple Pivot Table.
- [Power Query solution: partial match count with a condition](https://myspreadsheetlab.com/power-query-solution-partial-match-count-with-a-condition/) - Partial match count with a condition using Excel Power Query
- [All Combinations Using Power Query](https://myspreadsheetlab.com/all-combinations-using-power-query/) - Use Excel Power Query to get all text combinations.
- [Subtotal helper column](https://myspreadsheetlab.com/subtotal-helper-column-2/) - Use a helper column to reduce formula complexity
- [How many unique List 1 names found in List 2?](https://myspreadsheetlab.com/how-many-unique-list-1-names-found-in-list-2/) - How many unique list 1 names are found in list 2?
- [Sum Cells in Overlapping Ranges](https://myspreadsheetlab.com/sum-cells-in-overlapping-ranges-2/) - This is a cruel Excel challenge (I've used it!). Why? Because there is a brilliantly simple solution to summing cells that overlap two ranges.
- [Mr Excel (Bill Jelen) Power Excel Seminars](https://myspreadsheetlab.com/mr-excel-bill-jelen-power-excel-seminars/) - Last week I attended one of Bill Jelen's Power Excel Seminars. The event was hosted by Excel4Apps at the SoHo Metropolitan Hotel in Toronto.
- [Liam Bastick from sumproduct.com](https://myspreadsheetlab.com/liam-bastick-from-sumproduct-com/) - One of the many great things about ModelOff's Global Training Camp was that I had the pleasure of meeting Excel guru Liam Bastick.
- [Auditing & Editing M code (Power Query)](https://myspreadsheetlab.com/auditing-editing-m-code-power-query/) - Power Query is such a powerful and intriguing tool. However, there are some stumbling blocks that make it challenging. Let's audit and then modify some M code!
- [How Many Unique Visitors To Site Each Day?](https://myspreadsheetlab.com/_how-many-unique-visitors-to-site-each-day/) - Such a clear question originating from the classic: "How many unique items per group"?
- [Chess FEN viewer](https://myspreadsheetlab.com/chess-fen-viewer/) - FEN notation provides the necessary info to restart a chess game from a given position. See how I created a FEN viewer in Excel!
- [Largest Number Inside Alphanumeric String](https://myspreadsheetlab.com/largest-number-inside-alphanumeric-string/) - Extract the largest number from a cell that has a mix of letters and numbers.
- [Video 00165 Show Column Header for Matrix Value](https://myspreadsheetlab.com/video-00165-show-column-header-for-matrix-value/) - When Excel data isn't normalized and we need to analyze the data we have many ways to solve it!
- [Video 00172 Unique Values for Data Validation Drop Down](https://myspreadsheetlab.com/video-00172-unique-values-for-data-validation-drop-down/) - We need to extract unique values from a list to be used in an Excel data validation drop down list. There are many ways to solve this. The best solution depends on asking the right questions.
- [Excel ChessGames Viewer](https://myspreadsheetlab.com/excel-chessgames-viewer/) - Review chess games in Microsoft Excel! Created by Robert H Gascon
- [Dependent Drop Down List in Excel](https://myspreadsheetlab.com/dependent-drop-down-list-in-excel/) - A data validation drop down list has 'Beverage', 'Food', 'Dessert'. You select 'Food'. In the 2nd drop down list you want to see only 'Food' items ('Chicken', 'Meatloaf', 'Seafood'). The 2nd list depends on the 1st.
- [Partial Match Count with a Condition](https://myspreadsheetlab.com/partial-match-count-with-a-condition/) - Once again I discovered a formula that I had written down in a notebook. What is it doing? Is there an easier way to solve this?
- [3 Newly Added Charts in Excel 2019 You Must Learn to Create](https://myspreadsheetlab.com/3-newly-added-charts-in-excel-2019-you-must-learn-to-create/) - Learn about 3 new charts available in Excel 2019 (or with a Office 365 subscription)
- [Sorted Data Validation List](https://myspreadsheetlab.com/sorted-data-validation-list/) - This post from ExcelFORO explains how to use VBA to create a sorted data validation list. It's a great solution! Are there other ways to solve this?
- [Weighted Average](https://myspreadsheetlab.com/weighted-average/) - Weighted average in Excel. I'll show you the formula AND what's really going on inside the formula.
- [Countifs confirms Vlookup](https://myspreadsheetlab.com/countifs-confirms-vlookup/) - So many times vlookup (or index & match) saves the day and gets your answer! ....wait...are you sure it's correct???
- [Why and How to Unpivot Data](https://myspreadsheetlab.com/why-and-how-to-unpivot-data/) - Unpivot data in Microsoft Excel to make it easier to analyze.
- [Concatenate Values to Create a Key](https://myspreadsheetlab.com/concatenate-values-to-create-a-key-in-excel/) - Excel users who don't know this concept waste hours manually looking through their data. A filter helps but creating a valid lookup key is essential!
- [Harvard CEO Ranking](https://myspreadsheetlab.com/harvard-ceo-ranking/) - Harvard Business Review ranked the top 100 CEOs with three weighted categories. I added some formulas to modify the weighting. Does it make a difference?
- [What is this formula doing?](https://myspreadsheetlab.com/what-is-this-formula-doing/) - I found an Excel formula in a notebook. Can you understand it's purpose? I'll walk you through it in this post. I'll also expand it for a more complex case.
- [Rearranging Data](https://myspreadsheetlab.com/rearranging-data/) - Rearranging data is initially about recognizing the pattern. I instantly saw the steps to rearrange the data (thanks to Ken's online course!)
- [Valentine's Day in Microsoft Excel](https://myspreadsheetlab.com/valentines-day-in-microsoft-excel-2/) - How can you improve your VBA skills? Build something! Anything!
- [Extract Largest Number (Power Query & Flash Fill solutions)](https://myspreadsheetlab.com/extract-largest-number-power-query-flash-fill-solutions/) - How should we extract the largest number from a alphanumeric string? Array? Flash Fill? Power Query?
- [unstacking-data-with-chandeep/](https://myspreadsheetlab.com/unstacking-data-with-chandeep/) - I saw Chandeep's Data Cleanup Challenge and it looked like fun. Others solved it using Power Query but I used good ol' fashioned formulas!
- [CAGR in Microsoft Excel](https://myspreadsheetlab.com/cagr-in-microsoft-excel/) - How to prove that the CAGR is correct.
- [Video 00047 Formulas_Add 20 minutes to TIME value](https://myspreadsheetlab.com/video-formulas_add-20-minutes-to-time-value-2/) - How do you add 20 minutes to a time value in Microsoft Excel? What it the difference between a time value and a date & time value?
- [Learning Power Query (Get & Transform)](https://myspreadsheetlab.com/learning-power-query-get-transform/) - This year I got serious about learning Power Query! Also known as Get & Transform. Read my post to follow my journey.
- [Re-arrange, Rotate, Transpose, Twist, Cascade the data!](https://myspreadsheetlab.com/re-arrange-rotate-transpose-twist-cascade-the-data/) - Who knows what could happen in the future but for now humans using software cleanup and analyze data (not nerdy robots!). Read how Excel can help!
- [What is the easiest way to calculate grades in Excel?](https://myspreadsheetlab.com/what-is-the-easiest-way-to-calculate-grades-in-excel/) - When calculating student grades in Excel what method is best: NESTED IF or LOOKUP/BINNING TABLE?
- [Video 00122 Normalizing Exported Data](https://myspreadsheetlab.com/video-00122-normalizing-exported-data/) - Many of us enjoy puzzles. Sudoku, Crosswords, Chess, etc. I solve a lot of data puzzles using Microsoft Excel.
- [Video 00162 Excel Formula Calculates Value of Chess Pieces](https://myspreadsheetlab.com/video-00162-excel-formula-calculates-value-of-chess-pieces/) - Every once in a while I learn something completely new that really boggles my mind! In this case the Chess world overlaps the Microsoft Excel world!
- [Excel Running Template](https://myspreadsheetlab.com/excel-running-template/) - My super fit cousin Joe Perry contacted me with a few questions about an Excel spreadsheet he uses to track his running. 
- [Dynamic Ranges Using Index Function](https://myspreadsheetlab.com/dynamic-ranges-using-index-function/) - You should be using Excel's INDEX function to create dynamic ranges (not the OFFSET function).
- [Index of Ignorance](https://myspreadsheetlab.com/index-of-ignorance/) - I did a quiz on The Guardian's website. The pic I saw after the quiz reminded me of Excel's INDEX function. Yes, I see Excel function names everywhere I go!
- [The Einstellung Effect in Excel?](https://myspreadsheetlab.com/the-einstellung-effect-in-excel/) - How did a Scientific American article help me create a much simpler solution in Excel? And what connection does it have to the Einstellung Effect? Read on and I'll tell you :)
- [False Friends in Excel](https://myspreadsheetlab.com/false-friends-in-excel/) - The term False Friends is used in various fields including linguistics and chess. In this post I'll explain how it applies to Microsoft Excel!
- [Excel Sorting Challenge](https://myspreadsheetlab.com/excel-sorting-challenge/) - This is a guest post from Allan Murray (computergaga) about sorting data. Allan compares two methods: VBA and Power Query. I know my preference, what about you?
- [Video 00171 Create Christmas Lights Using Excel Sheets](https://myspreadsheetlab.com/video-00171-create-christmas-lights-using-excel-sheets/) - Did you know that an Excel UDF can change the color of a sheet tab? Somehow I came up with the idea to create Christmas Lights using Excel sheet tabs!
- [Using Microsoft Excel for your hockey pool](https://myspreadsheetlab.com/using-microsoft-excel-for-your-hockey-pool/) - In this post I'll show you how Microsoft Excel can give you an big advantage in your hockey pool!
- [Let Excel's Solver do the heavy math!](https://myspreadsheetlab.com/let-excels-solver-do-the-heavy-math/) - HOW DO WE SOLVE THIS PUZZLE? I'm 7 times as old as Lisa is now. In 20 years Lisa will be just half the age I will be then. How old is Lisa now?
- [Creating Mondrian Art in Excel](https://myspreadsheetlab.com/creating-mondrian-art-in-excel-2/) - See how my vacation to Montreal inspired me to create Mondrian style art in Excel using VBA.
- [free data from Data.world MOMA artists](https://myspreadsheetlab.com/free-data-from-data-world-moma-artists/) - In February I was planning a trip to New York City. I stumbled upon an interesting data-set that MOMA had shared with data.world. 
- [Allocating costs](https://myspreadsheetlab.com/allocating-costs-in-microsoft-excel/) - In this post I'll show you how to allocate or spread expenses or income (any number) over time. In this case it will be years but it could also be months.
- [Who Won the 2018 Winter Olympics?](https://myspreadsheetlab.com/who-won-the-2018-winter-olympics/) - I watched the closing ceremonies of the Olympics last night. It was very nice...but who won the Olympics? Do we just count the total medals for each country? Shouldn't a gold medal be worth more?
- [Ken Puls Power Query Challenge #2](https://myspreadsheetlab.com/ken-puls-power-query-challenge-2/) - In this post I'll review my solution to Ken Puls' Power Query challenge #2.
- [Video 00147 Conditionally Add Checkboxes using VBA](https://myspreadsheetlab.com/video-00147-conditionally-add-checkboxes-using-vba/) - I often use check-boxes in my Excel videos to explain the solution steps. Creating them can be tedious so I thought that there had to be an easier way!
- [Data Disaster: non normalized data](https://myspreadsheetlab.com/data-disaster-non-normalized-data-in-excel/) - Imagine a weekly task of sending out a report. To do this you rely on data from someone else. When the layout of the data changes chaos reigns! What can we do?
- [formula or vba to add spaces?](https://myspreadsheetlab.com/formula-or-vba-to-add-spaces/) - formula or vba to add space after each character in Excel? Both work, which do you prefer?
- [Normalize Data using Excel Get & Transform](https://myspreadsheetlab.com/normalize-data-using-excel-get-transform/) - I'll show you how to use Excel's amazing Get & Transform feature (aka Power Query) to normalize the data.
- [Video 00160 Sum Values From Qualifying Mini Tables](https://myspreadsheetlab.com/video-00160-sum-values-from-qualifying-mini-tables-2/) - If we were to create this requirement as a hypothetical case many would say that it would never happen. This was a real Excel question that someone had for me.
- [Overlap of Binning and Rounding in Excel](https://myspreadsheetlab.com/overlap-of-binning-and-rounding-in-excel/) - Binning numbers and rounding numbers are two separate things in Microsoft Excel. However, there is one interesting binning twist that can be solved using a rounding function.
- [2018 World Cup and Excel !](https://myspreadsheetlab.com/2018-world-cup-and-excel/) - Last week I was helping a friend build a World Cup pool in Excel. It was fun debating the pool's scoring rules. I also taught him a few Excel tricks.
- [Excel-Picture-Link](https://myspreadsheetlab.com/excel-picture-link/) - Let's review basic picture links in Excel and then explore alternative solutions to picture link limitations.
- [Paste Formula Into Excel's Name Box](https://myspreadsheetlab.com/paste-formula-into-excels-name-box/) - See how to select multiple non adjacent ranges (from any sheet) by pasting a formula into Excel's Name Box!
- [Video 00042 Why would I need an array formula?](https://myspreadsheetlab.com/video-formulas_why-would-i-need-an-array-formula-2/) - Several examples that show what Excel array formulas can do.
- [Video 00062 Learn Excel: Add Sporadic Totals](https://myspreadsheetlab.com/video-solution_add-sporadic-totals-2/) - Add dynamic subtotals in Excel (you don't have to repeat the steps every time data changes) to a data set using formulas
- [Video 00073 Helping Dean Pelton with his menu in Excel](https://myspreadsheetlab.com/helping-dean-pelton-with-his-menu-in-excel-2/) - Watch this video to see how I help Dean Pelton, from TV show Community, modify his cafeteria menu.
- [Video 00119 Excel Helps to Determine the Closest Super Bowls](https://myspreadsheetlab.com/excel-helps-to-determine-the-closest-super-bowl-games-2/) - How can we define a close Super Bowl game?
- [My Favorite Excel Tips From Other Sites Part 2.](https://myspreadsheetlab.com/my-favorite-excel-tips-from-other-sites-part-2/) - As much as I enjoy sharing my knowledge I have found that this series is just as beneficial for me as it is for others. I sometimes ask myself or others "Do you remember that Excel thing that does...." In Part 2 of this series I continue to sort through tips from YouTube videos and
- [Video 00137 Vlookup_Returns Multiple Values](https://myspreadsheetlab.com/video-00137-vlookup_returns-multiple-values/) - Use a vlookup to look for 1 value and retrieve and add several values.
- [True Vlookup Tragedy](https://myspreadsheetlab.com/true-vlookup-tragedy/) - Instructions on how to use an Excel vlookup function
- [Video 00141 Formula Auditing Maestro](https://myspreadsheetlab.com/video-00141-formula-auditing-maestro/) - Some formulas are complex due to a complex question. Other formulas are complex due to inefficient data layout. Formula Auditing Maestro Auditing formulas is an essential skill to have for Data Analysts but with some practice you'll become a Maestro! In this video I audit this formula: =VLOOKUP(B1,INDIRECT(VLOOKUP(A1,Data1!A6:B9,2,FALSE)),2,FALSE) It is an unusual formula to
- [Video 00151 Custom Formats, VBA, and Nerds!](https://myspreadsheetlab.com/video-00151-custom-formats-vba-and-nerds/) - I doubt that you have never seen custom formats presented like this before!
- [Extracting Data That Could Be Anywhere In Any Sheet](https://myspreadsheetlab.com/extracting-data-that-could-be-anywhere-in-any-sheet/) - This post from Tom Urtis reminded me of a crazy Excel puzzle I once solved. The concept was similar except for one tiny twist!
- [Unstacking Data with Oz du Soleil](https://myspreadsheetlab.com/unstacking-data-with-oz-du-soleil/) - What is unstacking Data about? Two or more columns of data are jammed together into one column. It's easier to analyze the data if we re-arrange or unstack it.
- [Video 00156 One Complex Formula or Helper Formulas?](https://myspreadsheetlab.com/video-00156-one-complex-formula-or-helper-formulas/) - In Microsoft Excel should we use 1 complex formula or use helper formulas?
- [Video 00159 Create unique and sorted text list](https://myspreadsheetlab.com/video-00159-create-unique-and-sorted-text-list/) - We have a bunch of names in a column. We need to create a unique and alphabetically sorted list.
- [World Happiness Report](https://myspreadsheetlab.com/world-happiness-report/) - Studying World Happiness Report data in Microsoft Excel
- [Reverse Partial Match Lookup to Filter for a List](https://myspreadsheetlab.com/reverse-partial-match-lookup-to-filter-for-a-list/) - Excel's LOOKUP function can process an array formula without Control Shift Enter.
- [Video 00161 Extract Matrix Non Blanks Into 1 Column](https://myspreadsheetlab.com/video-00161-extract-matrix-non-blanks-into-1-column/) - Have you ever visited excelxor.com ? It's an amazing blog with a lot of Excel formula challenges.
- [2016 Rio Olympics Women's Marathon](https://myspreadsheetlab.com/2016-rio-olympics-womens-marathon/) - One of the highlights of my life was travelling to the 2016 summer Olympics in Rio de Janeiro to watch my sister, Krista DuChene, run in the women's marathon
- [Video 00164 Excel Magic Trick 1452 Max Monthly Customer](https://myspreadsheetlab.com/video-00164-excel-magic-trick-1452-max-monthly-customer/) - Which method is best for calculating the maximum amount that a customer has spent in a single month?
- [Video 00153 All Possible Pairs from List of Names](https://myspreadsheetlab.com/video-00153-all-possible-pairs-from-list-of-names/) - Oz du Soleil and I have been trading Excel ideas for a couple of years now. During ModelOff's Global Training Camp in Toronto (Sept 22&23) I met Oz in person! Oz flew in from Oregon to deliver one of the Excel sessions. At one point Oz asked the following question: "Given a list of 10
- [Video 00114_Cleanup Data From Internet](https://myspreadsheetlab.com/video-00114_cleanup-data-from-internet/) - Cleanup data from the internet that you want to use in Microsoft Excel.
- [Why I Enjoy Watching excel.tv](https://myspreadsheetlab.com/why-i-enjoy-watching-excel-tv/) - My review of YouTube channel ExcelTV
- [Video 00135 Cali Data Cleanup](https://myspreadsheetlab.com/video-00135-cali-data-cleanup/) - Have you ever received an awkward data set? In my life as a Data Analyst this has happened to me many times in different shapes and forms.
- [ModelOff Comes to Toronto – Friday Night Drinks](https://myspreadsheetlab.com/modeloff-comes-to-toronto-friday-night-drinks/) - My review of the Toronto ModelOff Meetup event
- [Video 00139 Beyond 3D Formulas](https://myspreadsheetlab.com/video-00139-beyond-3d-formulas/) - Excel's 3D formulas allow you to work with values in the same position in different sheets. Read my post to see how they work.
- [Learn Microsoft Excel with Twitter!](https://myspreadsheetlab.com/learn-microsoft-excel-with-twitter/) - We all have down time while we wait in line or while we commute. In the past two years I've used part of my down time to learn Excel by reading tweets.
- [The Dangers of Binning in Excel](https://myspreadsheetlab.com/the-dangers-of-binning-in-excel/) - In Excel we can bin numbers. We can also bin letters. Rare but possible. However, be careful when binning a mix of letters and symbols! What could go wrong?
- [Video 00142 Horizontal list to Vertical list (layered transpose)](https://myspreadsheetlab.com/video-00142-horizontal-list-to-vertical-list-layered-transpose/) - We don't always find out how data got twisted into awkward forms. Our job is to fix it by normalizing, unwinding, transposing, etc.
- [Retro 1980 Games & Correlation](https://myspreadsheetlab.com/retro-1980-games-correlation/) - What if learning statistics could be fun? Well, Omar Wagih has found a way to do this with a retro style game that teaches correlation!
- [BradEdgar_8 Search Techniques to Find Best Excel Content](https://myspreadsheetlab.com/bradedgar_8-search-techniques-to-find-best-excel-content/) - We've all done it. We've wasted time looking for Excel content on the web due to inefficient searches. Brad Edgar has some search tips for us!
- [Video 00148 Insert Rows & Cascade Numbers](https://myspreadsheetlab.com/video-00148-insert-rows-cascade-numbers/) - Our Excel task is to repeat each original row three times and then cascade each original number diagonally down to the right.
- [Hiding in Plain Site](https://myspreadsheetlab.com/hiding-in-plain-site/) - Someone else stopped by and said "Why didn't you just use Text To Columns?". Ouch. I wasted time and I was embarrassed.
- [Video 00149 Alphabetize Challenge (Oz001)](https://myspreadsheetlab.com/video-00149-alphabetize-challenge-oz001/) - Excel MVP Oz Du Soleil had an interesting challenge: "how could Excel alphabetize titles, but ignore A, An or The if a title begins with one of those?"
- [Video 00150 Sequential Keyword Search Dog Chases Squirrel](https://myspreadsheetlab.com/video-00150-sequential-keyword-search-dog-chases-squirrel/) - Extracting insights from text can get messy! The good news is that challenging requirements can often lead to very creative solutions!
- [Otis Can't Find a Date!](https://myspreadsheetlab.com/otis-cant-find-a-date/) - Otis is looking for a date but he can't find it! Let's review four solutions that help Otis find a date.
- [Compare Text Fonts in Excel using VBA](https://myspreadsheetlab.com/compare-text-fonts-in-excel-using-vba/) - Have you ever had the experience where one event causes you to remember something from years ago? This happened to me today while reading the New Yorker
- [Look for keywords inside of a column of text values](https://myspreadsheetlab.com/look-for-keywords-inside-of-a-column-of-text-values/) - On October 17 we celebrated spreadsheet day. Part of the celebration included a lookup formula challenge from Debra Dalgleish (spreadsheet day creator).
- [Who is the blame for Subway Delays?](https://myspreadsheetlab.com/who-is-the-blame-for-subway-delays/) - Subway riders cringe when a delay is announced. Emotions range from mild annoyance to outbursts of anger....
- [Game Review: The Worksheet Saga](https://myspreadsheetlab.com/game-review-the-worksheet-saga/) - I saw a tweet about an Excel based game called The Worksheet Saga. My first thought was "oh...it's based on VBA. I wonder if the code is unlocked?"
- [Becoming a Microsoft Excel master!](https://myspreadsheetlab.com/becoming-a-microsoft-excel-master/) - Want to become an Excel master? The first step might be to convince yourself that it's possible (it is!). Then, you need some good material and determination!
- [Video 00158 Keyword Data Validation List](https://myspreadsheetlab.com/video-00158-keyword-data-validation-list-2/) - Various ways to use keywords in long Microsoft Excel data validation lists.
- [An off switch! What an excellent idea!](https://myspreadsheetlab.com/an-off-switch-what-an-excellent-idea/) - Some Excel models have so many complex formulas that they just can't calculate any more. These models often need to be re-created. Some models can be saved by making formulas more efficient. One technique is to add an OFF SWITCH to heavy formulas.
- [Change Text to Sentence Case](https://myspreadsheetlab.com/change-text-to-sentence-case/) - As Puneet Gogia mentions in his post, we can change text using UPPER, LOWER and PROPER functions but we don't have a SENTENCE function to capitalize the first letter of each sentence. Puneet solves it with a formula. How exactly does it work? Let's audit it!
- [Video 00174 Ranking Values into Tiers in Excel](https://myspreadsheetlab.com/video-00174-ranking-values-into-tiers/) - Learn how to rank numbers in tiers (groups). Two different solutions. Question from Reddit.
- [Video 00173 Dynamically Combine Data From Excel Tables](https://myspreadsheetlab.com/video-00173-dynamically-combine-data-from-excel-tables/) - An ounce of prevention is worth a pound of cure but how does this apply to Microsoft Excel? In this post I will show you a common example. Too late for prevention? I'll show you two solutions (formulas, Get & Transform)
- [Rank within Groups in Excel](https://myspreadsheetlab.com/rank-within-groups/) - How can we rank within groups in Excel? Most experts will tell you to use the SUMPRODUCT function. Why? It's the only solution they know or maybe they're concerned about compatibility. Is anyone still using Excel 2003? Let's compare SUMPRODUCT and COUNTIFS.
- [Chandoo's Sequence Number Puzzle](https://myspreadsheetlab.com/chandoos-sequence-number-puzzle/) - I saw this post from Chandoo about sequencing: "Generate a new sequence number when value changes". Chandoo's formula solution is great but in the back of my mind I was thinking "What if we have 20000 rows?"
- [Retrieve 1st Code for Selected City When Description is not blank](https://myspreadsheetlab.com/retrieve-1st-code-for-selected-city-when-description-is-not-blank/) - In Microsoft Excel there are often many different ways to create a solution. The best solution is often subjective based on whether we emphasize simplicity or efficiency. Here is a good example:
- [Dynamic Hyperlinks in Excel to HockeyDB](https://myspreadsheetlab.com/dynamic-hyperlinks-in-excel-to-hockeydb/) - About 16 years ago I discovered HOCKEYDB. I was hooked! Why? Growing up in the late 70s and 80s I was a huge hockey fan but without cable or the internet information was limited. I had so many unanswered questions.
- [Rouge National Urban Park](https://myspreadsheetlab.com/rouge-national-urban-park/) - Get free bird data from a variety of different sites. Yes that's correct: 'bird data'.
- [YouTube Video Transcript Template](https://myspreadsheetlab.com/youtube-video-transcript-excel-template/) - Have you noticed there's no way to create bookmarks within a YouTube video? I've always thought that it would be a great feature. Well, I have created an Excel template that can do this!
- [Create Your First Pivot Table in 5 Minutes](https://myspreadsheetlab.com/create-your-first-pivot-table-in-5-minutes/) - One of Microsoft Excel's most prolific features is the Pivot Table. Pivot Tables offer an efficiency and effectiveness in making sense of large amounts of data in almost no time. Let's create a Pivot Table in five minutes!
- [Excel Pivot Tables Analyze Taco Data!](https://myspreadsheetlab.com/excel-pivot-tables-analyze-taco-data/) - Learn different ways to normalize (rearrange) data in Microsoft Excel and then created Pivot Tables.
- [NYT Lack of Cat Research article leads to Spanish study](https://myspreadsheetlab.com/nyt-lack-of-cat-research-article-leads-to-spanish-study/) - How did a New York Times article about the lack of scientific cat research lead me to a spreadsheet about this: "Affective norms of 875 Spanish words for five discrete emotional categories and two emotional dimensions" ? 
- [Excel data concept taught backwards](https://myspreadsheetlab.com/excel-data-concept-taught-backwards/) - I help business people build data models. Mostly spreadsheets these days. It's often challenging to accurately & quickly explain certain concepts. There is one concept that is a classic and I'm going to explain it with the help of Hugh MacLeod's book "Evil Plans". No nerdy tech terms. The concept first. 
- [Variable Sized Groups Within Each Column](https://myspreadsheetlab.com/variable-sized-groups-within-each-column-of-data/) - Every once in a while we get a unique challenge in Excel. This one required some creativity to quickly create a solution due to a pending deadline.
- [Excel Error "You can't enter an array formula over merged cells"](https://myspreadsheetlab.com/excel-error-you-cant-enter-an-array-formula-over-merged-cells/) - You created a cool array formula and then merged it across several cells. Later, you realize that you need to modify this array formula. When you try to press Control Shift Enter you get this horrible error: You can't enter an array formula over merged cells
- [Stack Groups of 3 Numbers in Excel](https://myspreadsheetlab.com/stack-groups-of-3-numbers-in-excel/) - When faced with a challenge in Microsoft Excel it's rare that two very different approaches can both be equally amazing! In this post I'll review two completely different solutions from Oz du Soleil and David Hager. 
- [National Electronic Injury Surveillance System (NEISS)](https://myspreadsheetlab.com/national-electronic-injury-surveillance-system-neiss/) - Knowledge really is powerful and knowing how people get injured is important in order to learn from it and avoid future accidents. Let's explore this free data
- [Don't break the chain](https://myspreadsheetlab.com/dont-break-the-chain-2/) - Jerry Seinfeld's advice for improving as a comedian also applies to learning Excel !
- [Mr Excel & excelisfun Trick 141: Lookup 3 Items in 3 tables](https://myspreadsheetlab.com/mr-excel-excelisfun-trick-141-lookup-3-items-in-3-tables/) - I enjoy the dueling Excel podcasts between Bill Jelen and Mike Girvin! The challenges, the energy, the solutions, the community involvement...everything! Let's look at Excel duel 141 (the PI episode). The best solution depends on asking one question.
- [Women Who Excel](https://myspreadsheetlab.com/women-who-excel/) - Despite years of experience I still do a lot of Excel google searches. I'm often in a rush and I know which websites to trust. Three of my favorite go to Excel websites are run by: Debra Dalgleish, Mynda Treacy and Leila Gharani. 
- [Array Formula Examples](https://myspreadsheetlab.com/array-formula-examples/) - Why do you use array formulas? Why can't we use a normal Excel function? What does an array formula do? People often ask me questions like these. A quick answer is that array formulas can be used to answer very complex questions about data. Sometimes, one array formula can replace thousands of intermediary formulas. Normal
- [Stand-up comedy about Spreadsheets](https://myspreadsheetlab.com/stand-up-comedy-about-spreadsheets/) - Stand-up mathematician Matt Parker did a comedy routine about spreadsheets two years ago.
- [Video 00163 Creating a Weighted Random Dataset in Excel](https://myspreadsheetlab.com/video-00163-creating-a-weighted-random-data-set/) - Learn how to easily create a weighted random data-set in Microsoft Excel.
- [Video 00166 Count Groups Above or Below Targets](https://myspreadsheetlab.com/video-00166-count-groups-above-or-below-targets/) - This Excel puzzle almost sounds like it could be solved with a quick COUNTIFS function but it's a bit more involved than that.
- [Video 00167 Sliding Formula Ranges](https://myspreadsheetlab.com/video-00167-sliding-formula-ranges/) - Data lands in Excel in many different structures. Data Analysts will often tell you to normalize your data before starting your analysis. There are exceptions!
- [12 Different Binning Solutions & Ideas](https://myspreadsheetlab.com/12-different-binning-solutions-ideas/) - Learn various methods of binning numbers into groups with Microsoft Excel
- [Video 00081 Count and find different types of Excel errors](https://myspreadsheetlab.com/video-formulas_count-and-find-different-types-of-errors-2/) - Learn how to distinguish between different types of errors in Excel using ERROR.TYPE and ISFORMULA functions.
- [IFERROR post from www.MBAexcel.com](https://myspreadsheetlab.com/iferror-post-from-www-mbaexcel-com/) - Be careful when using Microsoft Excel's IFERROR function. It can be helpful but hiding errors can also create more problems.
- [Video 00121_Crazy String Manipulation!](https://myspreadsheetlab.com/video-00121_crazy-string-manipulation/) - Extract date and time numbers from a mixed string, add more time to it while keeping the text in the same place!
- [Formulas or VBA to create military code?](https://myspreadsheetlab.com/formulas-or-vba-to-create-military-code/) - Sometimes both work and sometimes only one works. This series will explore this question. Let's start with an idea from Sumit Bansal at TrumpExcel.
- [How Can I Improve My Excel Skills?](https://myspreadsheetlab.com/how-can-i-improve-my-excel-skills/) - Some advice on how you can improve your Microsoft Excel skills
- [Trump Excel: Get the List of File Names from a Folder in Excel](https://myspreadsheetlab.com/trump-excel-get-the-list-of-file-names-from-a-folder-in-excel-4/) - When you want to get a list of Excel file names from a folder and display it in an Excel sheet most people would think about using VBA (Excel's programming language). But what if you don't know VBA? Sumit Bansal from trumpexcel.com In Sumit's post and video he teaches us how to extract a
- [Video 00035 Solution_Dynamic array HYPERLINK](https://myspreadsheetlab.com/video-solution_dynamic-array-hyperlink-2/) - Create a dynamic hyperlink using an array formula! This means that you can jump to a location in your data depending on conditions in the values. This is one of my favorite ways to use an array formula! In fact, Debra Dalgleish thought my hyperlink array was cool. She wrote an blog post about it! Thanks
- [Video 00069 Are my Excel formulas dragged down far enough?](https://myspreadsheetlab.com/video-are-my-excel-formulas-dragged-down-far-enough-2/) - How far should you drag down your formulas? Is it possible that Excel could tell you the answer?
- [Formulas the easy way!](https://myspreadsheetlab.com/another-sample-post/) - Microsoft Excel formulas
- [Video 00067 What you see may not be what you get](https://myspreadsheetlab.com/video-what-you-see-may-not-be-what-you-get-2/) - You are trying to compare two lists of data in Microsoft Excel to see what items from 'List B' are in 'List A'. Sounds simple enough, right?
- [Video 00120 Is the solution benefit worth the cost](https://myspreadsheetlab.com/video-00120_is-the-solution-benefit-worth-the-cost-2/) - Here is an example of a unique data validation solution that takes several steps to create. Is it worth it?
- [My Favorite Excel Tips From Other Sites Part 1.](https://myspreadsheetlab.com/my-favorite-excel-tips-from-other-sites-part-1/) - I work full time as a Data Analyst currently specializing in Microsoft Excel and Microsoft Access. To keep up to date I watch a fair amount of YouTube videos and follow several websites. This series of posts will feature videos or articles from other sites that I have found to be very helpful. I find
- [Free Excel Template: Guest List Planner](https://myspreadsheetlab.com/free-excel-template-guest-list-planner/) - Microsoft Excel Free Template for Planning a guest list
- [Video 00003 Intro_Excel2010_RIBBON](https://myspreadsheetlab.com/video-intro-to-excel-2010-ribbon-2/) - In this video I introduce Excel 2010's Ribbon. The Ribbon is a new way to display Excel's many commands. The Ribbon is found at the top of the screen and consists of various 'Tabs'. 'Tabs' consist of various 'Groups' of commands. Watch my YouTube video Subscribe to my YouTube channel and learn more!
- [Video 00004 Intro_Excel2010_WINDOW](https://myspreadsheetlab.com/video-intro-to-excel-2010-window-2/) - Learn about Microsoft Excel 2010's Windows Components. Name Box, Formula Bar, Worksheet, Status Bar, Worksheet Tabs, Views, Zoom Level, Scroll Bars
- [Video 00006 Intro_NAVIGATION](https://myspreadsheetlab.com/video-how-to-navigate-inside-a-sheet-2/) - Save time by discovering efficient ways to navigate within a sheet in Microsoft Excel.
- [Video 00002 SUMPRODUCT_function Part1](https://myspreadsheetlab.com/sumproduct-function-intro-2/) - Introduction to Microsoft Excel's Sumproduct function
- [Video 00005 Intro_EXCEL-FORMULAS](https://myspreadsheetlab.com/video-intro-to-excel-formulas-2/) - This video introduces you to Microsoft Excel formulas. No prior knowledge is necessary.
- [Video 00007 Intro_HOW-TO-ENTER-DATA](https://myspreadsheetlab.com/video-how-to-enter-data-in-excel-2/) - This video shows you how to enter data in Microsoft Excel.
- [Video 00008 Features_Basic_FIND](https://myspreadsheetlab.com/video-how-to-use-excels-find-feature-2/) - Microsoft Excel's find feature will allow you to search for values in cells, comments and formulas. You can even search for cells containing a certain format.
- [Video 00009 FIND-and-SEARCH Excel functions](https://myspreadsheetlab.com/video-formulas_basic_find-search-2/) - Learn how to use Microsoft Excel's FIND and SEARCH functions
- [Video 00013 Pivot Table: Introduction](https://myspreadsheetlab.com/learn-how-to-create-a-pivot-table-2/) - Learn how to create a basic Pivot Table in Excel to quickly summarize your data!
- [Video 00036 Intro_WORKING-WITH-SHEETS](https://myspreadsheetlab.com/video-intro-working-with-sheets-2/) - Learn more about Microsoft Excel sheets
- [Free Excel template: Multi Quote Budget](https://myspreadsheetlab.com/free-excel-template-multi-quote-budget/) - Type in a budget item, select a category and then you can list up to 3 different quotes. Select a winning quote for each item.
- [Video 00012 SUMPRODUCT_Part4 this OR that](https://myspreadsheetlab.com/video-formulas_part4-this-or-that-2/) - Advanced uses of the SUMPRODUCT function including how to incorporate "this or that" logic. Download my Excel file Download the template here or via my OneDrive (file 00012) Watch my YouTube video Are you up for a challenge? Click here for Mike Girvin's Sumproduct playlist! You'll be dreaming about the Sumproduct function! Subscribe to my YouTube channel
- [Video 00010 SUMPRODUCT_Intro_Part2](https://myspreadsheetlab.com/video-formula_sumproduct_intro_part2-2/) - A quick review of Excel's Sumproduct function and 2 more examples.
- [Video 00011 SUMPRODUCT_Part3 How it really works!](https://myspreadsheetlab.com/video-formulas_sumproduct_part3-how-it-really-works-2/) - Learn what Excel's sumproduct function is really doing. See what's going on inside by evaluating it. Remember this: the F9 key is your friend! Download my Excel file Download the template here or via my OneDrive (file 00011) Watch my YouTube video Subscribe to my YouTube channel and learn more! See my free templates here!
- [Video 00014 Pivot Table: Extend the data range](https://myspreadsheetlab.com/video-pivottable_extend-the-data-range-2/) - If you've created a pivot table and later added more data then you'll need to expand the pivot's data range. NOTE: You can change your data into an Excel Table (Hold 'Ctrl' key and press 'T') and when you add more data the Pivot range won't require expanding (just refresh the Pivot) Download my Excel file
- [Video 00017 VLOOKUP Introduction Part2](https://myspreadsheetlab.com/video-formulas_vlookup_introduction-part2-2/) - review of vlookup parameters col_index_num and table_array
- [Video 00016 VLOOKUP introduction](https://myspreadsheetlab.com/video-formulas_vlookup_introduction-2/) - Learn how to find things using Excel's vlookup function
- [Video 00018 SORT_DATA in Excel](https://myspreadsheetlab.com/video-features_sort_data-2/) - Learn how to sort data in Microsoft Excel
- [Video 00023 TEXT TO COLUMNS to parse data](https://myspreadsheetlab.com/video-features_text-to-columns-2/) - Learn how to use Microsoft's Text To Columns feature.
- [Video 00024 Intro_Working with DATE and TIME_in Excel](https://myspreadsheetlab.com/video-intro_working-with-date-and-time_in-excel-2/) - Watch this video to learn how Microsoft Excel handles dates and times. Find errors in your date values.
- [Video 00027 COUNT functions in Excel](https://myspreadsheetlab.com/video-formulas_count-functions-in-excel-2/) - Learn how to count numbers, blanks, non blanks and how to conditionally count.
- [Video 00020 Use a FILTER to hide rows](https://myspreadsheetlab.com/features_use-a-filter-to-hide-rows-2/) - Learn how to hide rows using Excel's FILTER feature.
- [Video 00015 Pivot Table: How to use a PIVOT FILTER](https://myspreadsheetlab.com/video-pivot-table-how-to-use-a-pivot-filter-2/) - Learn how to exclude data from a pivot by using a report filter.
- [Video 00025 Financial Functions_FUTURE VALUE](https://myspreadsheetlab.com/video-formulas_financial-functions_future-value-2/) - Calculate the future value of your money in Microsoft Excel using the Future Value function.
- [Video 00019 Pivot Table: How to Group Dates](https://myspreadsheetlab.com/video-pivot-table_how-to-group-dates-2/) - Learn how to group a column of dates by Year & Month and sum another field with a pivot table in Excel
- [Video 00026 Financial Functions_FUTURE VALUE part 2](https://myspreadsheetlab.com/video-formulas_financial-functions_future-value-part-2-2/) - Watch this video to learn the difference between Compound Interest and Simple Interest.
- [Video 00030 Create a HYPERLINK in Microsoft Excel](https://myspreadsheetlab.com/video-formulas_create-a-hyperlink-in-microsoft-excel-2/) - A hyperlink is an easy way to jump from one location to another location.
- [Video 00028 OFFSET function introduction](https://myspreadsheetlab.com/video-formulas_offset-function-introduction-2/) - Learn how to retrieve a value or several values using the offset function.
- [Video 00029 OFFSET function with combo box](https://myspreadsheetlab.com/video-formulas_offset-function-with-combo-box-2/) - Watch this video to learn how to combine the offset function with a combo box..
- [Video 00031 DATA VALIDATION restrict values entered into a cell](https://myspreadsheetlab.com/video-features_data-validation-restrict-values-entered-into-a-cell-2/) - Use Excel's data validation feature to restrict the values that can be entered into cells. This can save you hours of data cleanup work.
- [Video 00037 Formulas_Adding numbers in Excel](https://myspreadsheetlab.com/video-formulas_adding-numbers-in-excel-2/) - Learn how to add numbers in Microsoft Excel using these functions: SUM, SUMIF, SUMIFS.
- [Video 00032 Solution_identify rows if any in same group meet condition](https://myspreadsheetlab.com/video-solution_identify-rows-if-any-in-same-group-meet-condition-2/) - Excel Challenge: identify all items within a group if any of the items in the group meet a condition
- [Video 00033 Solution_identify rows if any in same group meet condition_V2](https://myspreadsheetlab.com/video-solution_identify-rows-if-any-in-same-group-meet-condition_v2-2/) - Requirement: Identify all items within a group if any of the items in that group meet a condition. Solution: This time I use the SUMPRODUCT function for a quicker solution. SUMPRODUCT can be used to count with conditions (within the same group). Watch my YouTube video Subscribe to my YouTube channel and learn more! See
- [Video 00043 Formulas_Array Formulas_Example1_LEN_function](https://myspreadsheetlab.com/video-formulas_array-formulas_example1_len_function-2/) - Learn how to use an array formula to extend the use of Excel's LEN function.
- [Video 00044 Array Formulas_Example2_EXACT LEFT_functions](https://myspreadsheetlab.com/video-formulas_array-formulas__example2_exact_left_functions-2/) - One array formula answers a complex question in Microsoft Excel.
- [Free Excel template: SWOT planner](https://myspreadsheetlab.com/free-excel-template-swot-planner/) - Enter and compare your companies strengths, weaknesses, opportunities, and threats.
- [Video 00057 Find the Monday before the oldest date](https://myspreadsheetlab.com/video-find-the-monday-before-the-oldest-date-2/) - Find the Monday before the oldest date (from a range of dates)
- [Video 00058 Filter Out Number (digits in any order)](https://myspreadsheetlab.com/video-formulas_filter-out-number-digits-in-any-order-2/) - Filter out the cells that contain the same numbers no matter the order (i.e. 127 = 721 = 712 etc.)
- [Free Excel template: Class Student Grade Calculator v2.20](https://myspreadsheetlab.com/free-excel-template-class-student-grade-calculator-v2-20/) - This Excel file is more of a custom solution than it is a template. So, why share it? Because, you can learn a lot about Excel by auditing formulas! Take apart the template and see how it works (password is 'test'). Use Excel's formula auditing feature (found under 'FORMULAS' on the ribbon) to audit the
- [Video 00064 Solution_Customized and Sorted Data Validation List](https://myspreadsheetlab.com/customized-and-sorted-data-validation-list-2/) - Learn how to create a data validation list that sorts the text in the list. Create a formula to select 1st letter of last name to see a shorter list of names.
- [Free Excel Template: Gantt Chart_Planned vs Actual](https://myspreadsheetlab.com/free-excel-template-gantt-chart_planned-vs-actual/) - We all need to get things done, right? This free template allows you to plan out tasks and also look back to see if things turned out the way you had planned. Download the free template You can download the file here or here from my OneDrive (file 00099) Watch my YouTube video Here
- [Free Excel Template: Birthday and Anniversary Tracker](https://myspreadsheetlab.com/free-excel-template-birthday-and-anniversary-tracker/) - Birthday and Anniversary Tracker Excel template.
- [Video 00070 Use array formula to solve an algebra equation](https://myspreadsheetlab.com/video-use-array-formula-to-solve-an-algebra-equation-2/) - Here is an Algebra equation: 9x - 7 = 47 Watch the video or read my post to see how a simple array formula in Excel can solve it.
- [Free Excel Template: Small Business Outsourcing Template](https://myspreadsheetlab.com/free-excel-template-small-business-outsourcing-template/) - Are you a small business owner or are you thinking of starting a small business? Do you wish you had more hours in a day? If you answered yes to both of these questions then you should do an audit of all of your tasks to see where you can save time. I created a

## Pages

- [Blog](https://myspreadsheetlab.com/blog/) - My Spreadsheet Lab blogs about Microsoft Excel. How to use Excel with free lessons, formulas, free templates and video tutorials.
- [Templates](https://myspreadsheetlab.com/templates/) - Easy to use free excel templates. Learn more from my videos and template lessons.
- [Contact Kevin](https://myspreadsheetlab.com/contact/) - Contact Kevin Lehrbass, Excel Coach at My Spreadsheet Lab. Watch, Learn and practice and connect on web, FaceBook, YouTube, Twitter and LinkedIn.
- [About Me](https://myspreadsheetlab.com/about/) - Kevin Lehrbass has been working with Microsoft Excel and databases since 2001.
- [Home](https://myspreadsheetlab.com/home/) - If you would like to learn more about Microsoft Excel then this ‘Excel How To’ website is for you.
- [Excel Training](https://myspreadsheetlab.com/excel-training/) - Learn Microsoft Excel
- [Videos](https://myspreadsheetlab.com/videos/) - You can learn Microsoft Excel! You can greatly improve your knowledge of Excel! I will help you! Watch my videos and step by step you will start to unlock the mysteries of Microsoft Excel!.
- [Tips](https://myspreadsheetlab.com/tips/) - I make a lot of Excel videos but I will also be adding written tips with a variety of quick formulas. You will also learn different aspects of Microsoft Excel. Made easy. one tip at a time.
- [Articles](https://myspreadsheetlab.com/articles/) - I make a lot of Excel videos but I will also be adding written tips with a variety of quick formulas. You will also learn different aspects of Microsoft Excel. Made easy. one tip at a time.
- [Testimonials](https://myspreadsheetlab.com/testimonials/) - If you would like to learn more about Microsoft Excel then this ‘Excel How To’ website is for you. You can get free templates, learn all about using Microsoft Excel Spreadsheets in my easy steps videos online.
- [FAQ](https://myspreadsheetlab.com/faq/) - If you would like to learn more about Microsoft Excel then this ‘Excel How To’ website is for you. You can get free templates, learn all about using Microsoft Excel Spreadsheets in my easy steps videos online.
- [Disclaimer](https://myspreadsheetlab.com/disclaimer/) - If you would like to learn more about Microsoft Excel then this ‘Excel How To’ website is for you. You can get free templates, learn all about using Microsoft Excel Spreadsheets in my easy steps videos online.

## Clients

- [Client6](https://myspreadsheetlab.com/myclients/client6-2/)
- [Client5](https://myspreadsheetlab.com/myclients/client5-2/)
- [Client4](https://myspreadsheetlab.com/myclients/client4-2/)
- [Client3](https://myspreadsheetlab.com/myclients/client3-2/)
- [Client2](https://myspreadsheetlab.com/myclients/client2-2/)
- [Client1](https://myspreadsheetlab.com/myclients/client1-2/)

## Team

- [Calendars](https://myspreadsheetlab.com/team/calendars/) - Free Excel Template: Gantt Chart_Planned vs Actual May 24, 2014
- [Business](https://myspreadsheetlab.com/team/business/) - Free Excel Template: Small Business Outsourcing Template June 24, 2014 Free Excel template: SWOT planner April 17, 2013 Free Excel template: Multi Quote Budget February 25, 2013
- [Sean Lindsey](https://myspreadsheetlab.com/team/sean-lindsey/) - Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat
- [Austin Heeney](https://myspreadsheetlab.com/team/austin-heeney/) - Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat
- [Adam Johnson](https://myspreadsheetlab.com/team/adam-johnson/) - Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat
- [Karl Ball](https://myspreadsheetlab.com/team/karl-ball/) - Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat
- [Paul Windsor](https://myspreadsheetlab.com/team/paul-windsor/) - Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat
- [John Bishop](https://myspreadsheetlab.com/team/john-bishop/) - Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat

## Testimonials

- [JOHN DEERE](https://myspreadsheetlab.com/testimonial/john-deere/) - The Spectrum theme has made our website the best in our industry, none of our competitors even come close to us. Just a huge thanks to the CMSSuperheroes team for a stunning theme!

## Categories

- [Sports](https://myspreadsheetlab.com/category/videos/sports/)
- [Templates](https://myspreadsheetlab.com/category/templates/)
- [Tips](https://myspreadsheetlab.com/category/tips/)
- [Videos](https://myspreadsheetlab.com/category/videos/)
- [Welcome](https://myspreadsheetlab.com/category/welcome-message/)
- [T_Business](https://myspreadsheetlab.com/category/templates/business/)
- [T_Calendars](https://myspreadsheetlab.com/category/templates/calendars/)
- [T_Checklists](https://myspreadsheetlab.com/category/templates/checklists/)
- [T_Education](https://myspreadsheetlab.com/category/templates/education/)
- [Gurus](https://myspreadsheetlab.com/category/articles/excel-gurus/) - My favorite Excel tips & solutions from the web
- [Features](https://myspreadsheetlab.com/category/videos/features-basic/)
- [Errors](https://myspreadsheetlab.com/category/articles/errors/)
- [Formulas](https://myspreadsheetlab.com/category/videos/formulas-advanced/)
- [Excel Intro](https://myspreadsheetlab.com/category/videos/introduction-to-microsoft-excel/)
- [Macros (vba)](https://myspreadsheetlab.com/category/videos/macros-vba/)
- [Other](https://myspreadsheetlab.com/category/templates/other-templates/)
- [Pivot Tables](https://myspreadsheetlab.com/category/videos/pivot-tables/)
- [T_Planning](https://myspreadsheetlab.com/category/templates/planning/)
- [Solutions](https://myspreadsheetlab.com/category/videos/solutions/) - Solutions to questions posted by readers
- [Articles](https://myspreadsheetlab.com/category/articles/) - Posts with no corresponding YouTube video.
- [Reviews](https://myspreadsheetlab.com/category/articles/reviews/) - Reviews of other Excel websites, products, books, etc.
- [EXCEL Path](https://myspreadsheetlab.com/category/articles/the-excel-path/)
- [Free Data](https://myspreadsheetlab.com/category/articles/free-data/)
- [Formula or VBA](https://myspreadsheetlab.com/category/articles/formula-or-vba/)
- [Stats](https://myspreadsheetlab.com/category/videos/stats/)
- [Challenges](https://myspreadsheetlab.com/category/videos/challenges/)
- [Efficiency](https://myspreadsheetlab.com/category/articles/efficiency/)
- [Auditing](https://myspreadsheetlab.com/category/articles/auditing/)
- [Get & Transform](https://myspreadsheetlab.com/category/videos/get-transform/)
- [Art](https://myspreadsheetlab.com/category/articles/art/)
- [vba](https://myspreadsheetlab.com/category/articles/vba/)
- [PowerBI](https://myspreadsheetlab.com/category/articles/powerbi/)

## Tags

- [Algebra](https://myspreadsheetlab.com/tag/algebra/)
- [and](https://myspreadsheetlab.com/tag/and/)
- [Anniversary](https://myspreadsheetlab.com/tag/anniversary/)
- [Array formula](https://myspreadsheetlab.com/tag/array-formula/)
- [Array Formulas](https://myspreadsheetlab.com/tag/array-formulas/) - Posts that use array formulas.
- [Birthday](https://myspreadsheetlab.com/tag/birthday/)
- [counta](https://myspreadsheetlab.com/tag/counta/)
- [counter](https://myspreadsheetlab.com/tag/counter/)
- [countif](https://myspreadsheetlab.com/tag/countif/)
- [custom formats](https://myspreadsheetlab.com/tag/custom-formats/)
- [Data analysis toolpak](https://myspreadsheetlab.com/tag/data-analysis-toolpak/)
- [Data cleanup](https://myspreadsheetlab.com/tag/data-cleanup/)
- [Data Validation](https://myspreadsheetlab.com/tag/data-validation/) - Posts that use Excel’s Data Validation feature.
- [Dean Pelton](https://myspreadsheetlab.com/tag/dean-pelton/)
- [Equation](https://myspreadsheetlab.com/tag/equation/)
- [error.type](https://myspreadsheetlab.com/tag/error-type/)
- [errors](https://myspreadsheetlab.com/tag/errors/)
- [Excel](https://myspreadsheetlab.com/tag/excel/)
- [flashfill](https://myspreadsheetlab.com/tag/flashfill/)
- [Formula](https://myspreadsheetlab.com/tag/formula/)
- [formulas](https://myspreadsheetlab.com/tag/formulas-2/)
- [hyperlink](https://myspreadsheetlab.com/tag/hyperlink/)
- [if](https://myspreadsheetlab.com/tag/if/)
- [index](https://myspreadsheetlab.com/tag/index/)
- [isformula](https://myspreadsheetlab.com/tag/isformula/)
- [isnumber](https://myspreadsheetlab.com/tag/isnumber/)
- [Learn Excel](https://myspreadsheetlab.com/tag/learn-excel/)
- [left](https://myspreadsheetlab.com/tag/left/)
- [lookup](https://myspreadsheetlab.com/tag/lookup/)
- [match](https://myspreadsheetlab.com/tag/match/)
- [Math](https://myspreadsheetlab.com/tag/math/)
- [max](https://myspreadsheetlab.com/tag/max/)
- [microsoft](https://myspreadsheetlab.com/tag/microsoft/)
- [Mr Excel](https://myspreadsheetlab.com/tag/mr-excel/)
- [not](https://myspreadsheetlab.com/tag/not/)
- [offset](https://myspreadsheetlab.com/tag/offset/)
- [Search](https://myspreadsheetlab.com/tag/search/)
- [small](https://myspreadsheetlab.com/tag/small/)
- [Sort](https://myspreadsheetlab.com/tag/sort/) - Posts that use Excel’s Sort feature.
- [String Manipulation](https://myspreadsheetlab.com/tag/string-manipulation/)
- [sum](https://myspreadsheetlab.com/tag/sum/)
- [sumif](https://myspreadsheetlab.com/tag/sumif/)
- [template](https://myspreadsheetlab.com/tag/template/)
- [Text to Columns](https://myspreadsheetlab.com/tag/text-to-columns/) - Posts that use Excel’s Text to Columns feature
- [Weddings](https://myspreadsheetlab.com/tag/weddings/) - Posts related to weddings.
- [camera](https://myspreadsheetlab.com/tag/camera/)
- [chilled](https://myspreadsheetlab.com/tag/chilled/)
- [coctail](https://myspreadsheetlab.com/tag/coctail/)
- [cool](https://myspreadsheetlab.com/tag/cool/)
- [food](https://myspreadsheetlab.com/tag/food/)
- [hardware](https://myspreadsheetlab.com/tag/hardware/)
- [hipster](https://myspreadsheetlab.com/tag/hipster/)
- [holidays](https://myspreadsheetlab.com/tag/holidays/)
- [light](https://myspreadsheetlab.com/tag/light/)
- [place](https://myspreadsheetlab.com/tag/place/)
- [retro](https://myspreadsheetlab.com/tag/retro/)
- [video-2](https://myspreadsheetlab.com/tag/video-2/)
- [watch](https://myspreadsheetlab.com/tag/watch/)
- [ExcelTV](https://myspreadsheetlab.com/tag/exceltv/)
- [Jordan Goldmeier](https://myspreadsheetlab.com/tag/jordan-goldmeier/)
- [ModelOff](https://myspreadsheetlab.com/tag/modeloff/)
- [Oz du Soleil](https://myspreadsheetlab.com/tag/oz-du-soleil/)
- [Reviews](https://myspreadsheetlab.com/tag/reviews/)
- [Rick Grantham](https://myspreadsheetlab.com/tag/rick-grantham/)
- [Szilvia Juhasz](https://myspreadsheetlab.com/tag/szilvia-juhasz/)
- [sumifs](https://myspreadsheetlab.com/tag/sumifs/)
- [Filter](https://myspreadsheetlab.com/tag/filter/)
- [Super Bowl](https://myspreadsheetlab.com/tag/super-bowl/)
- [Mike Girvin](https://myspreadsheetlab.com/tag/mike-girvin/)
- [Debra Dalgleish](https://myspreadsheetlab.com/tag/debra-dalgleish/)
- [chart](https://myspreadsheetlab.com/tag/chart/)
- [gantt](https://myspreadsheetlab.com/tag/gantt/)
- [time](https://myspreadsheetlab.com/tag/time/)
- [date](https://myspreadsheetlab.com/tag/date/)
- [Tim Hill](https://myspreadsheetlab.com/tag/tim-hill/)
- [array](https://myspreadsheetlab.com/tag/array/)
- [exact](https://myspreadsheetlab.com/tag/exact/)
- [len](https://myspreadsheetlab.com/tag/len/)
- [Bill Jelen](https://myspreadsheetlab.com/tag/bill-jelen/)
- [Chip Pearson](https://myspreadsheetlab.com/tag/chip-pearson/)
- [cleanup](https://myspreadsheetlab.com/tag/cleanup/)
- [vlookup](https://myspreadsheetlab.com/tag/vlookup/)
- [Pivot Table](https://myspreadsheetlab.com/tag/pivot-table/)
- [sumproduct](https://myspreadsheetlab.com/tag/sumproduct/)
- [Find](https://myspreadsheetlab.com/tag/find/)
- [data entry](https://myspreadsheetlab.com/tag/data-entry/)
- [Navigation](https://myspreadsheetlab.com/tag/navigation/)
- [go to special](https://myspreadsheetlab.com/tag/go-to-special/)
- [formula intro](https://myspreadsheetlab.com/tag/formula-intro/)
- [budget](https://myspreadsheetlab.com/tag/budget/)
- [constant array](https://myspreadsheetlab.com/tag/constant-array/)
- [Sumit Bansal](https://myspreadsheetlab.com/tag/sumit-bansal/)
- [dashboard](https://myspreadsheetlab.com/tag/dashboard/)
- [pivot](https://myspreadsheetlab.com/tag/pivot/)
- [Alt D P](https://myspreadsheetlab.com/tag/alt-d-p/)
- [export](https://myspreadsheetlab.com/tag/export/)
- [normalize](https://myspreadsheetlab.com/tag/normalize/)
- [Seminar](https://myspreadsheetlab.com/tag/seminar/)
- [Toronto](https://myspreadsheetlab.com/tag/toronto/)
- [PSCL](https://myspreadsheetlab.com/tag/pscl/)
- [Binning](https://myspreadsheetlab.com/tag/binning/)
- [3D Range Formulas](https://myspreadsheetlab.com/tag/3d-range-formulas/)
- [Indirect](https://myspreadsheetlab.com/tag/indirect/)
- [Twitter](https://myspreadsheetlab.com/tag/twitter/)
- [combinations](https://myspreadsheetlab.com/tag/combinations/)
- [IFERROR](https://myspreadsheetlab.com/tag/iferror/)
- [Audit](https://myspreadsheetlab.com/tag/audit/)
- [Data Layout](https://myspreadsheetlab.com/tag/data-layout/)
- [Transpose](https://myspreadsheetlab.com/tag/transpose/)
- [NEISS](https://myspreadsheetlab.com/tag/neiss/)
- [data](https://myspreadsheetlab.com/tag/data/)
- [free](https://myspreadsheetlab.com/tag/free/)
- [public](https://myspreadsheetlab.com/tag/public/)
- [named range](https://myspreadsheetlab.com/tag/named-range/)
- [BradEdgar](https://myspreadsheetlab.com/tag/bradedgar/)
- [vba](https://myspreadsheetlab.com/tag/vba/)
- [check-box](https://myspreadsheetlab.com/tag/check-box/)
- [helper formula](https://myspreadsheetlab.com/tag/helper-formula/)
- [grades](https://myspreadsheetlab.com/tag/grades/)
- [Subway](https://myspreadsheetlab.com/tag/subway/)
- [random](https://myspreadsheetlab.com/tag/random/)
- [data-set](https://myspreadsheetlab.com/tag/data-set/)
- [Leila Gharani](https://myspreadsheetlab.com/tag/leila-gharani/)
- [3D Map](https://myspreadsheetlab.com/tag/3d-map/)
- [Sliding ranges](https://myspreadsheetlab.com/tag/sliding-ranges/)
- [game](https://myspreadsheetlab.com/tag/game/)
- [udf](https://myspreadsheetlab.com/tag/udf/)
- [Comedy](https://myspreadsheetlab.com/tag/comedy/)
- [Jon Acampora](https://myspreadsheetlab.com/tag/jon-acampora/)
- [Rank](https://myspreadsheetlab.com/tag/rank/)
- [Roundup](https://myspreadsheetlab.com/tag/roundup/)
- [countifs](https://myspreadsheetlab.com/tag/countifs/)
- [textjoin](https://myspreadsheetlab.com/tag/textjoin/)
- [Get & Transform](https://myspreadsheetlab.com/tag/get-transform/)
- [address](https://myspreadsheetlab.com/tag/address/)
- [name box](https://myspreadsheetlab.com/tag/name-box/)
- [picture link](https://myspreadsheetlab.com/tag/picture-link/)
- [char](https://myspreadsheetlab.com/tag/char/)
- [rounding](https://myspreadsheetlab.com/tag/rounding/)
- [mod](https://myspreadsheetlab.com/tag/mod/)
- [slicer](https://myspreadsheetlab.com/tag/slicer/)
- [Power Query](https://myspreadsheetlab.com/tag/power-query/)
- [hockey](https://myspreadsheetlab.com/tag/hockey/)
- [expanding range](https://myspreadsheetlab.com/tag/expanding-range/)
- [chess](https://myspreadsheetlab.com/tag/chess/)
- [volatile](https://myspreadsheetlab.com/tag/volatile/)
- [Unpivot](https://myspreadsheetlab.com/tag/unpivot/)
- [CAGR](https://myspreadsheetlab.com/tag/cagr/)
- [charts](https://myspreadsheetlab.com/tag/charts/)
- [subtotal](https://myspreadsheetlab.com/tag/subtotal/)
- [Normal Distribution](https://myspreadsheetlab.com/tag/normal-distribution/)
- [Standard Deviation](https://myspreadsheetlab.com/tag/standard-deviation/)
- [intersect](https://myspreadsheetlab.com/tag/intersect/)
- [beer](https://myspreadsheetlab.com/tag/beer/)
- [Conditional Formatting](https://myspreadsheetlab.com/tag/conditional-formatting/)
- [MMULT](https://myspreadsheetlab.com/tag/mmult/)
- [Rollover](https://myspreadsheetlab.com/tag/rollover/)
- [dynamic array](https://myspreadsheetlab.com/tag/dynamic-array/)
- [checkbox](https://myspreadsheetlab.com/tag/checkbox/)
- [worksheet change](https://myspreadsheetlab.com/tag/worksheet-change/)
- [DAX](https://myspreadsheetlab.com/tag/dax/)
- [List.Transform](https://myspreadsheetlab.com/tag/list-transform/)
- [List.Sum](https://myspreadsheetlab.com/tag/list-sum/)
- [sequence](https://myspreadsheetlab.com/tag/sequence/)
- [DSUM](https://myspreadsheetlab.com/tag/dsum/)
- [Application.OnKey](https://myspreadsheetlab.com/tag/application-onkey/)
- [S curve](https://myspreadsheetlab.com/tag/s-curve/)
- [LOG](https://myspreadsheetlab.com/tag/log/)
- [INT](https://myspreadsheetlab.com/tag/int/)
- [MrExcel](https://myspreadsheetlab.com/tag/mrexcel/)
- [3D Model](https://myspreadsheetlab.com/tag/3d-model/)

## Client Categories

- [Clients](https://myspreadsheetlab.com/clientscategory/clients/)

## Portfolio Categories

- [Renovations](https://myspreadsheetlab.com/portfolio_category/renovations/)
- [Domestic Projects](https://myspreadsheetlab.com/portfolio_category/domestic-projects/)
- [Commercial Projects](https://myspreadsheetlab.com/portfolio_category/commercial-projects/)
- [Industrial Projects](https://myspreadsheetlab.com/portfolio_category/industrial-projects/)

## Portfolio Tags

- [Fencing](https://myspreadsheetlab.com/tag/fencing/)

## Team Categories

- [Carpenter](https://myspreadsheetlab.com/team_category/carpenter/)
- [Craftsman](https://myspreadsheetlab.com/team_category/craftsman/)
- [Joiner](https://myspreadsheetlab.com/team_category/joiner/)
- [Manager](https://myspreadsheetlab.com/team_category/manager/)

## Testimonial Categories

- [Manager](https://myspreadsheetlab.com/testimonial_category/manage/)