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

51: Oz du Soleil & the Global Excel Summit 2021

We continue with Season 05 and our continued support of the Global Excel Summit.  Oz du Soleil joins us to discuss his presentation at the Summit.  The topic for his presentation is ‘Risk Taking with Content Creation.  As you likely know, Oz has been an Excel MVP for several years and was involved as a […]

Continue reading

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

50: Randy Austin – Excel for Freelancers

Note: This was originally recorded in early 2020 and was shelved until now because the Excel Global Summit was postponed due to the global pandemic of 2020.Welcome back to Season 05.  We had the pleasure of interviewing and getting to know Randy Austin of Excel for Freelancers.   He is one of the Ambassador at the […]

Continue reading

49: Theresa Estrada – Microsoft Principal Program Manager Lead

Note: This was originally recorded in early 2020 and was shelved until now because the Excel Global Summit was postponed due to the global pandemic of 2020.Starting off Season 05 with a BANG, we bring you Theresa Estrada – Principal Program Manager Lead at Microsoft. She is one of the Keynote Speakers at the Global […]

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

How to: Power Query File From Folder

Get file from FolderGet File From Folder is what Microsoft has named the functionality that let’s you take multiple files and bring them together as one using Power Query.  Back in the day, the process to do something like this was very much VBA driven.  You would use something the File System Object to read every spreadsheet […]

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

Oz’s Excel Tip: Keep a Workbook for Random Data in Excel

IntroductionWelcome back to another episode of Excel.TV where Oz du Soleil shares his Excel tip. Here it is: always have a workbook with random data.  With this workbook, you’ll have a ready made resource to test your dashboards, workbooks, and financial models.  In this video, Oz goes through his many worksheets showing off fake data. I […]

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

Visual Analytics in Microsoft Excel Webinar: Raw and Uncut

Get the Download FilesClick here to download the files used in this webinarWhat Happened? Last week, I recorded a webinar for BhamQuants. Unfortunately, the video did not come through well on the webinar. So I rerecorded it on my own.  Unfortunately, I didn’t really have time to edit it this week. So you get to watch it […]

Continue reading

How to create a relative file path in Power Query

What do you think of the video thumbnail? I was trying to go for Excel Vaporwave.  In this blog post, we’ll talk about how to create a relative file path. I’m sharing this because it’s a common problem: the client asks me to build something, which happens on my computer, but then I need to […]

Continue reading
1 2 3 30
>