What You'll Learn
- Understanding the Excel Interface.
- Navigating Workbooks, Worksheets, and Ribbons.
- Saving, Sharing, and Printing Excel Files.
- Using Basic Formulas and Functions (SUM, AVERAGE, COUNT).
- Understanding Relative, Absolute, and Mixed References.
- Sorting and Filtering Data.
- Conditional Formatting and Rules.
- Using Logical Functions (IF, AND, OR).
- Lookup and Reference Functions (VLOOKUP, HLOOKUP, INDEX, MATCH).
- Creating Slicers for Dynamic Filtering.
- Advanced Filtering Techniques.
- Using What-If Analysis (Goal Seek, Scenario Manager, Data Tables).
- Creating advanced charts (Waterfall, Histogram, Pareto).
- Designing professional dashboards.
- Customizing chart elements.
- Using sparklines and data bars.
Requirements
- A basic understanding of Excel (no advanced experience required)
Who This Course is For
- Anyone interested in using Excel to make smarter, data-backed decisions
- Students in business, finance, economics, and related fields
- Business professionals and managers who want to enhance decision-making with data
- Aspiring data analysts looking to gain Excel based experience
Your Instructor
Skillify Academy
Data Analyst | Instructor at Udemy
4.0 Instructor Rating
254 Reviews
14,068 Students
13 Courses
Related Courses
More free Office Productivity courses you might be interested in
Free 100% Off
Today
Expires in 3 days
Excel - Microsoft Excel Formulas and Functions For Beginners
Master the core functions of Excel step by step, perfect for students, job seekers, and professiona…
Free 100% Off
Today
Expires in 3 days
Excel VBA for Beginner to Advanced
Unlock the Power of Excel: Master VBA from Beginner to Advanced
Free 100% Off
Today
Expires in 3 days
Advanced Excel Course With Shortcuts Tips and Tricks for JOB
Master Advanced Excel Formulas. Solve Complex Problems. Learn Advanced Excel Skills to Save Time & …
Free 100% Off
Today
Expires in 3 days
Mastering Microsoft Word: A Comprehensive Guide to Boost You
Unlock the Full Potential of MS Word with Advanced Tips, Tricks, and Time-Saving Techniques
Never Miss a Coupon!
Subscribe to our newsletter to get daily updates on the latest free courses.