Power BI Fundamentals - Create visualizations and dashboards from scratch
NY State-Licensed Certificates in Design, Coding & AI — Online
Overview
Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
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