FAITH COMPUTER EDUCATION

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  ü   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) 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 / 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) ...

  M.S.OFFICE M.S.OFFICE WORD Q.1) RESUEM/ CURRICULUM VITAE Q.2) Mail Merge (To write a 5 contact information’s) Q.3) Prepare following INVOICE Date   Invoice No. 1234 To Name Street Address City, ST ZIP Code Ship To Same as recipient Instructions Delivery Instructions     Quantity Description Unit Price Total                                                                           Subtotal         GST 18 %         Shipping & Handling         Total Due       Due upon receipt Thank you for your business! Due upon receipt Thank you for your business! M.S.OFFICE EXCEL Q-1) Excel VLOOKUP example, using an exact match You have the following table: Product ID Product Name Available Stock Price 2345 Pen 500 28...