Hello, Namaste & Kia Ora. Welcome to Chandoo.org.
My name is Chandoo. My mission is to make you awesome in Excel and Power BI.
I do this by sharing Excel & Power BI tutorials, examples, tips, videos and articles on this website. I live in Wellington, New Zealand with my beautiful wife Jo & our twins Nishanth & Nakshatra. Take a minute to browse various topics of the site to see how I can help you.
Thank you and welcome.
Let’s say you manage a fund or charity. You get money from various places and you use that money for various reasons. How do you
Excel has hundreds of formulas. But as a new learner or user, you may want to just focus on top 10 formulas to get the most out of it. Assuming you already know the basics (check out Beginner Excel page if you are complete newbie), here is a list of top 10 Excel formulas for you.
If you want to tell the story of how your business / project / charity / thing is going on, then making a dashboard is the best way to go about it. Dashboards can combine heaps of data, insights and messages in to one concise format that fits on to a desktop or table or mobile screen.
But let’s be honest. Creating them in Excel is a lot of work. Even after spending hours on them, they might still look meh. So, let me share a trick to make your dashboards look snazzy (without compromising on insights per inch).
Create dashboard tiles, something like above.
Hiya folks… just a quick update on whats keeping me busy this year, with a bonus Excel tip at the end. Take a sip of your favorite brew and read on.
Work in HR and use Power BI? You are going to love this extensive, powerful and useful Employee Turnover Dashboard. In this detailed article, learn how to create your own attrition dashboard system with Power BI. Full example workbook, video and sample data included.
So you have built that excel report your boss wanted. And you were all eager to use the spreadsheet in your presentation. But in the last minute, your boss asked you to change average sales to total sales figures. You also want to grab an espresso before rushing to the meeting. Now what?
If you are new to Excel or have never used it, use below links to come up to speed.
Work with Excel a lot and know your game well? We have some very-advanced topics for you too. Check out:
Power BI is the most exciting thing to happen for your data since spreadsheets. If you are looking for a new skill to learn this year, I highly recommend Power BI. Check out below tutorials and get started today.
Learn how to work with data, make calculations, pivots, create amazing charts and powerful dashboards from scratch using Excel School + Dashboards program. Suitable for analysts, managers or professionals who need to use Excel often.
Use VBA to automate your tasks and build powerful spreadsheet based apps. In this course, learn all about how to program with VBA, how to use the language and object model to your advantage. Suitable for people who build a lot of things with Excel.
Power BI, the newest technology from Microsoft is a game changer. You can build rich, interactive and informative displays for your audience using Power BI. In this course, learn all about Power BI, Power Query and Power Pivot and how to combine them to achieve awesome results.
One email per week with Excel and Power BI goodness. Join 100,000+ others and get it free.
© 2019 All rights reserved