Overview
Learn the fundamentals of Excel through a practical and beginner-friendly course designed for real business use.

Instead of only explaining buttons and menus, this course focuses on how Excel is actually used inside companies for reporting, calculations, data organization, and management summaries.

You will start with the Excel interface, entering data, workbook structure, and formatting. Then you will move into formulas, cell references, functions such as SUM, IF, VLOOKUP, and XLOOKUP, followed by sorting, filtering, charts, and Pivot Tables.

You will also learn how to clean data, organize worksheets, prepare files for printing, and work more efficiently using shortcuts and smart Excel tools.

At the end of the course, you will complete a full practical project where you build a monthly sales report from raw data to a final management-ready report.
What you'll learn
✓ Understand how Excel is really used inside companies
✓ Work correctly with rows, columns, cells, and tables
✓ Write essential formulas and connect data together
✓ Use relative and absolute references correctly
✓ Format data and tables professionally
✓ Clean and prepare data before analysis
✓ Use sorting, filtering, and lookup tools
✓ Build practical reports ready for printing and sharing
✓ Work faster using important keyboard shortcuts
✓ Complete a final project that simulates a real business case
Requirements
No previous Excel experience is required
A computer or laptop with Microsoft Excel installed
Willingness to learn and apply practically
Commitment to watching lessons and completing exercises
Excel 2019 or Microsoft 365 is preferred
Course Content
🎬 45 Lessons ⏱️ 3h 35m
Getting Started with the Excel Interface
14:10
A Complete Tour of the Excel Screen
6:06
Unlock the Power of the Formula Bar
1:55
Master Sheet Management in Excel
2:23
Learn How to Control Your Excel Sheets
3:46
Formatting and Building Professional Worksheets
13:42
The Secret to a Well-Formatted Excel Worksheet
2:53
How to Build a Salary Sheet Step by Step
6:40
Make Your Salary Sheet More Professional
4:09
Basic Formulas and Data Visualization
13:03
Visualize Your Data Instantly with One Click
3:40
Turn Your Data into the Right Visual Story
2:19
Basic Function - Master the SUM Function in Excel
7:04
Saving, Managing, and Recovering Workbooks
Formatting and Designing Reports That Look Professional
Essential Formulas Used Every Day Inside Companies
25:00
Understanding Relative and Absolute References
5:00
Using Fixed References to Build Better Formulas
5:00
Using IF Statements in Real Business Scenarios
5:00
The Most Important Functions Used Every Day
5:00
Using VLOOKUP to Connect and Match Data
5:00
Visualizing Data with Charts
15:00
Introduction to Choosing the Right Chart Type
5:00
Creating Professional Column and Bar Charts
5:00
Formatting Colors and Titles in Charts
5:00
Cleaning, Sorting, and Filtering Data
25:00
Finding Data Problems Before They Ruin Your Report
5:00
Cleaning Duplicate, Empty, and Messy Data
5:00
Splitting and Extracting Data Professionally
5:00
Formatting Dates, Numbers, and Financial Data
5:00
Using Sort, Filter, and Search Tools Like a Professional
5:00
Analyzing Data with Pivot Tables
15:00
What is a Pivot Table and Why is it Important?
5:00
Creating Your First Pivot Table from Sales Data
5:00
Using Filters, Values, Rows, and Columns
5:00
Working Faster with Flash Fill
10:00
Using Flash Fill to Split Names and Data
5:00
Combining Text and Data Quickly with Flash Fill
5:00
Viewing Large Workbooks Efficiently
10:00
Using Freeze Panes to Lock Rows and Columns
5:00
Using Split View and Page Break Preview
5:00
Managing Multiple Sheets and Workbooks
15:00
Adding, Deleting, and Renaming Worksheets
5:00
Copying and Moving Worksheets Between Files
5:00
Linking Data Between Multiple Workbooks
5:00
Protecting, Sharing, and Collaborating on Files
15:00
Protecting a Workbook with a Password
5:00
Locking Specific Cells for Editing
5:00
Sharing the Workbook Securely with Others
5:00
Printing Reports Professionally
15:00
Setting Print Area and Adjusting Margins
5:00
Adding Headers, Footers, and Page Numbers
5:00
Preparing the Final Report for Print or PDF
5:00
Final Business Case Study
25:00
Thinking Like a Manager Before Building Reports
5:00
Building a Simple Dashboard That Explains the Numbers
5:00
Preparing Reports for Printing, Sharing, and Presentations
5:00
Final Business Project: Sales Data Analysis
5:00
Presenting Your Final Excel Solution Professionally
5:00
Your Next Step After This Course
5:00
Your Next Learning Path After Excel Foundations
5:00
🔒 45 lessons locked — enroll to access all   Unlock All
Who should Enroll
Beginners who want to learn Excel correctly from scratch
Graduates who want to add a strong in-demand skill to their CV
New employees who need Excel inside companies
Business owners who want to track their reports and data themselves
Anyone who wants to learn Excel professionally in a real business environment
Instructor
Ashraf Elsheikh
Ashraf Elsheikh
Founder & CEO of Elite Training & Consulting
Ashraf Elsheikh is the Founder & CEO of Elite Training & Consulting with more than 20 years of experience in training employees inside companies on Excel, Data Analysis, Power BI, Power Query, and AI. Over the years, he has helped professionals improve the way they think about reports, dashboards, business workflows, and decision-making using data.
 5  Courses  125  Learners
Profile Page
Frequently Asked Questions
Is this course suitable for beginners?
Yes, this course is fully designed for beginners and starts from the fundamentals up to building professional workbooks and reports.
Do I need previous Excel experience?
No, you do not need any previous experience. You will learn everything from the beginning in a simple and practical way.
Does the course include real business examples?
Yes, the course is built around real company workflows and includes practical business examples, reports, and scenarios.
Will I get a certificate after completing the course?
Yes, you will receive a completion certificate after finishing all required lessons.
Can I watch the course more than once?
Yes, you get lifetime access and can watch the lessons anytime.
Which software do I need for this course?
You will need Microsoft Excel, preferably Excel 2019 or Microsoft 365.