Data Analysis using Excel

Learn valuable insights and strategies from industry experts.

  • Expert-led Training
  • Industry Best Practices
  • Practical Implementation
  • Real-world Scenarios
Josh Valdeleon

Speaker: Josh Valdeleon

Download Brochure Set Reminder
Software Webinar Image
Date
20 May, 2026 (Wednesday)
Time
10:00 AM PDT | 01:00 PM EDT
Duration
60 Minutes

Overview

Learn how to turn raw data into clear, actionable insights using Excel. In this one-hour workshop, you’ll learn how to organize and clean datasets, apply essential formulas like SUM, IF, and XLOOKUP, and explore data using sorting and filtering techniques. We’ll also cover creating and using PivotTables to quickly summarize large datasets, as well as building charts (bar, line, and pie) to visualize trends and patterns. Perfect for beginners, this session focuses on practical, hands-on techniques you can immediately apply to real-world data.

Area Covered

  • Introduction to Excel for Data Analysis (interface, key features, and best practices)
  • Structuring data in tabular format (headers, consistent data types, avoiding common errors)
  • Data cleaning techniques (removing duplicates, handling blanks, text-to-columns)
  • Basic and essential formulas (SUM, AVERAGE, COUNT, IF)
  • Lookup functions (VLOOKUP and XLOOKUP) for data retrieval
  • Sorting and filtering tools for quick data exploration
  • Creating and using PivotTables for data summarization
  • Generating Pivot Charts for visual insights
  • Building standard charts (bar, line, pie) for data visualization
  • Applying conditional formatting to highlight trends and outliers
  • Basic data validation to control data input
  • Practical examples and hands-on exercises for real-world application (sales, HR, etc.)

Why Should You Attend

The main reason to attend this webinar is to gain practical, job-relevant skills in analysing data using Excel, one of the most widely used tools across industries. In just one hour, you’ll learn how to quickly summarize data with PivotTables, apply essential formulas, and create charts that turn numbers into clear insights. Whether you're a student, professional, or beginner, this training will help you work more efficiently, make better data-driven decisions, and add a valuable skill to your toolkit.

Who Will Benefit?

This workshop is suitable for anyone who are dealing with large data and trying to make sense out of it. For example, sales people who are looking at their sales data and wanting to learn how to improve sales, managers who want to easily see top performing employees and monitor employees that require more focus, and HR people who would like to analyse attendance data, create compliance reports, analyse employee demographics.
 
This is for everyone from all levels who has access to Excel and data to analyse to solve their business-specific problems.

Speaker

Josh Valdeleon works as a consultant focusing on business intelligence (BI) and data engineering projects. He’s been in the data field for more than 6 years now. He helps organizations in establishing and improving their data ecosystems and he also conducts learning workshops to empower organizations in managing and analysing their data. Last year, he was recognized by Microsoft as one of its Most Valuable Professionals (MVP) under Developer Technologies category.

Upcoming Webinars

View All Webinars