MS Office Advanced

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

MICROSOFT EXCEL ADVANCED

MANAGE WORKBOOK OPTIONS AND SETTINGS

MANAGE WORKBOOKS

Save a workbook as a template
Copy macros between workbooks
Mange Document Versions
Reference data in another workbook
Reference data by using structured references
Enable macros in a workbook
Display hidden ribbon tabsSave a workbook as a template
Copy macros between workbooks
Mange Document Versions
Reference data in another workbook
Reference data by using structured references
Enable macros in a workbook
Display hidden ribbon tabs

MANAGE WORKBOOK REVIEW

Restrict editing
Protect a worksheet
Configure formula calculation options
Protect workbook structure
Mange workbook versions
Encrypt workbooks with a password

APPLY CUSTOM DATA FORMATS AND LAYOUTS

APPLY CUSTOM DATA FORMATS AND VALIDATION

Create custom number formats
Populate cells by using advanced Fill Series options
Configure data validation

PREPARE A WORKBOOK FOR INTERNATIONALIZATION

Display data in multiple international formats
Apply international currency formats
Manage multiple options for +Body and +Heading fonts

APPLY ADVANCED CONDITIONAL FORMATTING AND FILTERING

Create custom conditional formatting rules
Create conditional formatting rules that use formulas
Manage conditional formatting rules

CREATE AND MODIFY CUSTOM WORKBOOK ELEMENTS

Create custom color formats
Modify fonts
Insert Form Controls
Create and modify cell types
Create and modify custom themes
Create and modify simply macros
Configure form controls

CREATE ADVANCED FORMULAS

PERFORM DATA ANALYSIS AND BUSINESS INTELLIGENCE

Import, transform, combine, display, and connect to data
Consolidate data
Perform what-if analysis by using Goal Seek and Scenario Manager
Use cube functions to get data out of the Excel data model
Calculate data by using financial functions

TROUBLESHOOT FORMULAS

Trace precedence and dependence
Monitor cells and formulas by using the Watch Window
Validate formulas by using error checking values
Evaluate formulas
Calculate data by using financial functions

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

CREATE ADVANCED FORMULAS

PERFORM DATA ANALYSIS AND BUSINESS INTELLIGENCE

Import, transform, combine, display, and connect to data
Consolidate data
Perform what-if analysis by using Goal Seek and Scenario Manager
Use cube functions to get data out of the Excel data model
Calculate data by using financial functions

TROUBLESHOOT FORMULAS

Trace precedence and dependence
Monitor cells and formulas by using the Watch Window
Validate formulas by using error checking values
Evaluate formulas
Calculate data by using financial functions

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

APPLY FUNCTIONS IN FORMULAS

Perform logical operations by using AND, OR, and NOT functions
Perform logical operations by using nested functions
Perform statistical operations by using SUMIFS, AVERAGEIFS, AND COUNTIFS functions

LOOK UP DATA USING FUNCTIONS

Look up data by using the VLOOKUP
Look up data by using the HLOOKUP function
Look up data by using the MATCH function
Look up data by using the INDEX function

APPLY ADVANCED DATE AND TIME FUNCTIONS

Reference the date and time by using the NOW and TODAY functions
Serialize numbers by using date and time functions

PERFORM DATA ANALYSIS AND BUSINESS INTELLIGENCE

Import, transform, combine, display, and connect to data
Consolidate data
Perform what-if analysis by using Goal Seek and Scenario Manager
Use cube functions to get data out of the Excel data model
Calculate data by using financial functions

PERFORM DATA ANALYSIS AND BUSINESS INTELLIGENCE

Import, transform, combine, display, and connect to data
Consolidate data
Perform what-if analysis by using Goal Seek and Scenario Manager
Use cube functions to get data out of the Excel data model
Calculate data by using financial functions

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

PERFORM DATA ANALYSIS AND BUSINESS INTELLIGENCE

Import, transform, combine, display, and connect to data
Consolidate data
Perform what-if analysis by using Goal Seek and Scenario Manager
Use cube functions to get data out of the Excel data model
Calculate data by using financial functions

TROUBLESHOOT FORMULAS

Trace precedence and dependence
Monitor cells and formulas by using the Watch Window
Validate formulas by using error checking values
Evaluate formulas
Calculate data by using financial functions

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

CREATE ADVANCED CHARTS AND TABLES

CREATE ADVANCED CHARTS

Add trend lines to charts
Create dual axis charts
Save a chart as a template

CREATE AND MANAGE PIVOT TABLES

Create PivotTables
Modify field selections and options
Create slicers
Group PivotTable data
Reference data in a PivotTable by suing the GETPRIVOTDATA function
Add calculated fields
Format data

CREATE AND MANAGE PIVOTCHARTS

Create Pivot Charts
Manipulate options in existing Pivot Charts
Apply styles to Pivot Charts
Apply Styles to Pivot Charts
Manipulate options in existing Pivot Charts
Apply styles to pivot Charts
Drill down into PivotChart detaile