MrExcel Excel Videos

Identify all records where three or more conditions are met. Bill and Mike offer alternate formulas to simulate the mythical =THREEQUARTERAND() function. Also - using Evaluate Formula to test order of operations, converting Boolean results to numeric results, testing multiple conditions in a SUMPRODUCT formula.

It is a new year, with new software running the MrExcel shopping cart. One of the perpetual questions is how to find your downloads after purchasing. This video shows the steps.

In this episode from ModelOff, PW's Gavin Jordan shows how to create a confidence chart - an interesting way to show increased risk in a forecast as the forecast extends out over the next 15 years. This chart reminds me of the Hurricane Cone charts that are published in the newspaper in Florida.

In Excel, your function arguments contain a mix of off-sheet and on-sheet references. Once you touch another sheet in Point mode, Excel starts using the sheet name for on-sheet references. Mike and Bill discuss three ways to prevent this.

The source of your data validation list contains blank cells and you don't want those blanks to appear in the dropdown. Bob Umlas combines many advanced Excel techniques to solve this problem. Check out Bob's book at Excel Outside the Box

7 year old Excel is Funner tries to teach two old guys about Excel. There are some gems here ... 1:04 Mike shows you can resize the camera tool 2:17 in the outtake, Isaac points out a Camtasia tip

Excel MVP Jordan Goldmeier created a cool holiday card in Excel using Excel VBA to create falling snow flakes. Download the card from http://optionexplicitvba.com/2013/12/22/excel-holiday-card/ I asked Jordan's permission to share the workbook with you on today's podcast. In this episode, you will see how to create a custom type in VBA that has several properties. When Jordan's macro simulates the falling snow, he is managing an array of 150 Snowflake types - a very fast way to manage a large number of items in Excel. Also - Jordan keeps the red Happy Holidays message on top by using conditional formatting. Thanks to Jordan for sharing this macro with everyone!

Wouldyouthinkoftypingsentencewithoutspaces? Well, then why are you typing formulas without spaces? ModelOff 2012 World Champion Alex Gordon suggests you should be adding spaces in your formulas to make things easier to read.

In this dueling Excel podcast, the goal is to use a formula to convert 20131220 to a real Excel date. We'll meander through the usual suspects: Text to Columns, DATE(MID), Flash Fill and then be amazed as Mike provides a crazy TEXT function to solve the problem.