Log In

E Accounting Diploma Course

E Accounting Diploma Course Accounting
  • curriculum

Excel Module

Excel Basics

Lesson 1.1: What is Excel? Lesson 1.2: What Kind of Work Excel Does? Lesson 1.3: What are Columns, Rows, and Cells? Lesson 1.4: Insert Values in a Cell Lesson 1.5: Basic Cell Reference & Practice Lesson 1.6: What are Workbooks & Worksheets? Lesson 1.7: Tabs & Ribbons

Excel 2- Save Workbook:

Lesson 2.1: Save Workbook

Excel 3- Basic Data & Formula:

Lesson 3.1: Basic Data & Formula

Excel 4- Understanding Excel Syntax:

Lesson 4.1: What is Syntax?

Excel 5- Essential Math Functions:

Lesson 5.1: SUM Syntax Essentials Lesson 5.2: SUM Syntax Practical Lesson 5.3: MAX Syntax Essentials Lesson 5.4: MAX Syntax Practical Lesson 5.5: MIN Syntax Essentials Lesson 5.6: MIN Syntax Practical Lesson 5.7: AVERAGE Syntax Essentials Lesson 5.8: AVERAGE Syntax Practical Project 1 - Sales Performance Dashboard Project 2 - Budget Tracker

Excel 6- Advanced Math Functions:

Lesson 6.1: LARGE Syntax Essentials Lesson 6.2: LARGE Syntax Practical Lesson 6.3: SMALL Syntax Essentials Lesson 6.4: SMALL Syntax Practical Project 1 - Top 5 Sales Performance Project 2 - Small Inventory Level Tracker

Excel 7- Ranking & Referencing:

Lesson 7.1: Basic of RANK Syntax Lesson 7.2: Create Marksheet with RANK Syntax Lesson 7.3: Absolute & Relative Reference (MOST IMPORTANT) Lesson 7.3: Absolute & Relative Reference (MOST IMPORTANT)

Excel 8- IF Functions:

Lesson 8.1: IF Syntax Essentials & Practical Lesson 8.2: NESTED IF Syntax Essentials & Practical Project 1 - 26 Condition IF Formula Practice

Excel 9- Conditional Mathematical Functions:

Lesson 9.1: SUMIF Syntax Essentials Lesson 9.2: SUMIF Syntax Practical Lesson 9.3: AVERAGEIF Syntax Essentials Lesson 9.4: AVERAGEIF Syntax Practical Lesson 9.5: COUNT Syntax Essentials & Practical Lesson 9.6: COUNTA Syntax Essentials & Practical Lesson 9.7: COUNTIF Essentials & Practical Lesson 9.8: COUNTIF Practical with Name Manager Project 1 - Sales Performance Analysis Project 2 - Customer Satisfaction Survey Project 3 - Customer Segmentation

Excel 10- Advanced Conditional Functions:

Lesson 10.1: SUMIFS Syntax Essentials & Practical Lesson 10.2: SUMIFS Syntax Practical with Name Manager Lesson 10.3: AVERAGEIFS Syntax Essentials & Practical Lesson 10.4: AVERAGEIFS Syntax Practical with Name Manager Lesson 10.5: COUNTIFS Syntax Essentials & Practical Lesson 10.6: COUNTIFS Syntax Practical with Name Manager Project 1 - Analyze Financial Performance

Excel 11- Working with Date & Time:

Lesson 10.1: SUMIFS Syntax Essentials & Practical

Tally Module

Tally.ERP9 - 1. Learn Accounting First:

Lesson 1.1- Nature of accounting Lesson 1.2- Husband wife relationship Lesson 1.3- Modern rules of accounting Lesson 1.4- Four steps in accounting

Tally.ERP9 - 2. Basic Accounting Entries:

Lesson 2.1- Basic accounting entries

Tally.ERP9 - 3. Advance Accounting:

Lesson 3.1- Advance accounting concept

Tally.ERP9 - 4. Download Tally ERP9:

Lesson 4.1- Download Tally ERP9

Tally.ERP9 - 5. Create Company In Tally ERP9:

5.1- Create company in Tally.ERP9

Tally.ERP9- 6. Contra Vouchers:

Lesson 6.1- Contra vouchers logics Lesson 6.2- Contra vouchers ledgers Lesson 6.3- Contra vouchers entries

Tally.ERP9- 7. Payment Vouchers:

Lesson 7.1- Payment vouchers logics Lesson 7.2- Payment vouchers ledgers Lesson 7.3- Payment vouchers entries

Tally.ERP9- 8. Receipt Vouchers:

Lesson 8.1- Receipt vouchers logics Lesson 8.2- Receipt vouchers ledgers Lesson 8.3- Receipt vouchers entries

Tally.ERP9- 9. Journal Vouchers:

Lesson 9.1- Journal vouchers logics Lesson 9.2- Journal vouchers ledgers Lesson 9.3- Journal vouchers entries

Tally.ERP9- 10. Purchase Vouchers:

Lesson 10.1- Purchase vouchers logics Lesson 10.2- Purchase vouchers ledgers Lesson 10.3- Purchase vouchers entries

