Welcome to Our Career Site
- How to be successful at entry level Accounting jobs
- How to be successful as a Staff Accountant
- How to be a successful auditor
- How to be a successful Forensic Accountant
- How to be a successful Management Accountant
- How to be a successful Tax Accountant
- How to integrate Technology in Accounting
- How to integrate AI in Accounting
- Top 100 Accounting Questions for Entry level
- Excel formula for Accounting-part 1
- Excel formula for Accounting-part 2
- Excel formula for Accounting-part 3
- Excel formula for Accounting-part 4
- Excel formula for Accounting-part 5
Job Listings
Explore the latest requirement for accounting jobs.
Click on the links to the left to learn more about specific aspects of accounting jobs.
Important Excel Formulae for Accounting-Part 3
Set 7: Text Functions
CONCATENATE: Joins two or more text strings into one string.
LEFT: Returns the specified number of characters from the start of a text string.
RIGHT: Returns the specified number of characters from the end of a text string.
MID: Returns a specific number of characters from a text string, starting at the position you specify.
TRIM: Removes all spaces from text except for single spaces between words.
Set 8: Additional Financial Functions
NPV: Calculates the net present value of an investment based on a series of periodic cash flows and a discount rate.
IRR: Returns the internal rate of return for a series of cash flows represented by the numbers in a list.
XNPV: Returns the net present value for a schedule of cash flows that is not necessarily periodic.
XIRR: Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic.
DB: Returns the depreciation of an asset for a specified period using the fixed-declining balance method.