COURSE OBJECTIVES

This program is designed to equip you with practical skills that will give you an edge over other candidates. It is tailored to increase your Excel skills to become more efficient at work, school, or any personal project. You will learn powerful Excel functions that will allow you to automate much of your work and make your life easier. You will also learn how to setup and format different accounting tables and use advance functions to organize your data.

KEY TOPICS

• The basics of excel
• Debiting and crediting journal entries in excel
• Posting to the general ledger
• Important Excel Functions
• Excel Formats for clean spreadsheets
• Vlookup, hlookup, index & match functions
• Sumifs & countifs functions
• Creation of integrated financial statements (Balance Sheet, Income Statement, Statement of Cash Flows)
• Forecasting revenues
• Creation of pivot tables
• Flash fill functions
• Creation of professional data tables
• Perform Financial statement analysis
• Calculation of liquidity, solvency, profitability, and growth ratios to analyze a company’s performance
• Assessment of projects’ Financial viability via the net present value (NPV) technique
• Calculation of complete loan schedule

LEARNING OUTCOMES

By the end of the course participants will be able to:

• The basics of excel: how to input numbers, how to input formulas, and the different functions of Excel
• How to debit and credit journal entries in excel
• Posting to the general ledger
• Functions that will help you analyze your data at a deeper
• Formats that will make your spreadsheets look clean
• Vlookup, hlookup, index & match functions
• Sumifs & countifs functions
• How to create integrated financial statements (Balance Sheet, Income Statement, Statement of Cash Flows)
• How to create debt schedules and pp&e schedules
• Forecasting revenues
• How to create pivot tables
• Flash fill functions
• How to create professional data tables
• Perform Financial statement analysis
• Calculate liquidity, solvency, profitability, and growth ratios to analyze a company’s performance
• Assess whether a project is feasible via the net present value (NPV) technique
• Calculate a complete loan schedule

TARGET PARTICIPANTS

Current University students, Recent University Graduates and Early Career Accountants and/or Financial Analysts. Course Fees: Current Students: TZS 45,000/= The fee covers materials, course delivery, certificates, and refreshments. Venue: UDSM UDBS Block C Mode of Payments All payments should be made to NBC Bank Acc. Name: FACULTY OF COMMERCE Acc. # 040103000924 Swift Code: NLCBTZTX

Offered By : ACCOUNTING - University of Dar es salaam Business School

OTHER DETAILS

Cost: 45,000

Currently Not Accepting Applications
Cancel