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(…)
In Chapter 2 of “PowerPivot For The Data Analyst”, you will see how to import a 1.8 million row text file into the PowerPivot window. Podcast 1216 reveals the power of Microsoft’s PowerPivot in conjunction with Excel. …This episode is the video podcast companion to the book, “PowerPivot For The Data Analyst: Microsoft Excel 2010“, from Bill(…)
Couldn’t make it to one of Bill Jelen’s [a.k.a. ‘MrExcel’s’] live Excel seminars? Do you really want to learn Microsoft Excel from, “…the most experienced Excel Trainer on the planet”? Then Live Lessons with Bill Jelen is the tool for you! View The Live Lessons Selection by Clicking Here!
Learn about the changes to and capabilities of Microsoft Excel 2010 and learn more about the new book, “Microsoft Excel 2010 – In Depth” by Bill Jelen a.k.a. ‘MrExcel’! Microsoft Excel 2010: In-Depth by Bill Jelen – Paperback: 1008 Pages Excel 2010 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone who wants to streamline their work(…)