In today's podcast, a quick way to hide the column headers, and a row height in inches. Episode #1186 shows you how.
...This blog is the video podcast companion to the book Learn Excel 97-2007 from MrExcel.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
MrExcel Excel Videos
Learn Excel from MrExcel - Excel tips and tricks from Bill Jelen.
Create a pivot table that drives a SmartArt diagram.
...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!
Is the fill handle smart enough to fill in quarters and halves? Maybe. Maybe not.
Episode #1183 shows you why.
Also, in this episode, a challenge to users - view the podcast for details
How to visually present statistical values (+/-) in a cell
...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!
Create a dropdown that will display a different chart on your worksheet!
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!
A client wants to know how to insert checkmarks into a spreadsheet for printing only.
Check out this podcast entered into competition at: www.alphageekchallenge.com ! Click the "Vote Now" tab to view the contest entry.
Ahmed asks how to do a lookup that only looks at the text portion of the lookup value. Mike and Bill compare methods in this Dueling Excel Episode 1169.
Create 2009 Actual vs 2010 Budget in a pivot table.
Using PowerPivot for Excel 2010 to create asymmetric pivot tables.
