Tally

Share on Facebook

Share on Twitter

Share on LinkedIn

Share on Email

Share More

Articles by CA Kumar Mukesh

avatarView Full Profile

Rediff Money | How to get latest stock price in Microsoft Excel

  CA Kumar Mukesh    23 November 2016 at 11:23

Rediff money - In this post we will learn about how to get stock quotes for specified all symbols using simple Excel Tricks.

Continue Reading »
Posted in Info Technology  10 comments |   42006 Views


SUMIFS - Advance Excel

  CA Kumar Mukesh    18 October 2016 at 12:16

In this article I will try to explain SUMIFS function in 5 different scenario from basic to advance.

Continue Reading »
Posted in Info Technology  3 comments |   5367 Views


Two way lookup in Microsoft Excel - Advance Excel

  CA Kumar Mukesh    29 September 2016 at 10:55

Name Manager + Indirect function of excel can be used in place of INDEX+MATCH

Continue Reading »
Posted in Info Technology  9 comments |   19575 Views


Extracting data in Microsoft Excel - Advance Filter

  CA Kumar Mukesh    30 August 2016 at 11:05

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.

Continue Reading »
Posted in Info Technology  23 comments |   23934 Views


Ageing report from pivot table - Advance Excel

  CA Kumar Mukesh    31 May 2016 at 10:59

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

Continue Reading »
Posted in Info Technology  13 comments |   34584 Views


Vlookup's Advance Function (Advance Excel)

  CA Kumar Mukesh    21 January 2015 at 10:42

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

Continue Reading »
Posted in Info Technology  13 comments |   56049 Views


Data Consolidation in Microsoft Excel Part-2 (Advance Excel)

  CA Kumar Mukesh    13 January 2015 at 10:19

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

Continue Reading »
Posted in Info Technology  15 comments |   27963 Views


Data Consolidation in Microsoft Excel (Advance Excel)

  CA Kumar Mukesh    12 January 2015 at 10:47

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

Continue Reading »
Posted in Info Technology  49 comments |   38988 Views


Linking Tally with Excel Steps (Advance Excel)

  CA Kumar Mukesh    08 January 2015 at 11:05

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

Continue Reading »
Posted in Info Technology  87 comments |   164823 Views


Scenario Manager in Excel (Revised)

  CA Kumar Mukesh    03 January 2015 at 10:59

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

Continue Reading »
Posted in Info Technology  14 comments |   24429 Views