Computer Skills

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)

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

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

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

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

• 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