Take This Quiz & Predict Your Score in the coming CA CS or CMA Exam!
  • How important it is for you to pass the exam in this attempt?
  • What percentage of course you have finished well so far roughly?
  • How many hours you study in a day?
  • How many times you have revised the topics you have finished
  • Have you taken online or pen drive or live class from a renowned faculty?
  • What percentage of the classes you have watched?
  • Have you attempted mock tests or practice tests yet?
  • Are you planning to attempt mock tests conducted by external bodies- ICAI, ICSI, ICMAI or other institute?
  • How many tests you have taken?
  • Did you manage to finish the test papers on time?
  • Are you strictly following study material provided by the exam conducting authority such as ICAI/ICSI/ICMAI/Other Body?
  • How is your health in general?
  • How is your food habit?
  • Any interest in yoga or exercise or play sports regularly?
  • Planning to sleep well nights before the exams?
  • Planning to have light food and water before exams?

Excel Formula List

Excel Formula List 

Excel formulas can always be very handy, basically when you are stuck with data and need to get something done fast, but it is possible only if you know the basic function of  Excel.

Excel formulas are very helpful as they save a ton of time. Here we are providing all A-Z Excel Formulas that are important and very useful for doing all calculations.

Scroll down download the pdf of A-Z Excel Formula list

In Auditing periods we find Auditee staff is normally busy in doing Excel Work . Auditee work is just like writing a Company Book manually for example, preparing different types of report without having any knowledge of basic Formula/Function of Excel.

A-Z Excel Formula list contains following functions:

Image result for excel


  • Split Forename and Surname: This is useful when you have one cell containing texts which needs to be split up.
  • Concatenate : This function joins separate pieces of text into one item
  • Correl : It examines two sets of data to determine the degree of relationship between two sets.
  • Percentages
  • How to see all formula in worksheet
  • Sum using names
  • Instant charts
  • Brackets in formula
  • Age calculation
  • Auto sum shortcut key
  • Count Blank : It counts number of blank cells in a range.
  • Year : It extracts the year number from a date.

For more functions download the A-Z Excel Formula List pdf  given below.

Find the excellent Excel video lectures in the below table:

These courses will help you learn Advanced Excel Tools & Techniques and Increase Efficiency of your Project Management and Accounting activities. It contains hundreds of Excel tricks and techniques .

Excel video lectures

 Excel Video lecturesExcel for Project Managers -BASIC
Excel for Project Managers – PRO
Excel for Project Managers – COMBO
Excel for Accounting – BASIC
Certificate in Microsoft Excel for Business Professionals


Download the pdf of A-Z Excel Formula list in the below link:

   Download A-Z Excel Formula List      


Other best recommended articles check out here:


Depreciation Calculator under Companies Act 2013

Balance sheet Finalisation check list

CA Parveen Sharma



cakart At CAKART you will get everything that you need to be  successful in your CA CS CMA exam – India’s best faculty video classes (online or  in pen drive) most popular books of best authors (ebooks hard copies) best  scanners and all exam related information and  notifications.Visit and chat with our counsellors any time. We are  happy to help you make successful in your exams.



Click here to download FREE CA CS CMA books


Leave a comment

Your email address will not be published. Required fields are marked *