Data Analysis in Excel

Course Overview

Skills and Knowledge Acquired:
This course will provide students with the skills and knowledge to analyze data in Excel. Students will learn about the data analysis process and a framework to transform raw data into useful information. Additionally, students will learn a variety of functions to prepare text and date fields, as well as the VLOOKUP function to insert data from another table. Finally, students will use a variety of functions to analyze Kickstarter data and gain insight into the characteristics of successful projects.


Contribution to Professional Growth:
This course provides a comprehensive overview of data analysis in Excel, which is an essential skill for professional growth. It covers the data analysis process, a framework to help transform raw data into useful information, and a variety of functions to prepare text and date fields. Additionally, the course covers VLOOKUP, one of Excel's most important functions, and provides an opportunity to apply the skills learned to analyse Kickstarter data and gain insight into the characteristics of successful projects. This course is an invaluable resource for professionals looking to develop their data analysis skills.


Suitability for Further Education:
This course provides a comprehensive introduction to data analysis in Excel, which can be a valuable tool for preparing for further education. Learners will gain an understanding of the data analysis process and a framework to assist in transforming raw data into information that can be used to make decisions. Additionally, learners will explore a variety of functions to prepare text and date fields, as well as use VLOOKUP, one of Excel's most important functions, to insert data from another table into their dataset. Finally, learners will get down to business and use a variety of functions to analyze Kickstarter data and better understand what characteristics successful projects share. Therefore, this course is suitable for preparing further education.