Microsoft Excel In Data Analysis
Beginner: 6+ weeks
Developing/Proficient: 4 weeks
Course Introduction
The learning pathway in these modules will engage in practical exercises and real-world application to solidify understanding. There are six engaging modules with a cumulative project to assess your knowledge and expertise in utilizing Microsoft Excel in Data Analytics. It is a progressive pathway with a structured approach by building foundational skill with the introduction of Excel and how it is utilized in data. Advanced techniques will be utilized to demonstrate the proficiency of formulas and functions, data cleaning, and automation. Please click the intro module below and complete the survey to get an assessment of your skill level prior to starting the course.
Facilitator Guide
The purpose of this guide is to facilitate the learning of ‘Microsoft Excel in Data Analysis’, especially in a group setting. The link below provides objectives, course materials, and activities/projects given in a timely manner to complete the course.
The Pathway to Mastering Microsoft Excel in Data Analysis
The link below provides the entire ‘Microsoft Excel in Data Analysis’ course in one document. If you prefer to view material one module at a time, please scroll further down for individualized module presentations.
Modules
Module 1: Introduction to Excel for Data Analysis
In this module, you will gain foundational understanding of Excel and navigate the interface to enter data
Module 2: Data Manipulation and Visualization
In this module, you will learn to manipulate data, use basic functions for analysis, and create and format charts for appropriate data representation
Module 3: Advanced Functions, Formulas, and Data Cleaning
In this module, you will develop advanced formula skills, clean and prepare data for analysis, and understand data issues and how to resolve them
Module 4: Let’s Pivot with Tables and Charts
In this module, you will master PivotTables and Pivot Charts, learn to summarize, and analyze large datasets
Module 5: Advanced Tools and External Data
In this module, you will utilize advanced Excel tools to perform complex data analysis task and import and export data from different sources
Module 6: Using Automation with Macros
In this module, you will automate tasks with macros and understand the basics of VBA (Visual Basic for Applications)