- You are here:
- Home »
- Blog »
- Excel Tips & Tricks
Category Archives for Excel TV Seasons
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
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
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
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
45: Kasper Langmann – Spreadsheeto.com
Kasper Langmann – Spreadsheeto.com Kasper Langmann of Spreadsheeto.com joined the Excel TV crew for Episode 45 on Wednesday July 27th at 9:05 pm Eastern. The panel discussed the pros and cons of formal (collegiate) Excel education vs learning Excel on the job. The group discussed how they learned Excel. There was some discussion of this episode with George […]
Continue reading
44: Danielle Stein Fairhurst – Financial Modelling in Excel
Danielle Stein Fairhurst – Financial Modelling in Excel Specialist Danielle started out in Investment Banking during the London boom-time of the ‘90s and has been using Excel ever since! As Principal Consultant of Plum Solutions, she is regularly engaged as a speaker, course facilitator, financial modeling consultant and analyst. She runs many training seminars around […]
Continue reading
43: George Mount – Economics & Business Analytics Blogger
George Mount joined us Tuesday April 19, 2016. George runs the Economics & Business Analytics website GeorgeJMount.com George’s blog at georgejmount.com is a resource for analysts wanting to advance through Microsoft Excel and business analytics. The site logs everything he’s learned after years of experience to help those beginning to use data for business analysis, […]
Continue reading
42: Brad Edgar – Excel Dashboard Expert at BradEdgar.com
Brad Edgar joined us on Tuesday March 15 at 9:05pm Eastern. Brad runs the Excel Dashboard website Brad Edgar.com How Brad Got Started Brad’s experience with Excel dashboards started out from the more technical end as he started his career implementing ERP systems and developing short database queries to gather, collect and update data for his […]
Continue reading
41: John Michaloudis – Excel Trainer at MyExcelOnline.com
The show aired Tuesday February 15 at 7:05pm Eastern. We were joined by John Michaloudis. John runs the Excel training website myExcelOnline.com John also runs a very successful Excel Podcast where he interviews Excel Bloggers, Authors and Trainers. Podcast? Courses? If you are sitting in a desk right now. Working for “The Man” and you […]
Continue reading
40: Ginger Grant – Power BI Blogger, Trainer and Speaker
Ginger Grant joined the show on January 19th, 2016 at 9:05pm Eastern. Ginger is an Excel Trainer, blogger and conference speaker focusing on Power BI and all the Power Excel Tools. Check out her blog, Desert Isle SQL Have you been curious about Power BI? Want to learn more? Then join at 9:05pm Eastern on […]
Continue reading
39: Power Query Book Author Ken Puls
Excel MVP, Blogger and Author Ken Puls Ken originally appeared on Excel TV during Season 1 where we discussed training methods for Excel teachers. Ken is the host at http://ExcelGuru.ca The site is popular for the Excel Guru forum as well as Ken blog posts. Most recently, Ken’s posts have focused on Power Query This brings us […]
Continue reading