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.
This course focuses on some of the best practices for using Excel as a financial analysis tool. Keep a close watch as we reveal some of the interesting facts and tricks of MS Excel 2013.
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: Navigating worksheets|
|Section 3: Understanding Cell References|
Understanding Cell ReferencesPreview
|Section 4: The Backstage view - Analysis Perspective|
The Backstage view - Analysis Perspective
|Section 5: Printing Worksheets - Print Area, Headers /Footers|
Printing Worksheets - Print Area, Headers /FootersPreview
|Section 6: Excel protection features (password Protecting sheets, and hiding Formula)|
Excel protection features (password Protecting sheets, and hiding Formula)
|Section 7: Exporting Excel data to other formats - CSV, PDF, and others|
Exporting Excel data to other formats - CSV, PDF, and othersPreview
|Section 8: Handling conditional structures using IF Functions|
Handling conditional structures using IF Functions Part 1
Handling conditional structures using IF Functions Part 2
|Section 9: Using Nested IF conditions|
Using Nested IF conditions
|Section 10: Using Operators with IF – AND, OR, NOT|
Using Operators with IF – AND, OR, NOT
|Section 11: Advanced Excel Functions – SUMIFS, COUNTIF, SUMPRODUCT and related functions|
Advanced Excel Functions – SUMIFS, COUNTIF, SUMPRODUCT and related functionsPreview
|Section 12: Creating Mega-Formula using multiple functions|
Creating Mega-Formula using multiple functions
|Section 13: Datasets|
|Section 14: Additional Material|
|Section 15: Exercises|
|Section 16: Mock Test|
|Section 17: 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.