Excel TV
Share The LOVE

5 Takeaways From Our 2016 Reader Survey

This is our first year doing a reader/viewer survey.  I figured it would be important, but honestly didn’t know what to expect.  Although Excel TV Media Group, LLC is a corporation, to me it feels like my child.  I (and others) have cared for it, given it our love, attention, time and creative energy for some time […]

Continue reading

How to Change Comment Formatting – Excel VBA Coding Tips

Excel MVP Jordan is continuing the Excel VBA Coding tips. While coding comments play an important role. Comments explain what certain piece of code does so that it would be easy when you share the code with others. So, Jordan unfolds the new coding tip related to comment. He explains the feature which adds color […]

Continue reading

Legacy Excel Features – Clippy and other Excel Characters

This week’s episode is dedicated to the rarely missed, often forgotten and historically unnecessary Office Assistants! Yes, that’s right, we are talking about Clippy and its buddies. The episode will also focus on first encounters with Excel and its sweet memories. With Jordan Goldmeier facilitating the session, we have Oz du Soleil, Rick Grantham and […]

Continue reading

Using SumProduct in Inventory Management Spreadsheets

In many situations, particularly when it comes to inventory management, there is a need to do SUMPRODUCT with conditions. We can definitely implement it using many hidden calculations, but isn’t it elegance that we strive for? Join Oz du Soleil to learn about an amazing trick that will change how you think about Excel formulas. […]

Continue reading

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

Excelpalooza 5 – Sept 18-21 Discount Code – Excel TV News

Excelapalooza: User Conference and Training Event 10% Discount for Excel.TV Subscribers Earn Up to 19 CPE Credits Excelapalooza, the fifth annual Excel user conference and training event featuring Microsoft Excel Senior Program Manager Renu Devi, Bill “Mr. Excel” Jelen and L.A. “Mac” McClelland of K2 Enterprises, is offering a 10% registration discount to Excel.TV subscribers. […]

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

This Excel Keyboard Shortcut Hack – Save 10 Hrs Every Week

Imagine a situation where in you applied some border, changed font color, did something with alignment, added a background color or even added some formulas to that cell or group of cell, How to get rid of every thing that you applied to that cell. One thing which 90% of the People would do is […]

Continue reading

New Webinar Series on August 16th Presented in Partnership with PASS Excel BI VC – Register Now!

Join us on Tuesday August 16th for our upcoming webinar series with Excel TV brought to you by PASS Excel BI VC. Excel TV is partnering with the PASS Excel BI VC to bring you four back-to-back 1-hour webinars live! Learn to create outstanding spreadsheet modules, clean your data, create effective dashboards and understand how […]

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