Data Analysis using Microsoft Excel - Intelligent Secure Data (ISD) CO. LTD

Data Analysis using Microsoft Excel

0(0 Ratings)

Level

All Levels
Total Enrolled

4
Duration

2 hours 26 minutes
Last Updated

December 19, 2024
Certificate

Certificate of completion

Level

All Levels
Total Enrolled

4
Duration

2 hours 26 minutes
Last Updated

December 19, 2024
Certificate

Certificate of completion

Course content:

Data Analysis Microsoft Excel

Introduction to Excel

01:13
Excel Resources Files

00:09
The Excel Interface

06:38
Understanding Worksheets and Workbooks in Excel

02:34
Basic Formulas and Functions

05:15
Sorting and Filtering Data

01:24
Data Validation for Consistency

01:54
Removing Duplicates

01:01
Splitting Data

01:36
Handling Missing Data

01:01
Data Standardization

00:37
Statistical Functions (AVERAGE, MEDIAN, MODE)

01:02
VLOOKUP and HLOOKUP

03:21
Logical Functions (IF, AND, OR,AVERAGEIF,COUNTIF)

11:39
Date and Time Functions

08:41
Strings Functions

11:27
Pivot Tables and Pivot Charts

07:23
Using Power Query for Data Transformation

01:59
Connect to a data source

04:00
Remove N/A rows

01:58
Use first row as header

00:28
Pivot and Unpivot operators

01:27
Split columns

01:27
change data types

00:40
Append operator

07:25
load and Analysis Data

01:16
Project : Analyzing customer purchase behaviors and trends.

58:27
Excel quiz

Navigate the Excel interface and understand worksheets and workbooks.
Apply basic formulas and functions for data analysis.
Use sorting, filtering, and data validation to manage data effectively.
Handle duplicates, missing data, and perform Find and Replace.
Master VLOOKUP, HLOOKUP, and pivot tables for data manipulation.
Utilize statistical functions like AVERAGE, MEDIAN, and MODE.
Transform data with Power Query
PROJECT

No Review Yet

Instructor:

Eng Mohammed

Big Data Engineer and Data Consultant @ ISD Company

Want to receive push notifications for all major on-site activities?

✕