IC3 - Key Applications

Course details

• This course aims to familarise candidates with Office 2013 environment for Word 2013, Excel 2013 and Powerpoint 2013 package. This course aims to cover the expert and indepth knowledge of the 3 packages where end-users can learn and carry their Office applications expertise to a higher level.

Who Should Attend:

• Inpiduals who are already familiar with basic level of Office 2003, 2007 and/or 2010. Candidates who feel they wish to cover the Key Applications of Office 2013 namely the Word 2013 , Excel 2013 and Powerpoint 2013

Certificate Of Attendance :

• Certificate Of Attendance will be awarded to participants completing the course achieving minimum 75% attendance.

Training Methodology & Materials:

• Practical hands-on sessions, 75% lab-based and 25% theory-based.
• Well-designed lab sessions to enhance further understanding of the courseware

Course Outline:

Module - Excel Expert 2013

Data Presentation

• Customizing Charts
• Formatting a Chart
• Formatting Legend, Axis, Data and Chart Area
• Using Sparklines
• Using Trendlines

Sharing and Protecting Workbooks

• Working with Templates
• Creating, Modifying and Deleting Templates
• Creating a Shared Workbook
• Protecting your workbook using passwords

 Advanced Functions

• Vlookups and Hlookups
• Using Reference
• Using Conditional Logic Functions
• Using Summary Functions

 Data Analysis

• Using PivotTables
• Creating PivotTables
• Manipulating PivotTables
• Advanced Filtering
• Using Advanced Filters and Comparison Operators
• Outlining
• Using Automatic Subtotals
• Manually Grouping and Ungrouping Data

 Module - Word Expert 2013

Sharing and Maintaining Word Documents

• Working with Word 2013  Templates
• Managing Word 2013 Templates
• Restricting Document Access

Tracking and Reviewing Word Documents

• Reviewing Documents
• Setting Tracking Options
• Tracking Changes
• Reviewing Document from Others
• Comparing or Combining Documents

Merging Documents

• Merging with Forms
• Merging with Outlook Contacts
• Merging with Envelopes
• Merging to Labels
• Setting Rules for Merges

Module - Microsoft Powerpoint 2013

Enhanching Powerpoint Presentations

• Enhancing Powerpoint Presentations
• Using Animations
• Applying, Changing or Removing Animations
• Change Animation Settings
• Removing Animations
• Inserting and Modifying Action Buttons

Using Slide Transitions

• Formatting a Slide Master
• Formatting a Notes Master
• Formatting a Handouts Master
• Adding Presenter Notes
• Removing Animations
• Inserting and Modifying Action Buttons

Reviewing Presentations

• Protecting Presentations -  Setting Passwords
• Sharing Presentations
• Broadcasting a Presentation
• Using Sharepoint
• Publishing Presentations