Excel Course for Accountants

For a Better Career Foundation

Master Excel and streamline your accounting tasks! Our course offers practical and relevant techniques that are guaranteed to save you time. Join now and become an Excel-savvy accountant!

Rs. 3,000/-

Excel Course for Accountants

For a better career foundation

Master Excel and streamline your accounting tasks! Our course offers practical and relevant techniques that are guaranteed to save you time. Join now and become an Excel-savvy accountant!

Rs. 3,000/-

Course Duration

7 Live Session

Course Mode

Online

Next Batch

Every Friday

Excel E-Books For Quick Reference

KBA provides you with multiple E-Books and Quick References for your conceptual clarity. Our study materials are often designed with practical illustrations and summarized versions.

50+ Templates For Practicing

Only obtaining theoretical accounting knowledge is not adequate for long-term career growth. We help you with multiple practice templates where you can experiment & learn with real data.

Interactive Live Sessions

Your learning experience will be maximized with our live sessions in addition to on-demand concept videos. You can interact, discuss real-life queries and clear your confusion.

Excel E-Books For Quick Reference

KBA provides you with multiple E-Books and Quick References for your conceptual clarity. Our study materials are often designed with practical illustrations and summarized versions.

50+ Templates For Practicing

Only obtaining theoretical accounting knowledge is not adequate for long-term career growth. We help you with multiple practice templates where you can experiment & learn with real data.

Interactive Live Sessions

Your learning experience will be maximized with our on-demand concept videos in addition to live sessions. You can interact, discuss real-life queries and clear your confusion.

Course Contents:

1. Basic Accounting Functions

Introduction to Excel for Accountants
Using Excel Shortcuts
Basic Summary Functions
Number, Text & Date Functions

2. Data Formatting Tools

Using Accounting Data Filter
Conditional Formatting
Getting help with Data Validation
Excel Table for efficiency
Sorting & Organizing Accounting Records

3. Data Analytics

If Functions for logical test
AND, OR, NOT Functions
VLOOKUP & HLOOKUP to retrieve specific data
INDEX & MATCH Functions

4. Pivot Table in Accounting

Creating Pivot Table for complex data
Value Field Setting for computation
Refreshing Pivot for change in data source
Table Layout & Extraction

5. Financial Reports with Excel

Importing & Preparation of FS
Tax Calculator
Repayment Schedule
Layout, Page Set-up & Protection
Printing Your Reports

6. Troubleshoot in Excel

Common Errors in Excel
Error checking and evaluation
Tracing Precedent & Dependent

Meet your Mentor

CA Gunjana Manandhar

This course is exclusively developed and delivered by CA Gunjana Manandhar. She qualified her Chartered Accountancy from ICAI, India in 2017 with All India Rank 49. She then moved to Barclays India where she got an opportunity to work on Taxation & Finance. In 2019, she returned to Nepal and co-founded Khata Business Academy. She has also been involved in the preparation of several other courses in KBA like NFRS For Accountants, Corporate Finance Practicals, etc.

How to get Started

Step: 1

Create a Free Account

Step: 2

Make Necessary Payment

You need to make a payment to access our resources. Once the payment is done, kindly send it on WhatsApp or on any Social Media Handle

Send in WhatsApp

Step: 3

Get Access to Our Resource Materials

Start learning with our Conceptual Videos, E-Books, and Practice Templates

Step: 4

Attend live sessions

Clear your doubts and confusion in our interactive live sessions

Step: 5

Complete Assessment Test

Once the course is completed, select and attempt the quiz in your portal

Access Learning Page

Step: 6

Get Course Completion Certificate

Score at least 70% in the assessment test to be eligible for Completion Certificate

Upgrade Your Profile!

Listen to our Students!

I really want to appreciate and thank you KBA for giving us knowledge and skill ,the way you were interacting with us was very wonderful as well as the way of teaching.Learning was made interesting as the concept were taught clearly and precisely. Secondly i would say teaching staff was very helpful for communication even after class my doubts were solved personally in a simple and easy manner that was very delightful .

Khata Business Academy has exceeded my expectations. I’m so glad that I chose to enrol in their online accounting training because it has been highly productive during this lockdown. Tutors were incredibly knowledgeable and their teaching styles were very interactive despite the fact it was virtual. This is the first time i have completed this kind of course and I enjoyed it very well. Thank you KBA

My honest recommendation, you won't regret studying here you will get enough information both theoretically and practically about accounting plus extra knowledge in a minimum time period. I was a student of this academy I got a new experience, new studying technique and the most important, networking with different people with different opportunity. Get the hell out of your comfort zone and try it you will be the next recommending the same 😉

