Introduction to Data Analysis using Microsoft Excel
Using sales data from a hypothetical corporation, you will master the fundamentals of data analysis with Microsoft Excel in this assignment. You'll learn how to arrange your data and get precise information about it by using sorting and filtering tools. You'll also learn how to produce new data and link data from other tables using functions like IF and VLOOKUP.
Finally, you'll learn how to use PivotTables to summarize your data and make comparisons. These abilities will enable you to execute data analysis efficiently on a variety of data types and will serve as a basis for expanding your toolkit as you learn more about data analysis techniques.
THE SKILLS YOU WILL DEVELOP
- Formulas and Functions in Spreadsheets
- Data Analysis
- Data Calculations
LEARN STEP BY STEP:
- Upload a document using the free online version of Microsoft Office 365.
- Perform data analysis using sorting and filtering tools.
- Perform data mining using the IF function.
- Create references between tables and search for information with VLOOKUP.
- Perform data analysis using PivotTables.
Rating: 4.7/5
Enroll here: coursera.org/projects/introduction-data-analysis-microsoft-excel
