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 readingUsing 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 readingHow 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 readingKeyboard 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 readingHistory 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 readingWhy 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 readingIs 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 readingGames 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 readingExcel 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 readingWhat 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 readingStupid 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 readingHow 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 readingHow 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 readingDynamic 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 readingExcel 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