Articles by CA Kumar Mukesh
View Full Profile
Extracting data in Microsoft Excel - Advance Filter
This article is in continuation with my Advance Excel tips and inspired by one of my friend facing problems in extracting relevant data in Microsoft Excel from Huge Raw Data, dumped from ERP software.
Ageing report from pivot table - Advance Excel
We all are finance professionals, some may be in INDUSTRY few in PRACTICE and most of us are student to become future professionals. But whatever stage we are everyone have to face computer screen filled with Microsoft Excel Spreadsheets
Linking Tally with Excel Steps (Advance Excel)
Linking Tally with Microsoft ExcelIf you are using tally and preparing reports from Tally Data, then have you observed, any time, there is additional work load or repetition of work. Means to generate reports from tally you need to first update tall
Rediff Money | How to get latest stock price in Microsoft Excel
Rediff money - In this post we will learn about how to get stock quotes for specified all symbols using simple Excel Tricks.
Vlookup's Advance Function (Advance Excel)
Lookups in Microsoft Excel, most of us always preferred to go with VLOOKUP as it is regarded as a basic lookup function in Microsoft Excel and also essential for those who willing to work or already worked on
SUMIFS - Advance Excel
In this article I will try to explain SUMIFS function in 5 different scenario from basic to advance.
Two way lookup in Microsoft Excel - Advance Excel
Name Manager + Indirect function of excel can be used in place of INDEX+MATCH
Data Consolidation in Microsoft Excel (Advance Excel)
DATA CONSOLIDATION IN MICROSOFT EXCELWe all are finance professionals or students of respective professional institute. In which ever field we are workings, no one can afford to be untouchable with Microsoft Excel. In most of cases, more than half o
Data Consolidation in Microsoft Excel Part-2 (Advance Excel)
Before you like to proceed with this article I like to request to you please go through with my previous article on this Microsoft Excel Function, if you still have not read click here &qu
Scenario Manager in Excel (Revised)
Scenario Manager in Excel A Step Towards Advance Excel (Revised)On Scenario Manager, I have already written an article but that was not properly presented and had some confusions. After getting review from some users, where they suggested that if t
Popular Articles
- Individual Income Tax Return Filing Due Dates for FY 2025-26 (AY 2026-27)
- Due Date Extended: Check Which Return Filing Gets More Time?
- New Column in ITR For AY 2026-27: "Receipts Not in Nature of Income" - What Is It?
- PNB FD Interest Rates 2026 for 444 days: Maximize Your Returns Without a Long Lock-In
- AIS Income Tax Transactions: What to Report and What to Skip in AY 2026-27?
- Pensioner ITR for AY 2026-27: Guide to Reporting Pension Income and Claiming Your Tax Refund
- ITR Processing Time 2026: Know How Long Will It Take and What Each Status Message Means
- Income Tax Update: How to Transfer TDS From Wife to Husband's ITR?
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
CAclubindia
