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

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 reading

NPV 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 reading

Command + 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 reading

Documenting 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 reading

Data 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 reading

Relationships 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 reading

Excel 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 reading

Power 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 reading

Excel 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 reading

Johann 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 reading

Excel 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 reading

Weird 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 reading

Index 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 reading

Tackling 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 reading

Dynamically 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
>