About the Course

This course aims to develop participants' skills in spreadsheet techniques and terminology to an advanced level.

By the end of the course delegates will be able import and export data, use pivot tables and charts, audit and analyse worksheets, manage worksheets and customise Excel.

Course Content

Using Templates

• Create and Edit Templates
• Create New Workbooks Based on User-defined Templates
• Modify Workbook Properties
• Change Default Templates and Modify Template Settings

Working with Ranges

• Create and Use Named Ranges in Formulas
• Use Lookup Functions
• Create and Modify List Ranges

Formatting Cells

• Create and Apply Custom Number Formats
• Apply Conditional Formatting
• Create and Modify List Ranges
• Importing and Exporting Data
• Import Data from Text Files
• Export Data to Other Applications
• Link to Web Page Data

Using PivotTables and Pivot Charts

• Formatting Graphics
• Crop and Rotate Graphics
• Control Image Contrast and Brightness
• Scale and Resize Graphics
• Apply Formats to Data Series

Auditing and Analyzing Worksheets

• Explore Formula Auditing
• Trace Precedents and Dependents
• Locate Errors in Formulas
• Circle Invalid Data
• Evaluate a Nested Formula
• Watch all Cells with Formulas

Summarizing Data

• Group and Outline Structured Data
• Add Subtotals to Worksheets
• Create and Remove Custom Filters
• Use Database Functions
• Create Scenarios
• Use Solver

Managing Worksheets

• Consolidate Data from Several Worksheets
• Create Shared Workbooks
• Track Changes
• Merge Workbook Revisions
• Protect and Unprotect Cells and Worksheets
• Protect Workbooks

Customizing Excel

• Record Macros
• Run Macros
• Change Security Levels for Macros
• Understand Editing Macros
• Add and Remove Buttons from Toolbars
• Add Custom Menus
• Modify Default Font Settings
• Set the Default Number of Worksheets

Entry Requirements

Delegates should have knowledge of Windows 2003 or 2007 and be able to use a keyboard and mouse.

Equipment Requirements

All equipment will be supplied.

Assessment

Due to the workshop nature of this one day course, there are no formal examinations or assessments.

Progression

Delegates may wish to extend their knowledge by completing an ECDL qualification or improve their understanding other Microsoft Office packages.

Enrolment Instructions

Bookings can be made online, or complete a Reservation Form and return it to the Employer Engagement Team.  Please ensure you read a copy of the terms and conditions for bookings and that we are informed of any special requirements.  

Related Tags

About the Course

Delegates should have completed the Fast Track MS Project Introduction course or have knowledge and experience of the topics covered on that course.

By the end of the course delegates will have sufficient knowledge to use MS Project to use all of the resourcing features, both in stand alone projects and across multiple projects.

To give delegates the skills to be able to assign resources, identify over allocation of resources, use the leveling features, import and export data, filter the project, insert sub projects and view consolidated projects.

Course Content

Assigning Resources

• Specify Resources for Projects
• Determine Resource Working Hours
• Create new resource calendars
• Understand Effort-Driven Scheduling
• Modify the Gantt Table
• Assign resources to Tasks
• Make Part-Time Resource Assignments
• Display Resource Allocations
• Set Fixed-Units, Fixed Duration and Fixed Word Task Types
• Assign Additional resources to Increase Work
• Assign Additional resources without Increasing Work

Coordinating Multiple Projects

• Create New Project Files with Custom Templates
• Create Master Projects
• Set Start Dates for Master Projects
• Arrange Project Files for Viewing
• Link Tasks between Sub-Projects
• Share Resources between Projects
• Assign Resources from Resource Pools
• Save Baselines for Master Projects

Integrating MS Project with Applications

• Copy Sheet Data into MS Excel
• Link to Additional Task Information
• Save Projects as Web Pages

Re-using Project Plan Information

• Create a Project Plan Template
• Create a Custom Combination View
• Make Custom Views Available to Other Project Plans

Exchanging Project Plan Data with Other Applications

• Import a Task List from an Excel File into a New Project Plan
• Create a Custom Import Map
• Export Project Plan Cost Data into Excel
• Copy a Picture into a Word Document
• Save Project Plan Information as a Web Page

Entry Requirements

Delegates should have completed the Fast Track MS Project Introduction course or have knowledge and experience of the topics covered on that course.

Equipment Requirements

All equipment will be supplied.

Assessment

Due to the workshop nature of this course, there are no format assessments or examinations.

Progression

Candidates may wish to pursue a Prince2® course with City Business.  For further details, please contact us on 023 8057 7426.

Enrolment Instructions

Contact City Business, City College, St Mary Street, Southampton, SO14 1AR
Tel: (023) 8057 7426  Fax: 023 8057 7491
Email: info@resultsforyourbusiness.com

