Interested in learning Excel Basics for Data Analysis? This free online course from IBM is for you. Gain job-ready skills and advance your career.
About IBM’s Excel Basics for Data Analysis Course
This course starts with an introduction to spreadsheets like Microsoft Excel and Google Sheets and loading data from multiple formats. With this introduction you will then learn to perform some basic level data wrangling and cleansing tasks and continue to expand your knowledge of analyzing data through the use of filtering, sorting, and using pivot tables within the spreadsheet. By performing these tasks throughout the course, it will give you an understanding of how spreadsheets can be used as a data analysis tool and understand its limitations.
There is a strong focus on practice and applied learning in this course. With each lab, 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. The final project enables you to show off your newly acquired data analysis skills. 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 all without having to learn any code.
Getting started with Excel is made easy in this course. It does not require any prior experience with spreadsheets or coding. Nor does it require downloads or installation of any software. All you need is a device with a modern web browser, and ability to create a Microsoft account to access Excel online at no-cost. However if you already have a desktop version of Excel, you can follow along quite easily as well.
In this free Excel Basics for Data Analysis course, you’ll learn:
- Data Analysis using spreadsheets
- Getting started with Using Excel speadsheets
- Cleaning & wrangling data using spreadsheets
- Analyzing data using spreadsheets
Excel Basics for Data Analysis Course details
- Institution: IBM
- Level : Beginner
- Language: English
- Duration: 12 hour, self-paced
- Provider: Coursera
NB: Select « Audit Course » when registering to take the course for free.
You might also like: