Microsoft Office Package

Get empowered with advanced microsoft office tools and know-how to help maximize your productivity and efficiency.

MICROSOFT WORD

This hands-on Microsoft word training course covers the basics of Microsoft® Word and looks at advanced topics as well. The training program outline is up to date and pertinent to marketplace requirements, thus catering well to all analytical prediction of training needs in the specified area. A customised proposal can also be arranged, to suit the training requirement of your team.

 

Course Objectives:

By the end of this Microsoft word training course, participants will be able to :

•Comprehend the basics of Microsoft® Word 2010, and how it is different from the previous versions

•Understand how to navigate efficiently to the relevant tools within the Microsoft® Word Ribbon

•Explore quick ways of enhancing the appearance of your documents

•Gain an understanding of the various tools available within Microsoft® Word and their different uses

 

Course Outline:

• The Microsoft® Ribbon & The Office / Home Button –

•What Is New in Microsoft® Word 2010?

•Understanding Commands, Tabs, & Groups

•Creating Documents & Templates

•Enhancing The Appearance Of Your Documents

– Changing Font Type, Size, Colour, Case, Styles, Etc.

– Copying Existing Formatting Onto New Text

– Clearing All Formatting From Text

•Paragraphs

Using Paragraph Marks

– Aligning Text

-Applying Drop Cap Styles

•Customising Paragraph Indents, Line & Paragraph Spacing

•Borders & Shading •Using Find & Replace Options

•Using Tabs For Easy Alignment & Placing Of Text

•Changing Your Page Settings (Orientation, Size, Margin, Breaks, Etc.)

•Using Headers & Footers

•Inserting Tables Into Your Document

– Moving Across Cells & Rows

– Working With Text Within The Table

– Selecting All Cells, Rows, Or The Entire Table

– Working With Rows & Columns

•Inserting & Formatting Pictures, Clip Art, 3D Graphics, Etc.

•Checking Your Document For Errors

•Using The Various Printing Options To Suit Your Needs

•Previewing Your Document

•Viewing Your Document Using Different Page View Options

• Inserting Special Characters & Symbols Into Your Document

•Setting Auto Correct & AutoFormat •Working With 3D Text

– Wrapping Text Around Media

•Creating, Customising & Applying Styles

•Using Breaks In Your Document

•Creating Columns In Word Documents

•Tables

– Formatting Data As A Table

– Merging, Splitting, & Aligning Text Within Cells

– Sorting Data In Your Table

•Advanced Formatting For Pictures, Clip Art, 3D Graphics, Etc.

•Inserting & Formatting Text Boxes Within Your Document

•Creating Mail Merge Documents

– Using Your Mailing Database To Work With Microsoft® Word Documents

– Preparing, Printing & Emailing Your Mail Merge Documents

•Inserting, Editing & Removing Hyperlinks In Your Document

•Built-In Themes

– Applying Built-In Themes To Your Documents

– Customising & Creating New Themes

•Macros

– Recording Macros To Speed Up Frequently Performed Actions

– Assigning Shortcut Keys To Recorded Macros

•Securing Your Documents

– Finalising Your Documents As Read-Only

– Adding Password Protection To Your Documents

•Customising The Quick Access Toolbar

 

Who Should Attend? Individuals who would like to gain knowledge of Microsoft® Word 2010, beginners, as well as inter-mediates who would like to explore further tools and techniques to help improve their efficiency.

MICROSOFT EXCEL

This training programme, covers the more intermediate levels of Microsoft Excel in addition to looking at advanced topics as well. The course offers a plethora of knowledge on Microsoft excel and will equip participants to display a better grasp of its use. The training program outline is up to date and pertinent to marketplace requirements, thus catering well to all analytical prediction of training needs in the specified area. A customised proposal can also be arranged, to suit the training requirement of your team.

 

Course Objectives:
By the end of this course, participants will be able to:

• Understand the intermediate functions of Microsoft® Excel 2010, and how it is different from the basic version

• Understand how to navigate efficiently to the relevant tools within the Microsoft® Excel Chart Basics

• Prepare and format Microsoft® Excel sheets and working with multi worksheets

• Be able to format various chart styles

• Proficiently use Advanced Charting

• Be able to use different viewing options

• Be able to use all advanced formatting and display options

• Be able to consolidate data and formatting charts

• Inserting pivot tables and charts into your Excel sheets

• Be able to secure, protect and customise your workbook

• Understand how to use macros and be able to use all logical and statistical functions

• Understand advanced financial functions including all Lookup functions

• Understand and utilise advanced data management

 

Course Outlines:

Creating and Working with Tables

