Data Analysis with Excel

This Excel for Data Analytics course covers advanced SQL skills in data analytics.




Hours per week


Live Sessions

Jul 31, 2023

Next Date


The objective of this program is to provide participants with a comprehensive understanding of how to effectively analyze data using Excel. Participants will learn the core concepts and techniques of data analysis, including data cleaning, manipulation, visualization, macros and data modeling using Excel's powerful features and functions. They will gain practical skills in organizing and structuring data, performing calculations and data transformations, creating meaningful visualizations, and deriving insights from data using Excel. By the end of the course, participants will be able to confidently utilize Excel as a tool for data analysis, enabling them to make data-driven decisions, communicate findings effectively, and derive valuable insights from their datasets.


  • Basic understanding of statistics and probability for data analytics
  • Fundamental data analysis concepts, such as data types, data cleaning
  • Participants should have access to a computer spreadsheet (Microsoft Excel, Google sheets)


Introduction to Excel for Data Analytics

Explore Excel's interface and essential functionalities for data analytics. Learn about various data types and techniques to import and organize data efficiently. Data manipulation techniques such as sorting, filtering, and conditional formatting will be covered to prepare data for analysis and visualization.

Data Cleansing and Preparation

Data quality is crucial for accurate analysis. explore common data issues like missing values and duplicates and learn techniques to handle them effectively. Discover data cleaning techniques to improve data integrity and prepare it for further analysis, including formatting, transforming, and structuring data appropriately.

Data Analysis with Excel Functions

Excel offers a wide range of functions for data analysis. Learn how to use fundamental functions like SUM, AVERAGE, COUNT, as well as logical functions (IF, AND, OR) for categorization and condition-based calculations. Lookup functions like VLOOKUP and HLOOKUP will be explored to retrieve data from different datasets, facilitating data analysis.

Data Visualization with Excel Charts and Graphs

Explore chart types like bar charts, line charts, and pie charts to represent data visually. They will learn to create custom charts to enhance clarity and incorporate multiple datasets into a single chart for comparative analysis, facilitating data-driven decision-making.

Data Modeling with Excel

Data modeling enables to perform advanced analysis, such as forecasting, regression analysis, and scenario planning. Use data models and Excel's Solver tool for optimization problems. Additionally, Larn about What-If Analysis to assess the impact of different variables on the data model, making informed predictions and strategic decisions.

Excel Pivot Tables

Pivot tables are powerful tools for summarizing and analyzing large datasets quickly. Learn how to create pivot tables and manipulate them through filtering, grouping, and calculated fields. Explore pivot charts and slicers for advanced pivot table features, providing deeper insights into data trends and patterns.

Macros and Automation in Excel

Automating repetitive tasks is essential for efficient data analysis. Introduction to Excel macros, recording and editing them to suit specific data analysis needs. They will also get an introduction to VBA (Visual Basic for Applications) to create more complex automation solutions, saving time and effort in data processing.


Karla Michelli Zarco Chávez

Karla Michelli Zarco Chávez

Fraud analysis specialist has worked in companies such as American Express, HSBC and Clip.

Our alumni works in:

Learn all you can. No extra fees, no commissions, no surprises.

— We’re an hybrid learning platform with live-cohorts. Learn everything you want by acquiring a membership.