CAKART Excel for Accounting - BASIC

Excel for Accounting - BASIC

The complete 40+Video Tutorials+Study Notes+Progress Reports+Compatible on different platforms on Advanced Finance Excel for Accounting BASIC

Overview of Excel for Accounting - BASIC


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.


Table of contents


Module Name
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


Video Tutorials 
Easy to follow byte sized video tutorials of over 400 minutes created by topic experts. Learn the concepts at your own pace.
Unlimited Download Access 
Download the whole material anytime during your 1 year subscription and use it for any future reference.
Study Notes 
Download the study notes to supplement video tutorials.
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).
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
Mike Whitehead
Your Ability to Synthesise Information & Your Constant Reinforcement of Key Concepts Throughout the Lessons is Extremely Helpful. The sessions were extremely professional.
Mohamed Riyale


About faculty of Excel for Accounting - BASIC

All faculty at EDUPRISTINE are domain experts from the industry with many years of experience in their fields.

About institute

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.

Reviews of Excel for Accounting - BASIC

Rating - 4.2
5 stars 0
4 stars 0
3 stars 0
2 stars 1
1 stars 0

Have you used
Excel for Accounting - BASIC?

Rate Now:
Get Notifications
Watch best faculty demo video classes

These top faculty video lectures will
help u prepare like nothing else can.