Skip to main content

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 Presentations
  • Animations Effect
  • Slide show
  • Timing Effect
  • Projects
  • Etc...

 

Comments

Popular posts from this blog

SAP MM (Materials Management)

  SAP Materials Management (SAP MM)- Organizational structure/ Company structure What is a MM? Materials management is  the process of planning and controlling material flows . It includes planning and procuring materials, supplier evaluation and selection, purchasing, expenditure, shipping, receipt processes for materials (including quality control), warehousing and inventory, and materials distribution. Ø    How to Start SAP server? /POWER ON (Ctrl +B) Ø    How to POWER OFF (Ctrl + E) SAP Server? Ø    How to Suspend SAP Server? (Ctrl + J) ü    ECC 6.0 Latest version of SAP server ü    ECC (Enterprise Central Components) ü    SPRO (SAP Project Reference Object) ü    IMG (Implementation Guide) ü    Ctrl + Alt + Enter (Full Screen) ü    Going back to SAP EASY ACCESS screen . /N (forward slash & N) in command window . Transactions Code (T- code) Go to Additional Information -> Additi...

SAP-FICO with GST (Goods & Service Tax), TDS (Tax Deducted at Source) Index /Syllabus / System Application Programming & Data Processing (Finance & Controlling)

   SAP (FICO) FINANCE & CONTROLLING System Application Programming & Data Processing BASIC SETTING OF FICO CHAPTER NO   PARTICULAR T-CODE 1   Define company OX15 2   Define company code (HO) OX02 3   Assign company code to company OX16 4   Define business area OX03 5   Define chart of account OB13 6   Assign company code to chart of accounts OB62 7   Define accounts group with Number range OBD4 8   Define retain earning account OB53 9   Assign...

TallyPrime Volume-2 (Purchase & Sales voucher, Bank Payment, Bank Receipt, Cost Centers, Interest Calculations, Use separate Actual & Billed Qty columns in invoice, IGST, Multiple Pric, sales Voucher class, IGST, Multiple Price Level)

  How to Enable GST in TallyPrime ? Press F11 Features -> Taxation (Enable Goods & Service Tax (GST) -> Yes