Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Introduction to Data Analysis with Excel

Simon Sez IT via YouTube

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Dive into a comprehensive 2-hour training tutorial on data analysis with Excel. Learn to navigate Excel, understand data types, view and enter data, format cells, and master Excel formulas and functions. Explore data quality concepts, import file data, remove duplicates, identify data attributes, and clean datasets. Practice your skills with two hands-on exercises using downloadable course files. Gain essential spreadsheet skills for effective data analysis, from basic navigation to advanced data management techniques.

Syllabus

- Simon Sez IT Intro
- Course Introduction
- Navigating Excel
- Data Types in Excel
- Viewing, Entering and Copying Data
- Formatting and Data Types in Excel
- Excel Formula Basics
- Exploring Excel Functions
- Referencing Data in Formulas
- Exercise 01
- Introduction to Data Quality
- Importing File Data
- Removing Duplicate Data
- Identifying Data Attributes
- Cleaning Data
- Exercise 02

Taught by

Simon Sez IT

Reviews

5.0 rating, based on 1 Class Central review

Start your review of Introduction to Data Analysis with Excel

  • Profile image for Shola Smith
    Shola Smith
    Absolutely interesting, as a excel user myself the presenter made it more easier in his presentation.

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.