byIT
Basics of Data Analysis with Excel
Microsoft Excel is a popular program that provides users with the ability to construct spreadsheets. We explore the basic concepts of Excel and explain how to employ various spreadsheet techniques. We show you how to use functions for data analysis. We discuss how to design the perfect formula and keep your data clean when placing it in a spreadsheet. Sign up to become a skilled Excel user capable of using this program to analyze data.
read more
Basics of Data Analysis with Excel
Master the fundamental concepts used to handle data and manipulate functions in this free online Excel training course.
Microsoft Excel is a popular program that provides users with the ability to construct spreadsheets. We explore the basic concepts of Excel and explain how to employ various spreadsheet techniques. We show you how to use functions for data analysis. We discuss how to design the perfect formula and keep your data clean when placing it in a spreadsheet. Sign up to become a skilled Excel user capable of using this program to analyze data.
A short ad will play before each lesson.
11 Lessons
Data Analytics in Excel
This module will begin by helping you examine the basics of Excel. We will also help you find knowledge on the various types of data. This course will provide you with the opportunity to examine the various types of functions in Excel. You will have answers to questions like "How can reference data in Excel?" and "How to filter data in Excel?"
1.Learning Outcomes
Continue Learning
2.Course Introduction
Continue Learning
3.Viewing and Formatting Data
Continue Learning
4.Basic Formulas in Excel
Continue Learning
5.Referencing Data in Formulas
Continue Learning
6.Data Quality
Continue Learning
7.Removing and Identifying Data
Continue Learning
8.Cleaning and Managing Data
Continue Learning
9.Sort and Concatenation Data
Continue Learning
10.Analyzing Data
Continue Learning
11.Lesson Summary
Continue Learning
1 Lessons
Course assessment
Related
Articles
White-Labeling in Online Education: Whose Credential Is It Anyway?
Udemy Announces Layoffs Without Saying ‘Layoffs’
7 Best Technical Writing Courses to Master Documentation and Communication
Duolingo’s Q4 2025: Record Revenue, Record Stock Drop, One Massive Buyback
Chinese Edtech Pivots: Well-rounded Education, Hardware, Agriculture E-commerce, Fast-Food, Garments, and More
Coursera Q4 2025: 197M Learners, ~$197M Revenue, ~$27M in Losses
Recommended Related
Courses
byIT
Foundations of ITIL 4 for Service Management
Start learning
View Details
byIT
CompTIA A+ 1000 - Part 2
Start learning
View Details
byIT
Fundamentals of NIS2 Directive - EU Cybersecurity Enhancement
Start learning
View Details
byIT
Introduction to Electronic Document Management
Start learning
View Details
byIT
Introduction to CCTV Systems & AutoCAD Layouts
Start learning
View Details
byIT
Diploma in ISO 27001:2022 - Information Security Management System (ISMS)
Start learning
View Details
