Excel for Accountants

01. Course Structure

3 Parts

Course Syllabus

0 bytes MB

Play

1.1 Course Introduction

0 bytes MB

EXCEL Shortcuts PDF

1.27 MB

02. Data Entry & Basic Formatting

9 Parts

2.1 Data Entry & Editing

0 bytes MB

eBook: Excel Introduction

0 bytes MB

2.2 Navigate Data Screen

0 bytes MB

2.3 Selection Method

0 bytes MB

2.4 Basic Formatting Part-1

0 bytes MB

2.5 Basic Formatting Part-2

0 bytes MB

2.6 Practice Video

eBook: Data Entry and Basic Editing

0 bytes MB

Chapter 2 - Practice Templates

0.015 MB

03. Basic Accounting Functions

6 Parts

3.1 Cell Reference

0 bytes MB

3.2 Summary Functions

0 bytes MB

3.3 Text Function

0 bytes MB

3.4 Cell Reference & Text Function Practice

eBook: Basic Accounting Functions

0 bytes MB

Chapter 3 - Practice Templates

0.03 MB

04. Basic Data Analysis Tools

5 Parts

4.1 Sort & Filter

0 bytes MB

4.2 Conditional Formatting

0 bytes MB

4.3 Data Validation

0 bytes MB

eBook: Basic Data Analysis Tool

0 bytes MB

Chapter 4 - Practice Templates

0.07 MB

05. Organizing Data & Presentation

5 Parts

5.1 Organizing Worksheets

0 bytes MB

5.2 Organizing Worksheet Practice

5.3 Table

0 bytes MB

eBook: Organizing Data and Presentation

0 bytes MB

Chapter 5 - Practice Templates

0.3 MB

06. Data Analytics Function

10 Parts

6.1 Data Analytics Functions Part 1

0 bytes MB

6.2 Data Analytics Functions Part 2

0 bytes MB

6.3 If Logical Formula Practice

eBook: Data Analytics Function

0 bytes MB

6.4 Logical Summation Function Practice

6.5 Pivot Table

0 bytes MB

6.6 Pivot Table Practice

eBook: Pivot Table

0 bytes MB

6.7 Formula in Conditional Formatting

0 bytes MB

Chapter 6 - Practice Templates

0.25 MB

07. Financial Reporting Tools

10 Parts

7.1 Hyperlink Part 1

0 bytes MB

7.2 Hyperlink Part 2

0 bytes MB

7.3 Header & Footer

0 bytes MB

7.4 Screenshot

0 bytes MB

7.5 Illustrations

0 bytes MB

7.6 Page Layout

0 bytes MB

7.7 Miscellaneous

0 bytes MB

eBook: Financial Reporting Tools

0 bytes MB

Chapter 7 - Practice Templates

0.5 MB

Certification

1 Questions

5 Min

Passed grade: 100/100

Attempts: 0/

08. Accounting task in Excel

2 Parts

8.1 Nepali Date Converter

8.2 Party Confirmation

01. Basics of MS-Word

9 Parts

1.1 Table of content in MS Word

1.2 Creating a blank Document in MS Word

1.3 Save and Save as option in MS Word

1.4 Select and Edit text in MS Word

1.5 Cut, Copy and Paste in MS Word

1.6 Undo and Redo option in MS Word

1.7 Find and Replace option in MS Word

1.8 Print option in MS Word

1.9 Print Preview option in MS Word

02. Layouts and Formatting in MS-Word

6 Parts

2.1 Formatting option in MS Word part 1

2.2 Formatting in MS Word part 2

2.3 Page layout option in MS Word

2.4 Page Background in MS Word

2.5 Table option in MS Word part 1

2.6 Table - Row and Columns option part 2

03. Other Important Option in MS-Word

4 Parts

3.1 Autofit option in MS Word

3.2 Insert Illustration option

3.3 Header and Footer option

3.4 Review part in MS Word

Excel Club Recordings

52 Parts

Episode 01 - Preparation of VAT Summary in Excel