• Working With Multiple Excel Worksheets

– Renaming Your Sheet

– Inserting & Deleting Sheets

– Changing The Order Of Your Sheets

– Creating A Copy Of A Sheet

• Creating Charts Within Microsoft® Excel

• Chart Basics

– Viewing Various Preset Chart Options Available Within Microsoft® Excel

– Resizing A Chart

– Formatting The Text, Colour, Etc., Within A Chart

– Copying & Moving Charts Within Worksheets

• Advanced Charting – Chart Formatting Options

– Combination Charts

– Graphical Elements

• Using The Different View Options Available & Understanding Their Benefits

• Setting The Print Area For Your Sheet

• Inserting Headers & Footers

• Repeating Rows & Columns On Printed Sheets For Easy Viewing

• Using The Paste Special Options

• Importing & Exporting Text

• Naming Cell Ranges For Easy Viewing

Advanced Formatting

• Working With Subtotals

– Creating & Removing Subtotals

• Formatting & Display

– Formatting Tables Using Preset Styles

– Customising Preset Styles

– Using Conditional Formatting Options For Easy Formatting As You Type

– Hiding & Unhiding Rows, Columns & Worksheets

• Use The Sort & Query Functions

– Customising The Sort Function

– Applying Single / Multiple Filters To Data

– Customising The Filter Queries

– Removing Filters

• Consolidating Data

– Combining Data From Various Cells Into A Single Cell

– Linking Cells, Charts, Etc., – In Same & Different Sheets

• Formatting The Following In Your Charts:

– Pie Chart Angles – Formatting & Positioning The Chart Axis, Chart Title & Chart Legend

– Changing The Chart Design After A Chart Has Been Created

– Adding & Deleting A Data Series Within A Chart

• Inserting Pivot Tables & Charts Into Your Excel Sheets

• Protecting Your Workbook

– Adding A Password Protection For Your Workbook

– Finalising Your Workbook As ‘Read Only’

– Defining Data Entry Rules To Prevent Incorrect Information Being Entered

– Customised Protection For Your Workbook To Allow Selective Editing

• Macros – Recording Macros To Speed Up Frequently Performed Actions

– Assigning Shortcut Keys To Recorded Macros

• Customising The Quick Access Toolbar

• Logical & Statistical Functions

• Financial Functions

– Using PMT Functions

• Lookup Functions

• VLOOKUP AND HLOOKUP
• Advanced Data Management

– Observing Data Validation

– Creating Data Validation Rule

 

Who Should Attend?

Individuals who would like to be able to work comfortably with Microsoft® Excel, users who have a good understanding and knowledge of Microsoft® Excel and those who are keen to further their working knowledge of Microsoft® Excel.

 

MICROSOFT POWERPOINT

This intensive Microsoft PowerPoint training program covers the basics of Microsoft® PowerPoint and looks at advanced topics as well. Whether you are a beginner with Microsoft® PowerPoint, or have basic working knowledge, and would like to explore the various creative possibilities available in Microsoft® PowerPoint, this is the course for the likes of you. The training program outline is up to date and pertinent to marketplace requirements, thus catering well to all analytical prediction of training needs in the specified area. A customised proposal can also be arranged, to suit the training requirement of your team.

Course Objectives: By the end of this Microsoft PowerPoint training course, participants will be able to:

• Comprehend the basics of Microsoft® PowerPoint 2010, and how it is different from its previous version

• Understand how to navigate smoothly to the relevant tools within the Microsoft® PowerPoint Ribbon

• Practise using useful PowerPoint tools and functions to prepare creative designs and slides

• Gain a superior understanding of the various PowerPoint tools, and how they can be used in your presentations, to create impactful and professional PowerPoint presentations

• Use keyboard shortcuts to improve your efficiency and speed while using PowerPoint

• Insert charts / graphs / movies / sounds, etc., into your PowerPoint • Use the various Format functions available to enhance the creation and design of your PowerPoint slides

 

Course Outline:
• The Microsoft® Ribbon & The Home Button

– What Is in Microsoft® PowerPoint 2010?

• Understanding Commands, Tabs, & Groups

• Creating New PowerPoint Presentations

– Inserting & Deleting Slides From Your Presentation

• Choosing The Layout For Your Slides

• Inserting Slides From Different PowerPoint Presentations

• PowerPoint Views & The Benefit Of Each

• Adding & Formatting Text Boxes To Your Slides

• Formatting Text In Your Slides

• Inserting Pictures, 3D Shapes & AutoShapes Into Your PowerPoint, & Working With Them

• Inserting Charts / Graphs Into Your PowerPoint Presentations

