Канал: Excel Kida

Merging multi-line narration / remarks of Bank Statement using Claude AI

Merging multi-line narration / remarks of Bank Statement using Claude AI

Generating Indian Financial Year formula in Excel using Claude AI

Generating Indian Financial Year formula in Excel using Claude AI

Tally Prime to Excel Dashboard Report - Creating Sales Dashboard #02

Tally Prime to Excel Dashboard Report - Creating Sales Dashboard #02

3 Quick methods to import Credit Card PDF Statement into Excel

3 Quick methods to import Credit Card PDF Statement into Excel

Tally Prime to Excel Report Dashboard - Understanding Data #01

Tally Prime to Excel Report Dashboard - Understanding Data #01

Copilot for Excel - Profession Tax Calculation formula generation

Copilot for Excel - Profession Tax Calculation formula generation

How to Automate Import of CBS Bank Statement into Excel via Power Query

How to Automate Import of CBS Bank Statement into Excel via Power Query

Copilot for Excel - How to extract City State Pincode from Address

Copilot for Excel - How to extract City State Pincode from Address

SEQUENCE function of Excel - Syntax and Capabilities

SEQUENCE function of Excel - Syntax and Capabilities

Copilot for Excel - How to Generate formula to calculate Income Tax

Copilot for Excel - How to Generate formula to calculate Income Tax

Tally to Azure Data Lake Sync for Power BI / Excel Reporting & Dashboards

Tally to Azure Data Lake Sync for Power BI / Excel Reporting & Dashboards

Excel to Tally Import of Sales Invoice with multiple Debit / Credit and Stock Item

Excel to Tally Import of Sales Invoice with multiple Debit / Credit and Stock Item

Excel Novice to Pro #04: Formula Concepts / Cell Reference / Operators / Calculations / Functions

Excel Novice to Pro #04: Formula Concepts / Cell Reference / Operators / Calculations / Functions

Excel Novice to Pro #03: Tour of Excel / Concept of Cell / Data Type / Cell Value

Excel Novice to Pro #03: Tour of Excel / Concept of Cell / Data Type / Cell Value

Excel Novice to Pro #02: Signup / Installation / Pricing / Free Excel

Excel Novice to Pro #02: Signup / Installation / Pricing / Free Excel

Excel Novice to Pro #01: History / Versions / Applications / Competitors

Excel Novice to Pro #01: History / Versions / Applications / Competitors

Unpivot of Power Query and Pivot Chart in Excel

Unpivot of Power Query and Pivot Chart in Excel

Preparing Dashboard in IBM Cognos Analytics from Tally Data

Preparing Dashboard in IBM Cognos Analytics from Tally Data

How to Randomly select Lucky Draw winner in Excel

How to Randomly select Lucky Draw winner in Excel

Merging multi-line Narration into single in Bank Statement

Merging multi-line Narration into single in Bank Statement

Power Query based automation of GSTN Search & Validation via Razorpay API

Power Query based automation of GSTN Search & Validation via Razorpay API

How to import & combine multiple pages of PDF Bank Statement in Excel

How to import & combine multiple pages of PDF Bank Statement in Excel

Tally to OneDrive linking of Document via Excel

Tally to OneDrive linking of Document via Excel

Multi company Trial Balance Consolidation in Tally

Multi company Trial Balance Consolidation in Tally

How to prepare Financials dynamically linked to Tally

How to prepare Financials dynamically linked to Tally

How to extract Unique list of items from multi-column data

How to extract Unique list of items from multi-column data

Excel to Tally: How to create multiple Stock Items

Excel to Tally: How to create multiple Stock Items

How to merge multiple CSV files in Excel via Power Query - Merging Bhavcopy

How to merge multiple CSV files in Excel via Power Query - Merging Bhavcopy

Organization Data Types: Modern way of data lookup without VLOOKUP

Organization Data Types: Modern way of data lookup without VLOOKUP

IMAGE Function - Embedding Dynamic URL based images inside cell in Excel

IMAGE Function - Embedding Dynamic URL based images inside cell in Excel

Tally to Google Sheets - Importing Sales Register

Tally to Google Sheets - Importing Sales Register

Tally to Power BI: Sales Dashboard

Tally to Power BI: Sales Dashboard

Tally to Power BI: Sales Register

Tally to Power BI: Sales Register

Excel to Tally: Bulk update of Party GSTN & State Name

Excel to Tally: Bulk update of Party GSTN & State Name

How to convert Image into Table in Excel

How to convert Image into Table in Excel

TEXTSPLIT function: Address Info Extraction

TEXTSPLIT function: Address Info Extraction

Tally to Database: Power BI Ledger Voucher Report 02

Tally to Database: Power BI Ledger Voucher Report 02

Tally to Database: Power BI Ledger Voucher Report 01

Tally to Database: Power BI Ledger Voucher Report 01

XLOOKUP: Matrix Search

XLOOKUP: Matrix Search

XLOOKUP: Multi Column Fetch

XLOOKUP: Multi Column Fetch

How to Grab Mutual Fund historical NAV in Power BI & Excel

How to Grab Mutual Fund historical NAV in Power BI & Excel

