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.

------------------------------------------------------------------------
PASTE SPECIAL (Complete Tutorial):

Sum Magic Trick In Excel:

ROWS and COLUMNS Functions in Excel:

EXCEL FUNNY MAGIC TRICK SHORT:

Crack Jobs #2| MIS Interview cracker:

Crack Jobs #1| MIS Interview cracker:

Formula vs Function part 1:

Formula vs Function Part 2:

Custom Formatting Part 1:

Custom Formatting Part 2:

HOME TAB PART 4(EDITING GROUP-1K VIEWS SPECIAL):

MIXED CELL REFERENCE:

CONDITIONAL FORMATTING:

My Other Playlists:
Excel For Beginners:

Excel Tips and Tricks:

Excel Shorts:

MIS Interview Cracker:
------------------------------------------------------------------------
------------------------------------------------------------------------
Intro Music provided by
Infraction - No Copyright Music

------------------------------------------------------------------------
------------------------------------------------------------------------
Outro music provided by
Electro-Light-Symbolism [NCS Release]

Song : Symbolism
Artist : Electro-Light
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------

------------------------------------------------------------------------
------------------------------------------------------------------------
Let's Connect:
Instagram:

tags:
#exceltipsandtricks #pivottable #msexcel #excel #advance #gstr2 #tally #reconciliation #reco #comparision

[ShubhamGupta-vtzz]

Jabardast Maine try nahi kiya abhi khud se, but dekh k kaafi kuch sikhne mila hai, practically karne k baad, surely I will again get back

[pramodsaxena]

Thanku so much for data for practise, very helpful video, maine apke video pe jitna ads aaya use pura dekha aur bar bar dekh raha hu jitna bhi ads aaya hai taki apko thanku bole saaku, once again thanku so much

[ganga]

Yes very simple and wonderful teaching and a great video in simple teaching. God bless you more and more wisdom in your work.

[SureshSharma-ziqs]

I m very thankful to u..sb ki videos dekhi but..smj aap hi ka aya..

[shyamtiwari]

Your explanation is very simple and even a person without having much knowledge in the pivot table can easily understand. 🎉

[prabhatdubey]

This video add more skill and create an edge over others, what a wonder full video ..
Sach kaha tha apka video dekhte-2 PIVOT Table aajayega aur aa gaya 😊😊
👍👍🙏🙏

[supriyodutta]

VERY USEFUL FOR BEGINNER ( SHOULD WATCH )

[supriyodutta]

u described very well in manner from ZERO to SCRATCH .

[vijaybotkulwar]

I was finding it very difficult to reconcile. This video has made reconciliation easier for me. Really appreciate it and hoping you are gonna bring more videos.

[rajivkumarsingh]

Very helpful in lucid language of hard topic.
Thank sir.

[sagarkamrani]

Such a simple and effective method.. thanks for sharing

[komalbid]

Thanks for making such videos. It was very easy to understand.🙏🙏

[ranjitamishra]

Wonderful sharing . You have explained everything so nicely . Thanks for sharing such a great video

[kiranmayekar]

Mind blowing Knowledge Salute To Your Information

[Bhavin]

Mindblowing sir !!! thankyou so much for sharing valuable content

[Utdr]

Well explained.infomativ video share by you

[golapsakhatoon]

very helpful and useful video..every points you can explaine very easy ...it's reall very knowledgeable video..thanks for shearing

[khajamoinuddin]

Appreciate, well explained bro. Hats-Off to you.

[baljeetsharma]

this vedio is very helpfuul, for reco. thanks😀

[NehaSingh-hnkl]

No one have shared such a wonderful video. Thanks