Excel for Accounting

BY
Edupristine

Mode

Online

Fees

₹ 10000

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study
Mode of Delivery Video and Text Based

Course and certificate fees

Fees information
₹ 10,000
certificate availability

Yes

certificate providing authority

Edupristine

The syllabus

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

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books