Deglecy Computer · Data & AI
Microsoft Excel and Data Analysis Fundamentals
Master essential Excel skills for organizing, analyzing, and visualizing data through hands-on projects using real-world business and academic datasets.
40lessons
Beginnerlevel
20 hoursto complete
0already enrolled
About this course
Master essential Excel skills for organizing, analyzing, and visualizing data through hands-on projects using real-world business and academic datasets.
What’s included
Free to joinCreate an account and enroll at no cost.
Final examFinish all lessons, then take the exam.
CertificatePass the exam to earn your certificate.
Course content
Module 1: Excel Basics and Interface Navigation5 lessons
Introduction to Spreadsheets15 min
Navigating the Excel Interface12 min
Entering and Editing Data15 min
Basic Formatting Techniques15 min
Saving and File Management10 min
Module 2: Essential Formulas and Functions5 lessons
Understanding Formula Basics18 min
Mathematical Functions (SUM, AVERAGE)15 min
Logical Functions (IF Statements)20 min
Cell References and Ranges15 min
Error Troubleshooting12 min
Module 3: Data Organization and Cleaning5 lessons
Structuring Data Properly15 min
Text Functions for Data Cleaning20 min
Removing Duplicates and Blanks12 min
Find and Replace Techniques10 min
Introduction to Data Validation15 min
Module 4: Sorting and Filtering Data5 lessons
Basic Sorting Techniques12 min
Advanced Multi-Level Sorting15 min
Single and Multiple Column Filters18 min
Custom Filter Operations15 min
Wildcard and Date Filtering12 min
Module 5: Data Visualization with Charts5 lessons
Chart Types and Best Practices15 min
Creating Column and Bar Charts12 min
Line and Pie Chart Applications15 min
Formatting Chart Elements15 min
Dynamic Charts with Data Selection18 min
Module 6: Conditional Formatting and Analysis Tools5 lessons
Basic Conditional Formatting Rules15 min
Color Scales and Icon Sets12 min
Highlight Cell Rules15 min
Data Bars and Custom Rules15 min
What-If Analysis Introduction10 min
Module 7: Synthesize and summarize complex datasets using powerful pivot table functionality.5 lessons
Creating Basic Pivot Tables20 min
Grouping Data in Pivot Tables15 min
Pivot Table Calculations18 min
Slicers and Timeline Filters15 min
Pivot Charts and Dashboards20 min
Module 8: Capstone Business Data Analysis Project5 lessons
Project Overview and Dataset Setup15 min
Data Cleaning and Preparation20 min
Analysis with Formulas and Pivot Tables25 min
Creating Executive Dashboard25 min
Final Report and Presentation20 min