MrExcel Excel Videos

Learn Excel - Automatically add entries to total - Podcast #1973

John asks a common question: When I enter a value in B, can you immediately add the value to C and clear out B for the next entry? While this can be done, the loss of Undo makes it risky. I show a VBA macro to do immediately and also to sweep a batch of entries.

View full article »

Learn Excel - Forecasting What's Next - Podcast 1972

This video covers: Using the Fill Handle to generate a straight-line forecast. Using the new Exponential Smoothing ETS.FORECAST function in Excel 2016. Using Forecast Sheets in Excel 2016. Seeing R-Squared using a trendline on a chart.

View full article »

Learn Excel - VLOOKUP to Sum Entire Matching Row - Podcast 1971

Fabian asks if a VLOOKUP can sum all of the values in the matching row. This video looks at how to solve the problem using the "Address" version of INDEX. Also - a plug for my upcoming seminars in March 2016 in Australia and New Zealand

View full article »

Learn Excel - Stop Calculating Some Cells - Podcast #1970

Sam wants to Stop Calculating some cells in a worksheet but keep the formula there. Other cells need to keep calculating. Paste Values would cause the formula to be lost. Although that functionality is not built in, a VBA macro simulates what Sam is looking for.

View full article »

Dueling Excel 176.5 - Find First & Last

This is a follow up to yesterday's Duel 176 - with four new ways to solve the problem: Pivot table, AGGREGATE, Array Formula, MINIFS.

View full article »

Learn Excel - Increment 1-2 to 3-4 Podcast 1969

Haig wants a formula that will increment a cell with 1-2 into 3-4 and then 5-6 and so on. While the formula ends up being fairly long, it is a collection of steps to break the original cell apart and increment.

View full article »

Dueling Excel 176 - Embed a helper column in an array formula

Start with a tricky problem of how to detect the first and last events of a day. Bill uses a helper column with AND. Mike improves with a boolean multiplication, but then explains how to embed the helper column into a formula, both with and without Ctrl+Shift+Enter

View full article »

Learn Excel - Funnel Charts - Podcast 1968

Create a funnel chart in Excel 2016. This new chart type was added in February 2016 for subscribers of Office 365.

View full article »

Learn Excel - How to Get Latest Features in Office 365 - Podcast 1967

You've bought in to the subscription model of Office so you can perpetually get the latest features. Hold on a minute Sparky, it isn't that simple. This video will discuss the various versions of Office 365 and which hoops you have to jump through to get the latest bits.

View full article »