dots bg

D25A418

Course Instructor: Chelsee Williams

FREE

dots bg

Course Overview

Schedule of Classes

Course Curriculum

1 Subject

D25A418

65 Learning Materials

Fundamentals of Excel

Excel Applications

Video
00:07:19

Understanding the Excel Interface

Video
00:16:43

Sorting and Filtering

Video
00:15:18

Conditional Formatting

Video
00:08:59

Introductions to Statistical Functions

Video
00:09:39

Introduction to Mathematical Functions

Video
00:08:54

Introduction to Lookup Functions

Video
00:08:15

Introduction to Index and Match

Video
00:07:50

Introduction to Pivot Tables

Video
00:10:16

Introduction to Pivot Charts

Video
00:11:06

Introduction to Logical Function

Video
00:06:37

Formatting Cells based on Logical Functions

Video
00:04:53

Introduction to Text Functions

Video
00:06:43

Formatting cells based on Text Functions

Video
00:09:22

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

Scenario Manager

Video
00:07:48

Goal Seek Analysis

Video
00:04:57

Data Tables

Video
00:17:37

The Solver Package

Video
00:07:02

Data Visualization Best Practices

Video
00:09:10

Types of Charts in Excel

Video
00:04:53

Creating and Formatting Charts

Video
00:03:48

Introduction to Linear Regression

Video
00:10:11

Preliminary Forecasting Analysis

Video
00:06:51

Python

Real world use cases of Python

Video
00:04:42

Installation for Windows

Video
00:04:49

Introduction to Variables

Video
00:05:58

Introduction to Data Types and Type Casting

Video
00:06:26

Scope of Variables

Video
00:08:19

Introduction to Operators

Video
00:19:05

Introduction to Lists and Tuples

Video
00:14:09

Introduction to Sets and Dictionaries

Video
00:12:13

Introduction to Stacks and Queues

Video
00:06:58

Introduction to Space and Time Complexity

Video
00:13:27

Introduction to Sorting Algorithms

Video
00:08:37

Introduction to Searching Algorithms

Video
00:08:48

Introduction to Parameters and Arguments

Video
00:15:20

Introduction to Python Modules

Video
00:05:40

Introduction to Filter, Map, and Zip Functions

Video
00:13:45

4 Introduction to List, Set and Dictionary Comprehensions

Video
00:10:24

Introduction to Lambda Functions

Video
00:07:04

Introduction to Analytical and Aggregate Functions

Video
00:08:09

Introduction to Strings

Introduction to Important String Functions

Introduction to String Formatting and User Input

Video
00:08:31

Introduction to Meta Characters

Video
00:22:31

Introduction to Built-in Functions for Regular Expressions

Video
00:07:46

Special Characters and Sets for Regular Expressions

Video
00:07:31

Introduction to Conditional Statements

Video
00:06:37

Introduction to For Loops

Video
00:04:20

3 Introduction to While Loops

Video
00:05:16

Introduction to Break and Continue

Video
00:03:10

Using Conditional Statements in Loops

Video
00:05:52

Nested Loops and Conditional Statements

Video
00:07:11

Introduction to OOPs Concept

Video
00:13:44

Introduction to Inheritance

Video
00:04:52

Introduction to Encapsulation

Video
00:03:29

Introduction to Polymorphism

Video
00:05:24

Introduction to DateTime and TimeDelta Class

Video
00:05:18

Introduction to Strings

Video
00:05:44

Introduction to Important String Functions

Video
00:10:48

DBA syllabus

DBA curriculum

PDF

Course Instructor

tutor image

Chelsee Williams

4 Courses   •   5 Students