Office Automation & Finance Accounting Course

Are you ready to advance your career in office automation and finance accounting? Enroll now in our Advanced Diploma program In Ahmedabad designed to equip you with essential skills for today’s workplace. Our comprehensive course covers advanced office automation tools and finance accounting techniques, ensuring you gain hands-on experience and practical knowledge. Taught by institute experts, you’ll master software applications crucial for efficient office operations and financial management near you. Upon completion, opening doors to exciting career opportunities in office administration and finance. Don’t miss this chance to enhance your skills and accelerate your career growth. Contact us today to enroll and secure your place in our Advanced Diploma in Office Automation & Finance Accounting Course!

Office Automation & Finance Accounting Course Module

Fundamental of Computer with Word, PPT & Excel

English Typing
Basic of Computer networks
Concept of Internet
WWW and Web Browsers
Web Browsing Software
Giving the URL address

Word Processing

Opening Word Processing Package
The Menu Bar
Using the Help
Using the Icons below menu bar
Opening Documents and Closing documents
Opening Documents
Save and Save AS
Page Setup
Printing of Documents
Using the Icons below menu bar
Display/Hiding of Paragraph Marks and Inter
Word Space
Moving Around in a Document
Scrolling the Document
Scrolling by line/paragraph
Fast Scrolling and Moving Pages
Text Creation and Manipulation
Paragraph and Tab Setting
Text Selection
Cut, copy and paste
Font and Size selection
Bold, Italic and Underline
Alignment of Text: Center, Left, right and Justify
Formatting the Text
Changing font, Size and Color
Paragraph indenting
Bullets and Numbering
Use of Tab and Tab setting
Changing case
Table Manipulation
Concept of table: Rows Columns and Cells
Draw Table
Changing cell Width and Height
Alignment of Text in Cell
Copying of cell
Delete/insertion of row and columns
Borders for Table

Making Presentations

Difference between presentation and
document
Using Power Point
Opening a Power Point Presentation
Using Wizard for creating a presentation
Creation of Presentation
Text Creation
Fonts and Sizes
Moving to Next Slide
Bullets and indenting
Selection of type of Slides
Using the Slide Show
Printing the Slides and Handouts
Slide sorter
Title sorter

Basic Excel to Advanced Excel

Introduction to excel
How is excel important to business
Understanding the excel interface
Insertion and Deletion in excel
Basic Formatting in excel
Data types in excel

Sort & Filter

Applying the sort Function
Applying the filter Function
Applying the Advanced Filter Function
Uses of Short Function to Analysis the Data

Text Functions

Using The Upper, Lower and Proper Functions
Using The Right, Left And Search Functions
Using the Trim, Concat and Len Functions

Statistical Functions

Using the MIN, MAX, AVERAGE functions
Finding the Standard Deviations
Find the Percentiles of data
Finding the outliers present in data
Array functions

Logical Functions

Using the If Functions
Using the IF ERROR Function
Applying the COUNTIF Function
Applying the SUMIF Function
Applying the AVERAGEIF function

Conditional Formatting

Using Colobars for Formatting
Using Color Scale for Data Formation
Lookup Functions
Applying VLOOKUP Function
Applying HLOOKUP Function
Applying XLOOKUP Function

Index and Match

Why to use index And Match
Applying Index and match

Pivot Tables

Making Pivot tables
Making Pivot Charts
What If Analysis
Goal Seek Analysis
Data Tables Scenario Management

Regression

Understanding Regression
Performing Liner Regression

Macros in Excel

Understanding Excel macros
Activating the Developer tab in excel
Creating your First Macro
File Types and Savings
Running a macro Using keyboard shortcuts
Running macros Using Buttons

Getting Started With VBA

Navigating the Visual Basic Editor
VBA Projects
Excel’s VBA Object Model
Where Do I put my Code?
Understanding Code: Macro Process
Editing & Deleting the Macros

Introduction to Excel Charts & Smart Art Graphics

Training On Charts
Bubble Charts
Pyramid Chart
Surface Chart
Tree map Charts
Donut Charts

How to Create Business Analytics Dashboards

