EXCEL TRICKS (VIKOM INSTITUTE)

Chapter 4 Operators in power query

Unpivot Data from Pivot Table

LET function in Excel

Vstack _A new function in msexcel 🤯🤯

Dynamic and linkable index in Ms word #vikominstitute #msword #excel 😀

Convert all numbers into positive numbers in excel #shorts

How to Reduce Size of Excel Files

Get rid off decimals without rounding off.mp4 #excel #vikominstitute #vikaljain

Intersection xlookup #excel #vikominstitute #xlookup

Do sum based on colour #vikominstitute #excel #sumbycolour

Keep data and linked source formatting #vikominstitute #excel #msword

Chapter 2 -- Unpivot data in Power Query in Excel in (HINDI)

#shorts ! calculate overtime in excel

Find next Sunday 🧐 #excel #vikominstitute #weekday

Extract numbers not text.mp4 #excel #vikominstitute #Extractnumbersnottext

5 Pivotby function

Make Subtotals sexy in excel ❤️❤️

Dynamic borders in excel 🤫 #excel #vikominstitute #vikaljain #dynamicborders

SUBTOTAL in EXCEL

Chapter 7 - List functions (Continued) in power query

#combochart ! Combo Chart in excel

Convert messy data into table in MS WORD #excel #pivottable #vikominstitute #msword

3D sum in excel 👌

Custom sort 🤭🤭 #customsorting #sorting #sortlefttoright #excelhacks #life #easylife #excel #custo

Convert number into thousands and millions

Extract PAN from GST numbers

Turn everything into QR CODE in excel 😱😱 #makeqrcode #qrcode #excel

Translate text into a different language - IN EXCEL

Regexextract, Regexreplace and Regextext in excel

Justify text in Excel #excel #vikaljain

Allowing text into center of multiple cells without merging them #shorts

Find Fiscal Qtr from dates 📅 #excel #vikominstitute #mexcel #fiscalquarter

Get rid of decimal without rounding off 📴

Generate date using sequence in excel 😱😱 #generatedates #sequence #sequencedates #vikominstitute

Add odd cells values in excel

Copy data from outlook to EXCEL

Default layout in pivot table

Extract fiscal quarter in power bi

Create 1000 folders.mp4

Custom sorting in excel

Open two sheets side by side in same excel file

Calculate EMI in excel

Vlookup and sequence function in excel 😱🤫

Find multiple lookup values 🔍

Clipboard in excel sheet 😭

New function in excel - text split

Highlight All Blanks cells using conditional formatting 🥰

Merge cells with dates 🤯

Loan Schedule in a minute

Restore old versions file in excel 📸

Copy password on disabled websites 😠😠