Mortgage Calculator with Extra Payments – Excel Download
Recently, we got a new mortgage. And I wanted to know the impact of “extra payments” on it. So I made an Excel calculator. Check it out ?
Learn SQL for Data Analysis in one hour
SQL is an important skill to have for people working with Data. In this article and the companion video, learn how to use SQL to perform common data tasks in under one hour. Sample files are provided.
How to create interactive tooltips in Power BI (step by step)
One of the easiest ways to impress your audience with Power BI is a tooltip. This simple idea can provide incredible value to the report readers and elevate your work to next level. In this easy tutorial, learn how to set up and work with tooltips in Power BI.
Can you split “The Hangover” expenses? [Excel Homework]
Can you split the atom? No, ok, how about splitting the expenses then?
In this homework challenge, can you take a look at the expenses of wolf-pack and tell me who owes who & how much?
What is LAMBDA? 4 Practical examples to REALLY understand it
Excel’s LAMBDA() Function let’s you create and share your own functions. It is a true game changer. Learn how to use it with 4 practical examples in this article.
FREE 2022 Calendar & Monthly Planner Printable Template
Do you want a stylish, interactive and useful monthly calendar & planner template? Then please use below link to download it. A new year gift to you from Chandoo.org ?
How to write complex Excel formulas (hint: it’s a lot like LEGO)
Writing advanced formulas is a lot like LEGO. Use what you already have and combine them in creative ways. Let me demo with 5 examples.