Macquarie University - Excel Fundamentals for Data Analysis
4.7 /5- Offered byCoursera
- Public/Government Institute
Excel Fundamentals for Data Analysis at Coursera Overview
Duration | 15 hours |
Total fee | Free |
Mode of learning | Online |
Difficulty level | Intermediate |
Official Website | Explore Free Course  |
Credential | Certificate |
Excel Fundamentals for Data Analysis at Coursera Highlights
- Shareable Certificate Earn a Certificate upon completion
- 100% online Start instantly and learn at your own schedule.
- Course 1 of 3 in the Excel Skills for Data Analytics and Visualization Specialization
- Flexible deadlines Reset deadlines in accordance to your schedule.
- Intermediate Level
- Approx. 15 hours to complete
- English Subtitles: Arabic, French, Portuguese (European), Italian, Vietnamese, German, Russian, English, Spanish
Excel Fundamentals for Data Analysis at Coursera Course details
- 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.
Excel Fundamentals for Data Analysis at Coursera Curriculum
Welcome and critical information
Course Introduction
Welcome to Excel Fundamentals for Data Analysis
Course goals and weekly learning objectives
Important information about versions and regions
Week 1 Introduction
Excel functions for combining text values
Functions that split text data
Combining text functions
Cleaning data and changing case
Removing and replacing text characters
Read me before you start: Quizzes and Navigation
Download the Week 1 workbooks
Week 1 Practice Challenge
Week 1 Toolbox
Excel functions for combining text values
Functions that split text data
Combining text functions
Cleaning data and changing case
Removing and replacing text characters
Cleaning and manipulating text: Test your skills
Working with numbers and dates
Week 2 Introduction
Converting Data with VALUE and TEXT
Understanding dates and basic date functions
Generating Valid Dates using the DATE function
Calculations with Dates and using DAYS, NETWORKDAYS and WORKDAY
More sophisticated date calculations with EOMONTH and EDATE
Download the Week 2 workbooks
Week 2 Practice Challenge
Week 2 Toolbox
Converting Data with VALUE and TEXT
Understanding dates and basic date functions
Generating Valid Dates using the DATE function
Calculations with Dates and using DAYS, NETWORKDAYS and WORKDAY
More sophisticated date calculations with EOMONTH and EDATE
Working with numbers and dates: Test your skills
Defined Names for working more effectively with data
Week 3 Introduction
Cell Referencing and Naming
Defined Names and Create from Selection
Managing Names
Calculations with Named Ranges
Automating Data Validation with Named Ranges
Download the Week 3 workbooks
Week 3 Practice Challenge
Week 3 Toolbox
Cell Referencing and Naming
Defined Names and Create from Selection
Managing Names
Calculations with Named Ranges
Automating Data Validation with Named Ranges
Defined Names for working more effectively with data: Test your skills
Tables for automating data manipulation
Week 4 Introduction
Introduction to Tables
Customising Tables
Sorting and Filtering Tables
Table Calculations and Structured References
Automation with Tables
Download the Week 4 workbooks
Week 4 Practice Challenge
Week 4 Toolbox
Introduction to Tables
Customising Tables
Sorting and Filtering Tables
Table Calculations and Structured References
Automation with Tables
Tables for automating data manipulation: Test your skills
Logical and lookup functions
Week 5 Introduction
Apply logical operations to data using IF
Nested IF, AND and OR
Categorising data with VLOOKUP
Matching data with VLOOKUP and XLOOKUP
Power Lookups with INDEX and MATCH
Download the Week 5 workbooks
Week 5 Practice Challenge
Week 5 Toolbox
Apply logical operations to data using IF
Nested IF, AND and OR
Categorising data with VLOOKUP
Matching data with VLOOKUP and XLOOKUP
Power Lookups with INDEX and MATCH
Logical and lookup functions: Test your skills
Final assessment
Other courses offered by Coursera
Student Forum
Anything you would want to ask experts?