- Data Cleansing
- Data Transformation
- Data Analysis
- Microsoft Excel
- Data Manipulation
- Pivot Tables And Charts
- Automation
- Data Preprocessing
- Excel Formulas
- Data Validation
- Spreadsheet Software
Excel Fundamentals for Data Analysis
Completed by Ruyun Zhang
March 8, 2021
15 hours (approximately)
Ruyun Zhang'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
