bk-guide - VideoAndMovie

Guide regarding Excel, Word, AutoCAD, and other Computer related subjects are available here.

Super trick to unhide all sheets in excel

3:43

Super trick to unhide all sheets in excel

Summing by cells colour in excel

4:11

Summing by cells colour in excel

DATEDIF Function in Excel

10:47

DATEDIF Function in Excel

How to create searchable drop down list in excel

15:40

How to create searchable drop down list in excel

Get search result as you Type in excel

10:30

Get search result as you Type in excel

How to get multiple match result in excel

11:14

How to get multiple match result in excel

Amazing use of sumproduct with offset to find dynamic sum

12:20

Amazing use of sumproduct with offset to find dynamic sum

how to use offset function for dynamic range

9:16

how to use offset function for dynamic range

How to use windows clipboard

5:11

How to use windows clipboard

How to sum feet and inches in excel

10:35

How to sum feet and inches in excel

How to use fill justify in excel

3:53

How to use fill justify in excel

Rearrange and filter with advance filter

12:02

Rearrange and filter with advance filter

Index with sumproduct in excel

10:29

Index with sumproduct in excel

fantastic use of vlookup with sumproduct in excel

7:21

fantastic use of vlookup with sumproduct in excel

Advance use of sumproduct

15:51

Advance use of sumproduct

Extract unique list using advance filter

13:03

Extract unique list using advance filter

How to use Split in MS Excel & Word

7:49

How to use Split in MS Excel & Word

Fantastic create tick mark or cross mark in excel

5:08

Fantastic create tick mark or cross mark in excel

Copy Paste But Not Simple

3:01

Copy Paste But Not Simple

Just amazing find & replace in excel

9:21

Just amazing find & replace in excel

filtering merged cells in excel

6:23

filtering merged cells in excel

Use VLOOKUP Smartly

8:08

Use VLOOKUP Smartly

Dynamic sum formula in excel

21:56

Dynamic sum formula in excel

Custom Sort in Excel

7:42

Custom Sort in Excel

how to invert a range

11:24

how to invert a range

if with partial text match

9:14

if with partial text match

BAR CHART FOR PROJECT ACTIVITIES GANTT CHART IN EXCEL

6:39

BAR CHART FOR PROJECT ACTIVITIES GANTT CHART IN EXCEL

comparative histogram

7:05

comparative histogram

Displaying conditional colors in a column chart

11:11

Displaying conditional colors in a column chart

How to Draw Shapes and Text Box in Chart in Excel

2:32

How to Draw Shapes and Text Box in Chart in Excel