What You'll Learn
- Understanding the Excel Interface
- Navigating the Excel Window
- Working with Worksheets and Workbooks
- Entering Data into Cells
- Applying Cell Styles and Formatting
- Basic Arithmetic Operations (+, -, *, /)
- Using Built-in Functions (SUM, AVERAGE, COUNT, etc.)
- Sorting Data in Ascending or Descending Order
- Filtering Data Based on Specific Criteria
- Creating Pivot Tables to Summarize and Analyze Data
- Customizing Pivot Tables with Slicers and Filters
- Performing Descriptive Statistics (mean, median, mode, standard deviation, etc.)
- Scatter Plots and Bubble Charts
- Applying Conditional Formatting Rules
- Creating Data Bars, Color Scales, and Icon Sets
- Accessing and Transforming Data from Various Sources (Excel, CSV, text, web, etc.)
- Merging and Appending Data
- Shaping and Transforming Data
- Building Interactive Reports with Power Pivot and Power BI and more....
Requirements
- Basic knowledge of Microsoft Excel (helpful but not mandatory).
Who This Course is For
- Anyone looking to master Excel for data transformation, analysis, and visualization.
- Students preparing for data analysis roles in business or finance.
- Analysts who want to automate data workflows and enhance insights.
- Business professionals seeking to improve reporting and analysis skills.
Your Instructor
Skillify Academy
Data Analyst | Instructor at Udemy
4.0 Instructor Rating
232 Reviews
13,040 Students
13 Courses
Related Courses
More free Office Productivity courses you might be interested in
Free 100% Off
Today
Expires in 3 days
Office Productivity
English
Microsoft PowerPoint: From Beginner to Presentation Pro
Microsoft PowerPoint: Your Journey from Beginner to Confident Presentation Pro
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 2 days
Office Productivity
Arabic
Microsoft Project from Zero to Pro بروجكت من الصفر للاحتراف
كورس مايكروسوفت بروجكت الكامل بالعربية
Never Miss a Coupon!
Subscribe to our newsletter to get daily updates on the latest free courses.