Finance And Banking
Course Description
DSSD is the best Computer training institute in Delhi and the Certified Professional in Finance & Accounting course aims to support the development of accounting personnel at the downstream and intermediate level of the professional capable of capturing, processing, and preparing basic accounting reports that business, government, and regulatory authorities require. The best finance and accounting course in DSSD is suited to those students seeking to work or work in the public or private sector, and in business and commerce. The best finance and accounting training institute in Delhi-Delhi School of skill Development offers a firm foundation for those candidates wishing to pursue a degree in accounting or an accounting professional qualification.
Best Accounting and Finance course in Delhi-“Delhi School of skill Development” suitable for beginners to advanced level users who learn faster when demonstrated.
What You’ll Learn From This Course
MODULE-1 (MS-OFFICE)
- MS-Word
- Text Creation and manipulationText Selection,
- Font, Color, Style, and Size selection,
- Alignment of Text, Autocorrect,
- Find and Replace,
- Formatting the Text,
- Paragraph Indentation,
- Bullets and Numbering,
- Border and Shading.
Formatting a document
- Header & Footer,
- Table Manipulation, Insert & Draw Table, Changing cell width and height, Alignment of Text in the cell, Delete/Insertion
of Row, Column, Merging & Splitting of Cells, - Adjust margins,
- Table of Contents,
- Footnotes,
- Citation
Managing Graphic Elements
- Clip art picture,
- Working with symbols and special characters, Graphics including word art;
- Adept use of drop cap
- Inserting charts, themes & Watermark
Mail Merge
- Printing Envelopes, Labels, Letters
- Enter recipients,
- Inserting fields,
- Preview results
MS-Excel
Elements of Spread Sheet
- Creating of Spread Sheet
- Concept of Cell Address [Row and Column] and selecting a Cell
- Entering Data [Text, Number date] in Cell
Formulas and Function
- Using Formulas( Sum, Max, Min, Count, Average, If ),
- Function, basic mathematical operators, using Autosum using formulas with multiple cell reference
- Basic Conditional Formatting
- Sorting; Filter
Introduction of Pivot Chart
- Manipulating of Data
- Working with charts
- Working with pivot table
MS-PowerPoint
Creation of Presentation
- Creating a Presentation
- Using a Template,
- Entering and Editing Text,
- Inserting and Deleting Slides in a Presentation;
- Background, Themes, and Styles
Preparation of Slides
- Inserting Word Table or An Excel Worksheet,
- Adding Clip Art Pictures,
- Inserting Other Objects,
- Hyperlink
- Resizing and Scaling objects,
Presentation of Slides
- Viewing A Presentation,
- Choosing a Set-Up for Presentation,
- Printing Slides and Handouts.
Slide Show
- Running a Slide Show,
- Transition and Slide Timings, Automating a Slide Show.
MS-Outlook
Getting Started with Outlook
- Navigate the Outlook Interface, Work with Messages, Access Outlook Help
- Formatting Messages
Working with Messages, Attachments, and Illustrations
- Attack Files and Items
- Manage Automatic Message Content
- Track Messages
- Recall and Resend Messages
Managing Your Contacts
- Create, Edit Contacts, View and Print Contacts
Working with the Calendar, Tasks & Notes
- View the Calendar, Create Appointments, and Schedule Meetings
- Create Tasks & Notes
Accessing the internet
- Exploring the Internet, Popular Web Browsers (Internet Explorer/Edge, Chrome, Mozilla Firefox, Opera, etc.)
- Surfing the Web, Searching on the Internet
- Online Booking
MODULE-2 (ADVANCED EXCEL)
Introduction and Basic Brush-up of MS Excel and Excel Back-End Operations:
- Start-up with MS Excel, Quick review on MS Excel Customize Ribbon, Quick Access Toolbar, Mini Toolbar.
- Difference between Excel 2016 and 2019. Saving of Old version MS Excel 1999 and 2003 files to new excel version MS Excel 2007
- and 2010.
- Conversion of Excel files to PDF.
- Introduction of Excel Shortcut keys: Chart will be provided by Advanced Excel.
- Introduction to Excel Worksheet, Row, Column, Cells etc.
- Detailed discussion on Excel design, Back-End working structure and Excel Options.
- Use of Basic Operators like:-/*^ %.
- Introduction to the Data and Data Formats.
- Copy, Cut, Paste, Hide, Unhide, Link the Data in Rows, Columns and Sheet.
- Inserting, Deleting, Moving, and limping the data in between the multiple sheets.
- Introduction to the Paste Special all Option (Formulas, Values, Formats, Comments, Validation, All using source themes, All except borders Column widths, Formula and Number formats, Values and Number Formats, None, Add, Subtract, Multiply, Divide, Skip Blanks and Transpose)
- Format Cells, Rows, Columns and Sheets.
- Protection of Cells, Rows, Columns and Sheets.
- Password protection to the Worksheet, Sheets, Rows, Columns, and Cells.
- Printer Properties and Page Setup (Page, Margin, Header/Footer and Shee0t) for Printing.
- Insert Logo to your worksheet while printing.
Start-up With Formulas: Part-I AND Working with Name Ranges:
- Text Functions: Concatenate, Dollar, Left, Mid, Right, Lower, Upper, Proper, Replace.
- The report, Find, Search, Substitute, Trim.
- Combine multiple formulas
- Writing of Complex formulas for improvement in formulas writing skills.
- Date and Time Functions: Date, Date value, Day, Day360, Minutes, Hours, Now, Today, Month, Year, Yearfrace, Time, Weekday,
- Workday, Networkdays.
Basic If Formulas:
- If, If with OR, If with AND, If with AND & OR, If with OR & And.
- If with Trim, If with Concatenation, If with Left, Mid, Right.
- If with Other formulas, Complex formulas written in If.
Beginner Level( If Formulas):
- Nested If( For Multiple Conditions ), If condition used more than one time in the same formula.
- Production Store Management template with the help of Nested If.(Example)
- Nested if with left, Mid, Right
Advanced Level (If Formulas):
- Nested if with Multiple Text Functions in single formula.
- Preparation of the TAX Calculation Sheet by Nested if(Based on Indian and US Tax)
- Nested if with Other Critical Lookup Formulas(To be discussed after Super Advanced Look-up Class).
- Nested if with Look-up (To be discussed in Super Advanced Look-up Class)
- Other Complex Nested if to be discussed in Class.
- Introduction to Name Manager: Discussion on Name Ranges and Apply the Name Ranges on Cell and the combination of Cells.
- Use of Name Manager: Creating, Editing, and Deleting of Names.
- Create Name Ranges Automatically.
Startup with Formulas: Part-II And Use of Tool Find & Select Go To Special
- Math & Trig Functions: ABS, Aggregate, Power, Product, Rand, Randbetween, Round, Rounddown, Roundup, Subtotal Sum, Sumif, Sumifs, Sumproduct, Trunc.
- Use of Sumproduct as lookup and in various activities.
- Statistical Functions: Average, AverageA, Averageif, Averageifs, Count, CountA, Countblank, Countif, Countifs, MAX, MAXA, MIN, MINA, Samc Large.
- Use of Sumif, Sumifs, Countif, Countifs, Averageif, Averageifs with the Name Ranges.
- Informative AND Other Functions: Cell, Info, ISBLANK, ISERROR, ISEVEN,ISODD,Use of &.
- Use of Tool Find & Select: Discussion on Excel’s very important tool “Find & Select” (Go To Special) including all options:(Comments,
Constants, Formulas, Blanks, Current region, Current array, Objects, Row differences, Column differences, Precedents, Dependents, Last cell, Visible cells only, Conditional formats, Data validation).
Startup with Formulas:Part-III: Lookup Functions:
Lookup Functions: Basic Level Lookup Formulas:
- Discussion on Lookup Functions, Use of Lookup, Vlookup, Hlookup, Index, Indirect Match, Offset Choose
- Vlookup with Name Range.
- Hlookup with Name Range.
- Vlookup with Match, Hlookup with Match.
- Lookup from the Left side of Data (Lookup, Index and Match).
- Vlookup with Left, Mid, Right.
- Vlookup with Multiple Text Function.
- Hlookup with Multiple Text Function.
- Vlookup from multiple Data Ranges(With the help of Logical and Lookup Functions).
- Vlookup with arrays.
- Hlookup with arrays.
- Vlookup with other Multiple Lookup
- Functions.
- Hlookup with other Multiple Lookup functions.
- Creation of Hyperlink.
- Detailed Discussion on Arrays: What are the
- Array Formulas, How Array Formulas work and Use of the Array Formulas, Acceptance of Array Formulas in today’s scenario.
- Basic Array Formulas Example.
- Linking of Spread sheet with the help of Array
- Array in Multiple formulas.
- Array with Lookup functions.
- Advanced Use of formulas with Array.
Conditional Formatting And Working with charts
- Conditional Formatting: Detailed discussion on conditional formatting.
- Conditional Formatting with multiple cell rules and Top/Bottom Rules.
- Conditional Formatting with Data Bars.
- Color Scales and Icon Sets.
- Conditional Formatting on Desired Output, Create New rules, Manage the rules.
- Apply any formula to Conditional formatting.
- Choose Formatting as Table and different
- Cell Style.
- Working with Charts: Detailed discussion on graphically presentation of Data by using Charts.
- Presentation with different kind to Basic charts like Column Charts, Line Charts, Pie Charts, Bar Charts, Scatter Charts.
- Preparation of Advanced Level of Charts: Gnatt Chart, Bubble Chart, Speedo Meter Chart. Pareto chart
- Introduction to Multiple switches and buttons: Like Form controls, Combo Box, Check Box, Spin Box, List Box, and Option Box.
- How to use switches with offset function effectively in charts.
- Preparation of the Interactive Charts.
- Preparation of the Dashboards: Different kinds of Advanced levels of Dashboards
- Use of formulas Like Offset, Match, Sumif, Sumifs, and many more to prepare the Dashboards.
- Use of Data Validation in Charting
- Use of Sparkline to your Sheet, Interactive Sparklines
- Working with 2axis and 3axis charts.
Pivot Table and Pivot Charts with Slicer and Handling of Errors In Excel:
- Start with Pivot Table, Do the Multiple Field Setting in Pivot Table.
- Pivot form the Multiple Source of Data.
- Pivot from the Multiple Data Ranges.
- Pivot from the Name Range.
- Do the Juggling of Data in Pivot Table and Work on the layout of Pivot Table.
- Creating Groups, insert an additional Calculated Field in the Pivot table.
- Perform the % calculation on the basis of multiple fields.
- Start-up with Pivot Charts.
- Insert slicer in Pivot Table and Pivot Charts.
- Use of Tool “Error Checking”.
- Removing Duplicates.
- Trace Precedents, Trace Dependents.
MODULE-3(MANUAL & E-ACCOUNTING)
Fundamentals of Accounting
- Introduction to Accounting
- Accounting terms
- Accounting Assumptions, Concepts and Principles
- Double entry system of Accounting
- Types of Accounts
- Golden and Modern rules of Accounting
- Source Document of Accounting
- Recording of Transactions in Journal
- Subsidiary books of Accounts
- Classification of Accounts(Ledger Posting)
- Summary of Accounts(Trail Balance)
- Trading and Profit & Loss Account
- Balance Sheet
- Source Document of Accounting
- Recording of Transactions in Journal
- Subsidiary books of Accounts
- classification of Accounts(Ledger Posting)
- Summary of Accounts(Trail Balance)
- Trading and Profit & Loss Account
- Balance Sheet
Fundamentals of Tally Prime
- Getting Functional with Tally.ERP9
- Creation/Setting up of Company in Tally.ERP9
Accounting Masters in Tally Prime
- F11:Features
- F12:Configurations
- Setting up Account Heads
Inventory in Tally Prime
- Stock Groups
- Stock Categories
- Go downs/Locations
- Units of Measure
- Stock Items
- Creating Inventory Masters for National Traders
Voucher Entry in Tally Prime
- Accounting Vouchers
- Inventory Vouchers
- Invoicing
Accounting in Tally Prime
- Bill-wise Details
- Cost Centers and cost categories
- Multiple currencies
- Bank Reconciliation
- Interest Calculations
- Budgets & Controls
- Scenario Management
Advanced Inventory in Tally Prime
- Order Processing
- Reorder Levels
- Tracking Numbers
- Batch-wise Details
- Additional Cost Details
- Bill of Materials(BOM)
- Price Levels and Price lists
- stock Valuation
- Zero Valued Entries
- Inventory Ageing Analysis
- Different Actual and Billed Quantities
Recording day-to-day Transaction in Tally Prime
- Recording Transaction in Tally using a source document
- Accounting voucher-Receipt, Contra, Journal, Payment, Purchase, Sales, Debit Note and Credit Note
- Modify, Duplicate and copy the voucher
- keyboard Short-cuts and Reports
Payroll In Tally Prime
- Enabling and filling in statutory details
- PF and ESI Rules and rates
- PF and ESI calculation and Accounting
- TDS Deduction on salary
- Monthly Attendance
- Auto calculation and entry of Monthly salary
- Entry for PF, ESI
- Entry of User-defined salary components
- Generate payroll reports-Pay-slip, Attendance Register, and Salary Register
- Payment Advice
- Leave Reports
- Auto mailing of pay slips to employees
- Payroll statutory report
Are you ready? Let’s get started!
Certification
- Diploma Certificate
-
MS- Office
Microsoft Office, there are various courses available to help you gain proficiency in its applications. Here's an overview of the commonly used Microsoft Office applications and the skills you can develop through courses:
-
Advance Excel
advance Excel is defined as Highly Proficient with Microsoft Office and particularly excel (i.e., pivot tables, look ups, advance formulas etc.) In other word it requires an excellent opportunity for immediate jobs. Microsoft Excel is a spreadsheet which is use to allocate data with systematic worksheet. In which we easily apply advance formulas, pivot chart, slicer, viewable according to sheets etc.