MS Office

MICROSOFT WORD

Microsoft Word, is a word processor developed by Microsoft. MS Word is available stand-alone or as part of the Microsoft Office suite. Word contains rudimentary desktop publishing capabilities and is the most widely used word processing program in the market.

Word files are commonly used as the format for sending text documents because almost every user with a computer can read a Word document by using the Word application, a Word viewer or a word processor that imports the Word format.

CREATE A DOCUMENT

  • Create a blank document
  • Create a document using a template
  • Open a PDF in Word for editing

NAVIGATING THROUGH A DOCUMENT

  • Search for text
  • Insert hyperlinks
  • Create bookmarks
  • Navigate with Headings
  • Cross-reference
  • Move to a specific locations or object in a document

FORMATTING A DOCUMENT

  • Modify page setup
  • Apply document themes
  • Apply document style sets
  • Insert Headers and Footers
  • Insert page numbers
  • Format page background elements

CUSTOMIZE OPTIONS AND VIEWS FOR A DOCUMENT

  • Change document views
  • Customize views by using zoom settings
  • Customize the quick access toolbar
  • Split the window
  • Add document properties
  • Show or hide formatting symbols

PRINT AND SAVE DOCUMENTS

  • Modify print settings
  • Save documents in alternative file formats
  • Print all or part of a document
  • Inspect a document for hidden properties or personal information
  • Inspect a document for accessibility issues
  • Inspect a document for compatibility issues

FORMAT TEXT, PARAGRAPHS, AND SECTIONS

INSERT TEXT AND PARAGRAPHS

  • Find and replace text
  • Cut, copy, and paste text
  • Replace text by using autocorrect
  • Insert special characters

FORMATTING TEXT AND PARAGRAPHS

  • Apply font formatting
  • Apply formatting by using format painter
  • Set line and paragraph spacing and indentation
  • Clear formatting
  • Apply a text highlight color to text selections
  • Apply built-in styles to text
  • Change text to WordArt

ORDER AND GROUP TEXT AND PARAGRAPHS

  • Format text in multiple columns
  • Insert page, section, or column breaks
  • Change page setup options for a section

CREATE TABLES AND LISTS

CREATE A TABLE

  • Convert text to tables
  • Convert tables to text
  • Create a table by specifying rows and columns
  • Apply table styles

MODIFY A TABLE

  • Sort table data
  • Configure cell margins and set spacing
  • Merge and split cells
  • Resize tables, rows, and columns
  • Split tables
  • Configure a repeating row header

CREATE AND MODIFY A LIST

  • Create a numbered or bulleted list
  • Change bullet characteristics or number formats for a list level
  • Define a custom bullet character or number format
  • Increase or decrease list levels
  • Restart or continue list numbering
  • Set starting number values

CREATE AND MANAGE REFERENCES

CREATE AND MANAGE REFERENCE MARKERS

  • Insert footnotes and endnotes
  • Modify footnote and endnote properties
  • Create bibliography citation sources
  • Modify bibliography citation sources
  • Insert citations for bibliographies
  • Insert figure and table captions
  • Modify caption properties

CREATE AND MANAGE SIMPLE REFERENCES

  • Insert standard table of contents
  • Update table of contents
  • Insert cover page

INSERT AND FORMAT GRAPHIC ELEMENTS

INSERT GRAPHIC ELEMENTS

  • Insert shapes
  • Insert pictures
  • Insert screen shot or screen clipping
  • Insert text boxes

FORMAT GRAPHIC ELEMENTS

  • Apply artistic effects
  • Apply picture effects
  • Remove picture backgrounds
  • Format objects
  • Apply a picture style
  • Wrap text around objects
  • Position objects
  • Add alternative text to objects for accessibility

INSERT AND FORMAT SMARTART GRAPHICS

  • Create a SmartArt graphic
  • Format a SmartArt graphic
  • Modify a SmartArt graphic content

REVIEW A DOCUMENT

PROOFING A DOCUMENT

  • Spell Check
  • Check document statistics
  • Translate content

COMMENTS & TRACKING

  • Inserting comments
  • Managing Comments
  • Track the changes
  • Manage Markups
  • Accept/ Reject changes
  • Compare & Combine Documents

MAIL MERGE

PREPARING FOR MAIL MERGE

  • Creating a new list of recipients
  • Using an existing list of recipients
  • Using Outlook contacts
  • Editing the list of recipients

