Getting Started with Excel

The Comprehensive Guide to the Excel Ribbon: Making the Most of Your Data

Excel is a powerful spreadsheet software that has been around for decades and is used by millions of people all over the world. It is a software that can help you organize, analyze, and present data in a way that is both visually appealing and easy to understand. However, with so many features and functions,

Read More

Creating Charts & Graphs in Excel

Edit Excel Formulas in WORD – Spreadsheet Tips and Tricks

We all use Excel Spreadsheet and Microsoft Word document every time and we use them individually. But, do you know that Word document can be helpful if you face any problem with Excel Formulas? Yes, you heard it right. You can edit Excel Formulas in Word document easily. Let us say if you have any

Read More

Season 05

51: Oz du Soleil & the Global Excel Summit 2021

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

Read More

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

Read More

Season 05

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

Read More

Season 05

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

Read More

General

All Excel LOOKUPs Explained

Excel Ultimate Lookup Guide Free Download Sorry 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

Read More

General

How to: Power Query File From Folder

Get file from Folder Get 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 More

General

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

Read More