WIIW - Classic Pivot Layout - 1058 - Learn Excel from MrExcel Podcast

Michael sends in a great tip today about pivot tables. While Excel 2007 replaced the drag and drop feature with drop zones, there is an obscure setting in Excel 2007 that will let you go back to the old drag and drop method. Episode 1058 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!

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!

MrExcel's Learn Excel #983 - WIIW: Time

Bill from Washington asks how to track vacation time, specifically times greater than 24 hours and times less than 0 hours. This requires two different tricks. Episode 983 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 - WIIW #978 - Comment Shape

Cullen sends in today's Where Is It Wednesday question: how can you change the comment shape in Excel 2007? This was a cool feature in Excel 2003, we just can't find it anymore. Episode 978 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!

Episode 911 - WIIW - Equals

Where is it Wednesday? A person in one of my seminars asked me about a feature missing from Excel 2007. While the feature sounded familiar, it was also missing from Excel 2003. In Episode 911, we will take a look at a faster way to start a formula using the mouse.

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!

Episode 863 - WIIW - Protect Sheet

Where is it Wednesday: Where did they move Tools, Protection, Protect Sheet? In Episode 863, I will show you how to protect only the formula cells in Excel 2007. While this was complicated in Excel 2003, it is just a bit more complicated in Excel 2007 when you can't find the final command, Protect Sheet.

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!

Episode 833 - Close Excel

Back in the good old Excel, you could click the upper "X" in the top right corner to close Excel. Well...that does not work anymore - both of the "X"s will close the workbook. In Episode 833, I will show you the quick way to close out of Excel. (Maybe you work at a dot-com, and your manager would be upset if you were doing spreadsheets instead of playing solitaire?)

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!

Episode 828 - 2007 Macros

So, you upgrade to Excel 2007 and your macros stop working. If you are incredibly lucky, it might be a situation where the macro would work, but you need to enable macros. Episode 828 shows where Microsoft hid Macro Security options and what the new words actually mean.

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!

Episode 808 - Where are macros?

In our second Where is it Wednesday episode, we take a look at how to unlock all of the macro functionality in Excel 2007. Episode 808 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!

Episode 803 - Move or Copy Sheet

In our first Where's it Wednesday segment, I tried to figure out where the popular Move or Copy Sheet command is hidden in Excel 2007. Check out the cool new Wednesday theme from George Wood in Episode 803!

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!