Episode 02 - Preparation of Annexure 13

Episode 03 - Party Confirmation, Summary Report

Episode 04 - Fixed Asset Register

Episode 5 - Fixed Asset Schedule

Episode 6 - Purchase and Sales Register

Episode 7 - Hyperlink

Episode 8 - Excel Club Play with Dates

Episode 9 - Loan EMI Calculator

Episode 10 - Page Layout part 1

Episode 11 - All about Page Layout Part 2

Episode 12 - Tax Computation Excel Format

Episode 13 - Learn to Sort in more advanced way

Episode 14 - Accountants guide to MS Word

Episode 15 - Using MS Word Part 2

Episode 16 - Accountants Guide To MS Word Final Session.mp4

Episode 17 - Filter, Conditional Formatting & Useful Tips

Episode 18 - Utilizing Pivot Table in Accounting

Episode 19 - Restart From The Beginning - First Session

Episode 20 - Basic Accounting Functions in Excel.mp4

Episode 21 - Accounting Functions in Excel

Episode 22 - Sort & Filter

Episode 23 - Filter & Data Validation

Episode 24 - Using Nepali Date in MS Excel

Play

Episode 25 - Data Validation

Episode 26 - Conditional Formatting

Episode 27 - EXCEL Tables & Organizing Worksheets

Episode 28 - Application of If Function in EXCEL

Episode 29 - Using IF Function in Excel

Episode 30 - Accountants Guide to Conditional Summation

Episode 31 - Lookup Function

Episode 32: Excel Errors

Episode 33: Pivot Table

Episode 34: Pivot Table Settings and more

Episode 35: Page Layouts

Episode 36: Page Layout, Hyperlink, Header, footer, Misc topics

Episode 37:

Episode 38 Preparation of VAT Summary in Excel.mp4

Episode 39 VAT summary Part II.mp4

Episode 40 VAT Summary part II

EPISODE 41: Nepali Date Converter

Play

EPISODE 42 Party Confirmation

EPISODE 43 Annexure 13 preparation

EPISODE 44 Lookup Functions

EPISODE 45 : Annexure 13 preparation-Formula

EPISODE 46 Annexure 13 preparation part-2

EPISODE 47: Fixed Asset Register

EPISODE 48 Fixed Asset Part2

EPISODE 49 Fixed Asset Part-3

EPISODE 50 Cell Reference

EPISODE 51 Excel Security

EPISODE 52 Index Match

Sun Bahadur Gurung Student

19 Aug 2024 | 12:48 pm

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?

KBA Mod Student

20 Aug 2024 | 11:44 am

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 Student

10 Aug 2023 | 04:32 pm

mam personal pan ma vako tax haru ko etds garna milxa rw yedi milxa vani kasari gari teo process vanidinu pariyo it's urgent.

10 Aug 2023 | 05:52 pm

Kindly ask here: https://np.khataacademy.com/forums/create-topic?forum_id=2
And question lai alik elaborate garnu hola hai.

Samir Gaire Student

24 Apr 2023 | 11:15 pm

download nai hudainata mobile ma ta ebook??

Khata Academy Student

25 Apr 2023 | 08:23 am

Hi Samir!
None of the files are downloadable. You will get all the required practice materials as soon as class starts.

4.75

4 Reviews

Content quality (4.5)

Instructor skills (4.5)

Purchase worth (5)

Support quality (5)

Reviews (4)

Content quality

Instructor skills

Purchase worth

Support quality

Saroj Sapkota

8 Aug 2023 | 11:12 am

Thapaliya Prabin

4 Mar 2024 | 04:48 pm

Ravi Shrestha

3 Jun 2024 | 07:44 pm

Subash Poddar

2 Dec 2024 | 09:46 pm

Excel for Accountants

What you will learn?

About this course

Requirements

Comments (3)

Reviews (4)

Gift this course

Course specifications

CA Gunjana Manandhar

CA Bipin Lamsal

Tags

Report course

Share

Buy with points