Jamani Arsalan, Author at Excel TV - Page 2 of 5

All posts by Jamani Arsalan

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

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

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

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

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

Dynamic Labels – Excel Dashboards Tips

Many a times we want to include chart titles in our dashboards, but we don’t since they are not dynamic. If your user changes some filters, you would want your pivot chart titles to update automatically. Well, there is a way to actually do that, to make these chart labels truly dynamic. And Excel MVP […]

Continue reading

Excel File Naming Conventions – Name Style Rules

Naming your Excel files is something which doesn’t get any coverage of any of the Excel blogs out there. And many, if not most, people do not feel that file names are something to put a thought into. But time and again we are lost looking for a spreadsheet that we really need or are […]

Continue reading
>