Excel Data Analysis Course Overview:
This Excel Data Analysis Course will give you practical experience in data analysis using Microsoft Excel. This training is designed to equip you with the skills and knowledge required to analyze and visualize data effectively. Through a series of hands-on projects, you will learn essential Excel functions, data cleaning and manipulation techniques, statistical analysis, and data visualization methods.
Excel Data Analysis Course Outline:
Module 1: Introduction to Data Analysis
- Understanding the importance of data analysis in decision-making
- Overview of data analysis tools and techniques
Module 2: Data Cleaning and Preparation
- Importing and organizing data in Excel
- Data cleaning techniques, including handling missing values and outliers
Module 3: Excel Functions and Formulas for Data Analysis
- Essential Excel functions for data manipulation and calculations
- Advanced formulas for data cleaning, filtering, and conditional analysis
Module 4: Data Analysis Techniques
- Descriptive statistics: mean, median, mode, standard deviation, etc.
- Hypothesis testing and inferential statistics
- Correlation and regression analysis
Module 5: Data Visualization with Charts and Graphs
- Creating effective charts and graphs in Excel
- Customizing visuals to convey data insights
Module 6: Pivot Tables and Pivot Charts
- Introduction to pivot tables for data summarization and analysis
- Creating dynamic pivot charts for interactive data visualization
Module 7: Advanced Data Analysis Tools
- Solver for optimization and what-if analysis
- Scenario Manager for sensitivity analysis
Module 8: Data Analysis with Excel Add-Ins
Utilizing Excel add-ins for specialized data analysis tasks (e.g., Power Query, Power Pivot, etc.)
- Become Job Ready
- Become an expert in the field.
- Increase earning potential.
I am Deborah Osilade, I am a Data Analyst and an Instructor at Piston and Fusion Business Academy. I love leveraging data to create high-quality data-intelligent solutions. I enjoy working on building Predictive Models, Financial models and designing Dashboards solutions. My specialization and core skills are in Finance, Data Science & Machine Learning. I have a Post Graduate Diploma in Data Science and Business Analysis from the University of Texas at Austin and a B.A. Accounting and Finance degree from Middlesex University. My proficiency with data science tools spans Programming Language for Data Science, Data visualization, and Data management tools.
Excel Data Analysis Course
| Batch 1 | Batch 2 | Batch 3 | |
| Date | 24th May – 2nd June
2023 |
24th May – 2nd June | 24th May – 2nd June |
| Training Days | Mon & Wed | Tue & Thr | Sat |
| Training Time | 9am – 12pm | 1pm – 3pm | 9am – 3pm |
| Delivery Method | Classroom & Online | Hybrid | Classroom |
| Location | 122a Obadina street Lagos | zoom | Microsoft Teams |
Course FAQ
.accordion-flush class. This is the first item's accordion body..accordion-flush class. This is the second item's accordion body. Let's imagine this being filled with some actual content..accordion-flush class. This is the third item's accordion body. Nothing more exciting happening here in terms of content, but just filling up the space to make it look, at least at first glance, a bit more representative of how this would look in a real-world application.Related Courses