PROTECT A DOCUMENT

  • Formatting Restrictions
  • Editing Restrictions
  • Enforcing Protection
  • Encrypt with a password

WORKING WITH FIELDS

  • Inserting Merge Fields
  • Inserting Greeting Line
  • Inserting Rules
  • Match Fields

FINISHING MAIL MERGE

  • Preview documents
  • Finish & Merge
    1. Individual documents
    2. Print Mail Merge files
    3. E-mail mail Merge files

MICROSOFT POWERPOINT

Microsoft PowerPoint is a presentation program from Microsoft.PowerPoint is available stand-alone or as part of the Microsoft Office suite. It offers users many
ways to display information from simple presentations to complex multimedia presentations.

CREATE AND MANAGE PRESENTATIONS

CREATE A PRESENTATION

  • Create a new presentation
  • Create a presentation based on a template
  • Import Word document outlines
  • Apply a theme

INSERT AND FORMAT SLIDES

  • Insert specific slide layouts
  • Duplicate existing slides
  • Hide and unhide slides
  • Delete slides
  • Apply a different slide layout
  • Modify individual slide backgrounds
  • Insert slide headers, footers, and page numbers

MODIFY SLIDES, HANDOUTS, AND NOTES

  • Change the slide master theme or background
  • Modify slide master content
  • Create a slide layout
  • Modify a slide layout
  • Modify the handout master
  • Modify the notes master

MODIFY SLIDES, HANDOUTS, AND NOTES

  • Change the slide master theme or background
  • Modify slide master content
  • Create a slide layout
  • Modify a slide layout
  • Modify the handout master
  • Modify the notes master

CONFIGURE AND PRESENT A SLIDE SHOW

  • Create custom slide shows
  • Configure slide show options
  • Rehearse slide show timing
  • Present a slide show by using Presenter View

CHANGE PRESENTATION OPTIONS AND VIEWS

  • Change slide size
  • Change views of a presentation
  • Set file properties

CONFIGURE A PRESENTATION FOR PRINT

  • Print Settings
  • Print all or part of a presentation
  • Print notes pages; print handouts
  • Print in color, gray scale, or black and white

INSERT AND FORMAT TEXT, SHAPES, AND IMAGES

INSERT AND FORMAT TEXT

  • Insert text on a slide
  • Apply formatting and styles to text
  • Apply WordArt styles to text
  • Format text in multiple columns
  • Create bulleted and numbered lists
  • Insert hyperlinks

ORDER AND GROUP OBJECTS

  • Order objects
  • Align objects
  • Group objects
  • Display alignment tools

INSERT AND FORMAT SHAPES AND TEXT BOXES

  • Insert or replace shapes
  • Insert text boxes, resize shapes and text boxes
  • Format shapes and text boxes
  • Apply styles to shapes and text boxes

INSERT AND FORMAT IMAGES

  • Insert images
  • Resize and crop images
  • Apply styles and effects

INSERT TABLES, CHARTS, SMARTART, AND MEDIA

INSERT AND FORMAT TABLES

  • Create a table
  • Insert and delete table rows and columns
  • Apply table styles
  • Import a table

INSERT AND MANAGE MEDIA

  • Insert audio and video clips
  • Configure media playback options
  • Adjust media window size
  • Set the video start and stop time
  • Set media timing options

INSERT AND FORMAT CHARTS

  • Create a chart
  • Import a chart
  • Change the Chart Type
  • Add a legend to a chart
  • Change the chart style of a chart

INSERT AND FORMAT SMARTART GRAPHICS

  • Create SmartArt graphics
  • Convert lists to SmartArt graphics
  • Add shapes to SmartArt graphics
  • Reorder shapes in SmartArt graphics
  • Change the color of SmartArt graphics

APPLY TRANSITIONS AND ANIMATIONS

APPLY SLIDE TRANSITIONS

  • Insert Slide Transitions
  • Set transition effect options

ANIMATE SLIDE CONTENT

  • Apply animations to objects
  • Apply animations to text
  • Set animation effect options
  • Set animation paths

SET TIMING FOR TRANSITIONS AND ANIMATIONS

  • Set transition effect duration
  • Configure transition start and finish options
  • Reorder animations on a slide

MANAGE MULTIPLE PRESENTATIONS

