WhatsApp Excel for Accountants | Khata Academy
+9779801074002
learn@khataacademy.com
English flag
English
Select a Language
English flag
English
Nepali flag
Nepali
0
Login Register
Categories
Home Courses Store Forums Blogs Jobs
Explore Courses
20% Special offer
0 : 0 : 0 : 0
Day Hr Min Sec
Excel for Accountants
Courses Software Skills

Excel for Accountants

Master Excel for Accounting: Streamline your financial tasks with essential Excel skills for accountants.
(8)
857 Students
77 Lectures
CA Gunjana Manandhar
CA Gunjana Manandhar

Instructor

About
Content
Comments 2
Reviews 8

About this Course




Requirements

Internet Connection
Laptop/Computer
MS Office Package Installed
Requirements

FAQ

Check the frequently asked questions about this course.

1. Who is this Excel for Accountants course for?
This course is designed for accountants, finance professionals, students, and anyone who wants to use Excel confidently for accounting and reporting work.
2. How long will I have access to the course?
You will get 12 months of access, including video lessons, practice templates and downloadable resources.
3. Will I get a certificate after completing the course?
Yes. You will receive an official course completion certificate from Khataacademy after successfully completing the course.
CA Gunjana Manandhar
CA Gunjana Manandhar
(5)
7 Courses
3086 Students
Qualified 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.
CA Gunjana Manandhar

Recent Reviews

See what students are saying about the course.

More Reviews
ANIL LAMA
ANIL LAMA 7 Jun 2025
.
Subash Chandra Adhikari
Subash Chandra Adhikari 15 May 2025
Ravi Shrestha
Ravi Shrestha 3 Jun 2024
Prabin Thapaliya
Prabin Thapaliya 4 Mar 2024
Saroj Sapkota
Saroj Sapkota 8 Aug 2023
Curriculum Overview

This course includes 11 modules, 77 lessons, and 0 hours of materials.

01. Course Structure
3 Parts
Course Syllabus
Free
Volume 0 bytes MB
Play
1.1 Course Introduction [Free]
Free
Volume -
Play
EXCEL Shortcuts PDF
Volume 1.27 MB
02. Data Entry & Basic Formatting
9 Parts
2.1 Data Entry & Editing [Free]
Free
Volume -
Play
eBook: Excel Introduction
Volume 0 bytes MB
2.2 Navigate Data Screen [Free]
Free
Volume -
Play
2.3 Selection Method
Volume 0 bytes MB
2.4 Basic Formatting Part-1
Volume 0 bytes MB
2.5 Basic Formatting Part-2
Volume 0 bytes MB
2.6 Practice Video
Volume -
eBook: Data Entry and Basic Editing
Volume 0 bytes MB
Chapter 2 - Practice Templates
Volume 0.015 MB
03. Basic Accounting Functions
6 Parts
3.1 Cell Reference [Free]
Free
Volume -
Play
3.2 Summary Functions
Volume 0 bytes MB
3.3 Text Function
Volume 0 bytes MB
3.4 Cell Reference & Text Function Practice
Volume -
eBook: Basic Accounting Functions
Volume 0 bytes MB
Chapter 3 - Practice Templates
Volume 0.03 MB
04. Basic Data Analysis Tools
5 Parts
4.1 Sort & Filter [Free]
Free
Volume -
Play
4.2 Conditional Formatting
Volume 0 bytes MB
4.3 Data Validation
Volume 0 bytes MB
eBook: Basic Data Analysis Tool
Volume 0 bytes MB
Chapter 4 - Practice Templates
Volume 0.07 MB
05. Organizing Data & Presentation
5 Parts
5.1 Organizing Worksheets
Volume 0 bytes MB
5.2 Organizing Worksheet Practice
Volume -
5.3 Table
Volume 0 bytes MB
eBook: Organizing Data and Presentation
Volume 0 bytes MB
Chapter 5 - Practice Templates
Volume 0.3 MB
06. Data Analytics Function
10 Parts
6.1 Data Analytics Functions Part 1
Volume 0 bytes MB
6.2 Data Analytics Functions Part 2
Volume 0 bytes MB
6.3 If Logical Formula Practice
Volume -
eBook: Data Analytics Function
Volume 0 bytes MB
6.4 Logical Summation Function Practice
Volume -
6.5 Pivot Table
Volume 0 bytes MB
6.6 Pivot Table Practice
Volume -
eBook: Pivot Table
Volume 0 bytes MB
6.7 Formula in Conditional Formatting
Volume 0 bytes MB
Chapter 6 - Practice Templates
Volume 0.25 MB
07. Financial Reporting Tools
10 Parts
7.1 Hyperlink Part 1
Volume 0 bytes MB
7.2 Hyperlink Part 2
Volume 0 bytes MB
7.3 Header & Footer
Volume 0 bytes MB
7.4 Screenshot
Volume 0 bytes MB
7.5 Illustrations
Volume 0 bytes MB
7.6 Page Layout
Volume 0 bytes MB
7.7 Miscellaneous
Volume 0 bytes MB
eBook: Financial Reporting Tools
Volume 0 bytes MB
Chapter 7 - Practice Templates
Volume 0.5 MB
Certification
Questions 1
Duration 5 Minutes
Passing Grade 100/100
Total Grade 100
Attempts 0/
08. Accounting task in Excel
10 Parts
8.1 Nepali Date Converter
Volume -
8.2 Preparation of VAT Summary in Excel
Free
Volume -
Play
8.3 VAT Summary Part II
Volume -
8.4 VAT Summary part III
Volume -
8.5 Annexure 13 Preparation
Volume -
8.6 Annexure 13 Preparation Part-2
Volume -
8.7 Fixed Asset Register
Volume -
8.8 Fixed Asset Register Part 2
Volume -
8.9 Fixed Asset Register Part 3
Volume -
8.10 Party Confirmation
Volume -
01. Basics of MS-Word
9 Parts
1.1 Table of content in MS Word
Volume -
1.2 Creating a blank Document in MS Word
Volume -
1.3 Save and Save as option in MS Word
Volume -
1.4 Select and Edit text in MS Word
Volume -
1.5 Cut, Copy and Paste in MS Word
Volume -
1.6 Undo and Redo option in MS Word
Volume -
1.7 Find and Replace option in MS Word
Volume -
1.8 Print option in MS Word
Volume -
1.9 Print Preview option in MS Word
Volume -
02. Layouts and Formatting in MS-Word
6 Parts
2.1 Formatting option in MS Word part 1
Volume -
2.2 Formatting in MS Word part 2
Volume -
2.3 Page layout option in MS Word
Volume -
2.4 Page Background in MS Word
Volume -
2.5 Table option in MS Word part 1
Volume -
2.6 Table - Row and Columns option part 2
Volume -
03. Other Important Option in MS-Word
4 Parts
3.1 Autofit option in MS Word
Volume -
3.2 Insert Illustration option
Volume -
3.3 Header and Footer option
Volume -
3.4 Review part in MS Word
Volume -
Certificates
2 Parts
Certificate
Quiz Certificate
You will receive this certificate after passing the “CertificationZ” quiz.
Type Quiz Certificate
Passing Grade 100/100
Course Certificate
Course Certificate
If you pass all the lessons in this course, you will receive this certificate.
Type Course Certificate
Leave a Comment
Please log in to leave a comment.
Sun Bahadur Gurung
Sun Bahadur Gurung
Student
19 Aug 2024
I set Data Validation in a file and it works properly until that file closes. But it does not show that Data Validation after opening that file once closed. Why so happens?
Sujan Shah
Sujan Shah
Admin
20 Aug 2024
It works on our system, may be file save navayera huna sakchha, or try on another PC with latest version of MS Office installed
Saiman tamang
Saiman tamang
Student
10 Aug 2023
mam personal pan ma vako tax haru ko etds garna milxa rw yedi milxa vani kasari gari teo process vanidinu pariyo it's urgent.
Reply to Comment
Comments Approval

