CA Final Download the best Free CA FINAL android app for cracking your exam! Download Now
They are the best ca final faculties in India. They have produced many toppers & rank holders. Their video classes are available only here -
CHECK VIDEO CLASSES HERE

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 www.cakart.in 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 www.cakart.in 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 *