PRAYERS FOR ANDY MCADOO
Today we have a live coverage all the way from our reporter Carl Pepperseed! Let’s get to it. 1 – Background Andy McAdoo was able to combine five years’ worth of credit card statements, travel history and phone records, and merged them all in a spreadsheet. And with the support of advanced tools in Excel, […]
Continue readingUNPIVOT WITH POWER QUERY
Isn’t it just frustrating to receive a copy-paste summary table that requires analysis? Yes, we’d rather have the data source, which we can turn into a pivot table and analyze to our hearts content. Well, the world isn’t perfect, but Ken Puls has a trick up his sleeve that can potentially save us from tons […]
Continue readingSSSVEDA DAY 3 – Peek Inside My Excel Work Environment
There is always a set of problems we repeatedly run into as data analysts. We promise ourselves to fix them one day but that day never comes. Well, today might just be your lucky day. Oz is here to share with us some tips and tricks that has helped him smooth out his workflow. Let’s […]
Continue readingSSSVEDA DAY 1 – Beware of Ghost Peppers & Suspect Excel Charting
What to do when you are offered ghost peppers or Trinidad scorpion peppers? Which one would you choose? Oz is here to help us out. Let’s get started! 1 – The Evidence The chart on the right displays the Scoville Heat Units (SHU) of different peppers. Poblano isn’t even that hot. And Trinidad scorpion peppers […]
Continue readingUsing the Immediate Window – Excel VBA Tips
We all know that VBA allows us to create Macros in Microsoft Excel which does complex tasks in an easy way. You can create a Macro for tasks which you are supposed to do repeatedly. But, while writing VBA code we come across some issues or errors and finding them would be hard. So, we […]
Continue readingChandoo Excel Interview – Pointy Haired Dilbert – Chandoo.org
Purna Duggirala, or Pointy Haired Dilbert, of Chandoo.Org and StartUpDesi.com joins Excel TV host Rick Grantham and cohost Microsoft Excel MVP Jordan Goldmeier and author and Excel TV Host Oz du Soleil on Excel TV. Rick: All the way from India, welcome Purna Duggirala AKA Chandoo AKA Pointy Haired Dilbert! Chandoo, welcome to the show. […]
Continue readingKari Finn of Microsoft MVP Program
Kari Finn, Manager of Microsoft MVP program joins Excel TV host Rick Grantham and cohosts Microsoft Excel MVP Jordan Goldmeier and author and Microsoft Excel MVP Oz du Soleil on Excel TV. Rick: Kari joins us from Microsoft in Redmond. Would you mind saying hello and tell us a little bit about yourself? Kari: I […]
Continue readingHow to Create Dynamic Drop Down Lists Using Excel Tables
Updating spreadsheets can be a pain, especially when you have to change all the Data Validation dropdown menus manually. Of course, you may use a complicated mix of INDIRECT and ROW formulas to achieve a dynamic dropdown list. But there is a much better solution. And that is exactly what Zack Barresse is here to […]
Continue readingExcel Tables with Excel MVP Zack Barresse
Surprisingly, tables are the most misunderstood and, hence, underused feature of Excel. While some people confuse this feature with data tables developed by Scenario Manager, most people just plainly ignores it owing to its alien syntax. Microsoft Search Analytics revealed that less than 1% of the Excel users employ tables in their workbooks. This is […]
Continue readingHow Do Excel Gurus Solve Problems in Excel?
If we think about how Excel gurus solve problems in Excel, clearly the technical expertise comes to our minds. But that is not all there is to it. Things like communicating articulately and with confidence are also important factors. That said, there are even stranger things that might come into play, for example knowledge of […]
Continue readingPreparing for the Worst with Excel
This week’s episode is around fail-safes, that is, preparing for the worst! Of course, it might not always work out as planned. But one definitely ends up a few funny stories as a consequence. Let’s join our favorite Excel TV trio Jordan Goldmeier, Oz du Soleil, Rick Grantham and our special guest Ken Puls. Jordan […]
Continue readingContrarianism in Excel – When to Break The Rules
You need to know when to be a contrarian: someone who breaks the rules, bucks conventions and gives it to the client straight. When it comes to the field of data analytics, the motto “customer is always right” cannot be more wrong. With Szilvia Juhasz facilitating the session, we have Jordan Goldmeier, Oz du Soleil […]
Continue readingBrad Edgar – Excel Blogger & Dashboard Guru
Brad Edgar of BradEdgar.com joins Excel TV host Rick Grantham and cohosts Excel Author Szilvia Juhasz and Excel MVP and author Jordan Goldmeier to talk about Power Query and Dashboards. Rick: Welcome Brad Edgar, our special guest from Canada. Brad Edgar of BradEdgar.com where you can go to learn dashboard and dashboard products. How does […]
Continue reading
2017 – Roads? Where We’re Going We Don’t Need… Roads
Happy New Year everyone. It’s that time of year. The gyms are packed. 2016 was a good year for Excel TV. We laughed, we cried… you get the idea. But now it’s 2017, and there is a lot to look forward to this year. At Excel TV, we view this business as a labor […]
Continue reading
Excel TV 2016 Review
Howdy everybody. Happy New Year. It’s noon, so I’m awake now. 2016 was quite the transition year for Excel TV. Seems like a good time to take stock of where we are at and where we are heading. Give our readers an opportunity to help mold our direction going forward. 2016 Review Goals from Dec […]
Continue reading