Overview
Learn how to build smart Excel files using the formulas and functions companies use every day such as IF, VLOOKUP, XLOOKUP, SUMIF, and more to create professional reports, save time, and reduce errors.
What you'll learn
✓
Understand how formulas are used inside companies
✓
Master relative and absolute references
✓
Use IF, Nested IF, and IFERROR professionally
✓
Build formulas with multiple conditions
✓
Use VLOOKUP, XLOOKUP, and INDEX MATCH
✓
Clean and combine data with text functions
✓
Use date and time functions in reports
✓
Build smarter files that save time and reduce errors
✓
Handle formula errors professionally
✓
Complete a final project that simulates a real business environment
Requirements
It is recommended to complete Excel Foundations for Business first
Basic knowledge of cells, worksheets, and tables
Microsoft Excel 2019 or Microsoft 365 installed
Willingness to learn how companies think about formulas
Readiness to practice on real business files
Course Content
🎬 33 Lessons
⏱️ 2h 21m
Formula Mindset Inside Companies
Why Formulas Are the Most Important Skill in Excel
3:00
How Companies Use Formulas Every Day
3:00
The Most Common Formula Mistakes Employees Make
3:00
Understanding the Formula Bar and Function Library
3:00
Understanding References Like a Professional
Understanding Relative References
4:00
Understanding Absolute References
4:00
Using Mixed References Correctly
4:00
Real Business Examples for Cell References
4:00
Core Daily Functions
Using SUM, AVERAGE, and COUNT
4:00
Using MAX, MIN, and ROUND
4:00
Using TODAY and NOW in Reports
4:00
Using TEXT to Format Data Professionally
4:00
Logic Functions Used in Real Work
Using IF in Real Work Scenarios
5:00
Combining IF with AND and OR
5:00
Using Nested IF Without Confusion
5:00
Preventing Errors with IFERROR
5:00
Lookup Functions That Save Hours
Understanding VLOOKUP Step by Step
5:00
Common VLOOKUP Mistakes and How to Fix Them
5:00
Why XLOOKUP Is Better for Modern Users
5:00
Using INDEX and MATCH Together Professionally
5:00
Text Functions for Cleaning and Combining Data
Splitting Text with LEFT, RIGHT, and MID
4:00
Cleaning Text with TRIM and LEN
4:00
Combining Text with CONCAT and TEXTJOIN
4:00
Cleaning Employee and Customer Data
4:00
Date and Time Functions
Using TODAY and NOW in Reports
4:00
Calculating Service Time with DATEDIF
4:00
Using NETWORKDAYS for Working Day Calculations
4:00
Tracking Deadlines with EDATE
4:00
Final Business Scenario
Building a Full Sales Tracking File
5:00
Connecting Multiple Sheets Together
5:00
Building Smart KPI Calculations
5:00
Fixing Formula Errors Professionally
5:00
Final Project Walkthrough and Review
5:00
Who should Enroll
Employees who work with Excel files every day
Graduates who want stronger practical skills
Analysts who need to connect data quickly
Business owners who want smarter files
Anyone who wants to master Excel formulas inside companies
Instructor
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
Do I need to be good at Excel before taking this course?
It is recommended to complete Excel basics first or have simple knowledge of worksheets and cells.
Will I learn VLOOKUP and XLOOKUP?
Yes, the course covers VLOOKUP, XLOOKUP, and INDEX MATCH with real business examples.
Is the course practical or theoretical?
The course is fully practical and based on real company scenarios and files.
Will I receive a certificate?
Yes, you will receive a certificate after completing all required lessons.
Can I watch the course more than once?
Yes, you get lifetime access and can watch the lessons anytime.
Will I be able to build professional files after this course?
Yes, after the course you will be able to build smart professional files and reports using advanced formulas and functions.
