All posts by Jordan Goldmeier
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
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
Make Your Excel Spreadsheet into a Bitmap Image With This Excel Magic Trick
Turn any image into an Excel file?Ever think about turning your face or that picture of your neighbor’s dog into an Excel file? Well, even if you haven’t, you now can! Years ago I created this little utility that can turn any image into an Excel file. Click here to download it for yourself.How do we […]
Continue reading
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
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
Excel Tutorial Concat Function in Excel with TEXTJOIN – Excel.TV Episode: 53
And we’re back…We took a brief hiatus for the holiday season here in the United States (Passover, Easter, and 4/20) but we’re back and better than ever. Say “Hello,” TEXTJOINThis week, I wanted to introduce you to my next best friend, TEXTJOIN. TEXTJOIN was added to Excel a few years back, and came about – I […]
Continue reading
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