top of page

Data Analysis & Visualization with Excel

Data Analysis & Visualization with Excel (2 Days)


Service Description

Day 1: Data Analysis with Excel Morning: Introduction and Basic Data Analysis Introduction to Data Analysis in Excel Overview of Excel’s data analysis capabilities Key features for data analysis Data Import and Preparation Importing data from various sources (e.g., CSV, databases) Data cleaning and formatting Handling missing or inconsistent data Basic Data Analysis Techniques Using functions: SUM, AVERAGE, COUNT, MIN, MAX Sorting and filtering data Applying conditional formatting Afternoon: Intermediate Data Analysis Using Pivot Tables for Data Analysis Creating and customizing Pivot Tables Grouping and summarizing data Applying filters and slicers Advanced Formulas and Functions Introduction to advanced functions: VLOOKUP, HLOOKUP, INDEX, MATCH Using logical functions: IF, AND, OR Date and time functions Hands-On Lab Exercises on data import, cleaning, and basic analysis Creating and analyzing Pivot Tables Using advanced formulas in practice Day 2: Data Visualization with Excel Morning: Introduction to Visualization Overview of Excel’s Visualization Tools Types of charts and their uses Choosing the right chart for your data Creating Basic Charts Creating and formatting common charts: Column, Bar, Line, Pie Customizing chart elements: titles, labels, legends Advanced Charting Techniques Using combo charts and secondary axes Creating and formatting scatter plots and histograms Adding trendlines and error bars Afternoon: Interactive Dashboards and Advanced Visualization Creating Interactive Dashboards Combining multiple charts and Pivot Tables into a dashboard Adding slicers and interactive controls Advanced Visualization Techniques Using conditional formatting with charts Creating sparklines and heat maps Working with data bars and color scales Hands-On Lab Building and customizing various types of charts Creating an interactive dashboard with multiple visual elements Applying advanced visualization techniques to real-world data Conclusion and Q&A Review of Key Concepts Summary of data analysis and visualization techniques covered Q&A Session Addressing any remaining questions or clarifications


Upcoming Sessions


Contact Details

4313388726

BenninkTraining@shaw.ca

Winnipeg, MB, Canada


Get In Touch

Bennink Training

Winnipeg, Manitoba
Phone: (431) 338-8726

Email: BenninkTraining@shaw.ca

  • Facebook
  • Twitter
  • Instagram
  • YouTube

© 2024 Bennink Training. All Rights Reserved.

We've Received Your Message!

bottom of page