Excel Basics
About This Course
Microsoft Excel is one of the most powerful tools in the modern workplace. Whether you are a student, a business professional, or an aspiring data analyst, mastering the basics of Excel is essential for productivity and data management.
In this course, we strip away the complexity and focus on the fundamental building blocks. You will move from being intimidated by spreadsheets to confidently navigating the interface, entering data, and performing essential calculations. By the end of this journey, you will have a solid foundation to build upon for advanced data analysis.
Learning Objectives
Master the Interface: Confidently navigate the Excel ribbon, quick access toolbar, and workbook structure.
Efficient Data Entry: Learn time-saving shortcuts for entering, editing, and formatting data.
Basic Formulas & Functions: Understand how to use SUM, AVERAGE, MIN, MAX, and basic arithmetic operators.
Cell Referencing: Master the difference between relative and absolute cell references to automate your work.
Data Organization: Learn how to sort, filter, and freeze panes to manage large datasets easily.
Professional Formatting: Create clean, readable tables and use conditional formatting to highlight key trends.
Printing & Exporting: Prepare your spreadsheets for professional printing and PDF sharing.
Requirements
- A computer with Microsoft Excel installed (2016, 2019, 2021, or Office 365).
- No prior knowledge of Excel or data analysis is required.
- A basic understanding of using a computer (opening files, using a mouse/keyboard).
Target Audience
- Complete Beginners: Anyone who has never opened Excel or feels overwhelmed by it.
- Students & Graduates: Looking to add essential office skills to their CV.
- Small Business Owners: Who want to track expenses, inventory, or simple customer lists.
- Administrative Professionals: Seeking to improve their daily workflow and efficiency.
Curriculum
12 Lessons2h 20m
Introduction to Excel
Introduction to Excel00:2:49
Lesson 1
Lesson 2
Lesson 3
Lesson 4
Lesson 5
Lesson 6
Lesson 7
Lesson 8
Lesson 9
Lesson 10
Lesson 11
Your Instructors
Machinfy Academy
See more
EGP550.0EGP1,000.0
-40%
Tableau Full Course
EGP900.0EGP1,500.0
Login with Google