Technology & Tools Articles
Sumproduct - Advance Excel Formula
SUMPRODUCT –an advance excel formula The SUMPRODUCT function multiplies the corresponding items in the arrays and returns the sum of the results. SYNTAX The syntax for the Microsoft Excel SUMPRODUCT function is: SUMPRODUCT( array1, array2, ...
Automated Prepaid Expenses JV in Excel
Hello All,Attached is a file which contains the automated prepaid calculation. No Hassles of working out how much is accrued, how much is pending, etc. Just Update the table in the first sheet. And rest will happen automatically. Of course, you are f
How to make VLookup Foolproof
In your day job, you have an excel workbook which is setup to get you the values you need, in the format you need. Probably using basic formulas, including VLookup.Nothing is more annoying and depressing to get your carefully set VLookup formulas get
Reverse/Backward VLOOKUP - Advance Excel function
Reverse or Backward Vlookup or lookup. For understanding reverse or backward VLOOKUP lets get clear about forward / direct VLOOKUP function her : http://www.caclubindia.com/articles/excel-function-vlookup-21678.asp So I assume you are clear ab
Excel function VLOOKUP
1st Question now a days which comes while soft skill interview is.......Do you know VLOOKUP & if you dont respond immediately there grows eyebrows of interviewer up with that grinny smile on his/her face; lets bettle it out & be the master of
Advance Excel function - Indirect()
To understand benefit of indirect function do as I say. Put 100 in cell A1, now in Cell D1 put formula =INDIRECT("A1") & in cell D2 put formula =A1. Result is same in both case then why to put confusing formula in cell D2? Now select
5 advantages of using cloud accounting software
Any business can be managed efficiently by using business automation software. There are 2 types of software which a business owner can utilize namely Desktop software and Online software (Cloud software). Traditionally Indian companies have been use
Online Banking Payments Process: Bank Vs Merchant
Today online banking transactions are essential part of any business activity. Most of the people always feel bubbles in stomach
All about Cloud Computing
Cloud computingToday is the age of information technology. The facets of work and personal life are moving towards the concept of availability of everything online. Understanding this trend, the big and giant web based companies like Google, Amazon,
Bitcoin - Something New
Introduction:Making payment is one of our routines and its mode has changed very drastically. Initially there was barter system then we moved from gold/silver coins for making payments, to paper currency, plastic money and finally electronic payment.
Popular Articles
- Savings Account Rule 2026: New Limits For PAN Card Holder
- Tax Audit Due Date Extension for AY 2026-27
- Download PAN Card With Aadhaar Number in 2026: Know the Online Process
- Income Tax SMS Alert For Salaried and Pensioner FY 2026-27
- TDS on Professional Fees FY 2026-27: Rules and Threshold Limits
- Tax Audit Deadline AY 2026-27: A Practical Compliance Checklist for CAs and Taxpayers
- Income Tax Refund on Excess Recovery: Refund, Interest, Adjustment & Recovery Rules
- When Can GST Officers Visit Business Premises for Verification, Audit, Inspection, Search or Seizure?
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
CAclubindia
