Macquarie University
:
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.
Meet your Peer Coordinator
Heba Ledwon
@heba
I am enthusiastic about the interplay of product value, data-driven business and experience-centered design and tech solutions. As I continue to learn, I grow in different roles and gain an overview on what helps to provide the most possible value for the Class Central community.
Schedule Jun 16th, 2021 – Jul 20th, 2021
-
Week 1W1 June 16th – June 22nd
-
1.1
Welcome and critical information
-
1.2
Cleaning and manipulating text
-
-
Week 2W2 June 23rd – June 29th
-
2.1
Working with numbers and dates
-
-
Week 3W3 June 30th – July 6th
-
3.1
Defined Names for working more effectively with data
-
-
Week 4W4 July 7th – July 13th
-
4.1
Tables for automating data manipulation
-
-
Week 5W5 July 14th – July 20th
-
5.1
Logical and lookup functions
-
5.2
Final assessment
-
