ADVANCED GSTR 2A RECONCILIATION IN EXCEL | HOW TO RECONCILE PURCHASE WITH GSTR 2A

ADVANCED GSTR 2A RECONCILIATION IN EXCEL | HOW TO RECONCILE PURCHASE WITH GSTR 2A
Topics Covered in this video:
1) GSTR2A Reconcilation in Excel
2) How to make advanced Reco in Excel
3) Comparing Gstr2a and tally data in excel
4) Reconciliation with the use of pivot table in excel
5) Most effective way of reconcile data with the use of pivot table in ms excel
About this video:
In this video,you will learn how to use pivot table to reconcile gsr2a and tally data in excel. In this video you will learn how to make a advance reco by using pivot table in excel. please complete watch this video for better understanding.
Practice Workbook Download Link: cutt.ly/tLTslwE
------------------------------------------------------------------------
PASTE SPECIAL (Complete Tutorial):
• Paste Special in Excel...
Sum Magic Trick In Excel:
• SUM Magic Trick in Exc...
ROW and COLUMN Functions in Excel: • ROW and COLUMN Functio...
ROWS and COLUMNS Functions in Excel:
• ROWS And COLUMNS Funct...
CONCATENATE Function in MS Excel: • Concatenate Function i...
RIGHT Function in MS Excel: • RIGHT Function in Exce...
LEFT Function in Excel: • LEFT Function in MS Ex...
EXCEL FUNNY MAGIC TRICK SHORT:
• MS Excel Amazing Magic...
Crack Jobs #2| MIS Interview cracker:
• Crack Jobs #2 -How to ...
Crack Jobs #1| MIS Interview cracker:
• Crack Jobs #1 -How to ...
Formula vs Function part 1:
• formula vs function in...
Formula vs Function Part 2:
• Types of Function in E...
Custom Formatting Part 1:
• Top 5 Custom Formattin...
Custom Formatting Part 2:
• Top 2 Custom Formattin...
HOME TAB PART 4(EDITING GROUP-1K VIEWS SPECIAL):
• EDITING GROUP IN EXCEL...
MIXED CELL REFERENCE:
• How to use MIXED CELL ...
ABSOLUTE CELL REFERENCE • Excel Cell Reference :...
RELATIVE CELL REFERENCE: • Excel Cell Reference :...
CONDITIONAL FORMATTING:
• MS Excel - Conditional...
My Other Playlists:
Excel For Beginners:
bit.ly/3ocmbnn
Excel Tips and Tricks:
bit.ly/3bnOfiw
Excel Shorts:
bit.ly/3bouhUK
MIS Interview Cracker:
bit.ly/3fd74WN
------------------------------------------------------------------------
------------------------------------------------------------------------
Intro Music provided by
Infraction - No Copyright Music
Watch: • Epic Hybrid Trailer by...
Instagram: ...
Spotify: open.spotify.c...
------------------------------------------------------------------------
------------------------------------------------------------------------
Outro music provided by
Electro-Light-Symbolism [NCS Release]
Watch: • Electro-Light - Symbol...
Song : Symbolism
Artist : Electro-Light
------------------------------------------------------------------------
------------------------------------------------------------------------
Background music provided by bensound: www.bensound.com
------------------------------------------------------------------------
------------------------------------------------------------------------
Thumbnail graphic created by Freepik: www.freepik.com
------------------------------------------------------------------------
Let's Connect:
Instagram:
/ excelhurdles
tags:
#exceltipsandtricks #pivottable #msexcel #excel #advance #gstr2 #tally #reconciliation #reco #comparision