As data becomes the modern currency, so the ability to analyse the data quickly and accurately has become of paramount importance. Excel with its extraordinarily broad range of features and capabilities is one of the most widely used programs for doing this. In the first course of our Excel Skills for Data Analysis and Visualization Specialization, you will learn the fundamentals of Excel for data analysis. When you have completed the course, you will be able to use a range of Excel tools and functions to clean and prepare data for analysis; automate data analysis with the help of Named Ranges and Tables; and use logical and lookup functions to transform, link and categorise data.
This course is part of the Excel Skills for Data Analytics and Visualization Specialization
About this Course
What you will learn
Use Excel tools and functions to clean and prepare data for analysis.
Use Named Ranges and Tables to automate your analysis.
Understand the different types of data in Excel and use appropriate functions to work with them.
Use logical and lookup functions to transform, link and categorise data.
Skills you will gain
- Data Analysis
- Microsoft Excel
- Data Cleansing
Start working towards your Master's degree
MasterTrack Certificates are portions of Master’s programs that have been split into online modules, so you can earn a high quality university-issued career credential at a breakthrough price in a flexible, interactive format. If you enroll in the program, your coursework will count towards your MasterTrack Certificate.
Syllabus - What you will learn from this course
Welcome and critical information
Cleaning and manipulating text
Working with numbers and dates
Defined Names for working more effectively with data
Tables for automating data manipulation
- 5 stars81.86%
- 4 stars15.74%
- 3 stars1.58%
- 2 stars0.25%
- 1 star0.54%
TOP REVIEWS FROM EXCEL FUNDAMENTALS FOR DATA ANALYSIS
Well done. A small thing, though: in the quizzes, the grading could be made more fault-tolerant. Example: an answer such as AND(y,x) instead of AND(x,y) is deemed wrong, which borders on the nasty.
A very well structured course with easy to follow examples. I would give it a 4.5 because there is some error in the workbook and quizzes but apparently, it hasn't been changed despite to complaints
Very comprehensive and clearly laid out course with loads of content. Great videos, well explained and loads of practice exercises. I feel as if I've learned a great deal, Very Valuable, thank you
Really engaging with short videos, under 10 minutes, and separated by quizzes which keep your attention. The editing and quality of the videos were really great and kept engagement high.
About the Excel Skills for Data Analytics and Visualization Specialization
Frequently Asked Questions
When will I have access to the lectures and assignments?
What will I get if I subscribe to this Specialization?
Is financial aid available?
More questions? Visit the Learner Help Center.