All posts by Jamani Arsalan
How to Deliver Excel Training
This episode is around discussing tips on delivering Excel training. In our panel of experts we have Oz du Soleil, Jordan Goldmeier and Rick Grantham. And they are joined by our special guest Keidra Chaney. Keidra has 7 years of experience training people in Analytics at various levels. Let’s get on with it! 1 – […]
Continue readingNPV Calculator and IRR Formula in Excel
Excel makes it possible for simple buy / not-buy or do / not-do financial decisions very easy to arrive at. The underpinning concept behind making such decisions is that a dollar tomorrow is worth lesser than a dollar today. That’s right, it’s because of the additional return you can get by “investing” a dollar today. […]
Continue readingCommand + T To Cycle Through Excel Cell References On A Mac
As frequent Excel users, we know the importance of absolute and relative references. On Windows operating system, one can use the F4 key to turn cycle through absolute and relative references, and everything in between. But there are a lot of users who use Excel on MAC and are clueless about how to access the […]
Continue readingDocumenting Complex Excel Formulas with Mike “ExcelIsFun” Girvin
As Excel experts, we are constantly in need of using complex formulas to get tasks done faster and elegantly. But this can prove to be troublesome for the users if they want to understand the formulas or change something in them. One solution is to use comments extensively, but they can become messy really quickly. […]
Continue readingData Validation with Wingdings
Did you know you can indicate whether the user of your file is putting in the right information or not? And that too without using ‘Data Validation’ tool or ‘Conditional Formatting’? Sounds unbelievable, but it could definitely be done. And the advantages are straight-forward as well. Firstly, you do not have to use volatile conditional […]
Continue readingRelationships Between Linked Tables in Excel
Microsoft launched PowerPivot as a separate add-in for Excel 2010. And since then it has become an integral part of any data analyst’s toolkit. The immense “power” of this tool comes from the fact that it can aggregate data from related but distinct tables into one pivot table. Don’t worry if you’re slightly confused, Oz […]
Continue readingExcel MVP Program – Excel Community Involvement
This episode sheds light on why people do or should get involved with Excel’s online communities and what has Microsoft’s MVP program achieved. Our special guest for this episode is Kari Finn, Manager of MVP Community at Microsoft. What are we waiting for? 1 – Sharing Excel Expertise Online Being good at a particular technology […]
Continue readingPower Query Book Author Ken Puls – Excel Expert Interviews
This week’s special guest is Ken Puls. He’s a Certified Management Accountant who also runs ExcelGuru.ca. His recent accomplishments include a book on Power Query titled “M is for (Data) Monkey” and a video training endeavor “Power Query Training” which offers an online workshop for first-time Excel users and a digital version of the book. […]
Continue readingExcel Book Author Oz du Soleil – Excel Expert Interviews
This episode’s special guest is an Excel expert, consultant, blogger and book author. Yes, our very own Oz du Soleil. He discusses the progress on a book he’s writing on Excel and his upcoming online show on Excel. So, let’s get to it! 1 – Full Contact Data Management You guessed it right! His new […]
Continue readingJohann Odou, CoFounder of ModelOFF
ModelOFF is a, annual, two-hour, online contest in which thousands of people from over hundred countries compete. As you might have guessed it, the contest aims to square off Excel and Finance geeks in a bid to find the best, or the smartest, financial modeler. In the video below Johann describes some very interesting aspects […]
Continue readingExcel Requirements Gathering Process – Excel Dashboards
Excel consultants know that requirements gathering exercises can look deceptively simple. Whether that be for creating a dashboard for the client or an Excel application, there is always something in hindsight that one could have done better. Let’s not depend solely on our own mistakes to become better Excel consultants. Our in-house team of Excel […]
Continue readingWeird Things You Can Do In Excel
Excel is a data analysis and visualization tool. But is this all there is to Excel? We will let our in-house experts, accompanied by Excel MVP Mynda Treacy, answer this question for you. So, let’s begin. 1 – 3D Excel Reports Spreadsheets allows users to visualize data in 2D as arrays. But, it turns out, […]
Continue readingIndex Function In Excel To Move Columnar Lists To A Grid
Sometimes we have analyze or sort through data all of which is in a single column. The problem occurs when not every entry in that column represents the same type of data. For example, you might have names, addresses, email IDs and so on, all in just one column. It is really difficult to analyze […]
Continue readingTackling Complex Formulas in Excel
When dealing with a small but complex set of calculations, it is very tempting for many of us to put long, complex formulas in a few cells. Or sometimes, as Excel experts, we would be asked to find calculation errors in such situations. Of course, who wouldn’t like to have neat-looking workbooks? But there is […]
Continue readingDynamically Select Different Chart Types – Excel Dashboard Tips
Most of us employ Excel to analyze data in search of some insights. For us, this is an enjoyable step. The not-so-pleasing step is the one that follows data exploration: presenting our findings. It is not an easy job to decide which chart-type will depict our analysis in the best possible way to the end […]
Continue reading