Beacon
FinRecruit
FinConsult
Future of Finance
Linkedin

Beacon FinTrain

Provides an array of professional business and financial training services that stem from improving a corporate's treasury workflow —all the way to efficient, finance training programs.

Course Overview

This workshop is your gateway to mastering the art of data visualization and creating captivating presentations. Designed to demystify the process, participants will learn fundamental concepts and gain hands-on experience with suitable tools. Through interactive sessions, attendees will explore the intricacies of data visualization, learning how to design meaningful representations of data. Moreover, the workshop will delve into the creation of interactive dynamic dashboards using Microsoft Excel, empowering participants to convey information effectively. By the end of the workshop, attendees will possess the skills and knowledge needed to craft engaging visualizations that resonate with their audience.

Learning Outcome

Format and handle large data

Use Pivot Tables and Pivot Charts

Create dynamic textboxes and charts

Use Slicers and filters

Clean up large data in no time using power query

Combine all data together from different sheets

Course Outline

  • Introduction to pivot tables
  • Pivot tables rows, columns, values, and filtersPivot tables layouts and models
  • All ways to show data on pivot tables
  • Pivot tables advanced techniques
  • Using slicers and filters
  • Concept of date drill down and grouping
  • Using group by selection technique
  • Using show value as tool
  • Add pivot charts to pivot table
  • Types of charts and the best to use.

  • More about pivot chart benefits
  • Before creating dashboards: concept and plan
  • Create your own dashboard using a pivot table and pivot chart
  • Add a touch of dynamics to your dashboard
  • Power query editor to clean up (text , number, date ) data types
  • Power query to merge data from different sheets
  • Power query to combine data from different sheets
  • Final touches on dashboards

Who Should Attend

Anyone who deals with large data daily and needs to speed up his performance=Anyone who needs to show his work on attractive visuals=Anyone who needs to create dynamic reports and dashboards