The complete 40+Video Tutorials+Study Notes+Progress Reports+Compatible on different platforms on Advanced Finance Excel for Accounting BASIC
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.
COMPATIBLE ON DIFFERENT PLATFORMS: Use our specially-designed LMS(Learning Management system) on your phone, desktops, tablets & across various platforms viz. Windows, etc.
ONLINE VIEWING + DOWNLOAD ACCESS: With every purchase made with us, you get exclusive access to our downloads library for 1 year."
|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
All faculty at EDUPRISTINE are domain experts from the industry with many years of experience in their fields.
Founded by industry professionals from MNCs like Standard Chartered, Goldman Sachs, S & P and Accenture, EduPristine is known as a Premier Finance Training Provider around the world. EduPristine follows CFA Institute Prep Provider Guidelines plus as an authorized training provider for FRM® and PRM, it has also become the name trusted by Undergraduate Students, Finance Professionals and MBAs alike. What sets EduPristine apart is its user-friendly approach and each course's teaching methodology that includes the unique concept of online video tutorials.