Microsoft Excel 2021 Complete Course
Offered by
Benaadir Research, Consultancy & Evaluation Center (BRCE)
-
LevelAll Levels
-
Total Enrolled17
-
Duration4 hours
-
Last Updated11/02/2024
-
CertificateCertificate of completion
17 Cashir
4 Saacadood
Course Certificate
Course Description
The Microsoft Excel 2021 Complete Course is designed to take you from beginner to proficient user of Excel. Covering everything from basic navigation to advanced data analysis, this course equips you with the skills needed to effectively use Excel for various tasks. You’ll learn how to manage data, perform complex calculations, analyze datasets, and present data visually, making you more efficient and capable in your professional or personal projects.
Why should you take this course?
Excel is a powerful tool widely used in many industries for data management, analysis, and visualization. Mastering Excel can significantly enhance your productivity and open up numerous career opportunities. This comprehensive course covers all essential aspects of Excel, ensuring you gain practical skills that are immediately applicable. Whether you’re looking to improve your job performance, support your academic endeavors, or streamline your personal projects, this course provides the knowledge and tools you need.
Who is this course for:
- Beginners who are new to Excel and want to learn from scratch.
- Professionals seeking to improve their Excel skills for better job performance.
- Students needing Excel proficiency for their studies.
- Anyone interested in leveraging Excel for data management and analysis.
Course Curriculum
SECTION 1: Excel Basics
-
Getting Started with Excel
09:13
SECTION 2: Cells and Sheets
-
Cell Basics
12:44 -
Modifying Columns, Rows, and Cells
15:05
SECTION 3: General formulas
-
Simple formulas
20:00 -
Complex Formulas
09:18 -
Functions with examples
11:31 -
Calculating a mark sheet
17:55 -
Calculating the Profit, loss and profit margin
16:48 -
Calculating the Payroll
16:36
SECTION 4: Data analysis
-
Central tendency
14:19 -
Dispersion of data
06:00 -
Measurement of Positions
10:36 -
Pivot tables
10:48 -
Charts in Excel
07:49
SECTION 5: Working with Data
-
Freezing Panes and View Options
11:47 -
Sorting and Filtering Data
15:07 -
Conditional Formatting
11:09