• Creating A Photo Album In PowerPoint

• Applying Pre-Set Design Themes To Your Slides

– Customising Your Own Theme

Building Your Own Custom Font & Colour Set

• Customising The Quick Access Tool Bar

• Running Your Slide Show • Merge & Compare PowerPoint Presentations

• Printing Your PowerPoint Presentation & Handouts

• Inserting Tables Into Your Slides

– Formatting The Style & Colour Of Your Table

– Merging & Splitting Cells

– Formatting Text, Rows & Columns Within Your Table

• Inserting Media Into Your PowerPoint Presentation

– Downloading Media (Sound / Video Clip)

– Converting Them To PowerPoint Compatible Formats

– Trimming Your Videos In PowerPoint

– Embedding Videos Within Your Slides

– Formatting Media Icons In PowerPoint

• Adding Animation & Transition Effects To Your PowerPoint

– Customising The Preset Animation Effects

– Applying Animations & Transition Effects To Your PowerPoint

• Customising Your Slide Show

– Inserting Links, Action Buttons Or ‘Mouse Over’ Commands

– Rehearsing Your Presentation With Timings

– Reviewing Tools Available For Use During A Slide Show

• Advanced Formatting For AutoShapes, Smart Art, Clip Art, Etc.

– Adding Colour

– Fill Options & Effects

– Standard & Custom Colours

– Adding Gradients & Textures

– Formatting Shapes

– Inserting Text Into Shapes

• Advanced Formatting For Pictures

– Change Brightness, Contrast, Etc., For Pictures

– Re-Colour Pictures

– Compress Pictures In Your Presentation

– Change The Order & Alignment Of Pictures

– Rotate, Crop, Group & Ungroup Pictures

– Maintaining Proportion While Resizing Pictures

• Inserting WordArt Into Your Slides

• Creating A PowerPoint Portable Package On CD

• Creating A Video Of Your PowerPoint Presentation

• Customising PowerPoint Options

 

Who Should Attend?

Individuals who would like to bring creativity into their PowerPoint slides and maximize their presentation impact through the medium of Microsoft PowerPoint.

 

 

MICROSOFT OUTLOOK

This Microsoft Outlook training program focuses on the different functions available in Microsoft® Outlook, and how they can be used to help organize and maintain information about your contacts, meetings, appointments, records of emails, etc. The training program outline is up to date and pertinent to marketplace requirements, thus catering well to all analytical prediction of training needs in the specified area. A customised proposal can also be arranged, to suit the training requirement of your team.

Course Objectives:

By the end of this Microsoft Outlook training course, each participant will be able to: • Understand the basics of Microsoft® Outlook 2010 Explore various tools and functions available in Microsoft® Outlook 2010, where they can be found, and how to put them to best use • Use the Microsoft® Outlook Ribbon to increase efficiency • Set up email accounts on Microsoft® Outlook and find all necessary technical information required to do this • Format emails and insert attachments • Use the Microsoft® Outlook Address Book with Microsoft® Word, Microsoft® Publisher, etc., when using Mail Merge • Understand what ‘rules’ are and how they can help you organize your Inbox efficiently • Insert media into your documents and apply appropriate placement formats

Course Outline:

• The Outlook Menu Bar & Microsoft® Ribbon

• Customising Your Toolbar

• Using The Navigation Pane

• Creating Your Email Accounts – Sending & Receiving Emails

• Working With Emails

– Formatting Email Text

–Adding Signatures To Emails

–Inserting Attachments, Graphs, Charts, Etc.,

–Inserting Hyperlinks In Your Emails

–Using WordArt

– Applying Design Themes To Your Emails

–Creating Your Own Custom Font Set & Colour Palette

– Send Emails To Multiple Recipients

–Using The C.C. & B.C.C. Options

– Inserting Voting Buttons In Your Emails

– Requesting Delivery & Read Receipts For Your Emails

– Setting Custom Delivery Timings For Your Emails

• Applying Rules To Emails

– Set Automatic Actions To Be Performed When Receiving Certain Messages

• Using The Outlook Calendar

• Creating Your Address Book

– Add & Delete Contacts

– Create New Contact Folders

– Enable Contact Folders To Be Used As Mail Merge

• Address Books

– Importing & Exporting Contacts From & To Microsoft® Excel

– Creating A Distribution List

– Adding & Removing Contacts From A Distribution List

 

Who should Attend?

Professionals who would like to use Microsoft® Outlook comfortably, for sending/receiving mails and functions of Microsoft® Outlook, including the Address Book, Calendar, Tasks, etc.

 

Duration: 5days