- Data Cleansing
- Spreadsheet Software
- Automation
- Data Analysis
- Data Validation
- Data Manipulation
- Pivot Tables And Charts
- Data Transformation
- Excel Formulas
- Microsoft Excel
Excel Fundamentals for Data Analysis
Completed by ANG YI JIE
July 6, 2021
15 hours (approximately)
ANG YI JIE's account is verified. Coursera certifies their successful completion of Excel Fundamentals for Data Analysis
What you will learn
Use Excel tools and functions to clean and prepare data for analysis.
Use Named Ranges and Tables to automate your analysis.
Understand the different types of data in Excel and use appropriate functions to work with them.
Use logical and lookup functions to transform, link and categorise data.
Skills you will gain
