Jamani Arsalan, Author at Excel TV

All posts by Jamani Arsalan

SSSVEDA DAY 7 – Every Team Needs Someone Who Understands Data

Oz has dedicated this episode to explaining the importance of ‘understanding data’. It is different from ‘doing data’ or ‘following instructions’. Let’s get to it. 1 – What’s What Following instructions is a mindless task. And often, in face of exceptions, it is improbable the set of instructions would cover them. Doing data is about […]

Continue reading

SSSVEDA DAY 5 – When Data Analysis is Wrong

In this episode, Oz discusses the dos and don’ts of a sticky situation: when one’s data analysis is wrong! If your work involves a lot of number crunching, do read it. Let’s get started. 1 – The Situation Oz was processing commissions for some month and the numbers just looked plain wrong. He checked the […]

Continue reading

SSSVEDA DAY 4 – Sharing the Excel Knowledge

The theme of today’s episode is about finding better ways to get the job done. And nothing helps take the Excel community towards this end better than sharing of Excel knowledge. To demonstrate this, Oz will be describing one of his own experiences from the early days. Let’s get to it. 1 – Doing the […]

Continue reading


Today we have a live coverage all the way from our reporter Carl Pepperseed! Let’s get to it. 1 – Background Andy McAdoo was able to combine five years’ worth of credit card statements, travel history and phone records, and merged them all in a spreadsheet. And with the support of advanced tools in Excel, […]

Continue reading


Isn’t it just frustrating to receive a copy-paste summary table that requires analysis? Yes, we’d rather have the data source, which we can turn into a pivot table and analyze to our hearts content. Well, the world isn’t perfect, but Ken Puls has a trick up his sleeve that can potentially save us from tons […]

Continue reading

SSSVEDA DAY 3 – Peek Inside My Excel Work Environment

There is always a set of problems we repeatedly run into as data analysts. We promise ourselves to fix them one day but that day never comes. Well, today might just be your lucky day. Oz is here to share with us some tips and tricks that has helped him smooth out his workflow. Let’s […]

Continue reading

SSSVEDA DAY 1 – Beware of Ghost Peppers & Suspect Excel Charting

What to do when you are offered ghost peppers or Trinidad scorpion peppers? Which one would you choose? Oz is here to help us out. Let’s get started! 1 – The Evidence The chart on the right displays the Scoville Heat Units (SHU) of different peppers. Poblano isn’t even that hot. And Trinidad scorpion peppers […]

Continue reading

How to Create Dynamic Drop Down Lists Using Excel Tables

Updating spreadsheets can be a pain, especially when you have to change all the Data Validation dropdown menus manually. Of course, you may use a complicated mix of INDIRECT and ROW formulas to achieve a dynamic dropdown list. But there is a much better solution. And that is exactly what Zack Barresse is here to […]

Continue reading

Excel Tables with Excel MVP Zack Barresse

Surprisingly, tables are the most misunderstood and, hence, underused feature of Excel. While some people confuse this feature with data tables developed by Scenario Manager, most people just plainly ignores it owing to its alien syntax. Microsoft Search Analytics revealed that less than 1% of the Excel users employ tables in their workbooks. This is […]

Continue reading

How Do Excel Gurus Solve Problems in Excel?

If we think about how Excel gurus solve problems in Excel, clearly the technical expertise comes to our minds. But that is not all there is to it. Things like communicating articulately and with confidence are also important factors. That said, there are even stranger things that might come into play, for example knowledge of […]

Continue reading

Preparing for the Worst with Excel

This week’s episode is around fail-safes, that is, preparing for the worst! Of course, it might not always work out as planned. But one definitely ends up a few funny stories as a consequence. Let’s join our favorite Excel TV trio Jordan Goldmeier, Oz du Soleil, Rick Grantham and our special guest Ken Puls. Jordan […]

Continue reading

Contrarianism in Excel – When to Break The Rules

You need to know when to be a contrarian: someone who breaks the rules, bucks conventions and gives it to the client straight. When it comes to the field of data analytics, the motto “customer is always right” cannot be more wrong. With Szilvia Juhasz facilitating the session, we have Jordan Goldmeier, Oz du Soleil […]

Continue reading

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

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
1 2 3 5
Skip to toolbar