Introduction, Telephoning, Taking a taxi, Food and drink, Places in town and directions, Skills and abilities, requests, Life story, Shopping, Travelling by train, Action and timing, Telling the time, Daily routines, Days and dates, Personal information, Checking into / staying at a hotel, Comparing things, Rooms in a house; colors, Minor physical complaints – at the chemist’s, Likes and dislikes, Activities in the past

Hardware & Software | Working with Windows 10 | File & Folder Management | Introduction to MS Word 2016 | Page Set up | Drafting & Formatting Documents | Tables | Header & Footer |Introduction to MS Excel 2016 | Database design | Cell Reference | Number & Conditional Formatting| Look up & Reference Functions | Logical Functions | Financial Functions |Sort & Filter | Pivot Table & Pivot Chart | Protection | Project on Excel |MS PowerPoint 2016 | MS Outlook 2016| Internet & E-mailing | Mail Merge | Google

Introduction | Accounting Concepts | Capital & Revenue Transactions | Accounts Documents | Journal Entries | Depreciation | Stock Valuation | Year-end Adjustments | Final Accounts | Rectification of Errors | BRS | Projects on preparation of Books of Accounts | Online Journal Entry Test – JET

Introduction | Company Creation | Alteration | Shut Company | Select Company | Delete Company | Company Features | Company Configuration | Ledger Creation | Alteration,Display | Delete(Single & Multiple) | Backup | Restore | Report | Sample problem|Bill allocation | Sample problem | Accounting Entry | Accounting vouchers | Types of reference |Cost centre | Costcategory | Pre-defined cost centre|BRS|Stock group | Stock category | Unit of measurement | Multiple godown | Stock item|Purchase order | Receipt note | Rejection out | Purchase invoice,Purchase return|Sales order | Delivery note | Rejection in,Sales bill | Sales return,Batch|Zero value voucher | Actual and billed quantity in inventory voucher | Separate discount column | Standard rate | Credit limit | Additional cost of purchase | Price list |Interest calculation|Bill of material | manufacturing voucher creation | manufacturing entry|Non accounting voucher | Budgeting & control | Sample question |Export | Import data | GST introduction | Activating GST | GST Master Creation | Inward & Outward Supply Of Goods (Local) | GST Reports |Inward & Outward Supply Of Goods (Inter State)|Input Tax Credit|Sale And Purchase Of Services (Local) | (Inter State)|Treatment Of Advanced Receipt | Treatment on Reverse Charge|TDS|Payroll

Basic concepts of GST | Levy & Collection of Tax | Time & Value of Supply | Valuation | Input Tax Credit | General Procedures | Payment of Tax | Returns | GST using Tally | Practice on GSTN | Project on GST

Working with Quickbooks Accounts Program Basics|Creating Account names, Numbers & Bank Payments|Financials|Bank Reconciliations|Generating Customers Invoices|Products|Stock Control|Monitoring Customer Activity|Generating Product Invoices & Credit Notes|Compiling & Sending Customer Statements|Creating Customer Receipts & Purchase Invoices|Supplier Payments|Managing Recurring Entries|Generating Reports & Information|The Active Set-Up Wizard|VAT/GST Changes

Section – 1

Introduction to Excel Open or launching Excel | Understand the main terms ued to describe excels work canvas | Create , save & open your first Microsoft Excel file | Basic formatting | Exercise

Section – 2

Editing worksheets Editing cell data | Insert & delete cells, columns and rows| Find & replace data | Go to | Transpose or flip a range of data | Change height, width & hide rows and columns | Check worksheet or workbook spelling with spell check | Smart lookup & Thesaurus | Editing worksheet | Exercise

Section – 3

Formatting Formatting text | Basic numbers formats | Basic custom number format | Adding borders & colors to cells | Formatting shortcuts | Adding background | Align, merge & wrap cell data | Cell styles | Applying themes | Exercise

Section – 4

Microsoft excel 2016 (basic) Filling series | Flash fill | Basic conditional formatting | Adding comments and formatting cell | Custom list | Adding and deleting rows columns and cells | Changing column and row width

Section – 5

Moving data Cut, copy, paste | Copying formulas

Section -6

Formatting worksheets Formatting cells | Borders and shading | Format as table | Using style | Using format painter | Fill handle& custom list

Section 7

charts Creating charts | Types of charts | Editing chart | Using graphics

Section 8 

working with names Creating range names | Managing names | Using names in formulas

Section – 9

sorting and filtering Sort data | Filter data | Advance filters | Remove duplicates | Convert text to columns

Section – 10

working with views New window options | Custom views | Freeze pane | Print set up | Password protection

Section 11

advanced formula creation VLOOKUP | Hookup | Data validation | Logical functions

Toggle Content

Communication skills, Assertive communication ,Non-verbal communication , Presentation skills, Interview skills, Sell your skills(cover letter, Resume designing),People skills(workplace Behavior) ,E-mail etiquette, Goal setting and Time management