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:
- 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 |
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
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