Excel TV Blog - Excel TV Updates, Tips, and Tricks
Excel TV
Share The LOVE

Protect Cells in Excel by Locking Scrollbar

We all know that for some problems, Protect Sheet tool under the REVIEW tab doesn’t cut it. Well, Jordan has found another way to restrict end-user access and it has its own advantages. Let’s get to it. 1 – The Basics – Restricting Users The way this technique works is by restricting users to a […]

Continue reading

Sorting in Excel Dashboards

We all aware of harnessing the power of VBA to dynamically sort dashboards based on user input. But is there a simpler, more elegant solution? Yes, there is. And Excel MVP Jordan Goldmeier is here to solve this mystery for us. Let’s dive in! 1 – The Excel Dashboard Data The image below shows an […]

Continue reading

Intersection Operator with Named Ranges – Excel Tips and Tricks

Hello All! We all are aware that VLOOKUP allows us to find the intersecting value of ranges or lists. It takes the value of one column and finds the corresponding value in the same row of another column. For example, VLOOKUP helps to find the telephone number of a person from the telephone directory. But, […]

Continue reading

Inquire – Workbook Analysis in Excel

Troubleshooting Excel workbooks of others can be mind-numbing, if not excruciating. There are various tools that VBA experts have developed over the years to help with this process. But there is one great tool that is rarely mentioned. Developed by Microsoft itself, INQUIRE is available in the Office Professional Plus and Office 365 Professional Plus […]

Continue reading

Remove Auto Syntax Popup – VBA Excel Coding Tips

We all love Excel and looks like there is no need any introduction for what is Visual Basic programming. As we all know VB programming allows us to automate tasks and we can do a lot more in Excel with it. But, have you observed the pop-up shown when you make any syntax error while […]

Continue reading

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
>