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
(Expert)
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.
Vlookup
Pivot table
Sort & Filter
Sumif
Subtotal
Various shortcuts for drawing borders
Conditional formatting
& others as per requirement in work.
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.
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.
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- Tax on Amount transferred in HUF Account
- WRONG GSTR7 ENTRIES ACCEPTED ERRONEOUSLY
- Nursery business
- GST input credit on commercial property
- GST REFUND ISSUE ON PURCHASE OF PLANT AND MACHINERY
- GSTR-9C filing
- Import Order Cancelled.
- TDS on Dashcam rent and allied services
- Working on Gold wastage during Melting of old gold jewellery
- Advances to related party
- Form 144 TDS Return Validation Error – Mandatory Fields
- Subject: Legal Remedy for Removal of Income Tax Demand for AY 2024–25 – Charitable Trust
- Expert Help Required for TDS Refund 100000 Through TRACES – AY 2022–23
- IMPORT PURCHASE ENTRY PASSED IN BOOKS OF ACCOUNT
- FAST DS 26 Undisclosed Foreign Asset Disclosure Scheme 2026
- Regime change
- Tally: Imported bank entries do not show up in manual reconciliation
- Confused About My Career After 12th — Cyber Security, AI or Finance? Need Guidance
- FAST-DS 2026 Under Tax Law - No recourse or support for person declaring via this scheme?
- Guidance Needed: Linking Multiple Form 26QB Payments and Responding to ITD Defaulter Notice
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
