MrExcel Excel Videos

Learn Excel from MrExcel - Excel tips and tricks from Bill Jelen.
Link Formatting - 1057 - Learn Excel from MrExcel Podcast
Carrie from yesterday's podcast called in to say that the links are not working. It turns out that Carrie and Mike wanted to copy the cell shading of the linked cell and regular links don't do that. For Episode 1057, I go back to Excel 2003 to show where the Paste Picture Link is hidden. This blog is the video 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!
Dueling: Paper/Sticker - 1055 - Learn Excel Podcast
Faizee from Youtube posts a question about looking for certain words in a cell in order to create a category. While this sounds simple, Bill and Mike manage to come up with a number of possible formulae in Episode 1055! This is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of 377 tips from the book!
Axel Font for Excel! - 1054 - Learn Excel form MrExcel
Erik Spiekerman has designed a font that is ideal for use in Excel. The Axel font is designed to be narrow yet highly readable both on screen and on paper. In Episode 1054, we will take a look at the Axel font. This blog is the video 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!
Finding Cell Styles - 1053 - Learn Excel from MrExcel
If Jerry from podcast 1052 had been using cell styles to mark his input cells, he could have used advanced options in the Find dialog to clear all of the input cells. Episode 1053 shows you how. This blog is the video 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!
Clearing Input Cells - 1052 - Learn Excel Podcast
Jerry has a model with input cells and formula cells. He wants to copy the model for next month and clear out all the input cells. Episode 1052 will show you how to clear out the numeric input cells. This blog is the video 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 #567 - Truncation Justify
Are you a fan of Edit Fill Justify? If so, watch out if you try to justify particularly long text anything over 255 characters in a cell. Excel fails miserably, and you lost part of your text, without any warning from Excel. Episode 567 shows you the details. 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!

Forum statistics

Threads
1,226,693
Messages
6,192,460
Members
453,725
Latest member
cvsdatreas

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