Courses in Oldham

The content of the course includes Modules 1-18 and Modules 24-27 for operatives and complies with all the classroom and practical training requirements of Chapter 4 of HSG 247 – Asbestos: The Licensed contractors’ guide. Also available in-house at clients own premises/site....

Identify the Elements of the Excel Interface Navigate and Select Cells in Worksheets Customise the Excel Interface Create a Basic Worksheet Performing Calculations in an Excel Worksheet Create Formulas in a Worksheet Insert Functions in...

Calculating Data with Advanced Formulas Apply Cell and Range Names Calculate Data Across Worksheets Use Specialised Functions Analyse Data with Logical and Lookup Functions Organising Worksheet and Table Data Create and Modify Tables Format...

Streamlining Workflow Update Workbook Properties Create a Macro Edit a Macro Apply Conditional Formatting Add Data Validation Criteria Collaborating with Other Users Protect Files Share a Workbook Set Revision Tracking Review Tracked Revisions Merge Workbooks Administer...

Getting Started The Opening Screen Creating a New Document Saving a document Setting up the Workspace Preferences Using Palettes (toolbars) Creating basic Shapes Rectangle Tool Ellipse Tool Polygon, Star and Spiral Tools Creating Paths (lines) Introduction to the Pen Tool Creating Paths...

Review of Level 1 Knowledge Working with Artboards Creating, re-sizing and deleting Artboards Renaming Artboards Moving Between Artboards Artboard options Freehand tools Pencil Tool Smooth and Eraser Tools Paintbrush Tool Advanced Text Techniques Selecting and Altering Text Character Palette Paragraph Palette OpenType...

Review of Level 1 and Level 2 Knowledge Advanced Object Manipulation Creating a Clipping Mask Creating a Graph Creating a Gradient Mesh Free Transform tool Perspective Grids Expanding Objects Advanced Text Techniques Creating a Type Mask Outlining text Linking Text Boxes Moving...

Getting Started with Microsoft Project Explore the Microsoft Project 2010 Environment Display an Existing Project Plan in Different Views Creating a Project Plan Create a Project Plan Assign a Project Calendar Add Tasks to a Project Plan Enter the Task Duration...

Exchanging Project Plan Data with Other Applications Import Project Information Export Project Plan Cost Data to an Excel Workbook Copy a Picture of the Project Plan Information Updating a Project Plan Enter Task Progress Enter Overtime Work Edit Tasks Reschedule a...

Calculating Data with Advanced Formulas •Manage Cell and Range Names •Calculate Data across Worksheets •Use Specialised Functions •Analyse Data with Logical and Lookup Functions Organising Worksheet and Table Data •Create and Modify Tables •Format Tables •Sort or Filter Worksheet or Table Data •Calculate Data in...

Streamlining Workflow •Create a Macro •Edit a Macro •Apply Conditional Formatting •Add Data Validation Criteria •Update a Workbook's Properties •Modify Excel's Default Settings Collaborating with Others •Protect Files •Share a Workbook •Set Revision Tracking •Review Tracked Revisions •Merge Workbooks •Administer Digital Signatures •Restrict Document Access Auditing Worksheets •Trace Cells •Troubleshoot Errors in Formulas •Troubleshoot...

Creating and Editing Documents •Starting Documents •Starting Word •Identifying Components of the Word Screen •The Word 2007 Ribbon •Creating and Opening Documents •Moving the Insertion/Cursor Point •Building and Editing Documents •Selecting Text •Replacing and Deleting Blocks of Text •Moving and Copying Text •Modifying Page Breaks •Finishing Documents •Previewing Documents •Printing Documents •Closing Documents •Assignment Formatting Documents •Formatting...

Please note course content is currently being revised so may vary slightly when you attend. In the first course in this series, Microsoft® Office Word 2007: Level 1, you gained all the basic skills that you need to create a wide range...

Sorting and Merging Text and Data •Sorting •Merging •Protect •Document •Exercise 1 Introduction to Macros •Recording and Running Macros •Managing Macros •Deleting Macros Working With Formulas, Worksheets and Charts •Calculating in Tables •Using Formulas •Using •Worksheets •Creating and Modifying Worksheets •Embedding Existing Excel Worksheets •Working...

Getting Started with Word 2010 • Identify the Components of the Word Interface • Customise the Word Interface • Display a Document in Different Views • Enter Text in a Document • Save a Document Editing Text in a Word...

Managing Lists •Sort a List •Renumber a List •Customise a List Customising Tables and Charts • Sort Table Data • Control Cell Layout • Perform Calculations in a Table • Create Charts Creating Customised Formats with Styles and Themes •Create or...

Using Microsoft Office Word 2010 with Other Programs • Link a Word Document to an Excel Worksheet • Send a Document Outline to Microsoft® Office PowerPoint® • Send a Document as an Email Message Collaborating on Documents • Modify User...

PowerPoint Basics •Foreword •Getting Started with PowerPoint 2007 •Starting PowerPoint •Opening an Existing Presentation •Identifying Elements of the PowerPoint Window •The Ribbon •Moving Between Slides •Using PowerPoint Help •Using the Help Table of Contents Index •To use the Help Topics Index •Changing PowerPoint Views •Changing the Zoom Level •Viewing the Presentation in Outline...

Customising •Customising PowerPoint •About the Quick Access Toolbar •Add-in programs Drawing Tools •Drawing Options •Drawing Shapes •Editing shapes •Group/Ungroup objects Working with Objects •Insert a Table •Insert/Delete Rows/Columns •Merge Cells •Add Borders •Sorting a table in PowerPoint •Organisation Charts •How to Insert/Edit an Organization Chart •Inserting/Deleting boxes •How to Convert a Box •Box borders/Colour •Changing...

Getting Started with PowerPoint •Identify the Elements of the User Interface •View Presentations •Save a Presentation •Use Microsoft PowerPoint Help Creating a Basic Presentation •Select a Presentation Type •Enter Text •Edit Text •Format Text Placeholders •Add Slides to a Presentation •Arrange Slides •Work...