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
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
- TDS 194-T applicability
- Tds on commission charges
- TDS on Complimentary "Desi Ghee and Gold Coin" Provided to KBC Contestants
- GST ITC REVERSE
- Consolidated financials
- TDS on TRUST
- RCM ISSUE ON RENT AND TRANSPORTATION CHARGES
- Regarding Applicability of Tax Audit u/s 44AB
- Need Professional Opinion AY 2012-13 Old Demand
- Withdrawal in cash from partners capital account by partner
- New GST registration for new place of business.
- Starting trading business
- Regime change
- Goods sold but invoice not issued
- Tally: Imported bank entries do not show up in manual reconciliation
- Sales of goods of amount Rs97 lakhs to a party
- 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?
- STATUTORY AUDIT OF A SMALL PRIVATE COMPANY INCORPORATED ON 28.03.2025
- 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
Quick Links
ARTICLESHIP
01 September 2026
Articles
Saini Pati Shah & Co LLP, Chartered Accountants
Mumbai
CA Foundation
View Details
09 September 2026
Semi Qualified CA / CA Inter - 2 Groups Cleared
Getmyca Consultant Pvt Ltd
New Delhi
CA Inter
View Details
ARTICLESHIP
21 September 2026
CA Article Assistant
KK & Company Chartered Accountant
Pune
CA Inter
View Details
Featured
12 September 2026
Assistant Manager - Finance & Compliance
Naveen Fintech Pvt Ltd
Kolkata
CA Inter
View Details
09 September 2026
SENIOR AUDITOR & ACCOUNTS MANAGER
Anupam Parashar & Co.
Ghaziabad
CA Final
View Details
CCI
Pro
CAclubindia
