General Archives - Excel TV

Category Archives for General

Excel Data Visualization: Presidential Approval Ratings with Slicers & Power Query – Chart Tricks

No matter where you fall on the political spectrum, you’ll love the chart I’ve created, which you can adapt and use in your own work. The instructions are a bit complicated, so rather than go through every element with figures, I’ve written up what I would do assuming you’re watching and following along in the […]

Continue reading

5 Questions You Must Answer Before Starting a new Excel Project

In this episode, I discuss how to scope out an Excel project based on my history as a consultant. I give you the 5 questions you must answer before starting an excel project. Before I go into that, however, I should describe why many projects fail. Projects fail because they are too narrowly focused on […]

Continue reading

Using Power Query to Connect Tables for Reporting | Excel.TV, Episode 55

An Excel Joke to Start Off…Did you hear about the database developer that walked into a bar? They saw two tables and tried to join them.  And that’s what we’re doing this week! Last week, as you might recall, I posted an overly complicated solution to this problem based on formulas.   This week, I’ve simplified it […]

Continue reading

Advanced Excel Tutorial – VLOOKUP() Speed in Excel | Excel TV, Episode 54

CORRECTIONSeveral people pushed back on the video I release this morning and I want to thank them (and in particular Wim Gielis). This caused me to open my laptop on the train while on the way to a client’s office (so I could see if I was wrong … which I was!). When I realized […]

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

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

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

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

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

2017 – Roads? Where We’re Going We Don’t Need… Roads

Happy New Year everyone.  It’s that time of year.  The gyms are packed. 2016 was a good year for Excel TV.   We laughed, we cried…  you get the idea. But now it’s 2017, and there is a lot to look forward to this year.  At Excel TV, we view this business as a labor […]

Continue reading

Excel TV 2016 Review

Howdy everybody.  Happy New Year.  It’s noon, so I’m awake now. 2016 was quite the transition year for Excel TV.  Seems like a good time to take stock of where we are at and where we are heading.  Give our readers an opportunity to help mold our direction going forward. 2016 Review Goals from Dec […]

Continue reading

5 Takeaways From Our 2016 Reader Survey

This is our first year doing a reader/viewer survey.  I figured it would be important, but honestly didn’t know what to expect.  Although Excel TV Media Group, LLC is a corporation, to me it feels like my child.  I (and others) have cared for it, given it our love, attention, time and creative energy for some time […]

Continue reading

Please Take Our 2016 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 2016 Reader Survey. Click to Launch the Survey

Continue reading

Watch Excel TV LIVE

That’s Right, LIVE. Right here. We broadcast 20 times a year, 5 times a quarter. Usually every other Tuesday night at 9:05pm Eastern time. But instead of trying to remember which week and which time… just check this page and watch it right here. Episode 31 Dick Moffat from Dick Moffat’s Spreadsheet Blog https://dmoffat.wordpress.com/ The […]

Continue reading
>