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.

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:

• 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 lectures Excel 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

### Other best recommended articles check out here:

Depreciation Calculator under Companies Act 2013

Balance sheet Finalisation check list

CA Parveen Sharma

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.