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:(…)
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.
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.
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(…)
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!