XLOOKUP: Search Direction

XLOOKUP: Search Direction

XLOOKUP: Match Mode

XLOOKUP: Match Mode

XLOOKUP: Handling Not Found Values

XLOOKUP: Handling Not Found Values

VLOOKUP vs XLOOKUP

VLOOKUP vs XLOOKUP

Analysing Big Data in Excel

Analysing Big Data in Excel

Excel to Tally: Bulk Import of Accounting Entries

Excel to Tally: Bulk Import of Accounting Entries

LAMBDA Function: A modern technique to create your own function in Excel

LAMBDA Function: A modern technique to create your own function in Excel

How to Import Taxpro IT client Register in Excel

How to Import Taxpro IT client Register in Excel

US vs India Date Setting impact in Excel Calculations

US vs India Date Setting impact in Excel Calculations

Importing Bank Statement PDF into Excel via Power Query

Importing Bank Statement PDF into Excel via Power Query

Pivot in Indian Financial Year scenario

Pivot in Indian Financial Year scenario

Tally to Google Sheet via Azure SQL

Tally to Google Sheet via Azure SQL

Tally to Power BI via Azure SQL

Tally to Power BI via Azure SQL

Tally to Power BI Dashboard: Cash Analysis

Tally to Power BI Dashboard: Cash Analysis

Random Sampling of Rows in Excel

Random Sampling of Rows in Excel

Tally to Google BigQuery data transfer: Tutorial

Tally to Google BigQuery data transfer: Tutorial

FIFO Stock Valuation using Excel

FIFO Stock Valuation using Excel

Tally to MySQL Server data transfer: Tutorial

Tally to MySQL Server data transfer: Tutorial

Tally to SQL Server data transfer: Tutorial

Tally to SQL Server data transfer: Tutorial

Google Sheet to Tally report connectivity on realtime-basis

Google Sheet to Tally report connectivity on realtime-basis

Tally to Power BI Dashboards: Sales Bar Chart

Tally to Power BI Dashboards: Sales Bar Chart

Tally to Power BI Dashboards: Top 5 Receivables

Tally to Power BI Dashboards: Top 5 Receivables

Searching GSTN Vendor Names in Excel via Power Query

Searching GSTN Vendor Names in Excel via Power Query

PAN Validation 04: Formula Consolidation

PAN Validation 04: Formula Consolidation

PAN Validation 03: Array Formula

PAN Validation 03: Array Formula

PAN Validation 02: LET function

PAN Validation 02: LET function

PAN Validation 01: MID, CODE, IF, AND function

PAN Validation 01: MID, CODE, IF, AND function

GSTR-1 B2B JSON Import & Consolidation into Excel

GSTR-1 B2B JSON Import & Consolidation into Excel

Tally Ledger Vouchers import via Power Query

Tally Ledger Vouchers import via Power Query

Realtime linking of Share price to Excel via Power Query

Realtime linking of Share price to Excel via Power Query

Excel to Tally Financials Realtime linking with Power Query

Excel to Tally Financials Realtime linking with Power Query

NIFTY 50 Option Chain Data Extraction

NIFTY 50 Option Chain Data Extraction

Script Library: How to copy & run Google Spreadsheet Macro

Script Library: How to copy & run Google Spreadsheet Macro

Script Library: How to copy & run Excel VBA Macro

Script Library: How to copy & run Excel VBA Macro

Paste Special: Skip Blanks

Paste Special: Skip Blanks

Finacle Account Statement Import with Notepad++

Finacle Account Statement Import with Notepad++

3D Maps Chart

3D Maps Chart

XLOOKUP: NSE Option Chain Example

XLOOKUP: NSE Option Chain Example

Excel for Bank Audit: 03

Excel for Bank Audit: 03

Excel for Bank Audit: 02

Excel for Bank Audit: 02

NIFTY 50 Intraday Quick Analysis in Excel

NIFTY 50 Intraday Quick Analysis in Excel

Importing GSTR-1 JSON file in Excel without using any software/website

Importing GSTR-1 JSON file in Excel without using any software/website

Tackling GSTR-9/9C Technical & System related Issue

Tackling GSTR-9/9C Technical & System related Issue

Excel for Bank Audit: 01

Excel for Bank Audit: 01

Realtime Linking of MF/Share/F&O Data in Spreadsheet: Part 02

Realtime Linking of MF/Share/F&O Data in Spreadsheet: Part 02

Realtime Linking MF/Share/F&O Data in Spreadsheet : Part 01

Realtime Linking MF/Share/F&O Data in Spreadsheet : Part 01

Realtime Linking of MF/Share/F&O Prices in Spreadsheet

Realtime Linking of MF/Share/F&O Prices in Spreadsheet

ITC Matching using Excel / GST Annual Return

ITC Matching using Excel / GST Annual Return

Excel Techniques: ITC Matching Books with 2A

Excel Techniques: ITC Matching Books with 2A

IFS Function

IFS Function

Nested IF Function

Nested IF Function

IF function

IF function

Inserting Rupee symbol in Excel / Word

Inserting Rupee symbol in Excel / Word