Create and Publish Dashboards with Excel and Office 365

Discover the power of Excel dashboards with this training. Strengthen your business intelligence and optimize your data management.
Microsoft Partner
Private session

This training is available in a private or personalized format. It can be provided in one of our training centres or at your offices. Call one of our consultants of submit a request online.

Call now at 1 877 624.2344

  • Duration: 0.5 days
  • Regular price: On request

Course outline

Schedule : 8H30 to 12H00

Our scheduled sessions are offered in French. Private sessions are available to you in English, contact us for more info.

The Excel dashboard, easy to create if you know the right techniques, is a powerful tool that allows managers to see the information they need to make decisions.
This training was designed for anyone who wants to create dynamic, user-friendly dashboards that are accessible from everywhere, anytime even on mobile devices thanks to Office 365.
Thanks to this training, you will learn how to format and publish your data, and boost your business intelligence.

Audience

Intermediate users or anyone who has taken the “Optimize Data Analysis Using Pivot Tables and Graphs” training.

Duration

3.5 hours of theoretical presentation and demonstrations. This training may be followed by an optional practical workshop (3 hours) in the afternoon. Contact us for more information.
Versions taught

Excel 2013 | 2016 | Office 365

Objectives

Thanks to this training, you will be able to
  • create and publish efficient and visually compelling dashboards;
  • publish your dashboards in Office 365.
Contents
Using pivot tables
  • convert to a normal range and to a table range
  • use a local or shared slicer
  • use a Timeline Slicer
Using pivot graphs
  • modify the type of graph
  • use sparkline graphs
  • create and edit a graph
  • delete a graph or sparkline group
Creating a dynamic and user-friendly dashboard using dynamic graphs and tables
  • tips and tricks for creating useful dashboards
  • choose the right graphs
  • know how to avoid pitfalls
Publish a dashboard in an Office 365 library
  • save pivot tables in OneDrive, Groups, or Sharepoint
  • manage access
  • choose the navigator’s display options
  • use a pivot table online

Surround yourself with the best

Sylvain Richer
Sylvain Richer
Trainer and Desktop Application Consultant
Passionate about knowledge transfer and unparalleled in his ability to make complex information easy to understand, Sylvain is a professional efficiency trainer whose expertise is requested again and again.
Ghislain Parent
Ghislain Parent
Trainer and Professional Efficiency Consultant
With more than 25 years of experience, Ghislain thrives on the challenge of improving your work team’s efficiency.
Pierre-Edouard Brondel
Pierre-Edouard Brondel
Trainer and Desktop Application Consultant
Renowned as an educational expert in the IT and office technology field who has accumulated more than 25 years of experience, Pierre-Édouard is first and foremost passionate about human capital.
Valère Drainville
Valère Drainville
Trainer adn Expert Leader on Office 365 collaboration and efficiency
As the Expert Leader on Office 365 collaboration and efficiency, Valère Drainville specializes in helping you successfully implement and adopt Microsoft tools.