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.
In this ever-changing business environment, being able to accurately analyze economic inputs is a critical skill for business users. Microsoft Excel comes with several built-in financial functions which perform many of the commonly used financial calculations.
Whether you are new to Excel or an advanced user, Grey Campus Excel courses will cover what you need to know to become an expert in using Microsoft Excel as a sophisticated Financial Analysis tool.
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: Starting Microsoft Excel|
Understanding Cell References
The Backstage view - Analysis Perspective
Printing Worksheets - Print Area, Headers /FootersPreview
Excel protection features (password Protecting sheets, and hiding Formula)
Exporting Excel data to other formats - CSV, PDF, and others
|Section 3: Mastering Conditional Functions|
Handling conditional structures using IF Functions Part 1
Handling conditional structures using IF Functions Part 2Preview
Using Nested IF conditions
Using Operators with IF – AND, OR, NOT
Advanced Excel Functions – SUMIFS, COUNTIF, SUMPRODUCT and related functions
Creating Mega-Formula using multiple functions
|Section 4: Datasets|
|Section 5: Additional Material|
|Section 6: Exercises|
|Section 7: Performing complex calculations efficiently|
Using Lookup functions – easy demonstration of VLOOKUP and HLOOKUP
Using Lookup functions – easy demonstration of VLOOKUP and HLOOKUP Part 2
Using Lookup functions – easy demonstration of VLOOKUP and HLOOKUP Part 3
Using Lookup functions – easy demonstration of VLOOKUP and HLOOKUP Part 4
Reverse Lookup techniques – using INDEX and MATCH
Effective Error handling – using ISERROR/IFERROR
Tracing formula dependents and precedents
Using formula auditing tools to avoid errors
|Section 8: Datasets|
|Section 9: Slicing and Dicing of Data - some powerful techniques (Descriptive Analysis)|
Creating Pivot Tables using complex datasets
Generating Pivot Charts Instantly
Implementing Slicers to build Interactive dashboards
Grouping and Sub Total of Data in PivotsPreview
Beautifying reports / tables using Sparklines
|Section 10: Datasets|
|Section 11: Additional Material|
|Section 12: Exercises|
|Section 13: Advanced Data Validation and Analysis (What-If-Analysis)|
Designing Aged Reports and understanding data bucketing concepts
Reducing speculation with What-If-Analysis - Goal Seek, Data Table, Scenario Man
Quick Analysis Tools - for Charts, Tables, Formatting etc. (Excel 2013)Preview
|Section 14: Datasets|
|Section 15: Financial Forecasting and Capital Budgeting|
Building simple financial statements
Financial Functions in Excel
Time value for money - Present Value, Future Value New
Finding data co-relation of financial data and forecasting values
Calculating Return of Investment, and depicting Breakeven
|Section 16: Datasets|
|Section 17: Additional Material|
|Section 18: Exercises|
|Section 19: Mock Test|
|Section 20: Course Conclusion|
Quick Bonus for You!
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.