DATA ANALYSIS
(Excel for data analysis)
Excel for data analysis
duration: 4 weeks
This course covers the fundamentals of data analysis in Excel, including data preparation, visualization, and analysis. Students will learn how to work with data ranges, create charts and tables, and use basic formulas and functions.
Enrol NowDescriptions
This course focuses on advanced data modeling and analysis techniques in Excel. Students will learn how to create and manage data models, use pivot tables and pivot charts, and apply advanced formulas and functions for data analysis.
This course emphasizes data visualization and insights in Excel. Students will learn how to create interactive dashboards, use advanced charting techniques, and apply data visualization best practices to communicate insights and trends.
-
DATA ANALYSIS USING EXCEL COURSE OUTLINE
Book 1 Excel
Chapter 1 Introduction to Excel
Chapter 2 Worksheet Basics
Chapter 3 Excel Formula Basics
Chapter 4 Excel Advance Formula
Chapter 5 Essential Formatting
Chapter 6 Advanced Formatting
Chapter 7 Charting, Pivot Tables
Chapter 8 Project