I didn't even thought about your class, I'm a bachelor student now, 11-12, I read a lot about accounting till bachelor but after coming to your class I feel like I have a lot to learn, I got a chance to learn a lot of knowledge and I'm all thankful for your service. I want to learn more knowledge. I am always grateful for the account business. I hope you will give me a chance.

Hajur haru ko padhaone ramro lagyo malai, Sano sano kura pani bujhaonu hunnx. Plus paxi pahi guide garnu hunnx so overall price chai justify nai as per the material provided to learn.

I just completed the interactive Tally training and I am blown away by how helpful and comprehensive it was. The interactive quizzes and exercises really helped me retain the material and put my new skills into practice. The training was well-organized and easy to follow, and I feel much more confident using Tally now. I highly recommend this training to anyone especially for those who want to learn computarized accounting softwares and looking to learn or improve their skills in Tally.

Frequently Asked Questions

How are KBA Online Courses delivered?

We use On-demand conceptual videos as well as interactive live sessions to deliver our course to our learners. Apart from these videos, we also feature multiple practice templates, E-books & quick references to provide you with practical understanding.

Who is this course for?

If you’re an accountant, recently graduate, freelancer, or finance professional looking to enhance your Excel for accounting skills, this course is perfect for you. While prior accounting knowledge is recommended, no previous experience with Excel for accounting is necessary.

Is it necessary for accountants to learn MS Excel?

Yes, it is very important for accountants to learn MS Excel as it is a powerful tool that can greatly aid in accounting tasks. Excel is a spreadsheet software that allows users to organize, analyze, and manipulate data in various ways.

What are the basic excel skills an accountant needs to have?

Some of the basic excel skills an accountant needs to have can be listed as below:

Basic Navigation
Data Entry
Formulas and Functions
Conditional Formatting
Pivot Tables
Charts and Graphs
Data Validation

Do I need to visit KBA Center physically?

No, since this course is delivered online, you do not need to visit our learning centers.

How do I enroll in this course?

Please feel free to fill up the form in the “Enroll Now” section below or contact us directly at 9801074002 for payment and other enrollment matters.

How do I make payments?

E-Sewa: 9801074001
KHATA BUSINESS ACADEMY PVT LTD
NIC Asia Bank:
A/c No: 1044150060267002
A/c Name: KHATA BUSINESS ACADEMY PVT LTD
Branch: BHARATPUR

Can I get a job after this course?

You get a job when you convince your interviewer that you are the right candidate for a given profile. We shall certainly help you with the necessary financial reporting skills to enhance your accounting career and promote your current standing in your company.

Is there any discounts available on this course?

Please feel free to connect with our course team for any discount or referral-related matters: 9801074002 or https://wa.me/9779801074002

Looking for other courses?

KBA has got you covered! We have a range of Accounting & Taxation courses which you can choose according to your career requirement.

Excel Course for Accountants

For a Better Career Foundation

Rs. 3,000/-

Excel Course for Accountants

For a better career foundation

Rs. 3,000/-

Course Duration

Course Mode

Next Batch

Excel E-Books For Quick Reference

50+ Templates For Practicing

Interactive Live Sessions

Excel E-Books For Quick Reference

50+ Templates For Practicing

Interactive Live Sessions

Course Contents:

1. Basic Accounting Functions

Introduction to Excel for Accountants

Using Excel Shortcuts

Basic Summary Functions

Number, Text & Date Functions

2. Data Formatting Tools

Using Accounting Data Filter

Conditional Formatting

Getting help with Data Validation

Excel Table for efficiency

Sorting & Organizing Accounting Records

3. Data Analytics

If Functions for logical test

AND, OR, NOT Functions

VLOOKUP & HLOOKUP to retrieve specific data

INDEX & MATCH Functions

4. Pivot Table in Accounting

Creating Pivot Table for complex data

Value Field Setting for computation

Refreshing Pivot for change in data source

Table Layout & Extraction

5. Financial Reports with Excel

Importing & Preparation of FS

Tax Calculator

Repayment Schedule

Layout, Page Set-up & Protection

Printing Your Reports

6. Troubleshoot in Excel

Common Errors in Excel

Error checking and evaluation

Tracing Precedent & Dependent

Meet your Mentor

CA Gunjana Manandhar

How to get Started

Create a Free Account

Make Necessary Payment

Get Access to Our Resource Materials

Attend live sessions

Complete Assessment Test

Get Course Completion Certificate

Upgrade Your Profile!

Listen to our Students!

Frequently Asked Questions

Looking for other courses?

Practical Accounting Course

Business Taxation Course

Start with Enrollment Process!

Want to connect with us?