business

Concatenated Lookup? 1171a – Learn Excel from MrExcel

               

Another look at Formula Speed in Excel: I have to do a lookup to find both a city and a day. Rather than using a concatenated lookup, two alternative formulas that perfom faster.Episode 1171 Episode 1171 shows you how. …This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download(…)

Concatenated Lookup? 1171 – Learn Excel from MrExcel

               

Another look at Formula Speed in Excel: I have to do a lookup to find both a city and a day. Rather than using a concatenated lookup, two alternative formulas that perfom faster.Episode 1170 Episode 1170 shows you how. …This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download(…)

Microsoft First? 1170 Learn Excel Podcast

               

Szilvia noted a strange anomoly in Excel 2007 pivot tables. Microsoft started appearing at the top of every customer list! Episode 1170 Episode 1170 takes a look at this mystery and the solution. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every(…)

MrExcel’s Learn Excel #977 – Filtered Paste

               

Joe asks if there is any way to do a Filtered Paste operation. I can’t figure it out, so I had to resort to a macro. Check out Episode 977 and see if you have a better way. This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new(…)

Episode 674 – Negative Invert

               

Ute from Germany sends in a better way to show negative points in a column chart in a red color. His cool trick works for Excel 97-2003. Episode 674 will show 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(…)

Learn Excel from MrExcel