Excel Functions
Excel Functions Introduction to Excel Functions Excel Functions are preprogrammed commands that make the task of writing complex formulas easier. There are a total of 333 functions in Excel . These functions are separated into 11 categories as follows: 1. Database Functions (12) 2. Date and Time Functions (20) 3. Engineering Functions (39) 4. Financial Functions (53) 5. Information Functions (17) 6. Logical Functions (6) 7. Lookup and Reference Functions (18) 8. Math and Trigonometry Functions (59) 9. Statistical Functions (80) 10. Text Functions (27) 11. External Functions (2) Some Excel functions are more powerful than others and some are more relevant to the CPA than others. For example, most CPAs will find the IF, SUM, COUNT, SUBTOTAL, TEXT, and VLOOKUP are very relevant to the CPA while other engineering and trigonometry functi...