What You'll Learn
- Introduction to Microsoft Excel and the Interface
- Navigating Worksheets and Working with Data
- Basic Formatting: Fonts, Colors, and Borders
- Working with Rows, Columns, and Cells
- Understanding Formulas and Cell References
- Logical Functions: IF, AND, OR, NOT
- Lookup Functions: VLOOKUP, HLOOKUP, XLOOKUP
- Date and Time Functions
- Sorting and Filtering Data
- Removing Duplicates and Data Validation
- Using Flash Fill for Quick Data Entry
- Creating Basic Charts: Bar, Line, and Pie Charts
- Customizing Chart Styles and Layouts
- Advanced Charts: Combo Charts, Sparklines, Waterfall Charts
- Designing a Dashboard Layout
- Using Named Ranges and Dynamic Formulas
- Combining Charts, PivotTables, and Conditional Formatting
- Avoiding Common Excel Mistakes
- Essential Excel Shortcuts
Requirements
- No prior experience with data visualization is needed! I'll start with the fundamentals and build from there.
Who This Course is For
- Anyone who uses Excel: If you work with data and want to transform your static spreadsheets into dynamic, decision making tools, this course is for you.
- Financial Analysts & Accountants: Go beyond traditional reports and create stunning visuals that reveal hidden insights in financial data.
- Marketing & Sales Professionals: Track campaign performance, analyze sales funnels, and communicate results with powerful visual reports.
- Managers & Team Leaders: Gain the ability to monitor team performance, present data-driven reports, and make more informed decisions.
Your Instructor
Skillify Academy
Data Analyst | Instructor at Udemy
4.0 Instructor Rating
220 Reviews
12,917 Students
13 Courses
Related Courses
More free Office Productivity courses you might be interested in
Free 100% Off
Today
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
Today
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
Today
Expires in 3 days
Office Productivity
Arabic
Microsoft Project from Zero to Pro بروجكت من الصفر للاحتراف
كورس مايكروسوفت بروجكت الكامل بالعربية
Free 100% Off
Today
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.