Skip to main content

Posts

Salary Slip (BASIC, HRA, DA, TA, NET SALARY) & Extra Formulas || Advance Excel

  Emp roll no Name Basic HRA DA TA NET SALARY 1 a 5500 ? ? ? ? 2 b 7900 ? ? ? ? 3 c 8475 ? ? ? ? 4 d 15700 ? ? ? ? 5 e 21000 ? ? ? ? 6 f 9584 ? ? ? ? 7 g 22700 ? ? ? ? 8 h 5245 ? ? ? ? 9 i 42000 ? ? ? ?     Notes if basic salary is more t...

BASIC SYLLABUS / MICROSOFT OFFICE (WORD, EXCEL & POWERPOINT)

BASIC / MICROSOFT OFFICE (WORD, EXCEL & POWERPOINT) Duration: 2 Months Computer fundamental History of Computer English Typing & Gujarati Typing Internet Printing & Scanning M S Office Word All the type Documents works Letter & application Resume / CV / Bio-data Create table & Invoice Mail Merge Create school & collage pamphlets Spelling & Grammar formatting Projects Etc ... M S Office Excel All the type formulas (VLOOKUP & HLOOKUP, Student Marksheet, Concatenate, Count, count if, Upper case, Lower case, Today, Now, if condition, Round, Find, ABS, Ceiling, Even, Odd, Exact, Factorial, Len, Mod, Power, Product, Replace, Rept, Sqrt, Etc ….) All the type mathematic works Table creations School & collage mark sheet Chart Pivot Table Lookup formulas Use of Filter Projects Etc ….   M S Office  PowerPoint To create all the ...

TALLYPRIME GST ADVANCE || SYLLABUS

TALLYPRIME GST ADVANCE  ü   Volume -1  (Journal Entries, Provisions Entry, Prepaid Entries, & Other Adjustment Entries) ü   Volume -2  (Purchase & Sales Invoices || Purchase Return & Sales Return) ü   Bank Payment  ü   Bank Receipt ü   Cost Centers ü   Interest Calculations ü   Use separate Actual & Billed Qty columns in invoice ü   CGST, SGST  & IGST ü   Multiple Price List ü   Purchase & Sales Voucher class ü   Bank Reconciliations (BRS)   ü   Volume -3   Purchase and Sales Manufacturing ü   Godown Creations ü   Internal Stock Transfer ü   Cost Centers ü   Use Pre-defined Cost Center Allocations during Entry ü   Manufacturing Journal ü   Stock Journal with Class ü   Purchase Order ü   Receipt Note ü   Rejections Out ü   Sales Order ü   Delivery Note ü   Rejection In ü   Multy Currency ü   Price List...

FOREIGN ACCOUNTS (QUICKBOOKS, MYOB & SAGE)

FOREIGN ACCOUNTS (QUICKBOOKS, MYOB & SAGE) QuickBooks (USA & CANADA) - 2 Months Myob (AUSTRALIA) - 2 Months Sage (UK) - 2 Months Working with Quickbooks, Myob & Sage Accounts Program Basics. Creating Account names, Numbers & Bank Payments Financials rules Bank Reconciliations (BRS) Generating Customers & Vendor Invoices (with GST) Creating Customer Receipts & Vendor payments Stock Control Monitoring Customer Activity Generating Product Invoices & Credit Notes Compiling & Sending Customer Statements Managing Journal Entries Discounts Entries GST Taxation Prepare Profit & loss A/c. & Balance Sheet Generating Reports & Information

Rapid typing theory

Rapid typing / Typing Master: (how to typing in computer) v How to open rapid / Typing master typing? Ø Click to start button Ø Click to all programs Ø Click to rapid typing Folder Ø Click to rapid typing Ø Open typing software   v How to get Rapid typing icon on desktop? Ø Right click on rapid typing icon Ø Select Send to Ø Click to desktop create short cut key or click and drag   v How to put your fingers in the base position LEFT HAND RIGHT HAND A Little Finger ; Semicolon S Ring Finger L Ring Finger D Middle Finger K Middle Finger F Index Finger J Index Finger Spacebar => Thumb   keyboard: - 1)     In keyboard there are main 3 parts. a)     Alphabetics keys => A to Z (26 alphabetises) b) ...