All posts by Jordan Goldmeier
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 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 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 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 reading
Excel Pro Tip: Creating Custom Reports with Excel Slicers
When 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 reading2016 Interactive Election Map – FREE Download
The 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 reading
Blogging Buddies: Meet Alex of “It’s not about the cell”
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 a platform to help spread their message! Below we’ve asked Alex Powers, owner of Itsnotaboutthecell.com, answer some questions […]
Continue reading
Blogging Buddies: Tristan of ExcelSide.com
As 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 reading
Making Better Spreadsheet Models
At the PASS Business Analytics Conferences, I spoke about building better Excel models. Some of this was technical, but a good portion of my advice had to do with thinking about problems differently. Indeed, I suggest we must think differently about development specifically. There were three objectives I discussed: Development Memory Model Transparency Model Efficacy […]
Continue reading
What To Look For In An Excel Developer?
I’m often asked this question, so I’ve decided to give my thoughts on the matter. Previous articles I’ve read on this question often deal with typical contracting stuff; for instance, who owns the final work? Such questions really scrape the surface of what you should look for. At a minimum, you own the client work; […]
Continue reading
What the ModelOFF competition says about the future of Excel
Back to regular life… We had such a great time at ModelOFF, it’s hard to go back to the slow pace of real life. I know that we at Excel.TV always go back to this point. But Excel is so much more than a boring software program used by boring people. Excel has a lot […]
Continue reading
ModelOFF, the day of the test!
Today is the day of the final test for the sixteen competitors. Rick took some pictures of finalists (which will be posted in a later blog post). I had a chance to view the testing space, but only for a quick moment. I can tell you: the room was mostly silent except for the quick, […]
Continue reading
Tips from my new book, Advanced Excel Essentials
In case you missed it, my new book, Advanced Excel Essentials, was released in early November. I’ve release the first chapter for free – Click here to download the first chapter! Many early readers have already provided me with positive feedback about the book. In particular, several have mentioned they enjoyed my comments on using the IF […]
Continue reading
18: MVP Summit 2014
What a Great Time! In case you missed it, the Excel.TV team made a guest appearance at the Microsoft Most Valuable Professional (MVP) Showcase. According to Microsoft, the showcase is where, “over 65 MVPs congregate in one room during the 2014 MVP Summit to share their passion, expertise and projects.” As an Excel MVP, I nominated […]
Continue reading
Info Graphics with Excel
I’m not always the biggest fan of info graphics. Many of the posters-sized info graphics released these days have issues. But lately I’ve also received several requests on how to do info graphics with Excel. Many people don’t know where to start. How Info Graphics are Different Info graphics differ somewhat from your usual dashboard-style […]
Continue reading