Power BI Webinar, Amsterdam & Australia tours [update time]

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.

Power BI Webinar on 1st of April

Put on your best PJs and get ready for some DAX on this fools day. On 1st of April, I am running a webinar on Budget vs. Actual analysis in Power BI. In this webinar, you will learn:

• How to create dimensional data model for budget & actual data
• Creating necessary measures in Power Pivot for analysis
• Visualization and exploration of trends and key information
• Closing remarks

This webinar is a run-up event for my upcoming masterclasses in Australia this year (more on this below). So if you are keen to join me in Australia (or just want to learn some cool Power BI tricks), RSVP using below link.

Power BI Webinar – Sign up here.

Amsterdam Excel Summit – May 2019

I am thrilled to be part of Amsterdam Excel Summit this May. That is right, I will speaking on Advanced Excel & Power BI topics and meeting our readers and fans in Europe very soon. I will also be presenting two pre-conference sessions on Excel & Power BI. This summit is a great opportunity to learn from Excel & Power BI Pros from all around the world, in one of the coolest cities in Europe.

I will be speaking on:

• 13th May: Business charting & Dashboards in Excel – Pre-con
• 14th May: Interactive financial reporting & forecasting in Power BI – Pre-con
• 15th May: Unusual & interesting Pivot tables – business reporting made easy
• 15th May: Elegant & Powerful dashboards in Excel in an hour

If this sounds like something you enjoy, please head over to Excel Summit – Amsterdam website and register today. Don’t forget to use your special Chandoo.org discount code – CHANDOO to get Euro 50 discount.

Click here for Amsterdam Excel Summit information.

Excel & Power BI Masterclasses in Australia – June 2019

Soon after returning from Amsterdam, I will be hopping over ditch to Australia to run two-day masterclasses on Advanced Excel and Power BI. In these masterclasses, you will learn how to create dashboards, advanced analytics and reporting using either Excel or Power BI. You will also learn modern, in-demand skills like Power Query, Power Pivot, Data modeling and report design. These classes are intense, hands-on and interactive. I am running these with Plum Solutions Australia.

This year’s dates are:

Advanced Excel & Dashboard classes:

• 4-5 June 2019: Melbourne
• 10-11 June: Brisbane
• 17-18 June: Perth
• 24-25 June: Sydney

Power BI, Power Query & Power Pivot classes:

• 6-7 June 2019: Melbourne
• 12-13 June: Brisbane
• 19-20 June: Perth
• 26-27 June: Sydney

Sounds exciting? Then head over to our Australian Masterclass page for more information and enrollment process.

Click here for information & enrollment details – Australia classes – 2019

This will be my fourth such tour to Australia. My first trip was in 2012. I am just as excited about this as I was 7 years ago. Every time I go to Australia, I am amazed the kindness and enthusiasm of people who attend my classes or meet me after. Thank you for all the beautiful memories. I hope to help you learn and unlock new skills this year too.

Bonus Excel Tip: Check if a range has any 0s with AND() formula

This one is simple, but elegant. If you want to check a range of values has any ZEROs, you can use =AND(range). While AND() is a boolean function, since Excel treats 0 as FALSE, the AND() result will be FALSE if your range has 0, and TRUE otherwise. See this illustration.

Thank you…

Thank you so much for all that you do to support Chandoo.org. Everytime you visit my site or social media channels and learn, you make me happy. I am really glad I could help you become a master of your trade. More power & awesomeness to YOU.

Hello Awesome...

My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.

I hope you enjoyed this article. Visit Excel for Beginner or Advanced Excel pages to learn more or join my online video class to master Excel.

Thank you and see you around.