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.

Contact us form

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

Details

Developed by: Beacon FinTrain

Standard Total Hours: 12 Hrs

Language: English - Bilingual "English & Arabic"

Modalities: 
Register Now

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

Read More

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

Why Beacon

Quality

Beacon FinTrain prioritizes excellence in every service, ensuring top-notch, reliable, and consistent outcomes that meet and exceed client expectations.

Specialization

We focus on finance, offering expert knowledge and bespoke solutions that cater to the unique needs of finance professionals in the Middle East and Africa.

Punctuality

Time is money. We respect deadlines, delivering precise and timely results to help our clients stay ahead in the fast-paced financial world.

Guidance

Beacon FinTrain is a guiding light in finance, providing insightful advice and support to navigate the complexities of financial markets and regulations.

Integrity

We uphold the highest ethical standards, fostering trust and transparency in all our dealings to build lasting relationships with clients.

Flexibility

Adapting to the dynamic finance sector, we offer versatile services and solutions that align with the evolving needs of our clients.