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

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

By the end of the course, delegates will be able to customize workbooks, use list; incorporate functions to determine IF, OR, FV, PMT, and NOW, format worksheets, work with objects, templates, the Web and use 3-D references.

Course Content

Customising Workbooks

• Rename Worksheets
• Change Worksheet Tab Colours
• Select and Move Sets of Worksheets
• Copy, Insert, Delete Hide and Unhide Worksheets
• Rename Folders while Saving

Using Lists

• Learn About Database Features
• Find and Replace Cell Contents
• Freeze and Unfreeze, hide and unhide rows and columns
• Sort Lists
• Understand Filters

Working With Functions

• Understand Inserting Functions
• Use the IF, OR, FV, PMT and NOW functions

Formatting Worksheets

• Understanding autoFormatting
• Define, Apply and Remove Styles
• Indent and Rotate Text
• Page Breaks
• Find and Replace Cell Formats

Working With Objects

• Understand Inserting Objects
• Insert, Move, Delete, Create and Modify Graphics
• Add, Edit and Remove Comments

Using 3-D References

• Understand 3-D References
• Link Worksheets Using 3-D References
• Split and Arrange Workbooks
• Link Workbooks Using 3-D References

Using Excel with the Web

• Look at Online Information and The Web
• Understand, Create and Edit Hyperlinks
• Save Worksheets and Workbooks as Web Pages
• Examine the Research tool

Using Templates

• Explore Templates
• Create Workbooks Based on Templates
• Create New Templates

Entry Requirements

Delegates should have knowledge of Windows 2000, XP, 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 attending an Excel Advanced course after successfully completing the Intermediate level.

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

This course aims to provide participants with a basic introduction to Excel and enable them to use a spreadsheet with confidence and ease.

By the end of the course, delegates will be able to work with cells, rows and columns, move and copy data, explore cell references and formulas and functions, format cells and work with charts.

Course Content

Getting Started with Excel

• Open Microsoft Office Excel
• Examine the Excel Window
• Open and view Worksheets and Work Books

Working With Cells, Rows and Columns

• Create Workbooks
• Enter and Edit Cell Content
• Check Spelling
• Insert, Delete, Merge and Split Cells
• Insert, Delete and Modify Columns and Rows

Exploring Functions

• Understand and Build Functions
• Use AutoSum and AutoCalculate
• Calculate Sums using functions
• Create Averages, Minimum and Maximum Function

Formatting Cells and Cell Contents

• Understand Date and Number Formatting
• Change Text Alignment
• Wrap Text Within Cells
• Modify Text Appearance
• Apply Shading
• Use the Format Painter
• Use Border Drawing

Moving and Copying Data

• Look at the Clipboard
• Examine Cut, Copy and Paste
• Use Paste Special
• Move Cells and Ranges
• Understand Fills

Exploring Cell References and Formulas

• Understand Formulas
• Understand Cell References
• Use Cell References in Formulas
• Enter a Formula in the Formula Bar
• Copy and Edit Formulas

Working With Charts

• Examine Charts
• Use the Chart Wizard
• Change Chart Types
• Elevate, Rotate, Resize and Position Charts
• Edit and Resize Chart Titles

Exploring Printing

• Understanding Printing
• Preview Worksheets
• Change Page Orientation and Scaling
• Set Page Margins and Alignment
• Create Headers and Footers
• Select Print Options
• Set Print and Clear Print Areas
• Print Selections, Worksheets and Workbooks

Entry Requirements

Delegates should have knowledge of Windows 2000, XP, 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 attending an Excel Intermediate course after successfully completing the Introduction level.

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

About the Course

To introduce participants to basic word processing techniques and terminology, and to provide them with the skills required to use Word effectively in their work environment.

By the end of the course delegates will be able to create, print and save a document incorporating a graphic; change font size and type; insert bullets and numbering; create and use a document template.

Course Content

Looking at Word

• Understanding Word
• Open Documents
• Understanding the Working Screen
• Navigate Documents
• Closing Documents & the Application

Working with Text

• Selecting and Replacing Text
• Understanding Toolbars and Menus
• Create New Documents
• Templates
• Saving Documents
• Using the Clipboard ]
• Cut & Paste Text
• Delete Text
• Formatting Text

Working with Fonts

• Adjusting Font Size
• Applying Text Formatting
• Applying Character Effects
• Copying Formatting
• Using Formatting Techniques

Borders and Shading

• Bullets and Numbering
• Customising Bullets
• Aligning Text
• Understand the Shortcut Menus
• Headers & Footers

Create Headers & Footers

• Insert & Format Page Numbers
• Add Placements
• Being Your Own Editor

Find & Replace Text

• Check Spelling & Grammar
• Use the Thesaurus
• Undo & Redo Changes
• Use AutoCorrect for Common Errors
• Managing Documents

Check Word, Paragraph & Character Counts

• Create New Folders
• Use 'Save As'
• Review Document Properties
• Printing Documents

Previewing Documents

• Adjusting Print Settings
• Printing Documents

Entry Requirements

Delegates should have knowledge of Windows 2000, XP,2003 & 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 attending a Word Intermediate course after successfully completing the Introduction level.

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