Your comment will be visible after admin approval.

4.78
8 Reviews
Content Quality (4.8)
Instructor Skills (4.6)
Value for Money (5)
Support Quality (4.8)
Indrakala Yadav
Indrakala Yadav
3 Apr 2026 11:30 am
I am Indrakala Yadav, an ACCA student. The Excel course at Khata Academy is really excellent. CA Gunjana teaches very well and is very supportive. She even helps with CV preparation, guiding us on how to make a strong CV. The best part is that Khata Academy also shares job vacancies, which is really helpful for freshers and even higher-level students. The whole team is great and always ready to help. Highly recommended!
Anita Shrestha
Anita Shrestha
12 Feb 2026 08:57 pm
ANIL LAMA
ANIL LAMA
7 Jun 2025 12:29 pm
.
Subash Chandra Adhikari
Subash Chandra Adhikari
15 May 2025 08:26 am
Subash Poddar
Subash Poddar
2 Dec 2024 09:46 pm
Ravi Shrestha
Ravi Shrestha
3 Jun 2024 07:44 pm
Prabin Thapaliya
Prabin Thapaliya
4 Mar 2024 04:48 pm
Saroj Sapkota
Saroj Sapkota
8 Aug 2023 11:12 am
Reply to Review
Submit Reply

Your reply to this review will be visible to all users.

Excel for Accountants
Rs.2,400
Rs.3,000

This Course Includes

Downloadable Content
1 Online Quiz(zes)
Official Certificate
Instructor Support
Favorite
Share
Report Content

Course Specifications

Sections
11
Lessons
77
Capacity
Unlimited
Duration
15:00 Hours
Students
857
Access Duration
366 Days
Created Date
10 Mar 2023
Updated Date
13 Mar 2026
CA Gunjana Manandhar
CA Gunjana Manandhar

(5)
Faithful User
Expert Vendor
Golden Classes
Top Seller
Fantastic Support
Forum Loyal User
Profile

Send Course as Gift

Send as a gift to friends

Tags

Excel Excel course Excel Training Excel for Accountants
Certificate validation - Course page
Excel for Accountants
You are viewing
Excel for Accountants
footer cta btn icon
Let’s get started now!

Partner in Your Accounting Journey!

Explore Courses

Important Links

Login Register Forget Password Certificate Validation Terms & Conditions

Additional Links

WhatsApp Discussion Forum Webinars Contact Us About Us Privacy Policy

Contact US

Bharatpur-10, Hakim Chowk, Chitwan, Nepal
+9779801074002
+9779801074002
learn@khataacademy.com
© 2025 Khata Business Academy Pvt. Ltd. | All Rights Reserved.
Facebook Instagram LinkedIN Whatsapp YouTube
Cart
Subtotal
View Cart