Advanced Word 2007
Overview
This one day course covers macros and forms to name but two. This course covers working with long documents. Tasks include formatting long documents, creating a table of contents and an index, and using bookmarks and notes. Students will also learn how to track revisions, use comments, and create master documents. The course also covers the HTML features of Word
Examination information
There is currently no examination associated with this course
Prerequisites
Before attending this course, students must have:
- Attended the Word Introduction and Intermediate courses or have a very good working knowledge of the subject
Course outline
Module 1: FIELD CODES & FILL-IN FORMS
- Inserting a field code
- Updating fields
- Editing and deleting fields
- Locking or unlocking fields
- Displaying field codes
- Converting fields to text
Module 2: FORMS
- What are fill-in forms?
- Creating and editing a form
- Editing and formatting fill-in form fields
- Deleting fields within a fill-in form
- Protecting a fill-in form
Module 3: LINKING AND EMBEDDING
- Linking and embedding objects
- Embedding an Excel chart
- Formatting an embedded worksheet within a document
- Editing an embedded object
- Linking an Excel chart to a Word document.
- Using the 'Insert Chart' command
Module 4: REFERENCES OPTIONS
- Creating a Table of Contents
- Updating and modifying an existing Table of Contents
- Adding a bookmark
- Deleting a bookmark
- Going to a bookmark
- Cross-references
- Creating or editing an index
- Creating Footnotes
- Formatting Footnotes
- Deleting Footnotes
- Creating Endnotes
- Formatting Endnotes
- Deleting Endnotes
- Adding or updating a caption to an image, table or worksheet
Module 5: COLLABORATIVE EDITING AND SECURITY
- To password protect documents
- Inserting comments
- Checking documents for sensitive 'hidden' information
- Tracking changes within a document
Module 6: MASTER DOCUMENTS
- Creating a Master Document
- Inserting a table of contents into a master document
- Editing subdocuments
- Removing subdocuments
Module 7: CONDITIONAL MAIL MERGING
- Using conditional mail merging
Module 8: MACROS
- What are macros?
- Recording a macro
- Assigning a macro to a button
Module 9: WEB PAGES AND HYPERLINKS
- Microsoft Word and the Internet
- Save a document as a Web page
- Previewing a Web formatted page
- Saving a Web page from the Internet
- Saving documents from a Web page
- Creating Internet Hyperlinks
- Editing Internet Hyperlinks
- Removing a hyperlink
Module 10: THEMES
Advanced Excel 2007
Overview
This course introduces the skills necessary for working with pivot tables. Tasks include creating, revising, and formatting pivot tables, and adding pivot table fields. The course also introduces the skills necessary to utilize macros, and customize toolbars and menus. It includes tasks to use, record, edit, and debug macros. Students will also learn how to use the Personal Macro Workbook, custom functions, and custom toolbars and buttons; create a macro button and custom menus. The course also aims to introduce a range of additional features to improve the knowledge of the learner and increase his/her portfolio of spreadsheet skills
Examination information
There is currently no examination associated with this course
Prerequisites
Participants must have a basic understanding of computers and using Excel in Microsoft Windows environment.
Course outline
Module 1: Using Advanced Functions
- Lookup Functions
- Nested IF Functions
- Using Round Function
- Function Argument
- Logical Functions
- Date Functions
Module 2: Exporting and Importing Data
- Exporting data to other Applications
- Importing Data
- Removing the Query Definition
- Importing Dynamic Data from the Web
Module 3: Create Charts and Customize
- Create chart with Primary Axis
- Active Secondary Axis
- Create Gantt Chart
- Create Stock Chart
Module 4: Working with Tables
- Using Tables
- Creating a Table
- Creating a Total Row
- Using Data Validation
Module 5: Using Scenario and Goal Seeking
- Using Scenario Manager
- Creating a Summary Report
- Using Goal Seek
Module 6: Using Worksheet Protection
- protecting a worksheet
- Creating Allow-Editing Ranges
- Deleting Allow-Editing Ranges
- Protecting Workbook Windows
- Unprotecting Workbook Windows
- Assigning a Password
Module 7: Using Conditional and Custom Formats
- Applying Conditional Formats
- Adding a Conditional Format
- Deleting a Conditional Format
- Creating a Custom Format
- Using Data Bars
Module 8: Consolidating Worksheets
- Using Consolidated Worksheets
- Consolidating by Category
- Consolidating by Position
Module 9: Using Templates
- Working with Templates
- Saving a Workbook as a Template
- Deleting a Template
Module 10: Working with Views
- Using Views
- Creating a Normal View
- Creating a Custom View
- Displaying a View
- Deleting a Custom View
Module 11: Creating/Revising PivotTables
- Creating a PivotTable Report
- Changing the Summary Function
- Creating a Page Field Report
- Creating a Pivot Chart Report
- Publishing PivotTable Reports to the Web
Module 12: Sharing Workbooks
- Saving a Shared Workbook
- Viewing Users Sharing a Workbook
- Viewing Shared Workbook Changes
- Highlighting Changes
- Managing Conflicting Changes
- Adding a History Worksheet
- Reviewing Tracked Changes
- Merging Shared Workbook Files
Module 13: Using Data Tables
- Working with Data Tables
- Creating a One Variable Table
- Creating a Two Variable Table
- Applying Conditional Formats
- Adding a Conditional Format
- Deleting a Conditional Format
- Creating a Custom Format
- Using Data Bars
Module 14: Using Macros
- Opening a Workbook Containing Macros
- Running a Macro
- Opening the Visual Basic Editor Window
- Using the Visual Basic Editor Window
Module 15: Recording Macros
- Recording a Macro
- Using Relative References
- Assigning a Macro to a Menu
Module 16: Editing Macros
- Writing a New Macro
- Copying Macro Commands
- Editing Macro Commands
- Typing Macro Commands
- Running a Macro from the Code Window
Module 17: Creating Macro Buttons
- Creating a Macro Button
- Formatting a Macro Button
- Moving /Sizing a Macro Button
Advanced Powerpoint 2007
Examination information
There is currently no examination associated with this course
Prerequisites
Course outline
Module 1: Customizing the PowerPoint Environment
- Customize the Quick Access Toolbar
- Personalize the PowerPoint Interface
- Customize Save Options
- Apply Advanced Customization Options
Module 2: Customizing a Design Template
- Set Up a Slide Master
- Customize Slide Layouts
- Create Custom Themes
- Add Headers and Footers
- Modify the Notes Master
- Modify the Handout Master
Module 3: Adding Diagrams to a Presentation
- Create Diagrams
- Modify Diagrams
Module 4: Adding Special Effects to Presentations
Customize Slide Component Animation
Module 5: Customizing a Slide Show Presentation
- Set Up a Custom Show
- Annotate a Presentation
- Create a Presenter-Independent Slide Show
- Set Up a Slide Show to Repeat Automatically
Module 6: Collaborating on a Presentation
- Review a Presentation
- Publish Slides to a Slide Library
- Share a Presentation
Module 7: Securing and Distributing a Presentation
- Secure Presentations
- Package a Presentation
- Publish a Presentation as a Web Page
-
visit sri lanka
.
-
find us on facebook...
-
contact us
13 Lauries Place, Duplication Road, Colombo 4, Sri Lanka
Telephone : +94 (11) 2594654 Fax: +94 (11) 2595542