Related Tags

About the Course

This course will give delegates the skills to be able to create, modify and track a project schedule using the internatioanlly acclaimed MS Project platform.

By the end of the course, delegates will be able to define project dates; enter project tasks; create and manipulate summary tasks; create relationships between tasks; set task priorities; print reports and track progress.

Course Content

Working with Tasks

• Insert Tasks and their Durations 
• Delete Tasks 
• Create Outline Structures for Tasks 
• View Summary Tasks and Subtasks

Using Task Relationships

• Understand Task Relationships 
• Create Links 
• Create Finish-to-Finish Relationships 
• Create Start-to-Start Relationships 
• Create Milestones

Fine-Tuning Timelines

• Create Lag Time 
• Set Deadlines 
• Create Constraints

Adjusting & Tracking Your Project

• Enter Actual Work 
• Reschedule Uncompleted Work 
• Track Percent Complete 
• Enter Remaining Durations 
• Compare Actual Progress with Baselines

Viewing Project Information

• Display Critical Paths & Tasks 
• Understand & View Slack 
• View & Modify Standard Reports

Getting to the Baseline

• Save Baselines for Projects 
• Save Baselines for Selected Tasks

Updating Progress in Your Project

• Change the Current Date 
• Set Project Status Dates 
• Display Progress With Progress Lines

Entry Requirements

There are no formal entry requirments for this course, however delegates should have knowledge of Windows 2000, XP or 2003 and be able to use a mouse and keyboard.

Equipment Requirements

All equipment will be supplied by City Business.

Assessment

There are no formal assessments for this course.

Progression

Delegates may wish to proceed on to the MS Project Intermediate course offered by City Business.  Alternatively, successful candidates can progress on to our Prince2 accredited courses.

Enrolment Instructions

Contact City Business, City College, St Mary Street, Southampton, SO14 1AR
Tel: (023) 8057 7426  Fax: 023 8057 7491
Email: info@resultsforyourbusiness.com

Related Tags

About the Course

This course aims to develop participants skills in word processing techniques and terminology to an advanced level.

By the end of the course delegates will be able to navigate through master and subdocuments; include field references, use automated features and design forms, configure tables and charts and customise word.

Course Content

Working with Styles and Graphics

• Understand Styles
• Design New Character Styles
• Create and Modify Paragraph Styles
• Create, Format, Rotate and Crop Graphics

Including Field References

• Insert Endnotes and Footnotes
• Understand Fields and Cross-references
• Create and Go to Bookmarks
• Navigate with the Document Map
• Mark Text for an Index
• Generate Automatic Tables

Applying Layout and Formatting Techniques

• Understanding Pagination Options
• Include Page Breaks and Line Breaks
• Keep Text Together
• Sort Items in Tables
• Change Document Backgrounds

Using Master Documents

• Understand Master Documents and Subdocuments
• Create Master Documents
• Insert and Manage Subdocuments
• Using Graphics

Restricting Various Permissions

• Restrict Editing Changes
• View Tracked Changes
• Generate Document Versions
• Assign Digital Signatures

Using Automated Features and Designing Forms

• Use AutoSummarise to Update Document Properties
• View and Modify Document Properties
• Determine Readability Statistics
• Use Mail Merge for Form Letters
• Generate Labels with Mail Merge
• Insert Check Box Controls
• Add Drop-Down List Controls
• Protect Forms

Configuring Tables and Charts with External Data

• Format and Calculate in Word Tables
• Insert and Modify Fields in Tables
• Link to Excel Worksheets
• Create Charts Using Excel
• Insert Captions

Using XML in Microsoft Word

• Add Schemas and Stylesheets to the Schema Library
• Attach Schemas to Documents
• Define XML Options
• Apply Transforms to Documents

Customising Word

• Create Run and Modify Macros
• Add and Remove Toolbar Buttons
• Create Custom Menus
• Change the Default Font
• Set the Default Dictionary
• Define or Modify Default Locations

Publishing to Webs

• Create Web Frames
• Set Web Options
• Save to Web Servers

Entry Requirements

Delegates should have knowledge of Windows 2003 or 2007 and be able to use a keyboard and mouse.

Equipment Requirements

All equipment will be supplied.

Assessment

Due to the workshop nature of this one day course, there are no formal examinations or assessments.

Progression

Delegates may wish to extend their knowledge by completing an ECDL qualification or improve their understanding other Microsoft Office packages.

Enrolment Instructions

Contact City Business, City College, St Mary Street, Southampton, SO14 1AR
Tel: (023) 8057 7426  Fax: 023 8057 7491
Email: info@resultsforyourbusiness.com

Related Tags