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