INTEGRATING MS OFFICE APPLICATIONS FOR EFFICIENT PRODUCTIVITY

OVERVIEW

In today working environment, one needs to obtain sufficient knowledge and skills to use various techniques to expedite tasks and enhance productivity. One might encounter instances using MS excel for data entry and calculations but somehow need to produce it in using MS Word document. Thus, this specialized course is intend to assist participants to integrate various data across MS office applications. 

LEARNING OUTCOME

1. Relate and link data in using MS office applications using various methods like hyperlinks, linking and merging.
2. Easier updating repetitive task or entering new data
3. Create effective graphical elements such as graphs in reports and documents

TARGET AUDIENCE

Managers, Executives and administrative workers that mainly involve with using MS Office extensively across applications

REQUIREMENT & PREREQUISITE

Should knowledgeable or have basic essential skills of using MS office applications

COURSE DURATION	:	2 Day (14 Hours)
AWARD TYPE	:	Certificate Of Completion
MIN/MAX PARTICIPANTS	:	Minimum 10 Participants, Maximum 25 Participants

Module 1: Inserting links in Ms Office files

1. Inserting hyperlinks for internal and external links
2. Adding a screen tip for hyperlinks
3. Using alternative shapes as hyperlinks
4. Removing hyperlinks 

Module 2: Mail merge in Word using Excel data

1. Using mail merge wizard in Word
2. Inserting mail merge using excel data
3. Customize using filtering and sorting data
4. Saving and exporting mail merge documents

Module 3: Using Excel Data in a Word Document

1. Inserting an Excel File into Word
2. Copying and Pasting Excel Worksheet data or Chart into Word
3. Embedding Excel Data or Chart into Word
4. Linking Excel Data or a Chart into Word 

Module 4: Controlling Excel Data

1. Creating data filtering
2. Sorting and multiple sorting data
3. Importing and linking Excel data
4. Importing other data source to Excel 

Module 5: Integrating Excel spreadsheet and PowerPoint

1. Using copy and paste special for charts in PowerPoint
2. Linking and updating excel charts
3. Updating and breaking links 

Module 6: Integrating PowerPoint files and Word documents

1. Creating a PowerPoint Presentation from a Word Outline
2. Sending a PowerPoint Presentation to Word