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