Microsoft Excel Advanced Course

CURRICULUM

Microsoft Excel 2016 Advanced – Computer Short Course Diploma Coaching Training in Sialkot Pakistan

It’s time to put Excel in her place. You’ve come to the perfect place if you want to learn Excel from scratch or if you want to become a true power user.

The complex Excel formulas and functions that turn Excel from a simple spreadsheet programme into a dynamic and potent analytics tool will be thoroughly explained to you in this course.

While most Excel classes only cover what each formula does, I teach using practical, real-world examples that explain why these formulae are great and how they can be used in a variety of contexts. I won’t teach you how to memorise formula syntax and functions; instead, I’ll show you how to THINK like an Excel user.

Installation and Basics

• Installtaion of MS Excel
• Understanding Interface
• Worksheets
• Cell
• Text
• Numberic

Customers

• Details
• Addresses
• Terms & Conditions
• Shipping
• Documentation

Vendors

• Details
• Addresses
• Terms & Conditions
• Shipping
• Sales
• Quotations

Sales

• Orders
• Invoicing
• Receipts
• Credit Memo

Bank Reconciliation

• Cheques
• Issuance
• Withdrawals
• Bank Statement
• Reconciliation
• Omission
• Recording Exp.+ Incomes

Inventory

• Types of Inventory
• Master Stock Items
• Prices
• Adjustments

Payroll

• Employees
• Representatives
• Salaries
• Income Tax
• Benefits
• Deductions
• Salary Slip
• Payment of Tax
• Benefits
• Linking with F/S

Budgeting

• Expenses
• Revenues
• Reporting
• Analysis

Purchases

• Purchase Orders
• Receiving
• Payments
• Discounts
• Debit Memo

Professional Training

• Professional CV Making
• Professional Dressing
• Interview Preparation
• Job Application Writing
• Job Form Filling
• Accountant’s Job Ethics
• Professional Behavior of Accountant
• Filing & Record Keeping
• Office Management
• Personality Development

Microsoft Excel Advanced Course