Excel from the Scratch
Course Content
Introduction
-
Connect with Trainer
00:00 -
Basic Calculation in Excel
00:00 -
Shortcuts
00:00 -
Format Painter
00:00
Module 1
-
Insert/Delete Rows and Column
00:00 -
Sorting
00:00 -
Filtering
00:00 -
Formating
00:00 -
References
00:00
Module 2
-
SUM
00:00 -
MIN
00:00 -
MAX
00:00 -
AVERAGE
00:00 -
COUNT
00:00
Module 3
-
SUM
00:00 -
MIN
00:00 -
MAX
00:00 -
AVERAGE
00:00 -
COUNT
00:00
Module 4
-
POWER
00:00 -
CEILING
00:00 -
FLOOR
00:00 -
CONCAT
00:00 -
TRIM, REPLACE & SUBSTITUTE
00:00
Module 5
-
LEFT, RIGHT & MID
00:00 -
UPPER, LOWER & PROPER
00:00 -
DATEDIF
00:00 -
IF
00:00 -
SUMIFs
00:00
Module 6
-
INDEX
00:00 -
MATCH
00:00 -
COUNTIF
00:00 -
IFERROR
00:00 -
RANK
00:00
Module 7
-
TEXT
00:00 -
RAND
00:00 -
IFNA
00:00 -
TODAY
00:00 -
OR
00:00
Module 8
-
AND
00:00 -
DATEVALUE
00:00 -
ROUNDUP
00:00 -
IFBLANK
00:00 -
MEDIAN
00:00
Module 9
-
MODE
00:00 -
YEAR
00:00 -
TRANSPOSE
00:00 -
PMT
00:00 -
PRODUCT
00:00
Module 10
-
STDEV
00:00 -
LEFTB
00:00 -
FIND
00:00 -
NOW
00:00 -
LEN
00:00
Module 11
-
INDIRECT
00:00 -
SUBSTITUTE
00:00 -
ROUNDDOWN
00:00 -
ISNUMBER
00:00 -
IFBLANK
00:00
Module 12
-
NAVIGATING SHORTCUTS
00:00 -
FORMAT PAINTERS
00:00 -
CUSTOM LISTS
00:00 -
NESTED IF
00:00 -
AND & OR
00:00
Module 13
-
IF & AND
00:00 -
IF & OR
00:00 -
COUNT IF
00:00 -
AVERAGE IF
00:00 -
SUM IF
00:00 -
COUNT IFs
00:00 -
AVERAGE Ifs
00:00
Module 14
-
SUM IFs
00:00 -
VLOOKUP
00:00 -
HLOOKUP
00:00 -
2 WAY LOOKUP
00:00 -
INDEX
00:00 -
MATCH
00:00 -
INDEX MATCH
00:00
Module 15
-
DATA VISUALISATION
00:00 -
INSERTING CHARTs
00:00 -
ELEMENTS
00:00 -
COLUMN & BAR CHARTS
00:00 -
LINE CHARTs
00:00 -
AREA CHART
00:00 -
PIE CHART
00:00
Module 16
-
DONUT CHART
00:00 -
HISTOGRAM
00:00 -
SCATTER PLOTS
00:00 -
TREE MAP CHART
00:00 -
WATERFALL CHART
00:00 -
CONDITIONAL FORMATTING
00:00 -
HEAT MAPs
00:00
Module 17
-
Completing of Course
00:00 -
Review
00:00 -
Course Certificate
00:00
Student Ratings & Reviews
No Review Yet