04 385 2555
052 920 0515

enquiry@aceit-training.com

Computer Skills

Overview

The certificate program in Microsoft Office consists of five courses that provide a quick review of basic PC and Windows operations followed by detailed instruction on using the three most popular applications of Microsoft Windows; Word, Excel and PowerPoint. The program includes specific instruction for each application including theory and a hands-on project, followed by lessons that teach how to integrate applications like Word with PowerPoint and Word with Excel

Microsoft Office Word- Basics

Sharing and Maintaining Documents

  • Apply different views to a document
  • Selecting zoom options
  • Splitting and arranging windows (View Side by Side, Synchronous Scrolling)
  • Document views (reorganizing a document outline, master documents, subdocuments, web layout, draft)
  • Switching windows
  • Opening a document in a new window
  • Save a Document
  • Using compatibility mode, protected mode
  • Save As options
  • Apply a template to a document
  • Finding templates (locating a template on your disk, finding templates on the web)

Formatting Content

  • Apply font and paragraph attributes
    • Apply character attributes
    • Apply styles
    • Use Format Painter
  • Navigate and search through a document
    • Using the Navigation Pane (headings, pages, results), Go To, Browse by button, and Highlight features
    • Setting Find and Replace options (format, special)
  • Apply indentation and tab settings to paragraphs
    • Applying indents (first line, hanging)
    • Setting tabs
    • Using the Tabs dialog box
    • Setting tabs on the ruler
    • Clearing tabs
    • Setting tab stops
    • Moving tab stops
  • Apply spacing settings to text and paragraphs
    • Line spacing
    • Paragraph spacing
  • Create tables
    • Using the Insert Table dialog box
    • Using Draw Table
    • Inserting a Quick Table
    • Converting text to tables
  • Manipulate tables in a document
    • Sorting content
    • Adding a row to a table
    • Adding a column to a table
    • Splitting, merging, moving, resizing, and deleting a row or column
    • Defining the header ro
    • Converting tables to text
    • Viewing gridlines
  • Apply bullets to a document
    • Applying bullets
    • Selecting a symbol format
    • Defining a picture to be used as a bulle

Applying Page Layout and Reusable Content

  • Apply and manipulate page setup settings
    • Setting margins, non-breaking spaces, hyphenation, and columns
    • Working with breaks
    • Forcing a page break
    • Inserting a section break
    • Inserting a blank page into a document
  • Construct content in a document by using the Quick Parts tool
    • Adding built-in building blocks (quotes, text boxes, headers, footers, cover pages, watermarks, equations)
  • Create and manipulate page backgrounds
    • Formatting a document’s background
    • Setting a colored background
    • Adding a watermark
    • Placing page borders
  • Create and modify headers and footers
    • Inserting and formatting page numbers
    • Inserting the current date and time
    • Inserting a built-in header or footer
    • Adding content to a header or footer (custom dialog box, manual entry)
    • Deleting a header or footer
    • Changing margins
    • Applying a different first page attribute

Including Illustrations and Graphics in a Document

  • Insert and format Pictures in a document
    • Adding captions
    • Applying artistic effects and picture styles
    • Compressing pictures
    • Modifying a shape
    • Adjusting position and siz
    • Inserting screenshots
  • Insert and format shapes, WordArt, and SmartArt , Clip Art
    • Adding text to a shap
    • Mmodifying text on a shape
    • Adding captions
    • Setting shape styles (border, text)
    • Adjusting position and size
  • Apply and manipulate text boxe
    • Format
    • Text box styles
    • Text direction
    • Shadow effects
    • 3-D effects

Proof reading documents

  • Validate content by using spelling and grammar checking options
    • Grammar and style options
  • Configure AutoCorrect settings
    • Add
    • Remove
    • Exceptions
    • AutoCorrect dialog
  • Insert and modify comments in a document
    • Inserting a comment
    • Editing a comment
    • Deleting a comment
    • Viewing a comment (view comments from another user, view comments inline, view comments as balloons)

Microsoft Office Word- Advanced

Applying References and Hyperlinks

  • Apply a hyperlink
  • Hyperlink using text
  • Hyperlink using graphic
  • Headings and bookmarks
  • Create new document
  • E-mail address
  • Create Endnotes and Footnotes in a document
  • Manage footnote and endnote location
  • Configure footnote and endnote format
  • Presentation

Performing Mail Merge Operations

  • Setup mail merge
  • Perform a mail merge using the Mail Merge Wizard
  • Perform a mail merge manually
  • Auto check for errors
  • Execute mail merge
  • Print
  • Preview

Review and collaborating Documents

  • Track changes and set change tracking options
  • View changes, additions and comments
  • Use the Reviewing Pane
  • Choose what changes to show
  • Accept and Reject changes

Comparing and Combining Documents

  • Compare the documents to find out the changes
  • Combine the documents together

