Quickstart! - Managing Financial Data in Excel
- Offered byXLNC
Quickstart! - Managing Financial Data in Excel at XLNC Overview
Quickstart! - Managing Financial Data in Excel
at XLNC
Understanding of Financial Modelling techniques means minimising the risk of error and using validation tools in a better way
Duration | 6 months |
Total fee | ₹1,999 |
Mode of learning | Online |
Credential | Certificate |
Quickstart! - Managing Financial Data in Excel at XLNC Highlights
Quickstart! - Managing Financial Data in Excel
at XLNC
- Earn a certificate of completion from XLNC
- Get 24/7 access of the course content
Quickstart! - Managing Financial Data in Excel at XLNC Course details
Quickstart! - Managing Financial Data in Excel
at XLNC
Skills you will learn
Who should do this course?
- For MBA students
- For Commerce graduates
- For Investment Bankers
- For Business Analysts
- For Professionals into Corporate Finance
- For Project Finance or any finance and commerce professionals
What are the course deliverables?
- Valuation Modelling
- Project Finance Modelling
- Mergers and Acquisition Modelling
- Macros for Financial Modelling
- Advanced Excel functions for Financial Modelling
- Advanced Charting and Dash boarding Techniques
More about this course
- Microsoft Excel provides an excellent means to track personal and business expenses that will later be recorded on tax forms or reimbursement reports
- This practical QuickStart! course, led by long-time budget and organizational tutor, contains step-by-step instructional videos to help anyone create Excel spreadsheets to make tracking their financial expenses quick and easy
Quickstart! - Managing Financial Data in Excel at XLNC Curriculum
Quickstart! - Managing Financial Data in Excel
at XLNC
Introduction
Why use microsoft excel to manage finances
Tax and personal finances
Choosing expense categories - schedule a
Choosing expense categories - schedule c
Creating excel model - schedule a
Creating excel model - schedule c
Row and column notation
Excel functions
Excel formulas
Entering expenses
Using links
Annual reporting for tax documents
Business travel expenses
Using excel to track business expenses
Creating worksheets for expense reports
Tracking days of a trip
Entering expenses
Setting daily reimbursement limits
Using links to record unreimbursed items
Printing expense reports
Conclusion
Putting it all together
Wrap up and review
Credits
About the author
Other courses offered by XLNC
View Other 67 Courses
Quickstart! - Managing Financial Data in Excel
at XLNC
Student Forum
Anything you would want to ask experts?