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
3.6 Instructor Rating
195 Reviews
12,043 Students
13 Courses
Related Courses
More free Office Productivity courses you might be interested in
Free 100% Off
Yesterday
Limited Time
Office Productivity
English
Excel Data Analysis With Pivot Tables & Pivot Charts - 2025
Data analysis excel, data analysis, Pivot Chart, Microsoft excel, advanced excel, ms excel, Data An…
Free 100% Off
Yesterday
Limited Time
Office Productivity
English
Google Sheets at work : Impress Your Boss with Smart Works
MS Excel, Spread sheets , Microsoft Excel , G sheets , google spreadsheet, Google Workspace (G Suit…
Free 100% Off
Yesterday
Expires in 3 days
Office Productivity
Arabic
Microsoft Project from Zero to Pro بروجكت من الصفر للاحتراف
كورس مايكروسوفت بروجكت الكامل بالعربية
Free 100% Off
Yesterday
Expires in 3 days
Office Productivity
English
Mastering Power BI Report Design - Beginner to Advanced
A Full Guide to Creating Insightful Reports, Interactive Dashboards, and Effective Data Storytellin…
Never Miss a Coupon!
Subscribe to our newsletter to get daily updates on the latest free courses.