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 readingAs 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 readingHi 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 readingHello 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 readingHi, all. I was debating doing a post on this, but the books say to do it–so I will! (Who am I to second guess the wisdom of online marketing eBooks?) Hopefully, many of you have already signed for my free 3-part video series. (Once you put in your email, you’ll be emailed a page with the […]
Continue readingHi there, friends. In celebration of my new course for Excel.TV, I’ve released a free 3-part video series around building dashboards. The videos are as follows: Awesome Benefits of Building Dashboards With Excel 5 Rookie Dashboard Mistakes That Even the Experts Miss Excel Dashboard Questions Answered All you need to do is go to excel.tv/training/ […]
Continue readingWhen I teach how to develop dashboards in Excel, I’m often asked if the same visualizations and interactivity can be recreated for PowerPoint. My answer is always the same: use Excel as your PowerPoint (why? because the answer is also no). In other words, rather than pasting reports onto slides, use the spreadsheet instead as […]
Continue readingHi, there! Long time no see, am I right? Well, most of you have realized that my major focus this last year or so has been developing Excel.TV. And boy, what a I ride it’s been. Excel.TV now boasts tons of content. And, for the first time ever, I’m proud to introduce my first video […]
Continue readingThe 2016 Presidential Election Map is Now Available This was first created 4 years ago during the 2012 presidential election cycle and takes advantage of the “Hover Over” method. The Map has been updated and is now available as a FREE Download here on Excel TV. Click the button below to download the file. Once […]
Continue readingWritten by Bjoern Stiel APIs are the lifeblood of the internet, providing access to bits and bytes that make our personal and professional worlds work. For example, Quandl provide a vast amount of financial and economic data through their API, while GitHub and StackOverflow let you pull out all sort of user and repo data through their API. But how do we communicate […]
Continue readingEach month, we’ll introduce you to up-and-coming and new-to-the-scene Excel and data analysis blogs. We know how hard it’s to start a new blog, particularly in this space. So with this series, we want to give new bloggers a platform to help spread their message! Below we’ve asked Alex Powers, owner of Itsnotaboutthecell.com, answer some questions […]
Continue readingAs we kickoff this new year of Excel.TV, we’re proud to pioneer the new series, Blogging Buddies. Each month, we’ll introduce you to up-and-coming and new-to-the-scene Excel and data analysis blogs. We know how hard it’s to start a new blog, particularly in this space. So with this series, we want to give new bloggers […]
Continue readingI recently contributed to the article on MRC’s Cup of Joe Blog called 7 harmful business dashboard mistakes. I’ll excerpt a version of what I said below, but you should follow the link to read the whole thing. (I’ll use the original version I sent to blog so as not to compete for search keys.) I’ll […]
Continue readingOK, so I know a few days ago I said I had written my last blog posted before the end of the holiday. But then I’ve released holiday cards in both 2013 and 2014, so this year should be no different. So I went with a topical Star Wars theme. The text being shown is […]
Continue readingEDIT: Unfortunately, the deal has ended. I’m writing this from my car on my way to visit family so forgive the brevity and potential spelling errors. Thanks to fellow Apress author, Debra of Contextures.com, for letting me know! You can get my first book in ebook/pdf format for $10.00. Follow this link to get your […]
Continue reading