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.
Buy Now AED 239.99 + VAT
Monthly Subscription Starting at AED 99 + VAT
- Level Professional
- Duration 15 hours
- Course by Macquarie University
-
Offered by
About
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.Modules
About the course
-
1
Videos
-
3
Readings
-
1
Discussion
1
Discussions
- Set your goals and be successful
1
Videos
- Course Introduction
3
Readings
- Welcome to Excel Fundamentals for Data Analysis
- Course goals and weekly learning objectives
- Important information about versions and regions
Scenario: Cleaning and manipulating text
-
1
Videos
1
Videos
- Week 1 Introduction
Practice Videos and Challenges
-
5
Videos
-
3
Readings
-
5
Assignment
5
Assignment
- Excel functions for combining text values
- Functions that split text data
- Combining text functions
- Cleaning data and changing case
- Removing and replacing text characters
5
Videos
- Excel functions for combining text values
- Functions that split text data
- Combining text functions
- Cleaning data and changing case
- Removing and replacing text characters
3
Readings
- Read me before you start: Quizzes and Navigation
- Download the Week 1 workbooks
- Week 1 Practice Challenge
Toolbox
-
1
Readings
1
Readings
- Week 1 Toolbox
Assessment
-
1
Assignment
1
Assignment
- Cleaning and manipulating text: Test your skills
Scenario: Working with numbers and dates
-
1
Videos
1
Videos
- Week 2 Introduction
Practice Videos and Challenges
-
5
Videos
-
2
Readings
-
5
Assignment
5
Assignment
- 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
5
Videos
- 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
2
Readings
- Download the Week 2 workbooks
- Week 2 Practice Challenge
Toolbox
-
1
Readings
1
Readings
- Week 2 Toolbox
Assessment
-
1
Assignment
1
Assignment
- Working with numbers and dates: Test your skills
Scenario: Defined Names for working more effectively with data
-
1
Videos
1
Videos
- Week 3 Introduction
Practice Videos and Challenges
-
5
Videos
-
2
Readings
-
5
Assignment
5
Assignment
- Cell Referencing and Naming
- Defined Names and Create from Selection
- Managing Names
- Calculations with Named Ranges
- Automating Data Validation with Named Ranges
5
Videos
- Cell Referencing and Naming
- Defined Names and Create from Selection
- Managing Names
- Calculations with Named Ranges
- Automating Data Validation with Named Ranges
2
Readings
- Download the Week 3 workbooks
- Week 3 Practice Challenge
Toolbox
-
1
Readings
1
Readings
- Week 3 Toolbox
Assessment
-
1
Assignment
1
Assignment
- Defined Names for working more effectively with data: Test your skills
Scenario: Tables for automating data manipulation
-
1
Videos
1
Videos
- Week 4 Introduction
Practice Videos and Challenges
-
5
Videos
-
2
Readings
-
5
Assignment
5
Assignment
- Introduction to Tables
- Customising Tables
- Sorting and Filtering Tables
- Table Calculations and Structured References
- Automation with Tables
5
Videos
- Introduction to Tables
- Customising Tables
- Sorting and Filtering Tables
- Table Calculations and Structured References
- Automation with Tables
2
Readings
- Download the Week 4 workbooks
- Week 4 Practice Challenge
Toolbox
-
1
Readings
1
Readings
- Week 4 Toolbox
Assessment
-
1
Assignment
1
Assignment
- Tables for automating data manipulation: Test your skills
Scenario: Logical and lookup functions
-
1
Videos
1
Videos
- Week 5 Introduction
Practice Videos and Challenges
-
5
Videos
-
2
Readings
-
5
Assignment
5
Assignment
- 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
5
Videos
- 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
2
Readings
- Download the Week 5 workbooks
- Week 5 Practice Challenge
Toolbox
-
1
Readings
1
Readings
- Week 5 Toolbox
Assessment
-
1
Assignment
1
Assignment
- Logical and lookup functions: Test your skills
Final assessment
-
1
Assignment
1
Assignment
- Final assessment
Auto Summary
"Excel Fundamentals for Data Analysis" is a professional-level course within the Data Science & AI domain, taught by Coursera. This engaging course teaches you how to utilize Excel for data analysis, covering key tools and functions for data preparation, automation, and transformation. Follow Zara's journey to enhance your learning experience. The course duration is 900 minutes and offers Starter, Professional, and Paid subscription options, perfect for those looking to build a strong foundation in Excel for advanced data analysis techniques.
Nicky Bull
Dr Prashan S. M. Karunaratne