Data Cleaning
Data Sorting
Data Visualization

Advance formulas

Date time function
Draw symbol and insert picture
Emi calculation
Page setup
Array function
Formatting cell and workbook

Business Accounting with Tally Prime

Introduction Of Tally Prime
Accounting Assumptions, Concepts and Principles
Accounting Principles
Double Entry System of Accounting
Types of Accounts
The Golden Rules of Accounting
Recording of Business Transactions
The Accounting Equation
Recording of Transactions in Books of Original
Entry/Journal
Use of Debit and Credit
Rules of Debit and Credit
Recording of Business Transactions in Journal
Accounting Vouchers
Receipt Voucher (F6)
Contra Voucher (F4)
Payment Voucher (F5)
Purchase Voucher (F9)
Sales Voucher (F8)
Debit Note Voucher
Credit note Voucher

Maintaining Chart of Accounts in Tally. ERP

Introduction To Tally ERP
Getting Started with Prime
Mouse/Keyboard Conventions
Company Creation
Shut a Company
Select a Company
Alter Company Details
Company Features and Configurations
F11: Company Features
Ledger Creation
Altering and Displaying Ledgers
Display of Ledgers
Deletion of Groups and Ledgers
What is Ledger?
Classification of Ledger Accounts
Posting from Journal
Financial Statements
Trading Account
Profit & Loss Account
Balance Sheet
Accounts Payables and Receivables
Maintaining Bill-wise Details
Activation of Maintain Bill-wise Details Feature
New Reference
Against Reference
Advance Reference
On Account Reference

Maintaining Stock Keeping Units (SKU)

Introduction To Inventory Masters in Tally prime
Creating Inventory Masters
Creation of Stock Group
Creation of Units of Measure
Creation of Stock Item
Creation of Go down
Purchase cycle
Sales cycle
Stock Management In Tally

Storage and Classification of Inventory

Godown Management
Activating Godown
Creating A Godown
Recording Of Purchase, Sales And Stock
Transfers With Godown Details
Purchase Of Inventory
Recording Stock Transfer Entry Using Stock
Journal
Sale Of Inventory
Analyzing Godown
Movements Of Goods In Batches
Activating Batch-Wise Details In Tally Prime
Using Batch-Wise Details In Purchase Invoice

TDS & GST Taxation

Levy and exemption from Tax
Current tax under GST Regime
Overview Of Intra State Purchase & Sales
Overview Of Inter State Purchase & Sales
Overview GST Work Flow
Electronic Commerce
Explain E-Way Bill
Overview E-Way Bill Work Flow
Explain GST Number Code
GST Registration Process
Explain Composition Scheme
How Will I File GST Return?
GST Payments
GSTN Portal Information
Explain Ledger Of GSTN Portal
Explain Input Credit Adjustment
Explain ITC On Closing Stock
Explain Late Fee & Fines & Cancellation Of GST No.
Explain GST Rates
Create Company And Active GST In Company Level
Creating Masters And Set GST Rates
Creating Tax Ledger
Transferring Tax Credit Of VAT, Excise And
Service Tax To GST
Recording GST Sales And Printing Invoice
Recording GST Interstate Sales And Printing Invoice
Recording An Advanced Payment To Supplier
Under GST
Recording GST Local Purchase
Recording GST Interstate Purchase
HSN Code & SAC Codes
Recording Vouchers with TDS
Introduction To TDS
Basic Concepts of TDS
TDS Process
TDS in Tally prime
Activation of TDS Feature in Tally Prime
TDS Statutory Masters
Configuring TDS at Ledger Level
Recording Transactions
Activate of TDS During Voucher Entry

Advanced Tally Prime

Payroll Accounting in Tally
Payroll with Taxation Features
Back up & Restore
Interest Calculation
Cheque Printing in Tally
TCS – Tax Collected at Source
Cost center and cost category
Cost center with cost center class
Budeget & Control
Integrate Tally Prime with WhatsApp
Integrate Tally Prime with Excel
Integrate Tally Prime with Dashboard

Office Automation & Finance Accounting Course