MrExcel Excel Videos

Learn Excel from MrExcel - Excel tips and tricks from Bill Jelen.
MrExcel's Learn Excel #593 - Unprotect Green Cells
Today, the questioner asks how to unprotect the green cells. There isnt any good way to do this in the Excel user interface, so in Episode 593, I use a tiny bit of VBA code to achieve the effect. The code used in the podcast is: Sub UnProtectGreen For each Cell in Selection If Cell.Interior.ColorIndex = 4 then Cell.Locked = False Else Cell.Locked = True End If Next Cell End Sub This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
MrExcel's Learn Excel #592 - Missing Pivot Dates
Todays question is a follow-up to yesterdays question. How can you make sure that a pivot table shows you one row per day, even if there were no sales on a given day? Episode 592 shows two annoying solutions. If you have a better solution, please send in your ideas to bill @ MrExcel.com. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
MrExcel's Learn Excel #591 - Missing Dates
When you create a chart from data that might have missing dates, you might want Excel to plot the missing dates along the horizontal axis. In Episode 591, we take a look at why Excel sometimes chooses to use a time scale and sometimes does not. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
MrExcel's Learn Excel #590 - Rolling Charts
Say that you need to show a rolling 6 month chart. Usually, I show how to drag the blue outline around the source data. However, in todays podcast, Kirk offers an alternative tip include all of the columns in your chart and hide/unhide the columns that you want to appear in your chart. Episode 590 shows you how. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
MrExcel's Learn Excel #992 - TextBoxes 2
A second solution to Don's problem from podcast 991: add a textbox inside the cell. With a bit of formatting, the words inside the textbox will appear to float next to the number, but will not cause any subsequent formulas to incorporate the text. Episode 992 shows you how. This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
MrExcel's Learn Excel #991 - Add Text 1
Don from Europe calls with today's question: How can I add some text next to a number and still keep the number "as a number" that will flow into future formulas. Episode 991 shows you a cool trick for achieving this effect. This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
MrExcel's Learn Excel #989 - Pivot Complete Product
Rod sends in today's question. How can his pivot table indicate if ALL of the records for a certain level are marked as complete? Episode 989 will show you a use for the PRODUCT calculation in a pivot table. Also - the arcane custom number format to display positive, negative, zero values in different manners. This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
MrExcel's Learn Excel #988 - WIIW: Marker Fill
While creating a scatter chart, Don is trying to change the marker color in Excel 2007. This was relatively easy to find in Excel 2003. In Excel 2007, the equivalent dialog was split into several panes, but there is a much easier way to go. Episode 988 discusses the three charting tabs and shows you the solution. This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Forum statistics

Threads
1,225,322
Messages
6,184,277
Members
453,225
Latest member
adelphiaUK

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top