Microsoft Office is the world’s most popular productivity suite made by Microsoft, as a collection of computer programs for home users and business users. From administrative assistant jobs requiring a strong knowledge of Word to project management positions demanding strong Excel ability, Apec training yields real benefits in the workplace.

  • Create documents, spreadsheets, and presentations that capture your ideas
  • Master routine word processing tasks
  • Easily format information in Excel with tools and auto-complete data
  • Easily incorporate content from PDFs and create Word documents
  • Make attention-grabbing presentations that relay information with style and flair
  • Design customized marketng materials that fit your brand and customers


CERTIFYING BODY

  • Microsoft
  • In-house Certification

CAREER PROSPECTS

This course suits everyone who learns the basics of computer operation and word processing, to carry on routine daily operations and help them land employment or advance an existing career.

  • Computer Operator
  • Office Assistant
  • Admin Assistant

SYLLABUS

    MS OFFICE
    MS WORD
    • I ntroduction to Word
    • F ile – Open, Save, Close
    • B ackstage view, Ribbon
    • Q uick Access toolbar
    • C reate a document
    • P age Setup, Page Layout
    • P rint Setup, Page break
    • C ount no. of words in a document
    • F ormatting text, paragraphs
    • A dd a heading, Clear formatting
    • A dd or remove text effects
    • L ine spacing, Paragraph spacing
    • S et the default font
    • A pply themes to documents
    • R ead documents in Word
    • S how or hide formatting marks
    • P roofreading a document
    • C heck spelling and grammar

    • Find & Replace
    • Look up words in the thesaurus
    • L ook up words in the dictionary
    • M ake text superscript or subscript
    • A dding Pictures/WordArt
    • P aragraph/Character Styles
    • B ullets & Numbering
    • B orders & Shading
    • F ootnotes and Endnotes
    • H eaders and Footers
    • P age numbers, Date & Time
    • T ext Box, Screen shot
    • P ictures & ClipArt
    • W ordArt, SmartArt graphics
    • C reate an organization chart
    • R otate text in a SmartArt graphic
    • A dd alternative text to any shape
    • A dd or delete a table
    • M ail merge – Letters, Labels
    • C ompare documents
    • M acros – Recording, Execution
    • T ables – Drawing, Formatting
    • R eview tracked changes & comments
    • H yperlink, OLE
    • P review & Print Documents
    • L ist of recently used files
    • K eyboard Shortcuts
    MS POWERPOINT
    • I ntroduction to Powerpoint
    • D esign Slides, Create Presentation
    • W orking with Text, Tables, Shapes
    • W orking with Charts, Pictures
    • C ustom Animation, Custom Transition
    • O rganizing & Formatting Slides
    • R ehearse timings
    • A dding Graphics, Media Clips
    (eg. video, audio)
    • U sing Slide Master, T ypes of Views
    • R eview Slide Show
    • D elivering the Presentation
    • D istributing the Presentation
    MS ACCESS
    • I ntroduction to MS Access
    • D atabase, DBMS, RDBMS
    • C reate Database
    • M anage Database
    • C reate Tables
    – Design View
    – Table Wizard
    – Datasheet View
    • A dd Records to Table
    • U pdate data using queries
    • C reate Queries
    • T ypes of Queries
    – Select, Crosstab, Maketable
    – Append, Update, Delete
    • C reate Forms with UI controls
    • F orm Wizard
    • F ine-tune Form
    • S ort Data
    • F ilter Data
    • G enerate Reports
    • R eport Wizard
    • C ustom Reports