MS Excel Basic to Intermediate Free Course

By Mahabub Hossain Categories: Free, MS Excel, Self- Paced

01. Data Entry & Formatting
02. Data Entry with Restriction
03. Data Cleaning & Trimming
04. Data Import Method
05. Data Forecast
06. Basic to Intermediate Functions
07. Basic to Advanced Functions
08. Chart Creation & Data Visualization
09. Function's Associate Method
10. Advanced Features
11. Time-Saving Excel Tips

Course Content

Class 01- Excel Interface Overview

Class 01- Excel Interface Overview

05:57

Class 02 Basic Arithmatic Furmulas

Class- 03 Reference

Class- 04 Sort by Column & Row

Class-05 Conditional Formatting

Class-06 Data Validation

Class-07 Text to Columns, Flash Fill & Remove Duplicate

Class-08 Chart

Class-09 DATE Function

Class-10 SUMIF, AVERAGRIF & COUNTIF

Class-11 IF Function

Class-12 Clean and Trim Function

Class-13 Lookup & Reference Function 01

Class-14 Lookup & Reference Function 02

Class-15 Vlookup with Choose Function

Class-16 How to Import JSON File

Class-17 What If Analysis

Class-18 Without Password Recover Your Protect Sheet

Class-19 Enigma Machine in Excel 1

Conclusion with Bonus and Quiz

Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.

selected template

Student Ratings & Reviews

No Review Yet

No Review Yet

A course by

Mahabub Hossain

Microsoft Certified Office 365 Expert

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

✕