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 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.
The post Power BI Webinar, Amsterdam & Australia tours [update time] appeared first on Chandoo.org – Learn Excel, Power BI & Charting Online.
Original source: http://feedproxy.google.com/~r/PointyHairedDilbert/~3/0mwxng_iE9Q/