002: How To Make Excel Faster
How to Make Excel Faster Friday Fire is back with an all new episode on how to speed up things in Excel. I present two ways to make things faster: Replace repetitive volatile formulas (like NOW, RAND, etc) with a named range where only one volatile formula resides. Root out spreadsheet errors and handle them […]
Continue reading001: Build a Map in Excel with Conditional Formatting
Welcome to Friday Fire Hi everyone! After some hiatus, Excel.TV is back and ready to begin sharing to our community like never before. We’ll be doing that with all my new series, Friday Fire. It’s designed to help you end the week on a high note, with tips, tricks, comedy, interviews and more. But the […]
Continue reading
4 Takeaways From Our 2017 Reader Survey
This is our second year doing our reader survey. Late in 2017 we asked you about what you liked and didn’t like. In short, we wanted to understand the demographics of our audience so that we create content and products that are aligned with what you expect when you come to a website named “Excel […]
Continue readingSSSVEDA DAY 7 – Every Team Needs Someone Who Understands Data
Oz has dedicated this episode to explaining the importance of ‘understanding data’. It is different from ‘doing data’ or ‘following instructions’. Let’s get to it. 1 – What’s What Following instructions is a mindless task. And often, in face of exceptions, it is improbable the set of instructions would cover them. Doing data is about […]
Continue reading
Please Take Our 2017 Reader/Viewer Survey
We want to make our blog better and more relevant to your needs and interests. To do that, I need to know more about YOU. As a result, we have created the 2017 Reader Survey. Click to Launch the Survey
Continue reading
The Crown Jewel: What You Can Do With The Craft Keyboard, Part 3
As you know, Excel.TV has partnered with Logitech to let you know all about their awesome new CRAFT Keyboard. Want to learn how to get one for FREE? Sign up to our newsletter to find out more. Logitech gave us several keyboards to give away. We’re looking into contests and other ideas to give them to you! […]
Continue readingSSSVEDA DAY 5 – When Data Analysis is Wrong
In this episode, Oz discusses the dos and don’ts of a sticky situation: when one’s data analysis is wrong! If your work involves a lot of number crunching, do read it. Let’s get started. 1 – The Situation Oz was processing commissions for some month and the numbers just looked plain wrong. He checked the […]
Continue reading
Logitech CRAFT Keyboard Review Part 2: A tool for Excel Creators
Hi there, it’s Jordan — back again to talk about the Logitech CRAFT keyboard, the newest productivity keyboard from Logitech. In my last review, we went over the keyboard as whole. And, I’ve talked about how you can even get your hands on one for FREE. Sign up to our newsletter to find out more. […]
Continue readingJon Acampora of ExcelCampus.com
Rick: Next up is our special guest Jon Acampora. You may remember Zack Barresse mentioning Excel MVP John Acampora of ExcelCampus.com. Jon, say hello and tell us what ExcelCampus is about? Jon: Hello and thank you for having me. ExcelCampus is a blog that is about learning how to use Excel and saving time with […]
Continue readingNick Green of EchoXL.com
Nick Green of EchoXL.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 discussing the development and release of his Excel forecasting tool at EchoXL.com. Rick: Our special guest is Nick Green from Columbia by way of Australia. Welcome […]
Continue reading
Introducing the CRAFT keyboard, a new way of working in Excel!
Hello Excel.TV fans! As you know, Rick and I have been working super hard on developing awesome new training courses for you. At the same time, I’ve also been working on something secret—and I’d love to let you in on it now that I’m allowed. Excel.TV and Logitech have been working together on something exciting! […]
Continue readingKen Puls of ExcelGuru.ca
Rick: Welcome to our special guest straight out of Canada, Mr. Ken Puls of excelGuru.ca. I first became aware of Ken a year and a half ago when I was stalking his Twitter feed and Facebook page. He was about to get 100 Facebook page likes and he said whoever is my hundredth like I […]
Continue readingSSSVEDA DAY 4 – Sharing the Excel Knowledge
The theme of today’s episode is about finding better ways to get the job done. And nothing helps take the Excel community towards this end better than sharing of Excel knowledge. To demonstrate this, Oz will be describing one of his own experiences from the early days. Let’s get to it. 1 – Doing the […]
Continue readingPRAYERS 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 reading