Complete MS Excel Course | Basics to Pro – Data Analytics

Uncategorized

Course Content

Module 1: Introduction to Excel

Lesson 1.1: Introduction to Excel Interface
Lesson 1.2: Basic Excel Functions
Quiz 1: Excel Basics

Module 2: Data Importing and Preparation

Module 3: Data Structuring and Organization

Module 4: Basics Formulas – Data Analysis

Lesson 4.1: SUM Function in MS Excel – Data Analysis
Lesson 4.2: COUNT, COUNTA, COUNTBLANK Function in MS Excel – Data Analysis
Lesson 4.3: AVERAGE, AVERAGEA Function in MS Excel – Data Analysis
Lesson 4.4: MAX, MIN, LARGE and SMALL Function in MS Excel – Data Analysis
Lesson 4.5: COUNTIF, COUNTIFS Function in MS Excel – Data Analysis
Lesson 4.6: SUMIF and SUMIFS Function in MS Excel – Data Analysis
Lesson 4.7: AVERAGEIF and AVERAGEIFS Function in MS Excel – Data Analysis
Lesson 4.8: DAY, MONTH and YEAR – Working with Date & Time Data
Lesson 4.9: DATE, TODAY and NOW – Working with Date & Time Data
Lesson 4.9.1: NETWORKDAYS and NETWORKDAYS.INTL – Working with Date & Time Data
Lesson 4.9.2: WEEKDAY and WEEKDAY.INTL – Working with Date & Time Data

Student Ratings & Reviews

No Review Yet

No Review Yet