A channel for Microsoft Excel & Google Spreadsheet tricks, tips, knowledge, webinars, tutorials

How to Reverse list of values in Excel
6:49
How to Reverse list of values in Excel
XIRR Function - Calcution of ROI % on Jeevan Utsav Policy Case Study
8:41
XIRR Function - Calcution of ROI % on Jeevan Utsav Policy Case Study
#04 Tally based Dashboards in Hex Data Notebook - Purchase Dashboard
13:10
#04 Tally based Dashboards in Hex Data Notebook - Purchase Dashboard
#03 Tally based Dashboards in Hex Data Notebook - Sales Dashboard
27:36
#03 Tally based Dashboards in Hex Data Notebook - Sales Dashboard
#02 Tally based Dashboards in Hex Data Notebook - Data Modelling (via SQL Query)
19:00
#02 Tally based Dashboards in Hex Data Notebook - Data Modelling (via SQL Query)
#01 Tally based Dashboards in Hex Data Notebook - Intro / Signup / Setup
14:40
#01 Tally based Dashboards in Hex Data Notebook - Intro / Signup / Setup
01 Tally to Google Sheets - BigQuery SQL Basics
33:26
01 Tally to Google Sheets - BigQuery SQL Basics
Tally to Database utility walkthrough - GUI (Graphical) version
9:53
Tally to Database utility walkthrough - GUI (Graphical) version
Multi Company Trial Balance Consolidation of Tally Prime in Excel via Power Query
13:58
Multi Company Trial Balance Consolidation of Tally Prime in Excel via Power Query
#05 Tally Prime to Excel Dashboard - Bill Outstanding and Calculation of Working Capital Cost
36:14
#05 Tally Prime to Excel Dashboard - Bill Outstanding and Calculation of Working Capital Cost
#04 Tally Prime to Excel Dashboard - Generating Ledger Closing Balance Profit Loss Balance Sheet
23:16
#04 Tally Prime to Excel Dashboard - Generating Ledger Closing Balance Profit Loss Balance Sheet
How to convert Amount to Words in Excel (Indian Format) without using VBA Macros
6:26
How to convert Amount to Words in Excel (Indian Format) without using VBA Macros
#03 Tally Prime to Excel Dashboard - Stock Item Dashboards
22:01
#03 Tally Prime to Excel Dashboard - Stock Item Dashboards
How to develop Lotto / Housie game in Excel (without Macros)
21:21
How to develop Lotto / Housie game in Excel (without Macros)
Merging multi-line narration / remarks of Bank Statement using Claude AI
3:43
Merging multi-line narration / remarks of Bank Statement using Claude AI
Generating Indian Financial Year formula in Excel using Claude AI
3:50
Generating Indian Financial Year formula in Excel using Claude AI
#02 Tally Prime to Excel Dashboard Report - Creating Sales Dashboard
19:37
#02 Tally Prime to Excel Dashboard Report - Creating Sales Dashboard
3 Quick methods to import Credit Card PDF Statement into Excel
7:41
3 Quick methods to import Credit Card PDF Statement into Excel
#01 Tally Prime to Excel Report Dashboard - Understanding Data
46:07
#01 Tally Prime to Excel Report Dashboard - Understanding Data
Copilot for Excel - Profession Tax Calculation formula generation
4:40
Copilot for Excel - Profession Tax Calculation formula generation
How to Automate Import of CBS Bank Statement into Excel via Power Query
13:34
How to Automate Import of CBS Bank Statement into Excel via Power Query
Copilot for Excel - How to extract City State Pincode from Address
4:35
Copilot for Excel - How to extract City State Pincode from Address
SEQUENCE function of Excel - Syntax and Capabilities
7:29
SEQUENCE function of Excel - Syntax and Capabilities
Copilot for Excel - How to Generate formula to calculate Income Tax
12:47
Copilot for Excel - How to Generate formula to calculate Income Tax
Tally to Azure Data Lake Sync for Power BI / Excel Reporting & Dashboards
26:24
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
30:36
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
17:26
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
15:56
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
9:56
Excel Novice to Pro #02: Signup / Installation / Pricing / Free Excel
Excel Novice to Pro #01: History / Versions / Applications / Competitors
6:50
Excel Novice to Pro #01: History / Versions / Applications / Competitors