This course is designed to help beginners develop a strong foundation in Microsoft Excel, one of the world’s most widely used spreadsheet applications.
Learners will start by understanding the Excel interface and essential spreadsheet concepts before progressing to working with data, performing calculations, applying formulas and functions, and organizing information efficiently. The course also introduces text manipulation, logical decision-making, data lookup techniques, and data transformation methods.
As learners advance, they will explore data visualization using different chart types and conclude with powerful data analysis tools such as Excel Tables and PivotTables.
By the end of the course, participants will be able to confidently create, manage, analyze, and present data using Microsoft Excel.
Course Features
- Lectures 21
- Quiz 0
- Duration 10 weeks
- Skill level All levels
- Language English
- Students 9152
- Assessments Yes
Curriculum
- 6 Sections
- 21 Lessons
- 10 Weeks
- Getting Started with Microsoft ExcelBuild a solid understanding of the Excel environment and spreadsheet basics.2
- Working with DataLearn how to organize, clean, and manage data efficiently.3
- Essential Excel FunctionsLearn the most commonly used functions for calculations and decision-making.4
- Text and Lookup FunctionsLearn how to manipulate text and retrieve information from datasets.3
- Data Visualization with ChartsLearn how to present data visually using Excel charts.8
- 5.1Line Graph in Microsoft Excel5 Minutes
- 5.2Bar Chart in Microsoft Excel6 Minutes
- 5.3Area Chart in Microsoft Excel7 Minutes
- 5.4Pie Chart in Microsoft Excel6 Minutes
- 5.5Scatter Plot Chart in Microsoft Excel7 Minutes
- 5.6Bubble Chart in Microsoft Excel9 Minutes
- 5.7Heatmap Chart in Microsoft Excel10 Minutes
- 5.8Waterfall Chart in Microsoft Excel7 Minutes
- Advanced Data AnalysisApply Excel's advanced analytical tools to summarize and interpret large datasets.1
