Chandoo.org - Learn Excel, Power BI, Charting, Dashboards and VBA online

Latest Tips & Tutorials

Power BI

Nest Egg Calculator using Power BI

Welcome to Power Mondays. Every Monday, learn all about Power BI, Power Query & Power Pivot in full length examples, videos or tips. In the first installment, let’s take a look at something we all can related to – Money.

We all know that Power BI is good for creating awesome visual experiences. Today let me share another fun way to use Power BI – to build a calculator. Learn how to create nest egg calculator in this Power BI parameter example tutorial.

Read This »

August 6, 2018

blogging

Excel School v2.0, blogging schedule, personal life – a quick update

Hi all,

Time for a personal + blog related update. Bring a cup of your favorite brew, sit back, relax and read on. Read about our 2 years in New Zealand, Excel School v2.0 and revised blogging schedule. Catch glimpses of our live in NZ too.

Read This »

August 3, 2018

profit loss statement calculations - excel pivot tables

Pivot Tables & Charts

How to get percentage of something calculations in Excel Pivot Tables

Ever wondered how to get percentage of another value in Excel pivot tables, like this: In this tip, learn how to create such calculations using

Read This »

August 1, 2018

Learn Excel

Top 5 HR Analytics Examples – Free Video Masterclass

I recently finished a long consulting gig with one of the government ministries in New Zealand. Guess what I was doing? HR Analytics and Reporting. In this post, I want to share my top 5 Excel tips for HR people, based on what I learned in the last 18 months.

Specifically, we will cover:

Gathering and structuring Employee data in Excel
- How to use Power Query to collect data
- Polish / clean data in Power Query
- Bring cleaner data to Excel as refreshable table
Answering questions about employees
- Using Excel formulas such as COUNTIFS, SUMIFS, AVERAGEIFS
- Pivot tables for data analysis
- Understanding the results quickly with conditional formatting
Understanding pay gap
- Calculating gender pay gap
- Visualize pay gap
Creating salary distribution charts
- Working with histogram charts in Excel 2016 / Office 365
- Making interactive charts
Generating letters thru mail merge
- Calculating employee bonus based on bonus mapping logic
- Creating 100s of letters with a single click using Mail Merge + Word

Sounds interesting? Read on for details.

Read This »

July 27, 2018

Excel Howtos

Calculate travel time and distance between two addresses using Excel + Maps API

Ever wanted to calculate distance using Excel – between two locations (physical addresses)? If we know the addresses, we can go to either Google Maps

Read This »

July 19, 2018

Learn Excel

Mutual Fund Portfolio Tracker using MS Excel

Would you like to spend next 5 minutes learning how to create an mutual fund tracker excel sheet?

Make a live, updatable mutual fund portfolio tracker for Indian markets to keep track of your investments using this example.

Read This »

July 6, 2018

Charts and Graphs

Play spreadsheet soccer with Excel Penalty Game [VBA]

We love spreadsheets. And of course, once every four years, we also get mad about soccer. So why not merge both of them in to one awesome, frivolous and fun thing: Introducing….

Excel soccer game

The best part is you don’t have to run up to play this. Set your aim and let RANDBETWEEN() decide your fate.

Read This »

July 4, 2018

Excel Formula How-to and examples - Free Guide

Excel Howtos

100+ Excel Formula Examples + List

The first step of getting awesome in Excel is to understand that you can ask Excel do things for you. This is done by speaking a special language called as “Excel Formulas”. When you write a formula or function, you are asking Excel to figure out something from the values you have. Say you want to add up a bunch of values in a range A1:A10, you can ask Excel to do this for you by writing =SUM(A1:A10) and bingo, you get the result immediately. The best part is, if your numbers change, the answer changes too.

If you are a beginner, the world of Excel formulas can feel overwhelming. Why not? There are hundreds of different formulas in Excel. So which formulas should you learn?

This guide gives you the answer. Here are 100+ most common Excel formula examples for every occasion. Each box describes a problem statement, an example, result, some notes and link to learn more. Use this guide to learn formulas quickly.

Read This »

June 27, 2018