MrExcel Excel Videos

Two questions today with a similar solution using a VBA Event Handler. Question 1: Cells O19 and Q19 are mutually exclusive. If someone selects from the validation dropdown in one cell, the other cell should be cleared out. Question 2: In a certain range where you have to enter large numbers, can Excel add three zeroes to any number you type. Both of these are solved using the same event handler macro. Concepts in this video include: Changing Macro Security to Allow Macros ( 0:30 min ) Change file extension to Allow Macros ( 0:42 min ) Finding the worksheet code pane ( 1:06 min ) Starting a Worksheet_Change macro ( 1:20 min ) Using an IF Statement in VBA to check what cell just changed ( 1:50 min ) Why Target.Address requires dollar...

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.