Free training

When: 13 July 2017, 9 am - 5 pm

Where: Comarch, München, Riesstraße 16 

Free of charge

 

 

 

Improving MS Office Skills: Dashboarding, Mailings and Animations

In this course you will learn how to create dynamic analytical dashboard in Excel.


Training content:

  • Introduction to data visualization and dashboards
  • Creating analytical dashboard in Excel
  • Creating Mailings in Word
  • Creating Animations and Transitions in PowerPoint


Download the program >

Dawid Bachorczyk

MS Office and Power BI specialist, who loves help other people. This full of energy and joyful trainer shows that Excel and Data Analysis can be fun. Experienced in working with many different groups of business user. Fascinated with Power BI and Data Analysis.

Invitation

Hi I'm Dawid Bachorczyk and I'm happy to invite you to this unique free training which will improve your work with MS Office Applications. 

In this course you will learn how to create dynamic analytical dashboard in Excel.

We'll start from scratch so you'll learn how to use Table tool in Excel to avoid basic issues with PivotTable such as "Change source data" each time you add new rows to your dataset. After this we'll create PivotTables and you'll learn not only how to work with PivotTable basics but also how to add Calculated Columns or how to create percentage columns with few clicks. Next we'll work with PivotCharts so you'll learn how to add PivotChart, how to modify it and how to avoid basic issues. After this we'll combine all PivotTables and PivotCharts with Slicers - powerful filtering tool.

Next part of this course focuses on the MS Word. Here we'll learn about Mailings. How to create them, how to connect Excel file as database, and how to print and archive these Mailings.

Last part focuses on the MS PowerPoint. In this module you will learn everything about Animations in PowerPoint. How to add them, how to add more than one Animation to object, how to work with timeline and the best part: how to create popup slide that will apear after you click an object in Slide.

Again i want to invite you to this great course. I hope that we'll meet soon on this training and i'll teach you all this fantastic features.

Cheers,
Dawid