2010

Linking Tables with PowerPivot – Podcast #1221

               

If you have data in Excel and want to get that data into PowerPivot, you could copy and paste, or you can use the method in this video [Episode #1221]; declare the data as a table, then create a Linked Table. …This episode is the video podcast companion to the book, “PowerPivot For The Data Analyst:(…)

Excel In Depth: Paste Options Flyout – Podcast #1220

               

One of the best features in Office 2010 is the new Paste Options flyout menu. Episode #1220 takes a look at how to leverage the Paste Options menu. …This episode is the video podcast companion to the book, “Excel 2010 In Depth”, by Bill Jelen a.k.a. MrExcel.

VBA & Macros 2010: Never AutoSum – Podcast #1219

               

When you are recording a macro, never use the AutoSum button. Episode #1219 will show you the workaround to summing a column in a macro. …This episode is the video podcast companion to the book, “VBA And Macros: Microsoft Excel 2010“, from Bill Jelen a.k.a. MrExcel.

Excel In Depth – Morphing Ribbon #1218

               

As you start to use the Excel 2010 ribbon, you will notice that it has a different arrangement of icons depending on the resolution of your monitor. This can lead to some confusion as you try to help your coworkers over the phone, as Episode #1218 shows you. …This episode is the video podcast companion(…)

2010 Exit Excel – 1089 – Learn Excel from MrExcel

               

It became harder to exit Excel starting in Excel 2007. Episode 1089 takes a look at how to exit Excel 2010. 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!

Learn Excel from MrExcel