Welcome and critical information-About the course
Course Introduction
()
Welcome to Excel Fundamentals for Data Analysis
Course goals and weekly learning objectives
Important information about versions and regions
Cleaning and manipulating text-Scenario: Cleaning and manipulating text
Week 1 Introduction
()
Cleaning and manipulating text-Practice Videos and Challenges
Read me before you start: Quizzes and Navigation
Download the Week 1 workbooks
Excel functions for combining text values
()
Functions that split text data
()
Combining text functions
()
Cleaning data and changing case
()
Removing and replacing text characters
()
Week 1 Practice Challenge
Cleaning and manipulating text-Toolbox
Week 1 Toolbox
Working with numbers and dates-Scenario: Working with numbers and dates
Week 2 Introduction
()
Working with numbers and dates-Practice Videos and Challenges
Download the Week 2 workbooks
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
()
Week 2 Practice Challenge
Working with numbers and dates-Toolbox
Week 2 Toolbox
Defined Names for working more effectively with data-Scenario: Defined Names for working more effectively with data
Week 3 Introduction
()
Defined Names for working more effectively with data-Practice Videos and Challenges
Download the Week 3 workbooks
Cell Referencing and Naming
()
Defined Names and Create from Selection
()
Managing Names
()
Calculations with Named Ranges
()
Automating Data Validation with Named Ranges
()
Week 3 Practice Challenge
Defined Names for working more effectively with data-Toolbox
Week 3 Toolbox
Tables for automating data manipulation-Scenario: Tables for automating data manipulation
Week 4 Introduction
()
Tables for automating data manipulation-Practice Videos and Challenges
Download the Week 4 workbooks
Introduction to Tables
()
Customising Tables
()
Sorting and Filtering Tables
()
Table Calculations and Structured References
()
Automation with Tables
()
Week 4 Practice Challenge
Tables for automating data manipulation-Toolbox
Week 4 Toolbox
Logical and lookup functions-Scenario: Logical and lookup functions
Week 5 Introduction
()
Logical and lookup functions-Practice Videos and Challenges
Download the Week 5 workbooks
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
()
Week 5 Practice Challenge
Logical and lookup functions-Toolbox
Week 5 Toolbox
C1W5 Practice Challenge-x8OoUsOpTS2DqFLDqe0tyg.xlsx
(232 KB)
C1W5 Practice Challenge Soln-ltQm5HwcQ9WUJuR8HDPVgw.xlsx
(256 KB)
C1W5 Practice Challenge XLOOKUP Soln-KjmGZ3_uQVS5hmd_7jFUZw.xlsx
(256 KB)
C1W3 Practice Challenge-i7J8mpFxS9uyfJqRcXvbrw.xlsx
(103 KB)
C1W4 Workbooks-mJgBYWd-T_mYAWFnfh_5zQ.zip
(345 KB)
C1W3 Practice Challenge Soln-Xl_xvtsXQ6-f8b7bF-OveQ.xlsx
(105 KB)
C1W4 Practice Challenge-s1YOB3E_SkWWDgdxP1pFVQ.xlsx
(141 KB)
C1W4 Practice Challenge Soln-oc3mLTaMTQaN5i02jM0GGQ.xlsx
(149 KB)
C1W5 Workbooks-caEQGq09RcGhEBqtPRXB_w.zip
(14.2 MB)
C1W1 Workbooks-TPWyd8IpTc21snfCKS3NUA.zip
(374 KB)
C1W3 Workbooks-5Ed5pNDJTGOHeaTQyXxj6A.zip
(367 KB)
C1W2 Workbooks-hzuY6920Q0m7mOvdtANJHg.zip
(333 KB)
C1W2 Practice Challenge-XvFZDTiiT8exWQ04oi_HFg.xlsx
(59 KB)
C1W2 Practice Challenge Soln-OgdIuCo7ReKHSLgqOxXidQ.xlsx
(61 KB)
C1W1 Practice Challenge-R0UcxrUVTrSFHMa1Fc60Kg.xlsx
(301 KB)
C1W1 Practice Challenge Soln-pRKDWY_STGCSg1mP0gxgEw.xlsx
(304 KB)