ADVANCE EXCEL FULL COURSE IN HINDI Excel Tutorial For Beginners | Excel Training
In this video we are going to learn very important functions and formulas which will help you in your career. your office work will be get easy after using this functions and formulas, We did a lot of research to find out useable and tricky formulas to make your work smooth. Please watch Complete video & do Practice for best result.
Chapters of the Video :
00:00:00 Intro
00:00:45 Basic Function & Lock Cell (Absolute Reference)
00:06:50 Count Function
00:12:45 AND/OR/NOT Function
00:21:50 Date Function
00:31:38 Text Function
00:43:11 Advanced Filter
00:47:27 Custom Sorting
00:52:41 Data Base Function
00:57:26 Conditional Formatting
01:07:34 VLOOKUP
01:13:06 VLOOKUP with COLUMN Function
01:21:21 Match & Index Function
01:33:18 Data Validation
01:40:23 Consolidate Data
01:44:20 PMT
02:01:10 Data Table
02:06:01 Sum IF & Average If
02:16:03 Macro with 2 Example
02:23:00 Rank & Rank Average
02:25:40 Pivot Table With slicer and Charts
02:38:00 Transpose Data
Join this channel to get access to perks:
/ @omidaeducation7465
