Excel TV Blog - Excel TV Updates, Tips, and Tricks

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

47: Alex Powers of ItsNotAboutTheCell.com

Excel.TV is back, baby! Stop by here at 8:00pm Eastern on Wednesday January 23rd for a LIVE episode with Alex Powers of ItsNotAboutTheCell.com. Excel.TV alumnus Oz will also be joining us for an awesome show! If you missed the glory days of Excel.TV, well, now’s your chance to join us for the fun. Be sure […]

Continue reading

46: Like A Phoenix – We’re Back

It has been almost 2 & 1/2 years since our last show.  After some turmoil and growth, we are back for Season 4. What are you gonna find in this episode? Well, Rick and I (this is Jordan typing 🙂 ) discuss changes in our lives and changes in Excel. A lot has been going […]

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

001: 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 reading

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

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

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