Learn Data Analysis from Zero

10/02/2022

08/02/2022

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.

08/02/2022

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

07/02/2022

Thanks to all.

07/02/2022

https://meet.google.com/fra-ahwx-cft

We will start at 10 PM sharp

Real-time meetings by Google. Using your browser, share your video, desktop, and presentations with teammates and customers.

07/02/2022

Afnan Al Reza, a Territory Manager of bKash, will explain why university students should learn data analysis tools like MS EXCEL during their student life and how MS Excel knowledge is helping him to complete his day-to-day activities.
To meet our guest, join today's session at 10.00 PM on 'Why Excel is important?"