Excel Fundamentals for Data Analysis
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 will enable you to build a strong foundation in the fundamentals, helping you to be more efficient in your day-to-day and developing the necessary skills to work with the more advanced techniques used in later courses. To make the content easy to relate to and to personalize the learning experience, we are going to follow Zara’s journey through the course. Who is Zara? Well, she is no-one and everyone. You will find that Zara’s trials and tribulations sound familiar, and together with Zara, you will develop your Excel skills along the way — and, importantly, have some fun doing it.
The Excel Skills for Data Analytics and Visualization courses are the sequel to one of most successful specializations on Coursera, Excel Skills for Business, which has attracted hundreds of thousands of learners and top ratings. Transform your skills, your confidence, and your opportunities by adding this new set of skills to your repertoire.
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.
Syllabus
Syllabus - What you will learn from this course
Week 1
Welcome and critical information
Cleaning and manipulating text
Week 2
Working with numbers and dates
Week 3
Defined Names for working more effectively with data
Week 4
Tables for automating data manipulation
Week 5
Logical and lookup functions
Final assessment
FAQ
When will I have access to the lectures and assignments?
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.
The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I subscribe to this Specialization?
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.
Is financial aid available?
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.
Reviews
This excellent course for learnig Excel fundamentals like Text, Date, Lookup functions and Tables.
It will be useful for people handling large amoun tof data and its manipulation in computer.
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.
It is really an extraordinary course. I have learned a lot of functions that I have never heard of before. Thank you very much for your effort in providing always the best.
Amazing course and amazing lecturers! Great lesson structure and logical progression. I really recommend doing the practices at the end of each week. Looking forward to the next course!
