Analyzing Data with Excel

(5 customer reviews)

81,354.94

Category:

Description

This course gives students the fundamental knowledge to use Excel spreadsheets to analyze primary data. It consists of several videos, demos, examples, and hands-on labs to help you learn, and it ends with a final assignment project that will help you put what you have learned into practice.

Excel is an important tool when working with data—whether for business, marketing, research, or data analysis purposes. This course is targeted at people who have ambitions in Data Analytics or Data Scientist roles, as well as those who just need to use Excel to perform data analysis in their own company or environment.

Learners will gain helpful experience in cleaning and wrangling data using functions and analyzing data using methods such as sorting, filtering, and pivot tables. This course introduces spreadsheet applications such as Microsoft Excel and Google Sheets and discusses importing data from multiple formats. During this introduction, you will learn to carry out some basic-level data wrangling and data cleaning tasks. Then, you will expand your knowledge of data analysis via sorting, filtering, and pivot tables in a spreadsheet.

The emphasis is on applied learning and hands-on practice in this course, and with each hands-on lab, you will gain further experience in the manipulation and handling of data and start to understand the critical role that spreadsheets can perform in a data analysis environment. The final assignment project will allow you to apply these newly acquired skills to analyze data in a business scenario. By the end of this course, you will have worked with several data sets and spreadsheets and demonstrated the basics of cleaning and analyzing data without learning any code.