Learn Data Analysis from Zero

Meet Nokibul Alam, who has completed his graduation from North South University and gathered working experience from DBL Group.
He is the instructor of "Zero to MS Excel" course.

1) Ribbon, Tab, Cell, and all related basics
2) Shortcut key, Quick Access Toolbar, Basic Design and Formating
3) Excel data types, Types of Errors.
4) Different types of copy, paste special
5) Formula and Functions
Theory of formula and functions
What is cell reference and its types (Related, Mixed, Absolute)
Type of Function/Formula
1 Aggregate functions:
Sum, Sumif, Sumifs, Count, Counta, Countblank, Countif,
Countifs, Min, Minifs, Max, Maxifs
Theory and detailed description of Pivot table (Facilitator)
2 Logical / Boolean function/formula (If, isblank, isnumber,
istext, iserror)
Theory (If Vs Vlookup which one is best)
3 Lookup Function/Formula:
Theory and basic type of Vlookup
Vlookup, Hlookup (advantage and disadvantage)
Index and Match (advantage and disadvantage)
Xlookup (advantage and disadvantage)
Types of lookup (One way and Two way lookup)
Choose
Facilitator (Automation)
Name Range (adv and disadv)
Table features (adv)
4 Text Function/Formulas:
Ampersand (&), Concatenate, Concat, TextJoin, Text,
Rept
Data Cleaning (Left, Mid, Right, Len, Search, Proper,
Lower, Upper, Trim, Clean)
Facilitator:
3 ways of Data Extraction (Flash Fill, Text to Column,
Power Query)
Adv and disadv
5 Date Functions/Formula
Today, Now, EOMONTH, EDATE, Day, Year, Month,
Round, Roundup, Rounddown
6 Array Function/ Formula
Theory (Aggregate vs Array)
Large, Small, Transpose, Frequency, Array formula
using Sumifs.
Sort, Unique, Sequence

6) Data analysis tools
Sort, Filter, And, Or Logic, Advance Filter,
Conditional Formatting
Charts and Graphs (Column, Bar, Pie, Line, Scatter plot)
Some Automation (Power Query)
7) Data Entry and Data Validation
List, Dropdown
Consolidation, 2D Sum, 3D Sum



8) Lookup is nothing but a Relationship

Thanks to all.