Digital Skills

Spreadsheet Basics for Data Analysis (Course 833)

About The Course

This course is designed to provide you with basic working knowledge for using spreadsheets for Data Analysis. It covers some of the first steps for working with spreadsheets and their usage in the process of analyzing data. You will gain hands-on experience in manipulating data and begin to understand the important role of spreadsheets. Clean and analyze your data faster by understanding functions in the formatting of data. You will then convert your data to a pivot table and learn its features to make your data organized and readable.

Course Participants

This course is suitable for those aspiring to take up Data Analysis or Data Science as a profession, as well as those who just want to use Spreadsheet for data analysis in their own domains. Getting started with Spreadsheet is made easy in this course. It does not require any prior experience with spreadsheets or coding.

Course Presentation

The course is extensively 'hands on' with a functional knowledge based content. The participants will have considerable practical experience working with Spreadsheet. Comprehensive course notes with an extensive classroom presentations are provided.

Learning Outcomes

On completion of the course, participants will be able to

• use spreadsheets as a data analysis tool
• use functions and reference data in spreadsheet formulas
• import file data
• deal with inconsistencies in data
• filter and sort data with spreadsheets
• identify useful functions for data analysis
• Use VLOOKUP and HLOOKUP functions