MERGE CONTENT FROM MULTIPLE PRESENTATIONS

  • Insert slides from another presentation
  • compare two presentations
  • insert comments, review comments

FINALIZE PRESENTATIONS

  • Protect a presentation
  • Inspect a presentation
  • Proof a presentation
  • Preserve presentation content
  • Save in different formats
  • Export presentations to other formats

TEMPLATES AND MASTERS

CREATING AND MODIFYING TEMPLATES

  • Working with slide masters
  • Inserting Placeholders
  • Modifying backgrounds and color schemes
  • Saving templates

MICROSOFT OUTLOOK

Microsoft Outlook is a personal information manager fromMicrosoft, available as a part of the Microsoft Office suite. Primarily an email application, it also includes a calendar, task manager, contact manager etc.,

It can be used as a stand-alone application. Outlook mobile applications for most mobile platforms, including iOS and Android is also available.

MANAGE THE OUTLOOK ENVIRONMENT FOR PRODUCTIVITY

CUSTOMIZE SETTINGS

  • Customize reply messages
  • Change text formats for all outgoing messages
  • Customize the Navigation Pane
  • Manage multiple accounts
  • Add an account

PRINT AND SAVE INFORMATION

  • Print message, calendar, contact, or task information
  • Save message attachments
  • Preview attachments
  • Perform Search Operations in Outlook
  • Create new search folders

SEARCH FOR ITEMS IN MESSAGES, TASKS, CONTACTS, OR CALENDARS

  • Search by using advanced find; search by folder
  • Sort by Date, Category, Size etc.
  • Sort by Read, Unread

MANAGE MESSAGES

CONFIGURE MAIL SETTINGS

  • Set fonts for new messages and responses
  • Create, assign, and modify signatures
  • Create and manage rules
  • Create automatic replies
  • Create messages by using Quick Steps
  • Configure Junk Email and Clutter settings

ORGANIZE AND MANAGE MESSAGES

  • Sort messages
  • Move messages between folders
  • Add new local folders
  • Apply categories
  • Clean up messages
  • Mark a message as read or unread
  • Flag received messages, ignore messages
  • Sort messages by conversation
  • Delete messages
  • Automate repetitive tasks by using Quick Steps
  • Configure basic Auto Archive settings

CREATE MESSAGES

  • Create a message
  • Add or remove message attachments
  • Add cc and bcc to messages
  • Add tracking and voting options
  • Forward and reply to messages
  • Request a delivery or read receipt
  • Redirect replies
  • Flag outgoing messages for follow up, importance, and sensitivity
  • Recall a message

FORMAT A MESSAGE

  • Format text
  • Insert hyperlinks
  • Apply themes and styles
  • Insert messages
  • Add a signature to specific messages

MANAGE SCHEDULES

CREATE AND MANAGE CALENDARS

  • Create and add calendars
  • Appointment/ Meeting
  • Adjust viewing details for calendars
  • Modify calendar time zones
  • Delete calendars
  • Manage multiple calendars
  • Manage calendar groups
  • Display multiple calendars
  • Share calendars

CREATE AND MANAGE TASKS

  • Create and manage tasks
  • Forward, Move, Delete Tasks
  • Set reminders
  • Assign a Task
  • Set recurrence
  • Mark as completed

CREATE APPOINTMENTS, MEETINGS, AND EVENTS

  • Create calendar items
  • Create recurring calendar items
  • Cancel calendar items
  • Create calendar items from messages
  • Set calendar item times
  • Set up meetings
  • Set free or busy status for calendar items

MANAGE CONTACTS AND GROUPS

  • Create and Manage Contacts
  • Create a new contact
  • Delete contacts
  • Import contacts from external sources
  • Edit contact information
  • Attach an image to a contact
  • Add tags to contacts
  • Share contacts

ORGANIZE AND MANAGE APPOINTMENTS, MEETINGS, AND EVENTS

  • Set calendar item importance
  • Forward calendar items
  • Configure reminders
  • Add participants
  • Respond to invitations
  • Update individual or recurring calendar items
  • E-mail Calendar
  • Categorize calendar items

CREATE AND MANAGE ADDRESS BOOKS

  • Create and Manage Contact Groups
  • Create new contact groups
  • Add contacts to existing contact groups
  • Add notes to a contact group
  • Update contacts within contact groups
  • Delete contact groups
  • Delete contact group members

