Excel Kida

26/02/2024

How to use SEQUENCE function of Excel to generate number series, date series, tambola board & multiplication tables

19/02/2024

How to sync Tally Prime to Azure Data Lake for Power BI / Excel based reporting & Dashboards

18/02/2024

Bulk upload of Sales Invoice with items and multiple debit / credit into Tally Prime using Excel template

03/12/2023

Preparing Executive MIS Dashboard in IBM Cognos Analytics from Tally Prime data

03/12/2023

Tally Multi Company Trial Balance Consolidation in Excel

03/12/2023

Power Query based automation of GSTN vendor search & validation via Razorpay API

03/12/2023

Tally to OneDrive linking for documents / scanned invoice via Excel

03/12/2023

Extraction of unique items / values from multiple columns data in Excel

03/12/2023

How UNPIVOT of Power Query and Pivot Chart of Excel can help in good data analysis

26/09/2022

Know how to write VLOOKUP & XLOOKUP, limitations of VLOOKUP & how to overcome those using XLOOKUP

09/09/2022

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

This tutorial demonstrates solution to limitation in Pivot based reporting due to our Indian Financial Year system, which does not overlap with calendar year...