Tally.ERP9- 11. Sale Vouchers:

Lesson 11.1- Sale vouchers logics Lesson 11.2- Sale vouchers ledgers Lesson 11.3- Sale vouchers entries

Tally.ERP9- 12. Debit Note Vouchers:

Lesson 12.1- Debit Note vouchers logics Lesson 12.2- Debit Note vouchers entries

Tally.ERP9- 13. Credit Note Vouchers:

Lesson 13.1- Credit Note vouchers logics Lesson 13.2- Credit Note vouchers entries

Tally.ERP9- 14. Export Balance Sheet,Trial Balance:

Lesson 14.1- Export Balance Sheet,Trial Balance

MIS (Management Information System) Module

MIS 1 - VLOOKUP Syntax:

Lesson 1.1 - VLOOKUP Essentials & Practical

MIS 2 - HLOOKUP Syntax:

Lesson 2.1 - HLOOKUP Essentials & Practical

MIS 3 - Introduction To MIS:

Lesson 3.1 - What is MIS?

MIS 5 - Payroll Sheet Dashboard:

Lesson 5.1 - Payroll Sheet Dashboard

MIS 6 - Raw Sheet Dashboard:

Lesson 6.1 - Raw Sheet Dashboard

MIS 7 - Pay Slip:

Lesson 7.1 - Pay Slip

MIS 8 - Sales Data Analysis & Pivot Table Reporting:

Lesson 8.1: Extracting Year & Month from Sales Data Lesson 8.2: Creating a Table & Naming It Lesson 8.3: Creating a Pivot Table Lesson 8.4: Creating PivotTables for Key Metrics Lesson 8.5: Formatting Values with Currency Symbol Lesson 8.6: Enhancing PivotTables with Additional Fields Lesson 8.7: Adding Filters for Dynamic Analysis Lesson 8.8: Data Cleaning & Modifications

MIS 9 - Advanced Data Visualization & Dashboard Creation:

Lesson 9.1: Sorting SalesRep PivotTable Lesson 9.2: Creating a Dashboard Worksheet Lesson 9.3: Creating a Pivot Table Lesson 9.4: Creating a Clustered Bar Chart for SalesRep Lesson 9.5: Sorting Product PivotTable Lesson 9.6: Creating a Clustered Column Chart for Product Lesson 9.7: Sorting Zone PivotTable Lesson 9.8: Creating a Doughnut Chart for Zone

MIS 10 - Advanced PivotTable Grouping, Visualization & Interactive Dashboard:

Lesson 10.1: Creating a New PivotTable for Date to Total Lesson 10.2: Setting Up Rows & Values in PivotTable Lesson 10.3: Grouping Data in PivotTable Lesson 10.4: Changing Sum to Count in PivotTable Lesson 10.5: Creating a 3D Column PivotChart for Grouping Lesson 10.6: Analyzing Year & Month Wise Performance Lesson 10.7: Creating a Line Chart with Markers for Performance Lesson 10.8: Creating an Interactive Slicer for SalesRep Performance Lesson 10.9: Connecting Slicers to All Charts

MIS 11 - PivotTable Management & External Data Connectivity:

Lesson 11.1: Connecting to an External Data Source Lesson 11.2: Creating a Recommended PivotTable Lesson 11.3: Copying & Moving a PivotTable Lesson 11.4: Deleting a PivotTable Lesson 11.5: Clearing & Reapplying a PivotTable Lesson 11.6: Copying Values Only from a PivotTable

Course Benefits:

  • Govt. Approved Diploma
  • Learn From Microsoft Experts
  • Next 6 Months / 1 Years Free Online Classes
  • Industrial Training Experience Letter
  • Practice Time
  • Proper Notes & Assignment
Join This course

Our Student Projects

Graphic Designing Projects

Web Development Projects

UI/UX Projects

Animation & Editing Projects

Contact Us:

testimonial
Our Google Maps Reviews

What Our Students Have
to Say

As a student, I was looking for a course to upskill myself. United Tech Era's flexible timings and weekend batches made it possible for me to balance work and learning. The course content is relevant and up-to-date, covering the latest tools and trends. I've made some great connections with fellow students and even secured a project collaboration through the institute's network. United Tech Era has been an excellent investment in my career growth.

Nisha Singh

Full Stack Developer

United Tech Era has been a game-changer for my career. The instructors are highly skilled and patient, breaking down complex concepts into easily understandable chunks. The hands-on projects and real-world scenarios they provide have given me a strong foundation in various technologies. I'm grateful for the support and guidance I've received here see it can.

Khusboo Singh

E Accounting

When I first joined United Tech Era, I was a complete beginner in programming. The structured curriculum and small batch sizes ensured that I received personalized attention. The faculty is incredibly knowledgeable and always ready to help, even outside of class hours. United Tech Era has not only equipped me with technical skills but also groomed me for interviews and placements. The industry collaborations and regular workshops have opened up numerous opportunities for me.

Sumit Singh

Web Developer

shape shape
united logo
Login
whatsapp icon contact icon back top