MICROSOFT EXCEL

Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and IOS. It features calculation, graphing tools, pivot tables. It has been a very widely applied spreadsheet for these platforms. Excel has replaced Lotus 1-2-3 as the industry standard for spreadsheets. Excel forms part of the Microsoft Office suite of software.

Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letternamed columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering and financial needs.

CREATE AND MANAGE WORKSHEETS AND WORKBOOKS

CREATE WORKSHEETS AND WORKBOOKS

  • Create a workbook
  • Import data from a delimited text file
  • Add a worksheet to an existing workbook
  • Copy and move a worksheet

CUSTOMIZE OPTIONS AND VIEWS

  • Hide or unhide worksheets
  • Hide or unhide columns and rows
  • Customize the Quick Access toolbar
  • Change workbook views
  • Change window views
  • Modify document properties
  • Change magnification by using zoom tools
  • Display formulas

NAVIGATE IN WORKSHEETS AND WORKBOOKS

  • Search for data within a workbook
  • Navigate to a named cell, range, or workbook element
  • Insert and remove hyperlinks

CONFIGURE WORKSHEETS AND WORKBOOKS FOR DISTRIBUTION

  • Set a print area
  • Save workbooks in alternative file formats
  • Print all or part of a workbook
  • Set print scaling
  • Display repeating row and column titles on multiple worksheets
  • Inspect a workbook for hidden properties or personal information
  • Inspect a workbook for accessibility issues
  • Inspect a workbook for compatibility issues

FORMAT WORKSHEETS AND WORKBOOKS

  • Change worksheet tab color
  • Rename a worksheet
  • Change worksheet order
  • Modify page setup
  • Insert and delete columns or rows
  • Change Workbook themes
  • Adjust row height and column width
  • Insert headers and footers

MANAGE DATA CELLS AND RANGES

INSERT DATA IN CELLS AND RANGES

  • Replace data
  • Cut, copy, or paste data
  • Paste data by using special paste options
  • fill cells by using Auto Fill
  • Insert and delete cells

FORMAT CELLS AND RANGES

  • Merge cells
  • Modify cell alignment and indentation
  • Format cells by using Format Painter
  • Wrap text within cells
  • Apply number formats
  • Apply cell formats, apply cell styles

SUMMARIZE AND ORGANIZE DATA

  • Insert sparklines
  • Outline data
  • Insert subtotals
  • Apply conditional formatting

CREATE TABLES

CREATE AND MANAGE TABLES

  • Create an Excel table from a cell range
  • Convert a table to a cell range
  • Add or remove table rows and columns

CREATE AND MANAGE TABLES

  • Create an Excel table from a cell range
  • Convert a table to a cell range
  • Add or remove table rows and columns

FILTER AND SORT A TABLE

  • Filter records
  • Sort data by multiple columns
  • Change sort order
  • Remove duplicate records

PERFORM OPERATIONS WITH FORMULAS AND FUNCTIONS

SUMMARIZE DATA BY USING FUNCTIONS

  • Insert references
  • Perform calculations by using the SUM function
  • Perform calculations by using MIN and MAX functions
  • Perform calculations by using the COUNT function
  • Perform calculations by using the AVERAGE function

SUMMARIZE DATA BY USING FUNCTIONS

  • Insert references
  • Perform calculations by using the SUM function
  • Perform calculations by using MIN and MAX functions
  • Perform calculations by using the COUNT function
  • Perform calculations by using the AVERAGE function

FORMAT AND MODIFY TEXT BY USING FUNCTIONS

  • Format text by using RIGHT, LEFT, and MID functions
  • Format text by using UPPER, LOWER, and PROPER functions
  • Format text by using the CONCATENATE function

MODULE FIVE: CREATE CHARTS AND OBJECTS

CREATE CHARTS

  • Create a new chart
  • Add additional data series
  • Switch between rows and columns in source data
  • Analyze data by using Quick Analysis

FORMAT GRAPHIC ELEMENTS

  • Resize charts
  • Add and modify chart elements
  • Apply chart layouts and styles
  • Move charts to a chart sheet

ORMAT GRAPHIC ELEMENTS

  • Resize charts
  • Add and modify chart elements
  • Apply chart layouts and styles
  • Move charts to a chart sheet

Leave a Comment

Your email address will not be published. Required fields are marked *