Beginner
PKH DA - Database management and Spreadsheets
The complete data analytics course you need to master spreadsheets and Excel
You will learn:
- Basics of database management
- Microsoft Excel
- Google sheets
- Spreadsheet tools
Curriculum
- 6 Sections
- 15 Lessons
- 22h 48m Duration
Week 1 - Introduction to spreadsheets
2 Lessons
- 1 - What can a spreadsheet do?
- 2 - Solving a business case
Week 2 - Simple spreadsheet functions and tools
3 Lessons
- 1 - Basic table and charts interpretation
- 2 - Simple functions and references
- 3 - Basic queries
Week 3 - Spreadsheets
2 Lessons
- 1 - Data visualisation
- 2 - Assignment 1
Week 4 - Spreadsheets
3 Lessons
- 1 - Data cleaning
- 2 - Data wrangling
- 3 - Assignment 1 (solution)
Week 5 - Spreadsheets
2 Lessons
- 1 - Basic statistical concepts
- 2 - Basic statistical concepts (part 2)
Bonus: Careers in Data
3 Lessons
- Getting ready to search for roles
- Careers in Data
- Getting started in Big Data
Related Courses
Beginner
Data Analytics with Jane (3.0)
Popular choice
- Database management and spreadsheets (Google spreadsheets, Microsoft Excel)
75h 23m
0
1
19
Intermediate
