Introduction to Excel v1.0
Learn how to use Excel for data manipulation, visualisation, and analysis. This course gives you the skills to extract meaningful insights from data and make informed decisions in business contexts.
Data Analysis Tutorbot: Scarlette
Welcome to your course!
What you will learn in this course?
Excel for Data Analysis Syllabus Document
1.1 Introduction to Excel
1.2 How to Import Data
1.3 Import Data from CSV to Excel Activity
1.4 Cleaning Data
1.5 Formatting Data
1.6 Protecting Data
1.7 Test Your Knowledge Quiz
Introduction
Lesson 1 - Summarising Data
Lesson 2 - Data Transformation
Lesson 3 - Sorting Data
Lesson 4 - Filtering Data
Test Your Knowledge Quiz
Introduction to Data Visualization in Excel
Lesson 1 - Conditional Formatting
Lesson 2 - Different Types of Visual Displays
Lesson 3 - Pivot Tables
Test Your Knowledge Quiz
Course Feedback Form