General Archives - Excel TV

Category Archives for General

Global Excel Summit 2021

This is not our typical Excel blog post or video.  This is a promotional video that will play at our exhibitor booth the Global Excel Summit. However, it does contain insight on what the Excel TV Academy is all about (including a coupon code).  So I thought it would be nice to share here in the […]

Continue reading

All Excel LOOKUPs Explained

Excel Ultimate Lookup Guide Free DownloadSorry about how late this post is. Some of you might’ve noticed that the video was already out. The reason is because I wrote this really, really long explanation. And, let me tell you, it was a good one. But whenever I tried to save it–it wouldn’t save! I had […]

Continue reading

2020 – I can’t wait!

Jordan here… Wow, another year of Excel.TV in the books. I have to say, of all my years working on this company, last year was perhaps the most formative. At a certain point last year I woke up and realized I needed to focus 100 percent of my energy on creating something super valuable for the Excel […]

Continue reading

Monte Carlo Simulation in Excel with a Poisson Distribution

Howdy Folks.  It’s great to be back. One of our most popular blog posts and Youtube videos (by far) is how to do Monte Carlo simulation in Excel.  In the blog post we go through a lot of detail about what Monte Carlo Simulation is.  If you are interested in reading that first, then you can […]

Continue reading

Microsoft Excel Visio Data Visualizer Add In for Excel: A Quick Guide

IntroductionI wanted to let you know about a really cool new add in for Microsoft Excel. This is one of those modern add-ins you can download from the Microsoft store. This add-in can allow you to easily create hierarchy type process maps and flow charts. The free version creates standalone type charts. The paid version, the […]

Continue reading

Global Excel Summit – Save 15% Now

I’ve received a ton of buzz over email about the Global Excel Summit! Rather than answer each individual question, I thought I’d put together this FAQ.  How do I use the coupon code Excel.TV-15% to get 15 percent off? To save 15 percent on the registration fee, do this:Go to  https://globalexcelsummit.com/#ticketsSelect the Delegate TicketFill in your personal information […]

Continue reading

See you at the Global Excel Summit!

See you in London, April 2020!I’m super excited to let you know I’ll be teaching a session at the Global Excel Summit this April in London!  The speaker lineup looks to be incredible, and includes Excel greats like: Celia Alves, Randy Austin, Boriana Petrova, Leila Gharani, Danielle Stein Fairhurst, Cristiano Galvão, Gašper Kamenšek, Michael Olafusi, Purna Duggirala, […]

Continue reading

Highlighted Timeline Chart in Excel Without VBA: Raw and Uncut

IntroductionI built a chart that let’s you highlight a series from a smaller chart (take a look at that the chart under the timeline) and show it in more detail on a larger chart. Yahoo! Finance used to have something similar, although I can’t find it anymore. But anyone who has looked up stocks online […]

Continue reading

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

Budgets vs Actuals Target Chart in Microsoft Excel – Excel TV

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

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

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

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
>