Welcome to Free Mini Data Science Bootcamp Day 1 – Excel! Today we will cover Excel basics for beginners and look at introductory data-management techniques to prepare for learning data science. This bootcamp is free and gives everyone a chance to learn and develop data skills together.
Sound check and overview
Before we begin, let’s check that everyone can hear and see clearly. If you have a question or problem, type it in the chat. Today’s topic is Excel, an important tool for data analysis.
Quiz and certificate
After today’s lesson, there will be a 10-question quiz to check your understanding. If you answer at least 8 of the 10 questions correctly, you will receive a certificate confirming your basic Excel knowledge. You can take the quiz twice.
Excel: basics and overview
Excel is a widely used tool for managing and analyzing data across many industries. Today we will cover Excel basics, from entering data to using Custom Data Types and the Analyze Data feature.
Data, Information, Knowledge, Wisdom (DIKW) model
Understand the DIKW model, a framework for understanding the relationships between data, information, knowledge, and wisdom in data analysis.
Excel: tools and limitations
Explore the tools available in Excel and their limitations to understand what Excel can and cannot do when managing and analyzing data.
Basic data management
Learn basic data-management techniques in Excel, such as filtering and sorting data, creating a multi-level sort, and using the Filter function to organize and analyze data.
Using Analyze Data
Understand and learn how to use Excel's Analyze Data tool for basic analysis.
Filtering and sorting data
Learn to filter and sort data in Excel to find and organize information according to the conditions you want.
Creating a multi-level sort
Learn how to create a multi-level sort to order data by several priorities.
Using the Filter function
Learn to use the Filter function to filter data according to specified conditions.
Downloading files and slides
If you want to download the example files and lesson slides, you can get them from the online school.
Excel: entering numbers, text, and Boolean values
Start by learning the basics of entering data in Excel, including the differences between numbers, text, and Boolean values.
Using Custom Data Types
Learn to use Custom Data Types to organize data and make it easier to analyze.
Using Analyze Data
Take a closer look at using Excel's Analyze Data tool to analyze data.
Filtering data
Review how to filter data in Excel to find the information you need.
Sorting data
Review how to sort data in Excel.
Creating a multi-level sort
Review how to create a multi-level sort.
Using the Filter function
Review how to use the Filter function to filter data.
Getting started
Welcome and bootcamp overview
Start with a welcome and overview of Mini Data Science Bootcamp Day 1 – Excel, and learn about the goals and topics for today's session.
Sound check and ways to watch
Check that audio and video are working and learn how to watch through Facebook and YouTube.
Downloading files and slides
Learn how to download example files and the lesson slides.
Quiz and certificate
Quiz details
Learn the details of the quiz for receiving a certificate.
Passing score and number of attempts
Learn the passing score and how many times you can take the quiz.
Excel: basics and overview
Excel: entering numbers, text, and Boolean values
Learn the basics of entering data in Excel, including the differences between numbers, text, and Boolean values.
Excel: using Custom Data Types
Learn how to use Custom Data Types to manage data.
Setting Data Types in Excel
Learn how to set a data type in Excel.
Using the Analyze Data function
Take a closer look at Excel's Analyze Data tool.
Data management
Filtering data
Learn how to filter data in Excel.
Sorting data
Learn how to sort data in Excel.
Creating a multi-level sort
Learn how to create a multi-level sort.
Using the Filter function
Learn how to use the Filter function.
Summary and next steps
Preparing for Days 2 and 3
Learn how to prepare for the next two days of classes.
Questions and answers
Time for learners to ask questions.
- Learning Excel in the bootcamp
- Taking the quiz to earn a certificate
- The differences between numbers, text, and Boolean values in Excel
- Using Custom Data Types in Excel
- Using the Analyze Data function
- Filtering and sorting data
- Creating a multi-level sort
- Using the Filter function
💬 Get free financial guidance from an expert. Click to add us on LINE.
Or scan the QR code to add us.
