Video Archives - Page 3 of 13 - Excel TV

Archive Blog Archives

2016 Interactive Election Map – FREE Download

The 2016 Presidential Election Map is Now Available This was first created 4 years ago during the 2012 presidential election cycle and takes advantage of the “Hover Over” method.  The Map has been updated and is now available as a FREE Download here on Excel TV.  Click the button below to download the file. Once […]

Continue reading

How Personal Experience Impacts Excel Development

How a person approaches Excel project work is heavily ingrained in his or her personal experiences and life lessons. To start a discussion on such a unique topic, we have Jordan Goldmeier facilitating the session. Also, our in-house experts Oz du Soleil and Rick Grantham are also on the panel. Let’s get into it! 1 […]

Continue reading

Keyboard Shortcuts in Excel

Keyboard shortcuts, quite surprisingly, are a blessing and a menace at the same time. On one hand, when they become second nature, they are bound to improve your efficiency dramatically. On the other, shortcuts can disrupt learning during workshops and webinars. Jordan shares a funny perspective on this topic. Sometimes, when presenting in a workshop […]

Continue reading

How to Change Excel Serial Date Format Using Text to Columns

Microsoft Excel allows us to show any complex data in an easy way. You could only see some format changes when you extract the data from the database. For example, say you have the data related to employee related to joining date. Then, when you extract this data from the database, then you would see […]

Continue reading

History of Excel – Spreadsheets & Visicalc

It all started in 1978-79 with the introduction of VisiCalc. Or did it? It’s about time to revisit history and we have Szilvia Juhasz leading the way. Also featuring in the episode are our very own experts: Oz du Soleil and Rick Grantham. Chandoo.org has a brief and clear visualization of a Microsoft Excel’s entire […]

Continue reading

Excel Course Development – John Michaloudis of MyExcelOnline.com

John Michaloudis of MyExcelOnline.com joins Excel TV host Rick Grantham and cohost Microsoft Excel MVP Jordan Goldmeier and author and Guest Excel TV Host Oz du Soleil on Excel TV. Rick: Welcome to our favorite Aussie by way of Spain. Tell us about your website MyExcelOnline.com. John: My website has pretty much everything. It has […]

Continue reading

Why Is Excel Still Relevant? How Is Excel Still Dominant?

It has been 30 years since Excel’s initial release, yet it is still relevant, it is still dominant. In this week’s topic, we discuss the reasons behind this and a lot more. Facilitated by Jordan Goldmeier, we have Oz du Soleil and Rick Grantham on our panel joined by our special guests Johann Odou and […]

Continue reading

Is There An Analytics Talent Gap?

Analytics Landscape Even though the Analytics landscape is growing increasingly complex, imagining a future of Excel that is very different from the present still seems difficult. With tools like PowerPivot, would VLOOKUP finally be rendered obsolete? And if so, who will claim the “spreadsheet” throne? There’s just too many unanswered questions. With Szilvia Juhasz facilitating […]

Continue reading

Games in Excel and In Excel Training – Gamification with Spreadsheets

For all the gaming aficionados out there, this week’s topic will surely hit it out of the park. Together with Jordan Goldmeier, Rick Grantham, Oz du Soleil and our special guest Cary Walking (creator of Arena.Xlsm), we will explore quite a few interesting themes. From learning Excel through developing games to using games while delivering […]

Continue reading

Customize Excel Ribbon – Change Case of Text

We all know that Excel Ribbon has tabs like Home, Data, review, Insert and many more. This allows us to perform some tasks like formatting the text, inserting bullets and more. Without this Excel ribbon nothing can be done. But, if you observe it, text on all tabs of ribbon is in camel case. Do you […]

Continue reading

Excel for iPad

With the introduction of Excel for iPad, the obvious question that comes to mind is around usability. But a lot more important topics also surface up in the background. And that is exactly the topic for today’s discussion. Let’s join Jordan Goldmeier, Oz du Soleil, Rick Grantham and our special guest Bill Jelen to see […]

Continue reading

What Is Modern Excel?

We all know that Modern Excel is impacting our everyday lives. But the question is, five or ten years from now, would we be doing the same things but better? Or would the landscape have changed dramatically? Jordan Goldmeier is here to facilitate the discussion over this theme in the presence of our in-house experts […]

Continue reading

Stupid Excel Stories

What is the stupidest thing you have ever done in Excel? Our Excel experts are here to share their own stories. Facilitated by Jordan Goldmeier, we have Oz du Soleil, Rick Grantham and our special guest Jon Peltier on the panel. What are we waiting for? 1 – Jordan Jordan shared had a bunch of […]

Continue reading

How To Start An Excel Podcast

Welcome to Excel Podcast 101! In this week’s episode we will cover everything you need to know to get started with your own Excel podcast. Facilitated by Rick Grantham, we have Oz du Soleil, Jordan Goldmeier and our special guest John Michaloudis (from MyExcelOnline) on the panel. Let the learning begin! 1 – Why do […]

Continue reading

How To Fix Ugly Political Dashboards

It’s time to be brutal! And political-themed dashboards will take the brunt of it. With Szilvia facilitating the session, Jordan, Rick and our special guest Brad Edgar discuss the merits of various dashboard designs. Let’s get started! 1 – Readability Issues It’s easy to get carried away when it comes to designing dashboards. And this […]

Continue reading
>