Jordan Goldmeier, Author at Excel TV

All posts by Jordan Goldmeier

52: How to Create Running Totals & Rankings in Microsoft Excel Power Query

Let’s say Hi to Szilvia!This week Szilvia shows us some awesome Power Query tips in the context of something many of us do – bar trivia!  Excel.TV’s own high priestess reports from sunny, southern California, where spreadsheets are the brightest you’ve ever seen. Excel Tips & My thoughtsAs someone who is just really getting started with […]

Continue reading

Oz du Soleil…Supercut!

Excel.TV’s 50th Episode!It’s finally here! Roll out the red carpet, prep the T-shirt cannons, and turn on that fire house! BECAUSE. TODAY. EXCEL. TV. RELEASES. IT’S. 50TH. EPISODE. LOL: Last week was our 50th episode – but this feels momentous nonetheless!It’s Oz, like you’ve never seen him before!We took some of our favorite clips from the last […]

Continue reading

Budgets vs Actuals Target Chart in Microsoft Excel – Excel TV: Episode 50

In this week’s episode of Excel.TV, we show you how to build a budget vs. actuals chart. Really, though, this is what I call in my book Dashboards for Excel a performance-against-context type chart. It basically says: We have what we did against some context (in this case, a target). Take a look below. In this episode, […]

Continue reading

Dispatches from the Microsoft MVP Summit

Well, another Microsoft MVP Summit is now one-and-done. It’s my sixth year as a Microsoft MVP, and so much has changed since the first time I went back in the day. Excel 2013 was in development and many of us were still using Excel 2010! Crazy!Reflections on being in this space, and a big thank […]

Continue reading

49: How to land a data-driven role (even with a creative or nontraditional background)

IntroductionThis week, we take a departure from our normal Excel tips and focus on a more applied skill: getting a job with your Excel skills (and related data work). Most of us aren’t just Excel-ers, we’re much more: data visualizers, process improvers, etc. What we do with Excel we also apply to other code — […]

Continue reading

48: Dashboard Demo: Building your first Power BI Report

  Introduction & Updates  At Excel.TV, we’re trying something different. We want our videos to be more than just Excel tips. Instead, we want to help you excel your skills, your business and career.    That means, we’re going to focus on content that helps you do just that. So watch out, we’re going to start featuring content around:  Landing that perfect job! Today’s analysts sometimes […]

Continue reading

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

10 hours left to get My Excel Dashboard Pro Course

Hi, 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 reading

FREE 3-part Dashboard Video Series

Hi 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 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 reading

A Dashboard Video Course

Hi, 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 reading

2016 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
1 2 3 10
>