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
7:17

Understanding the Excel Interface

Video
16:41

Sorting and Filtering

Video
15:17

Conditional Formatting

Video
8:59

Statistical and Mathematical Functions in Excel

Introductions to Statistical Functions

Video
9:39

Introduction to Mathematical Functions

Video
8:57

Lookup functions, and Pivot Tables

Introduction to Lookup Functions

Video
8:16

Introduction to Index and Match

Video
7:48

Introduction to Pivot Tables

Video
10:15

Introduction to Pivot Charts

Video
11:5

Logical Functions, and Text Functions

Introduction to logical function

Video
6:35

Formatting Cells based on Logical Functions

Video
4:52

Introduction to Text Functions

Video
6:41

Formatting cells based on Text Functions

Video
9:21

Data Cleaning, and Feature engineering

Introduction to Date and Time Functions

Video
7:11

Basics of Data Cleaning in Excel

Video
9:16

Basics of Feature Engineering in Excel

Video
7:13

Introduction to Power Query in Excel

Video
5:10

What If analysis

Scenario Manager

Video
7:47

Goal Seek Analysis

Video
4:56

Data Tables

Video
17:35

The Solver Package

Video
7:1

Charts and Dashboards

Data Visualization Best Practices

Video
9:11

Types of Charts in Excel

Video
4:54

Creating and Formatting Charts

Video
3:47

Course Instructor

tutor image

Meritshot

71 Courses   •   15529 Students