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.0 Instructor Rating
244 Reviews
13,566 Students
13 Courses
Related Courses
More free Office Productivity courses you might be interested in
Free 100% Off
Today
Expires in 3 days
Complete MS Office Course Masterclass: Beginner to Advanced
The All-in-One Course for Beginners, Intermediate & Advanced Users: Word, Excel, PowerPoint
Free 100% Off
Today
Expires in 3 days
Complete MS Office and Web Design Development Course
Unlock Your Digital Potential: Master MS Office, Web Development, and WordPress
Free 100% Off
Yesterday
Expires in 3 days
Microsoft Word Essential Training: Master the Basics to Pro
Microsoft Word Essential Training Master the Basics to Pro for Business Professionals Formatting, E…
Free 100% Off
Yesterday
Expires in 1 day
How to Become a Thought Leader in Your Industry
Leadership, The Confidence-Competence Loop, Overcoming Imposter Syndrome, The Growth Mindset for Le…
Never Miss a Coupon!
Subscribe to our newsletter to get daily updates on the latest free courses.