Все публикации

0:00:27

Truncate decimals #decimals #truncate #vikaljainshorts3

0:00:58

Replace first and Last name using ChatGPT in Excel

0:00:45

Pie of Pie chart in excel

0:01:02

Find intersection using conditional formatting

0:00:42

Make positive and Negative bar chart in excel

0:00:36

Remove all whitespace characters

0:01:00

3 hacks of pivot tables #pivottables #excel #vikaljain

0:00:40

Extract first and last name using text before and text after#textbefore #textafter #excel

0:00:48

Create sheets list using ChatGPT #ChatGPT #excel #vikaljain

0:01:00

Custom sorting in excel #excel #vikaljain #customsorting

0:00:44

Intersection using Xlookup #xlookup #vikaljain #excel

0:00:31

Round off Time nearest to 15 min #roundoff #excel #vikaljain

0:00:37

Split Name without Spaces in excel#splitnames #vikaljain

0:01:00

Custom formatting for rounding off numbers in Thousands, Lakhs and in Crores #customformatting#excel

0:00:41

Clean mess up in excel #vikaljain #cleanmessup #excel

0:01:01

Set Default layout of pivot tables #defaultlayout #excel #vikaljain

0:00:44

Convert negative numbers to red #negativenumbers #excel #vikaljain

0:01:01

Vlookup and two lookup values #vlookup #vikaljain

0:00:30

Change gridlines colors #vikaljain #excel

0:01:01

Vlookup with variable column index number #vlookup #vikaljain

0:00:37

Compare two financials #vikaljain #comparefinancials

0:01:08

3 Hacks of Pivot Tables#pivottables #vikaljain

0:01:01

Intersection Xlookup#xlookup #vikaljain

0:00:36

Sumifs like a pro #sumifs #excel #vikaljain Multiple criteria in a array