Most Popular Job Level Combined Certificate Course on
Office & Financial Accounts
Learn basic to advanced Financial Accounting with Microsoft Office Pro Tools
Learning Tool:
- Microsoft Windows 10 Pro
- Microsoft Word
- Microsoft Powerpoint
- Microsoft Excel
- Fundamental Studies in Accounts & Taxation
- All new TallyPrime
Starting from :
₹ 12,000/-
- Quick Mode: 4months (3 days a week)
- Standard Mode: 6 Months (2 days a week)
- Class Duration: 1 – 2 Hours (1 Hour Minimum)
- Class Mode: Online / Offline / Hybrid
Course Objective:
- This is the most popular and highly demanded combined course of Microsoft Office Package and Financial Accounting.
- The modules of this course have been designed keeping in mind the needs of the current industry which will be helpful especially for Beginners & Job seekers.
- This course based on theory & practical oriented
- This course helps to learn basic computer operations with financial accounts from zero to advanced level.
- We will learn & explore Computer’s Basic, modern office applications, data analysis, preparing office documentations, data processing & data analysis, presentation building, Database Management & Crating Database Relationship, a to z ERP modules such as Finance & Accounts with GST, inventory management, manufacturing & human resource and many more…..
- Unlocking its full potential could see you drastically improve your productivity.
Ascent InfoTech is the famous ISO certified computer training center in Kolkata that offers Financial Accounting training Courses in Kolkata, Tally Training Institute in Kolkata, and also FA courses in Amtala, Tally Course in Amtala to ensure the best financial accounting course modules for helping students to learn in-depth. In this course, students will learn Tally, GST, E-filling, Microsoft Excel, and Microsoft Word with advanced mode. We also provide jobs in the related field to our students after completing the course successfully. Opportunity to learn Basic Computer training course in Kolkata at Ascent InfoTech Computer Institute. Opportunity to learn Basic Computer training course in Amtala at Ascent InfoTech Computer Institute. Opportunity to learn Tally training course in Kolkata at Ascent InfoTech Computer Institute. Opportunity to learn Tally training course in Amtala at Ascent InfoTech Computer Institute
What you'll learn
Learn the essential and advanced (Basic to Advanced)
Financial Accounting Course with Microsoft Excel & Tally ERP 9/TallyPrime
Learn about Microsoft Windows :
- Features & functions of Operating System
- Discover the elements & components of Microsoft Windows
- File & Folder management using File Explorer
- Learn Windows Paint for learning & improving mouse handling for Beginners
- Learn and discover different small gadgets, accessories/tools under Windows 10 Pro
- Learn different settings such as account settings, device settings, privacy settings, etc.
- Learn basic troubleshooting for OS
- Install & Remove applications
- Learn how to reset or format your pc
- Learn how to install Windows 10 Pro
- Learn list of PC maintenance skills
- Learn how to recover your OS and data using OS recovery tools
- Learn System restore for system protection and many more….
- How to install the original Microsoft Office OEM/Retail version
- How to Install Tally
Explore Microsoft Word :
- Features of Microsoft Word as a word processing tool
- Bringing Practice text & essential text formatting
- Essential Shortcut Key Commands
- Unlock the different skills to select and editing text
- Learn different Change Case options
- Explore different paragraph formatting options such as indentation, Line & Paragraph spacing, etc.
- Create your own Paragraph Style
- Learn about different Tab option in word and also the technique for tab spot & leader settings
- Inserting Pictures, Screen Shot, Graphic Objects, SmartArt, Charts and Symbols
- Learn & Unlock the special formatting features of Word such as word art, Bullet and Numbering, DropCap, Newspaper Columns, and many more…
- We will learn how to apply page color, page border, watermark, caption, create comments, track changes feature
- Learn about Table features of Word and different table properties
- Add Header & Footer options, auto age numbering features
- Mail Marge features & envelope printing\
- Learn about Measurement unit, Page Layout & Page Setup, Printing Options
- Different views in Word, also learn how to check spelling & grammar, about auto text entries, synonyms, etc.
- Find & replace text and advance find & replace options
- Preparing & Presenting Home & Office Documentation:
Explore Microsoft Excel :
- Introduction of Electronic spreadsheet & features
- Learn about Excel Window
- Learn about Cell, Rows and columns, Worksheet and workbook, Active Cell, Name Box, and formula bar in Excel
- Learn about selection methods & adjacent cells in Excel
- Discover different types of cell referencing in Excel
- Confidently use “Autofill” and “FlashFill” so you are more productive in Microsoft Excel.
- Learn about Series and how to make a calendar in Excel
- How to easily fill a range with your own list entries and can save time and reduce errors using Custom List in Excel.
- Learn the essentials and differences of using formulas and functions in Excel
- Learn basic functions like SUM, MIN, MAX, COUNT & COUNTA, AVERAGE
- Discover the essentiality of conditional formatting, consolidate, and goal-seek options for back calculation.
- Discover Charts in Excel such as Line charts, Pie charts, Bar and column Chart etc.
- Learn practical methods to sort and filter, Custom sort, Find & replace, advanced filtering your data in Excel
- Learn and explore different cell formats and number formats in excel
- Create dynamic reports by mastering one of the most popular tools, Subtotals & Pivot Tables in excel
- Learn how to calculate EMI, Maturity amount against short- or long-term deposits, depreciation on an asset, find out the rate of interest of a loan, etc. using Financial Functions in Excel
- Learn different useful functions such as database functions, string functions, if logic functions, statistical functions
- Unlocking dynamic formulas with IF, SUMIF, SUMIFS, VLOOKUP and HLOOKUP, XLOOKUP, INDEX, MATH functions, and many more….
- Learn & explore Date and time functions in Excel such as Days360, Networkdays, etc.
- Explore the ideas to print large databases, page orientation, and layout, page setup settings, header & footer, set print area, printing range, and manage pages as per requirement.
- Learn freezing and unfreezing columns or rows etc.
Explore Microsoft PowerPoint :
- Discover new features in PowerPoint 2019 including Icons and 3D Models
- Explore the features of the PowerPoint startup window
- How to Create a Blank Presentation
- How to create a presentation using a Pre-defined Design or PowerPoint Template
- How to create your own Animated Digital Photo Album
- Learn how to add or remove the slide, learn about Slide Layout, and how to customize or modify the slide layout
- Learn how to insert or Add shapes, graphics, and pictures, charts, tables to add some “dynamism”/ “Zing” to your PowerPoint
- How to change the background color, color scheme, or theme of a slide
- Get Tips and tricks for text formatting to create extra appeal to the text
- Learn about Transitions & Animation Effects in PowerPoint
- Animation, the animation pane, and motion paths
- Wow your audience by adding animations, audio, and video to PowerPoint
- Discover practical tips to present your PowerPoint presentation to your audience
- Learn different ideas and tips to create stunning presentations in PowerPoint 2019
- Learn time-saving techniques including how to copy slides, and export your presentation
- Discover how to use Slide Master in PowerPoint
- Learn the essential features of different views in PowerPoint
- Learn the essentials of the Hyperlink and Action buttons in PowerPoint 2019
- How to utilize Master Slides and just how much time this could save you
- Setting your slideshow options
- Presentation preparation and delivery
Explore Tally ERP 9 latest version OR all-new TallyPrime
- Learn types and elements of accounts, Commerce introduction, Accounting, Book-Keeping
- Company & Ledger Creation, Alteration, Deletion & Securing Company data & profile
- Basic and functional key commands and Tally Shortcut Keys
- Understanding all accounting groups
- Learn the basic rules, when & why use of different Tally Pre-Defined accounting vouchers
- Learn all Tally Accounting Vouchers such as Contra, Payment, Receipt & Journal Vouchers
- Learn how to manage outstanding & advanced journal entries using Journal Voucher in tally
- Understanding top Tally Reports such as Balance Sheet, Trial Balance, P/L Report, Day Book Report, Stock Summary Report, Ratio Analysis, different essential accounting & Inventory reports such as Sales and Purchase Registers, Outstanding Reports, Party wise Reports, Ledger wise reports, Stock Item wise reports, Batch number wise reports, Purchase & Sales order history and many more…
- Learn when & how to use cost centres and cost categories, a method to use of multiple cost categories, Pre-defined cost center allocation
- Tally Banking features- Cheque Book Configuration, Post Dated Cheque & Bank Reconciliation (BRS)
- Explore Inventory or stock management in Tally
- Learn about Stock Group, Stock Categories and Stock Items, and Godown creation
- Learn how to transfer goods from one location to another Godown with additional cost
- Learn Purchase and selling of Capital Goods & trading items
- Learn about Batch Control, Part Number, Ageing Analysis of an item
- Explore the beauty of inventory features such as different actual and billed quantity, separate discount columns, track additional cost on purchase, zero-valued entries, etc.
- Learn about order processing in Tally such as purchase & Sales orders Processing
- Learn the beauty and difficulties of purchase and sales return, stock adjustment through rejection inward/outward and bill adjustment using Debit or Credit note entries
- Learn to create Point of Sales (POS Invoice)
- Learn late fine and interest calculation in Tally
- Learn & explore Rejection in and Rejection Out inventory vouchers in Tally
- Learn how to Tax Invoice Configuration in Tally & Voucher Numbering in Tally
- Auto Billing, Logo Printing, Printing Configuration, Rate Inclusive of GST, Item Description
- Learn how to set predefined multiple price levels where we can set prices for the product
- Learn how to use non-accounting vouchers in Tally such as memorandum vouchers
- Explore Tally utility options such as multi-currency, splitting the company, group company, Migrating Data – Data Export/Import, multi-language features etc.
- Explore Manufacturing Voucher, Bill of Materials (BOM)
- Understanding GST, TDS, Direct or Indirect taxes
- Learn about enameling GST features in Tally
- Learn how to apply GST, HSN Code of the item in Tally
- Understanding GST Returns/Reports in Tally
- Learn GST Returns Filing (Monthly/Quarterly)-GST Tax Payments /Adjustments
- Learn GST Refunds-GST Annual Returns
- GST-Registration-Live
- GST Amendments (Core/Non-Core Fields)-Opting Regular & Composition
- GST Cancellation / Revocation (All Live Classes on Real-time Clients Data)
- Complete study with GSTR-1 FILING, GSTR-2 FILING, GSTR-3 & 3B FILING, GST E-Way Bills
- GST Tax Payments & Adjustments
- Manufacturing & Stock Journal in Tally and also learn about Bill of Materials (BOM)
- Learn how to create Pay Slip in Tally using Payroll management and also explore the elements of a Pay Slip, Payroll setup entries, Payroll Reports
- Security features, Tally Backup features, Budgets & Controls and Tally Audit features
Who can enrol in this Course :
- Anyone with/without a commerce background
- Especially the course designed for a Computer Beginners & Job Seekers
- Who wants to learn about Modern Office Applications with Tally
- The person wants to learn Tally.ERP Software with Basic Computer
- Who wants to know GST Portal?
- Students/Employee/Employers