Excel being the accountant's first tool for analyzing and reporting financial data, most accountants have never received any formal Excel training. And because of this, most accountants use time-consuming and error-prone processes to complete their day-to-day tasks.
This course by EduPristine contains hundreds of Excel tips, tricks, and techniques and has been designed specifically to improve accountant’s productivity and accuracy.
This is particularly useful for those who have a basic understanding of Excel, but want to improve their skills in order to achieve the automation in their work.
The objective of the course is to increase the productivity and efficiency of accountants and CPAs by introducing them to numerous advanced tools and techniques available in Excel.
Accountants and finance professionals who want to learn how to use Excel more efficiently and effectively. Especially accountants, who have never taken a formal Excel training course, need this course regardless of their level of experience.
This course would provide following benefits to the participant. Become more efficient at getting things done effectively through Excel.
Learn about best practices in Excel to reduce errors.
Manage time better by automating repetitive tasks.
Create robust models in Excel which are easy to understand and implement.
Impress Top Management with better presentation and analysis of data.
Understand underlying business dynamics by performing what if and sensitivity analysis.
As this is a special course designed for accountants. However, it would be helpful if you are familiar with fundamental knowledge of Excel (preferably Excel 2007 or 2010) as we have used various excel based case studies to explain important concepts in a simple way.
|Working with Databases||Importing Data from ERP Systems
Data mining and Lookups
Data formatting and Reporting tools
Working with External Data
|Recording & Using Macros - Introduction to VBA||Basics of VBA
Using Macros to Automate repetitive tasks
Creating User defined Functions
|Maintaining Financial Statements in Excel - Good Practices||Maintaining Grouping and GL Mappings used in Financial Statements
Tracing and Posting Journal Entries
Budgeting and Variable Analysis
|Building Scenarios, Models and doing what if analysis||Doing Scenario Analysis
Use of Scenario Manager
Doing What if Analysis
Using Solver to Maximize Profit and Minimize Cost
Easy to follow byte sized video tutorials created by topic experts. Learn the concepts at your own pace.
Create models following a step-by-step approach devised by professionals. These workbooks have been specially designed to ensure you incorporate best industry practices of LBO modeling.
Download the whole material anytime during your 1 year subscription and use it for any future reference.
A reference to get ahead in your career. At the end of the course, you will receive a Certificate of Participation. You can also earn the Certificate of Excellence upon completing our course assignment (Please get in touch with our sales representative for more details).
Your work and ability to explain it is fantastic.You are teaching the visual display of quantitative information in a way that would make Edward Tufte proud
Your Ability to Synthesise Information & Your Constant Reinforcement of Key Concepts Throughout the Lessons is Extremely Helpful. The sessions were extremely professional.
We have an active forum, where you can raise your doubts. We will be happy to share our knowledge.
Recorded video lectures with follow up course materials .
Around 9 hours of asynchronous recordings that you can listen to at your own pace.
Global Association of Risk Professionals, Inc. (GARP®) does not endorse, promote, review or warrant the accuracy of the products or services offered by EduPristine for FRM® related information, nor does it endorse any pass rates claimed by the provider. Further, GARP® is not responsible for any fees or costs paid by the user to EduPristine nor is GARP® responsible for any fees or costs of any person or entity providing any services to EduPristine Study Program. FRM®, GARP® and Global Association of Risk Professionals®, are trademarks owned by the Global Association of Risk Professionals, Inc
CFA Institute does not endorse, promote, or warrant the accuracy or quality of the products or services offered by EduPristine. CFA Institute, CFA®, Claritas® and Chartered Financial Analyst® are trademarks owned by CFA Institute.
Utmost care has been taken to ensure that there is no copyright violation or infringement in any of our content. Still, in case you feel that there is any copyright violation of any kind please send a mail to email@example.com and we will rectify it.
2015 © Edupristine. ALL Rights Reserved.