fbpx

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/-Ā 

Play Video

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!

Course Duration

7 Live Session

Course Mode

Online

Next Batch

Chaitra 2079

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

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. which shall be released soon.

How to get Started

Step: 1
Step: 1

Create a Free Account

Register to join our online learning platform by filling out our inquiry form.

Register Now
Step: 2
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
Step: 3

Get Access to Our Resource Materials

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

Step: 4
Step: 4

Attend live sessions

Clear your doubts and confusion in our interactive live sessions

Step: 5
Step: 5

Complete Assessment Test

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

Step: 6
Step: 6

Get Course Completion Certificate

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

Upgrade Your Profile!

KBA Certificate

Listen to our Students!

Amrita Nyaupane
Amrita Nyaupane
Read More
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 .
Sunita Gurung
Sunita Gurung
Read More
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
Nirajan Shakya
Nirajan Shakya
Read More
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 šŸ˜‰
Kamal Adhikari
Kamal Adhikari
Read More
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.
Pratikshya Poudel
Pratikshya Poudel
Read More
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.
Saroj Sapkota
Saroj Sapkota
Read More
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.
Previous
Next

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:

  1. Basic Navigation
  2. Data Entry
  3. Formulas and Functions
  4. Conditional Formatting
  5. Pivot Tables
  6. Charts and Graphs
  7. 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

Get in touch with our team!

Get started with the most interactive, practical and career enhancement courses from KBA!

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.