What You'll Learn
- 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
Requirements
- You only need access to Microsoft Excel (Office 365, 2019, 2021 or recommended) and a computer.
- No microsoft excel experience needed
Who This Course is For
- Anyone who wants to save time and get the most out of Microsoft Excel.
- Anyone who wants learn Microsoft Excel.
- Students and professionals who want to improve their excel skills.
- Entrepreneurs and office workers who prepare financial report regularly.
Your Instructor
Logic Labs
Instructor at Udemy | Programming | Data Analytics | AI Tool
4.5 Instructor Rating
9 Reviews
5,097 Students
25 Courses
Related Courses
More free Office Productivity courses you might be interested in
Free 100% Off
Today
Expires in 2 days
Pivot Tables - Microsoft Excel Pivot Table and Data Analysis
Hands-On Microsoft Excel Pivot Table Training for Effective Data Analysis
Free 100% Off
Today
Expires in 2 days
Excel Formulas and Functions: Tips, Tricks, and Shortcuts
Master Excel Formulas and Functions with Essential Tips, Tricks, and Shortcuts to Boost Your Produc…
Free 100% Off
Yesterday
Expires in 1 day
How to Become a Thought Leader in Your Industry
Leadership, The Confidence-Competence Loop, Overcoming Imposter Syndrome, The Growth Mindset for Le…
Free 100% Off
Yesterday
Expires in 17 hours
Microsoft Excel for Beginners: Excel for Everyday Use
Learn Essential Excel Skills to Organize Data, Create Reports, and Simplify Everyday Tasks with Con…
Never Miss a Coupon!
Subscribe to our newsletter to get daily updates on the latest free courses.