All posts by Jordan Goldmeier
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
15: Bill Jelen, Mr. Excel (ft. Zack Barresse)
Excel Cage Match After the kerfuffle Jordan and Bill got into over using Option Explicit (hint, hint: Bill is wrong), we decided we’d hold another cage match of sorts. Although, this time we’ve also invited heavy-hitter Zack Barresse to weigh in. Make sure to save your work before watching and close all applications–because this cage […]
Continue reading
13: Ken Puls, Excel MVP
In this episode, we interview the esteemed Ken Puls. Ken hails from Canada (the land of maple syrup and back bacon), and holds a CPA and CMA. By day, he moonlights as an Controller/IT Director for a resort in Vancouver, British Columbia. But by night, he dawns his Excel cape, and goes out to rescue […]
Continue reading
12: Oz d Du Soleil, Your Data Gaucho
The Most Interesting Spreadsheet Developer in the World This week we’re proud to interview one of own, Mr. Oz D Du Soliel–Excel philosopher, data gaucho, stand up comic, so much more. Oz might be the first ever spreadsheet philosopher. In this episode, he regales us with his background and how he came to be a […]
Continue reading