Excel educational and informative groups with video, question answer forum
How to use SEQUENCE function of Excel to generate number series, date series, tambola board & multiplication tables
How to sync Tally Prime to Azure Data Lake for Power BI / Excel based reporting & Dashboards
Bulk upload of Sales Invoice with items and multiple debit / credit into Tally Prime using Excel template
Preparing Executive MIS Dashboard in IBM Cognos Analytics from Tally Prime data
Tally Multi Company Trial Balance Consolidation in Excel
Power Query based automation of GSTN vendor search & validation via Razorpay API
Tally to OneDrive linking for documents / scanned invoice via Excel
Extraction of unique items / values from multiple columns data in Excel
How UNPIVOT of Power Query and Pivot Chart of Excel can help in good data analysis
Know how to write VLOOKUP & XLOOKUP, limitations of VLOOKUP & how to overcome those using XLOOKUP
Learn a new technique to convert any complex excel formula into your own function
22/08/2022
How to prepare PIVOT in Indian Financial Year scenario
https://www.youtube.com/watch?v=FT49nhB2sDM
Pivot in Indian Financial Year scenario This tutorial demonstrates solution to limitation in Pivot based reporting due to our Indian Financial Year system, which does not overlap with calendar year...