Excel commands

This query is : Resolved

Querist : Anonymous

Querist : Anonymous (Querist)

04 May 2015 Please suggest me about the Excel commands, which is a highest usage in accounting and preparing financial data

CA. Kuldeep Singhi

CA. Kuldeep Singhi (Expert)
Follow

04 May 2015 The excel commands which are in prominent usage are:
Vlookup
Pivot table
Sort & Filter
Sumif
Subtotal
Various shortcuts for drawing borders
Conditional formatting
& others as per requirement in work.

CMA. CS. Sanjay Gupta

CMA. CS. Sanjay Gupta (Expert)
Follow

04 May 2015 https://www.caclubindia.com/share_files/excel-tutor-12672.asp#.VUVijfmqqko

https://www.caclubindia.com/share_files/excel-useful-tips-12673.asp#.VUVikfmqqko

Also check out files on Excel from above link. Hope you will find them usefull.

Online classes for CA CS CMA