dots bg

Excel

Course Instructor Meritshot

FREE

dots bg

Course Overview

Schedule of Classes

Course Curriculum

1 Subject

Excel

25 Learning Materials

Fundamentals of Excel

Excel Applications

Video
00:07:17

Understanding the Excel Interface

Video
00:16:41

Sorting and Filtering

Video
00:15:17

Conditional Formatting

Video
00:08:59

Statistical and Mathematical Functions in Excel

Introductions to Statistical Functions

Video
00:09:39

Introduction to Mathematical Functions

Video
00:08:57

Lookup functions, and Pivot Tables

Introduction to Lookup Functions

Video
00:08:16

Introduction to Index and Match

Video
00:07:48

Introduction to Pivot Tables

Video
00:10:15

Introduction to Pivot Charts

Video
00:11:05

Logical Functions, and Text Functions

Introduction to logical function

Video
00:06:35

Formatting Cells based on Logical Functions

Video
00:04:52

Introduction to Text Functions

Video
00:06:41

Formatting cells based on Text Functions

Video
00:09:21

Data Cleaning, and Feature engineering

Introduction to Date and Time Functions

Video
00:07:11

Basics of Data Cleaning in Excel

Video
00:09:16

Basics of Feature Engineering in Excel

Video
00:07:13

Introduction to Power Query in Excel

Video
00:05:10

What If analysis

Scenario Manager

Video
00:07:47

Goal Seek Analysis

Video
00:04:56

Data Tables

Video
00:17:35

The Solver Package

Video
00:07:01

Charts and Dashboards

Data Visualization Best Practices

Video
00:09:11

Types of Charts in Excel

Video
00:04:54

Creating and Formatting Charts

Video
00:03:47

Course Instructor

tutor image

Meritshot

108 Courses   •   26272 Students