Learn to clean, analyze, and visualize data in Excel to create stunning, interactive dashboards with real insights.
Sub Category
- Microsoft
{inAds}
Objectives
- Introduction to Excel for Data Analysis
- Understanding the Excel Interface
- Importing Data into Excel
- Formatting Data for Analysis
- Removing Duplicates
- Handling Missing Data
- Standardizing Data Formats
- Using CONCATENATE, LEFT, RIGHT, and MID
- TRIM, CLEAN, and SUBSTITUTE Functions
- Using Conditional Formatting
- SUM, AVERAGE, COUNT, and COUNTA
- Logical Functions: IF, AND, OR
- Lookup Functions: VLOOKUP, HLOOKUP, XLOOKUP
- Creating and Formatting Pivot Tables
- Using Calculated Fields and Items
- Creating Bar, Line, and Pie Charts
- Customizing Chart Styles and Layouts
- Choosing The Right Chart for Your Data
- Linking Charts to Dynamic Data
- Descriptive Statistics (Mean, Median, Mode)
- Variance and Standard Deviation
- Using Analysis ToolPak for Statistical Functions
- Transforming and Shaping Data
- Merging and Appending Data
- Creating Data Models
- Relationships Between Tables
Pre Requisites
- You only need access to Microsoft Excel (Office 365, 2019, 2021 or recommended) and a computer.
- No microsoft excel experience needed
FAQ
- Q. How long do I have access to the course materials?
- A. You can view and review the lecture materials indefinitely, like an on-demand channel.
- Q. Can I take my courses with me wherever I go?
- A. Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
{inAds}
Coupon Code(s)