Excel Basics for Data Analysis

Excel Basics for Data Analysis

वर्ष

2020

शैली

Data

अभी चल रहा है: EP 1 / 8

Full

Now Playing

Excel Basics for Data Analysis

DataData

वर्ष

2020

अवधि

166m

Spreadsheet tools like Excel are an essential tool for working with data - whether for data analytics, business, marketing, or research. This course is designed to give you a basic working knowledge of Excel and how to use it for analyzing data. This course is suitable for those who are interested in pursuing a career in data analysis or data science, as well as anyone looking to use Excel for data analysis in their own domain. No prior experience with spreadsheets or coding is required - all you need is a device with a modern web browser and the ability to create a Microsoft account to access Excel online at no cost. If you have a desktop version of Excel, you can also easily follow along with the course. Throughout this course, you'll gain valuable experience working with data sets and spreadsheets. We'll start by introducing you to spreadsheets like Microsoft Excel and Google Sheets, and show you how to load data from multiple formats. From there, you'll learn how to perform basic data wrangling and cleansing tasks using functions, and expand your knowledge of data analysis through the use of filtering, sorting, and pivot tables. There is a strong focus on practice and applied learning in this course. With each lab, you'll have the opportunity to manipulate data and gain hands-on experience using Excel. You'll learn how to clean and format your data efficiently, and convert it into a pivot table to make it more organized and readable. The final project will allow you to showcase your newly acquired data analysis skills by working with real data sets and spreadsheets. By the end of this course, you'll have a solid foundation in using Excel for data analysis. You'll have worked with multiple data sets and spreadsheets, and will have the skills and knowledge needed to effectively clean and analyze data without having to learn any code. So let's get started!

आपको ये भी पसंद आ सकते हैं

What is Data Science?

Databases and SQL for Data Science with Python

Google Data Analytics Capstone: Complete a Case Study

Data Analysis with R Programming

ड्रामा★ 7.9

KS2 Drama

गणित★ 7.4

SS 1 Mathematics

गणित★ 7.5

SS 2 Mathematics

गणित★ 7.8

Primary 1 Mathematics

ड्रामा★ 7.2

KS3 Drama

व्यवसाय और वित्त★ 7.6

SS 1 Business & Finance

व्यवसाय और वित्त★ 7.8

JS 1 Business & Finance

अंग्रेजी★ 7.7

Primary 5 English

कार्टून★ 0

Shapes, Colors, & Music by CoComelon

CoComelon Lane | NEW Netflix Kids Show

Vehicle Adventures★ 6.7

BabyBus | Monster Truck | Fire Truck, Police Car, Ambulance | Cars for Kids | Kids Songs

कार्टून★ 0

Happy Holidays from Netflix Jr!

Introduction to Data Analytics

Excel Basics for Data Analysis

कार्टून★ 0

Kids Songs by CoComelon

CoComelon

Data Science Methodology

Ask Questions to Make Data-Driven Decisions

Process Data from Dirty to Clean

Data Visualization and Dashboards with Excel and Cognos