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.1 Instructor Rating
389 Reviews
19,424 Students
13 Courses
Related Courses
More free Office Productivity courses you might be interested in
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
Data Analysis and Data Visualization with Microsoft Copilot
Boost productivity by automating analysis and building interactive dashboards with Microsoft Copilot
Free 100% Off
Yesterday
Expires in 2 days
Office Productivity
English
Data Entry Skills via Google Sheets : A Practical Course
Complete Guide For Data Entry Skills to become a Successful Data Entry Worker by using Google sheet…
Free 100% Off
Yesterday
Expires in 2 days
Office Productivity
English
Microsoft Excel - Excel Course For Beginners
Learn The Excel Essentials - Drop Down Lists, Charts & Graphs, Pivot Tables, Sorting, Filtering, LO…
Never Miss a Coupon!
Subscribe to our newsletter to get daily updates on the latest free courses.