Develop Documentation using Macros

  • Record a macro
  • Run the macro
  • View the macros
  • Delete a macro

Random Useful Items

  • Customize the Ribbon
  • Editing pdf documents as MS Word application

Microsoft Office Excel- Basics

Getting Started with Microsoft Excel

  • Identify the Elements of the Excel Interface
  • Create a Basic Worksheet
  • Use the Help System

Performing Calculations

  • Create Formulas in a Worksheet
  • Insert Functions in a Worksheet
  • Reuse Formulas

Modifying a Worksheet

  • Manipulate Data
  • Insert, Manipulate, and Delete Cells, Columns, and Rows
  • Search for and Replace Data
  • Spell Check a Worksheet

Formatting a Worksheet

  • Modify Fonts
  • Add Borders and Color to Cells
  • Apply Number Formats
  • Align Cell Contents
  • Apply Cell Styles

Printing Workbook Contents

  • Define the Basic Page Layout for a Workbook
  • Refine the Page Layout and Apply Print Options

Managing Large Workbooks

  • Format Worksheet Tabs
  • Manage Worksheets
  • Manage the View of Worksheets and Workbooks

Microsoft Office Excel- Advanced

Working with formula/ Functions

  • Lookup and Reference Functions
  • Logical functions
  • Database functions
  • Date and time functions
  • Information functions
  • Math and Trigonometry functions
  • Statistical Functions
  • Text functions

Working with Conditional Formatting

  • Finding cells with conditional formatting
  • Use customized rules in conditional formatting
  • Clear conditional formatting

Data Sorting and Filtering

  • Custom sort order
  • Using autofilter
  • Creating the advanced filter
  • Applying multiple criteria
  • Using complex criteria

Data Validation

  • Allow a cell as drop down menu
  • Restrict the cell with some inputs only

Pivot Tables and Charts

  • Analyzing data with Pivot tables and charts
  • Creating and manage Scenarios and Summaries
  • Applying pivot table styles
  • Sorting and filtering pivot table data

Introduction of Macro

  • Recording macros
  • Running and deleting recorded macro
  • Working with the Personal macro workbook

Consolidation of worksheets

  • Consolidating data from all the worksheets
  • Apply different views to a workbook
  • Selecting zoom options
  • Splitting and arranging windows (View Side by Side, Synchronous Scrolling)
  • Worksheet views
  • Switching windows
  • Opening a worksheet in a new window

Security and Protection Option

  • Cell protection
  • Workbook Protection
  • Integrate the excel document with some other applications
  • Some Useful tips

Microsoft Office PowerPoint

Presentation Planning

  • Audience and Environmen
  • Design, Content and Layout

Slide Masters and Templates

  • Insert a new slide masterg
  • Edit slide master layouts
  • Working with templates

Graphical Objects

  • Formatting Drawn Objects
  • Formatting Pictures, Images
  • Handling Graphical Objects

Charts and Diagrams

  • Using Charts
    • Format chart title, legend, data labels, axes labels.
    • Change the chart type for a defined data series.
    • Change the gap, overlap between columns, bars in a chart.
    • Format columns, bars, plot area, chart area to display an image
  • Using Diagrams
    • Create using built- in options or other available drawing tools a diagram like: flowchart, cycle, pyramid.
    • Add, move, delete shapes in a diagram

Multimedia

  • Working with Movies and sounds
  • Animations

Enhancing Productivity

  • Linking and embedding Objects
  • Importing and exporting data

Managing Presentations

  • Custom show
  • Slide show settings
  • Slide show Controls
Corporate Training Center Dubai, UAE

Program Outcomes:

Upon completion of the program, students will be able to:

  • Demonstrate the fundamental skills needed to use the MS Word word-processing application
  • Create new Word documents, edit and format existing Word documents, add graphics and tables to Word documents, and merge Word documents
  • Demonstrate the fundamental skills needed to use the MS Excel spreadsheet application
  • Use the basic elements of Excel, create and use simple and complex formulas and functions, incorporate useful charts and graphs, add, delete, sort, and lay out table data
  • Demonstrate the fundamental skills needed to use MS PowerPoint presentation application
  • Create a PowerPoint presentation, work with PowerPoint tools, tables, and charts, apply Slide Master, shapes, and effects to a presentation, insert hyperlinks, illustration objects, and media clips
  • Identify the tools used to integrate Word and Excel files
  • Identify the tools used to integrate Word, Excel, and PowerPoint files
Text value required
Phone number value required
E-Mail address value required
Text value required
Please fill in captcha confirmation code
captcha

We offer a range of highly regarded executive and corporate development programmes

ACE IT TRAINING
ACE IT TRAINING

Our Strengths

  • Great reputation
  • Professional service
  • Committed to excellence
  • Exceptional team

Contact Us

Text value required
Phone number value required
E-Mail address value required
Please select one option
Text value required
Please fill in captcha confirmation code
captcha