Loading…
Data Visualization Course

About COURSE

This Excel for Accounting 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.

  • Video Recordings

    Easy to follow byte sized video tutorials of over 450 minutes created by topic experts. Learn the concepts at your own pace.

  • Excel Workbooks

    Create Financial models following a step-by-step approach devised by professionals. These workbooks have been specially designed to ensure you incorporate best industry practices of financial modeling.

  • Unlimited Download Access

    Download the whole material anytime during your 1 year subscription and use it for any future reference.

  • Certificate of Excellence

    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).

Course Structure

  • Importing Data from ERP Systems
  • Data mining and Lookups
  • Data formatting and Reporting tools
  • Working with External Data
  • Basics of VBA
  • Using Macros to Automate repetitive tasks
  • Creating User defined Functions
  • Maintaining Grouping and GL Mappings used in Financial Statements
  • Tracing and Posting Journal Entries Budgeting and Variable Analysis
  • Doing Scenario Analysis
  • Use of Scenario Manager
  • Doing What if Analysis
  • Using Solver to Maximize Profit and Minimize Cost

Schedule WHEN

 
loader
LocationStart DateBatch TypeClass Timing
LocationStart DateBatch TypeClass Timing
LocationStart DateBatch TypeClass Timing
LocationStart DateBatch TypeClass Timing

Need more info?

Just drop in your details and our support team will reach out to you as soon as possible.

Need more info?

Benefits WHY?

  • 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.

Reviews WHAT OTHERS SAY

Job well done!! The engagement with the EduPristine rep was favourable. The trainer, was knowledgeable. I like the fact that he has hands-on experience rather than just theory based.

Syahida Ismail Manager, Corporate Intelligence

Who should do this? TARGET

This course is aimed at entry level professionals in the Equity Research Field. It will enable MBAs, CAs, and newly appointed KPO Analysts to gain specific skill sets to enable success in job interviews and their career.

FAQsWHY?

Where can I get doubt clarifications?

What is the duration of the course?

- -