Course description
Analyzing Data with Excel
This course provides students with the fundamental knowledge required to use Excel spreadsheets to perform basic data analysis.The course consists of several videos, demos, examples, and hands-on labs to help you learn, and ends with a final assignment project which will help you put what you have learned into practice.
Excel is an important tool when working with data - whether it is for business, marketing, research, or data analysis purposes. This course is targeted at those people who have ambitions in Data Analytics or Data Scientist roles, as well as those who just have a need to use Excel to perform data analysis in their own company or environment.
Learners will gain useful experience in the cleaning and wrangling of data using functions, and in analyzing data using methods such as sorting, filtering, and pivot tables. This course starts with an introduction to spreadsheet applications such as Microsoft Excel and Google Sheets and discusses importing data from multiple different formats. During this introduction you will learn to carry out some basic-level data wrangling and data cleaning tasks and then you will expand your knowledge of data analysis via the use of sorting, filtering, and pivot tables in a spreadsheet.
Upcoming start dates
Who should attend?
Prerequisites
None
Course delivery details
This course is offered through IBM, a partner institute of EdX.
2–3 hours per week
Costs
- Verified Track -$99
- Audit Track - Free
Certification / Credits
What you'll learn
- The fundamentals of spreadsheet applications
- How to perform basic spreadsheet tasks
- About the importance of data quality
- How to import file data into Excel
- The fundamentals of analyzing data using a spreadsheet
- How to filter and sort data
- How to clean and prepare data
- How to analyze data using an Excel spreadsheet
Contact this provider
edX
edX For Business helps leading companies upskill their labor forces by making the world’s greatest educational resources available to learners across a wide variety of in-demand fields. edX For Business delivers high-quality corporate eLearning to train and engage your employees...