There are several exciting conferences and other training activities coming up in the next few months. I will be participating in the first two 2017 conferences listed below: my third Amsterdam Excel Summit, and my second tour of Australia and New Zealand.

## The Fourth Annual Amsterdam Excel Summit and Masterclass

### The Excel Data Analysis And Reporting Masterclass, April 18, 2017

Join four leading Excel experts and learn about advanced data analysis and reporting techniques. Gašper Kamenšek, Oz Du Soleil, Jon Peltier, and David Hoppe will guide you through working with data, building a model, and designing a dashboard.

### The Amsterdam Excel Summit, April 19, 2017

Several Excel experts and MVPs will present sessions on data analysis and modeling, Power Query, Power Pivot, Power BI, Excel Tables (and pivot tables and charts), and Excel extensibility (VBA, .Net, VSTO, JavaScript).

Register here for these events.

## Unlock Excel

### Powered for Accounting and Finance

For the second year in a row, the Excel MVPs tour Australia and New Zealand with a series of conferences aimed at accounting and finance professionals. Sponsored by CPA Australia, this year’s tour expands to four cities.

The experts are Liam Bastick, Roger Govier, Ingeborg Hawighorst, Jon Peltier, Ken Puls, Mynda Treacy, and Chandoo (in Auckland only). Topics include Modeling, Charts and Dashboards, Power Query, Power Pivot, Power BI, Spreadsheet Best Practices, and more. Microsoft PMs will also be present, sharing insights into new Excel developments.

Melbourne (1-2 May 2017), Brisbane (4-5 May 2017), Sydney (8-9 May) and Auckland (11-12 May 2017)

## Power BI Dashboards for Excel Users

Free Online Webinar by Mynda Treacy of MyOnlineTrainingHub

Presented on several dates: 14 February through 20 February, 2017.

Power BI is an amazing standalone dashboard tool From Microsoft. It lets you build powerful interactive dashboards and share them on any device.

Power BI plays nicely with Excel, allowing you to use Excel charts and tables, and it includes the same Power Query and Power Pivot tools available in Excel.

This webinar shows the power and benefits of Power BI while building two example dashboards. Sign up now.

## Data to Dashboards Boot Camp

Three-Day Boot Camp by Ken Puls of Excel Guru.

Hit the ground running with this intensive, three-day, hands-on boot camp covering all aspects of Power BI, including:

- Data sourcing and transformation
- Data modelling and DAX measures
- Working with data visualizations
- Publishing Power BI solutions
- Sharing dashboards with others

Vancouver BC

February 22-24 2017

*Excelguru.ca*

## Power Query Workshop

Live Online Workshop by Ken Puls and Miguel Escobar

This live online workshop covers basic and advanced topics of Power Query and the M Language to help you build your own data solutions.

- 1 Free Book (eBook version)
- 2-Day Course (4 hours each)
- 1-Q&A Session (4 hours)
- Top Quality Instructors
- 6 Hands-on Labs
- HD recordings of all sessions

March 1, 2, and 15, 2017