Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
Microsoft Excel comes with many built-in financial functions which perform many of the commonly used financial calculations. This course explores the easy solutions to financial data analysis and thus helps in increasing efficiency of business users.
This is a practical course that explores the easy solutions to financial data analysis and thus helps in increasing efficiency of business users. It has been designed for professionals who wish to explore the practical usage of advanced Excel functions with financial data.
At the end of the course, participants would learn/use/acquire the following techniques/knowledge:
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Course Introduction|
|Section 2: Designing Aged Reports and understanding data bucketing concepts|
Designing Aged Reports and understanding data bucketing conceptsPreview
Designing Aged Reports and understanding data bucketing concepts Part 2
|Section 3: Reducing speculation with What-If-Analysis - Goal Seek, Data Table, Scenario Man|
Reducing speculation with What-If-Analysis - Goal Seek, Data Table, Scenario ManPreview
|Section 4: Quick Analysis Tools - for Charts, Tables, Formatting etc. (Excel 2013)|
Quick Analysis Tools - for Charts, Tables, Formatting etc. (Excel 2013)
|Section 5: Datasets|
|Section 6: Building simple financial statements|
Building simple financial statementsPreview
|Section 7: Financial Functions in Excel|
Financial Functions in Excel
|Section 8: Time value for money - Present Value, Future Value|
Time value for money - Present Value, Future Value
|Section 9: Calculating depreciation|
|Section 10: Finding data co-relation of financial data and forecasting values|
Finding data co-relation of financial data and forecasting values
Finding data co-relation of financial data and forecasting values Part 2
|Section 11: Calculating Return of Investment, and depicting Breakeven|
Calculating Return of Investment, and depicting Breakeven
|Section 12: Datasets|
|Section 13: Additional Material|
|Section 14: Exercises|
|Section 15: Mock Test|
|Section 16: Course Conclusion|
GreyCampus is a leading provider of certification training solutions for professionals globally. We offer a personalized, interactive and engaging learning experience for professionals across sectors to help them clear the certification exams of their choice quickly and easily.
Our online learning portal uses a highly advanced, analytics-driven technology platform to deliver courses that are highly personalized, adapt to your learning needs and constantly provide feedback to help you achieve your objectives. Each eLearning program is independently hosted on a Cloud platform that guarantees 99.99% availability anywhere in the world 24×7.