Getting Started with Power BI – Sales Dashboard in one hour
Learn Power BI and create your own Sales Dashboard with this FREE Masterclass. Details inside.
Getting Started with Power Pivot & DAX – FREE Live Masterclass
Watch the replay Getting Started with Power Pivot & DAX 15 useful measures Sample files Blank data file Completed workbook What is in this event? Overview of Power Pivot & DAX 15 useful measures Data model, relationships & star schema Example file provided Your questions answered Got a question? Leave it here.
Dynamic Arrays Live Masterclass – Replay
Excel Dynamic Array functions are going to change the way to you work your data forever. Watch the replay of the event here and learn about…
* What is so different about Excel’s dynamic array functions
* The new # operator
* 6 important dynamic array functions – FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, RANDARRAY
* 25 practical examples of dynamic array functions for business analysis
* Your questions & answers
5 tips: Power Query for Accountants (and finance people) – Free Masterclass
Do you work with accounting or finance data? You are going to love, no scratch that, adore Power Query. It can save you precious time, make you look like a hero in-front of clients and keep you sane.
In this masterclass, learn all about Power Query for accountants (and other kinds of finance people) & 5 tips.
Why Power Query?
Power Query is a data processing software. Using Power Query, you can create process driven programs (queries) to collect data, clean or reshape it, calculate things and publish final output as a table. Once you create a query in PQ, when the underlying data changes, you just refresh the query and brand new data will be fetched, cleaned and published for you.
For example, you can use Power Query to combine ledger files from various accounts to one master file with Power Query. No more VBA or manual copy pasting. Just one query and you are done.
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.
Thank you, Houston meetup & Bonus tip
My mom will be very unhappy with this post. She always told me to focus on one thing at a time. But in this post we are talking about 3 things, not one. Sorry mom.
1. Thank you
I want to thank you for visiting chandoo.org & supporting us.
As I am about to leave to USA for attending Excelapalooza conference, I couldn’t help but be amazed at how much you have given me & my family. Almost 4.5 years ago, when I left my plush corporate job to work full time on Chandoo.org, I had no clue how the future will unfold. Today my heart is full of happiness, my family is secure, my site has grown by heaps and our community (especially you) is awesome.
Without your enthusiasm to learn and keen desire to become awesome, I would not have a job (of running this website). You inspire me to learn new things everyday so that I can share them with you.
Thank you for all the visits, clicks, comments, emails, tweets, likes, signups, purchases & love.
Thank you.
Become awesome in data analytics, charting & Power Pivot with Houston Masterclass [reminder]
Hello friends,
Let me stop our broadcast of Excel tips to bring an announcement.
Houston, we are going to get awesome
As you may know, I am doing 4 days of live masterclasses on Advanced Excel, Dashboards, Power Pivot & Data Analytics in Houston (Texas) this September.
- 15 & 16 September (Mon & Tue) on Advanced Excel & Dashboard Reporting
- 17 & 18 September (Wed & Thu) on Power Pivot & Data Analytics
This 4 day masterclass is aimed at managers, analysts, reporting professionals, executives in sales, marketing, customer service or anyone who wants to learn about Data Analytics, Advanced Excel, Dashboard reporting.