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

(a)Word Processor, MS Word

  • Introduction to Word
  • File – Open, Save, Close
  • Formatting text
  • Formatting Paragraphs
  • Page Setup, Page Layout
  • Print Setup
  • Paragraph/Character Styles
  • Bullets & Numbering
  • Borders & Shading
  • Footnotes and End notes
  • Headers and Footers
  • Page numbers, Date & Time
  • Proofreading a document
  • Checking Spelling & Grammar
  • Find & Replace
  • Drawing Shapes
  • Adding Pictures/Word Art
  • Mail merge – Letters, Labels
  • Macros – Recording, Execution
  • Tables – Drawing, Formatting
  • Hyperlink, OLE
  • Previewing & Printing Documents

Electronic Spreadsheet, MS Excel

  • Introduction to Excel
  • Entering & Formatting Titles
  • Worksheet calculations
  • Formatting Rows/Columns
  • Hiding Columns/Rows/Sheets
  • Cell Referencing
  • Cell Formatting, Cell Styles
  • Conditional Formatting
  • Format as Table
  • Number Series, Fill Handle
  • Adding Formulas
  • Formula bar, Status bar
  • Math Functions
  • Text Functions
  • Date& Time Functions
  • IF function
  • Adding Pictures/Shapes/Word Art
  • Page Layout, Print setup
  • Creating Graphs/Charts
  • Data Sort, Filter
  • Data Validation
  • Macros – Recording, Execution
  • Adding Header & Footer
  • Workbook Views, Freeze panes
  • Create Payrolls/Tables
  • Create Financial statements

Advanced MS Excel

  • Adding Smart Art objects
  • Align objects, Themes
  • Absolute Cell Referencing
  • Insert Page breaks
  • Paste Links, Paste Special
  • Working with Comments
  • Advanced Functions
  • VLookup, HLookup
  • SumIF, CountIF, CountBlank
  • Index, Match, Transpose
  • Find, Search
  • Replace, Substitute
  • Naming Range
  • Using Name box, Name Manager
  • Enhancing Chart Titles
  • Changing colors of Data bars
  • Rotating Charts
  • Filter – Text, Number, Date, Color
  • Advanced filter, Custom List
  • Text to Columns
  • Data Consolidation
  • Pivot table, Data SubtotalM
  • What-if Analysis
  • Scenarios, Scenario Manager
  • Goal Seek, Data Table
  • Formula Auditing
  • Protect Workbook/Sheet
  • Share Workbook
  • Save Workspace
  • Export Excel tables to Word
  • Excel Options

Presentation Package, MS PowerPoint

  • Introduction to Powerpoint
  • Design Slides
  • Create Presentation
  • Custom Animation
  • Custom Transition
  • Background, Color and Fonts
  • Rehearse timings
  • Adding Graphics, Media Clips (eg. Video, Audio)
  • Using Slide Master
  • Reviewing the Slide show
  • Delivering the Presentation

RDBMS, MS Access

  • Introduction to Access
  • Database, DBMS, RDBMS
  • Create Tables in Design view
  • Create Tables using Wizard
  • Adding Records
  • Create Queries
  • Types of Queries
    • Select
    • Make table
    • Update
    • Append
    • Delete
  • Create Forms with UI controls
  • Generate Reports (Report Wizard)
  • Custom Reports

Computer Training Institutes for Advanced Microsoft Office, Best Computer Training Institutes for Microsoft Office , Live Projects Microsoft Office, Best Institute for Microsoft Office in ameerpet, Computer Training   Institutes For Microsoft Office, Best Microsoft Office Training institutes in Ameerpet, Best Training institute for Microsoft Office, Institute for Microsoft Office,Online training for Microsoft Office, Microsoft Office training institute   in ameerpet.