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 2
Set 5: Financial Functions
PV: Calculates the present value of an investment.
FV: Calculates the future value of an investment based on periodic, constant payments and a constant interest rate.
PMT: Calculates the payment for a loan based on constant payments and a constant interest rate.
NPER: Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate.
RATE: Returns the interest rate per period of an annuity.
Set 6: Statistical Functions
AVERAGE: Calculates the average of values, including text and logicals.
MEDIAN: Finds the median, or the middle number, in a set of numbers.
MODE: Returns the most frequently occurring, or repetitive, value in an array or range of data.
STDEV.P: Calculates the standard deviation based on the entire population given as arguments.
VAR.P: Calculates the variance based on the entire population.