Excel Kida

Excel Kida Excel educational and informative groups with video, question answer forum

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

How to prepare PIVOT in Indian Financial Year scenariohttps://www.youtube.com/watch?v=FT49nhB2sDM
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...

Address

Nagpur
440033

Alerts

Be the first to know and let us send you an email when Excel Kida posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Contact The School

Send a message to Excel Kida:

Shortcuts

Share

Category