What You'll Learn
- Basic Excel Interface: Navigating the Ribbon and Workbooks
- Basic Arithmetic Operations: Addition, Subtraction, Multiplication, Division
- Understanding Cell References: Relative, Absolute, and Mixed
- Statistical Functions: (AVERAGE, SUM, COUNT, EOUND, MAX, MIN)
- Sorting and Filtering Data
- Using VLOOKUP and HLOOKUP Functions
- Conditional Formatting: Highlight Cell Rules, Data Bars, Color Scales
- Creating Basic Charts: Line, Bar, Pie, and Scatter Plots
- Power Pivot: Data Modeling and Analysis
- Macro Recording and VBA Basics
- Data Validation and Error Handling
- Create a daily sales report with deshboard
Requirements
- No prior Excel experience needed! Start from scratch and build up your skills.
Who This Course is For
- Anyone learn everything from Excel basics to advanced features.
- Work on real world examples and practical exercises.
Your Instructor
Skillify Academy
Data Analyst | Instructor at Udemy
4.1 Instructor Rating
598 Reviews
27,425 Students
13 Courses
Alternative Free Courses
Since this course has expired, check out these active free Office Productivity courses
Free 100% Off
Today
Expires in 3 days
Learn Microsoft Excel : From Zero to Hero
Master Microsoft Excel with this high value beginner to advanced level.
Free 100% Off
17 December 2025
Limited Time
SAP UI5 & Fiori Essentials: Beginner's Complete Walkthrough
SAP UI5 & Fiori Walkthrough for Beginners | HTML, JS, XML, Controllers, BAS, Bindings, Apps, and Mo…
12.99$ 28% Off
24 November 2025
Limited Time
Salesforce Admin & Developer Skills from Scratch
Master Salesforce Admin & Developer skills with Apex, automation, security, integrations and a wide…
Free 100% Off
20 November 2025
Limited Time
AI Skills and Management for Virtual Assistants (VA's)
Your Path to a Pro Virtual Assistant—Master Social Media, AI Tools, SEO, Email Marketing & Land Fre…
Never Miss a Coupon!
Subscribe to our newsletter to get daily updates and never miss another free course opportunity.