MrExcel Excel Videos

There are a couple of obscure functions in the analysis toolpak that will allow you to calculate how many workdays have elapsed. Enter a hire date and today's date, and you can calculate the number of workdays. This function even allows for you to enter a range of company holidays which are factored into the calculation. Episode 399 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!

The only toolbar that is easy to customize in Excel 2007 is the QAT or Quick Access Toolbar. Episode 398 shows you how to customize the QAT with your favorite icons. This blog is the video netcast companion to the upcoming book, Excel 2007 Miracles Made Easy. Download a new two minute video every Tuesday and Thursday to learn one of the tips from the book!

A much better way of showing leading zeroes. After episode 392, several listeners called in with a better better way to show leading zeroes for any number of characters. Episode 397 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!

A look at Excel 2007 data bars and color scale features. These new features allow you to quickly see the largest/smallest values in a sea of numbers. Episode 396 shows you how. This blog is the video netcast companion to the upcoming book, Excel 2007 Miracles Made Easy. Download a new two minute video every Tuesday and Thursday to learn one of the tips from the book!

In today's episode a caller asks how to split names that are in one cell into first name in column A and last name in column B. Episode 395 shows how to do this trick, but then the annoying gotcha that will happen for the rest of the day. 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!

Today's tip comes from Dave in Columbus, Indiana. Dave was at my Power Excel seminar last week and passed along a better way to invoke the Paste Special Values command. In the process of showing Dave's trick, I also talk about joining text using the concatenation operator, changing text from upper case to proper case, copying a formula by double-clicking the fill handle, using Ctrl z to undo. Episode 394 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!

It's another Excel 2007 Thursday. I'll take a look at how your old Excel 2003 shortcut keys continue to work in Excel 2007. Episode 393 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!

Have you ever tried to enter an ID number that starts with zeroes? Excel automatically removes the leading zeroes, making it impossible for your VLOOKUPs to work. Rather than resorting to using a Zip Code format, try one of the tricks in Episode 392 to make Excel keep the leading zeroes. 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!

Starting on Tuesdays and Thursdays, I will be taking a look at the new features in Excel 2007. Today, an introduction to the ribbon and the options to minimize the ribbon. Episode 391 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!