Analyzing Data with Excel IBM Full Course

الوصف:

Want to learn how to analyze data effectively using Excel? In this video, we’ll walk you through the essential Excel tools and techniques to help you clean, visualize, and interpret data like a pro. Whether you’re a beginner or looking to refine your skills, this tutorial covers data cleaning and preparation, the use of Excel functions for analysis such as SUM, AVERAGE, IF, and VLOOKUP, pivot tables for advanced data insights, and filtering and sorting efficiently. By the end of the video, you’ll be able to make data-driven decisions with confidence. 00:00:00 Course Introduction 00:02:58 Introduction to Spreadsheets 00:08:27 Spreadsheet Basics - Part 1 00:14:13 Spreadsheet Basics - Part 2 00:21:08 Viewpoints_ Using Spreadsheets as a Data Analysis Tool 00:26:30 Viewing, Entering, and Editing Data 00:32:21 Copying, Filling, and Formatting Cells and Data 00:39:59 The Basics of Formulas 00:47:06 Intro to Functions 00:52:35 Referencing Data in Formulas 01:01:57 Introduction to Data Quality 01:05:28 Importing File Data 01:11:04 Viewpoints_ Data Quality and Privacy 01:15:52 Removing Duplicated or Inaccurate Data and Empty Rows 01:24:40 Dealing with Inconsistencies in Data 01:33:42 More Excel Features for Cleaning Data 01:39:56 Viewpoints_ Issues with Data Quality 01:43:58 Intro to Analyzing Data Using Spreadsheets 01:49:31 Filtering and Sorting Data in Excel 01:56:57 Viewpoints_ Filtering and Sorting 01:58:52 Useful Functions for Data Analysis 02:10:16 Using VLOOKUP and HLOOKUP Functions 02:19:53 Introduction to Creating Pivot Tables in Excel 02:27:40 Viewpoints_ Pivot Tables 02:31:07 Pivot Table Features