Location, UK
01303 814099
marie@refine-it.co.uk

Courses

“Learning is a treasure that will follow it’s owner everywhere”

Up to-date knowledge, skills and capabilities are essential to success for any organisation and employee.

Invest in your biggest asset by training your employees to the highest standards possible and beat your competition.

Current Courses

Microsoft Excel

MS Excel 2016 – Introduction level

Aims

This course is designed for those who wish to acquire the basic skills of Excel. It would benefit anyone wishing to get to grips with the basics of creating spreadsheets.

Objectives

On completion of this course, attendees will be able to create a spreadsheet, format text and numbers, perform basic calculations.

Prerequisites

Attendees do not need any previous experience of Excel but must have a basic understanding of PCs, and be able to use a keyboard and mouse.

Courses are delivered in 2010, 2013, 2016.

Getting started

  • Excel basics
  • Terminology
  • The Excel environment
  • Backstage view 
  • Navigating the spreadsheet
  • Selecting methods
  • Entering data

Arranging your Data

  • Sorting & filtering data
  • Freeze Panes
  • Page Setup
  • Change Margins & Orientation
  • Print Titles
  • Setting a Print Area
  • Headers & Footers

Formatting

  • Font and cell formatting
  • Number and date formatting
  • Text alignment
  • Add/delete rows and columns
  • Resizing rows and columns 

Working with sheets

  • Rename/Add/Delete Sheets
  • Tab colour
  • Move/Copy a Worksheet
  • Use Formula across Worksheets
  • Group Mode

Formulas & Functions

  • Add/Subtract/Multiply/Divide
  • Absolute Cell References
  • AutoSum
  • Statistical functions
  • Counting
 

AutoFill

  • Numbers and dates
  • Creating lists
  • Using Flash Fill 
 

MS Excel 2016 – Intermediate level

Aims

This course is designed for those who wish to acquire the basic skills of Excel. It would benefit anyone wishing to get to grips with the basics of creating spreadsheets.

Objectives

On completion of this course, attendees will be able to create a spreadsheet, format text and numbers, perform basic calculations.

Prerequisites

Attendees do not need any previous experience of Excel but must have a basic understanding of PCs, and be able to use a keyboard and mouse.

Courses are delivered in 2010, 2013, 2016.

Charts

  • Create a chart
  • Chart formatting
  • Changing data source
  • Create a chart template
  • Sparklines

Named ranges

  • Create using the name box
  • Creating multiple named ranges
  • Managing named ranges
  • Using named ranges in formulas

Working across workbooks

  • Sum data from several workbooks

IF statements

  • Basic IF function
  • IF with AND / OR
  • Nested IF statements

Conditional formatting

  • Highlight cells rules
  • Icon sets & data bars
  • Managing rules
  • Create a rule to highlight a row

Lookup functions

  • VLOOKUP within a workbook
  • VLOOKUP across workbooks
  • HLOOKUP
  • VLOOKUP with IFERROR

Date and text functions

  • Today function
  • Working days
  • Text to columns
  • Joining text
  • Extract part of data from a cell 

Other logical functions

  • COUNTIF and SUMIF
  • COUNTIFS and SUMIFS

MS Excel – Advanced

Aims

This course is designed for those who.

Objectives

On completion of this course, attendees will be able to

Prerequisites

Courses are delivered in 2010, 2013, 2016.

Date and text functions

  • NOW/YEAR/MONTH/DAY/DATE
  • Changing text case
  • LEN / TRIM 

Reference functions

  • INDEX & MATCH
  • INDIRECT

Combination charts

  • Change chart Type of a data series 
  • Adding a secondary axis
  • Formatting axis

Advanced filter

  • Using advanced filter criteria

Pivot Tables

  • Create a pivot table
  • Modify how data is displayed
  • Create a pivot chart
  • Refreshing data
  • Filter data & use slicers

Formula auditing

  • Trace dependants/precedents
  • Error Checking

Data validation 

  • Create validation rules based on cell values and a list
  • Data validation with INDIRECT Function

Workbook and worksheet protection

  • Protect cells and/or structure

Macros

  • Recording and running macros
  • Assigning to the Quick Access Toolbar

Data consolidation

  • Consolidate by position/category
  • Consolidate across workbooks

What-if analysis

  • Goal Seek
  • Scenarios
  • Solver

Input Tables

  • One input tables
  • Two input tables

Microsoft Word

MS Word – Introduction level

Aims

This course is designed for those who.

Objectives

On completion of this course, attendees will be able to

Prerequisites

Courses are delivered in 2010, 2013, 2016.

Getting Started with Word

  • Understanding what Word can do
  • Navigate in Microsoft Word
  • Create and Save Word Documents
  • Manage Your Workspace
  • Edit Documents
  • Preview and Print Documents
  • Customise the Word Environment

Character and Paragraph Formatting

  • Apply Character Formatting
  • Control Paragraph Layout
  • Align Text Using Tabs
  • Display Text in Bulleted or Numbered Lists
  • Apply Borders and Shading

Working More Efficiently

  • Make Repetitive Edits
  • Apply Repetitive Formatting
  • Use Styles to Streamline Repetitive Formatting Tasks

Managing Lists

  • Sort a List
  • Format a List

Inserting Graphic Objects

  • Insert Symbols and Special Characters
  • Add Images to a Document

Page Formatting

  • Apply a Page Border and Colour
  • Add Headers and Footers
  • Control Page Layout
  • Add a Watermark

Adding Tables

  • Insert a Table
  • Modify a Table
  • Format a Table
  • Convert Text to a Table

Proofing and Printing

  • Check Spelling, Grammar
  • Use Research Tools
  • Save a Document to Other Formats
  • Previewing and printing options

MS Word – Introduction level

Aims

This course is designed for those who.

Objectives

On completion of this course, attendees will be able to

Prerequisites

Courses are delivered in 2010, 2013, 2016.

Organising Tables and Charts

  • Sort Table Data
  • Control Cell Layout
  • Perform Calculations in a Table
  • Create a Chart
  • Add an Excel Table to a Word Document

Styles and Themes

  • Create and Modify Text Styles
  • Create Custom List or Table Styles
  • Apply Document Themes

Inserting Content Using Quick Parts

  • Insert Building Blocks
  • Create and Modify Building Blocks
  • Insert Fields Using Quick Parts

Templates

  • Create a Document Using a Template
  • Create and Modify a Template
  • Manage Templates with the Template Organizer

Controlling the Flow of a Document

  • Control Paragraph Flow
  • Insert Section Breaks
  • Insert Columns
  • Link Text Boxes to Control Text Flow

Managing Long Documents

  • Insert Blank and Cover Pages
  • Insert an Index
  • Insert a Table of Contents
  • Insert an Ancillary Table
  • Manage Outlines
  • Create a Master Document

Mail Merge

  • Understanding what a Mail Merge does
  • Creating a merge to a letter
  • Creating a merge to labels
  • Creating a merge to Outlook
  • Merging to Envelopes and Labels
  • Merging to a Directory

MS Word – Advanced level

Aims

This course is designed for those who.

Objectives

On completion of this course, attendees will be able to

Prerequisites

Courses are delivered in 2010, 2013, 2016.

Microsoft Powerpoint

MS PowerPoint – Introduction level

Aims

This course is designed for those who.

Objectives

On completion of this course, attendees will be able to

Prerequisites

Courses are delivered in 2010, 2013, 2016.

Getting Started

  • The PowerPoint environment
  • Backstage view
  • Creating a new presentation
  • Inserting slides

Presentation etiquette

Formatting slides

  • Working with text
  • Adding bullet lists
  • Changing the background colour
  • Applying a theme   

Manipulating Objects

  • Adding graphics
  • Inserting shapes
  • Formatting shape fill and lines
  • Changing a shape
  • Ordering and grouping
  • Alignment
  • Duplicating

Working with slides

  • Views
  • Moving, copying, deleting and duplicating slides
  • Working with notes
  • Modifying the layout
  • Adding pictures
  • Inserting pictures
  • Working with the gallery
  • Modifying picture properties
  • Cropping and compressing

Slideshows

  • Adding slide transitions
  • Adding basic animations
  • Options when presenting

MS PowerPoint – Intermediate

Aims

This course is designed for those who.

Objectives

On completion of this course, attendees will be able to

Prerequisites

Courses are delivered in 2010, 2013, 2016.

Slide objects

  • Working with tables
  • Working with SmartArt
  • Working with charts
  • Working with video
  • Working with audio
  • Importing from Excel/Word   

Custom shows

  • Creating a custom show
  • Managing custom shows
  • Delivering a custom show

Hyperlinks

  • Inserting links
  • Modifying link properties
  • Adding action buttons

Working with the Slide Master

  • Customising master layouts
  • Adding your own layout

Templates and themes

  • Saving as a template
  • Creating and modifying themes

Other Options

  • Working with sections
  • Inserting comments
  • The presenter view

Microsoft Visio

Aims

This course is designed for those who.

Objectives

On completion of this course, attendees will be able to

Prerequisites

Courses are delivered in 2010, 2013, 2016.

Getting Started

  • Overview of Visio and what it is used for
  • Getting to know your way around 
  • Using the Quick Access Toolbar
  • The ribbons
  • Saving and opening drawings
  • Using/searching for stencils
  • Page Setup

Creating a basic drawing

Adding shapes to a page

Selecting shapes

Connecting shapes

Using connectors

Connecting shapes automatically

Adding connection points

Connecting shapes using Auto Connect

Working with Text 

Adding text to a shape

Inserting a text box

Formatting text

Working with shapes

  • Resizing/moving/copying shapes
  • Formatting shapes
  • Rotating/aligning/grouping
  • Distribution of shapes between margins or other shapes

Charts 

  • Create a flowchart using the stencil
  • Create an organisation chart using the wizard
  • Create an organisation chart from

Aims

This course is designed for those who.

Objectives

On completion of this course, attendees will be able to

Prerequisites

Courses are delivered in 2010, 2013, 2016.

Shape data

  • Add existing properties to shapes
  • Create new properties
  • Export shape data

Working with stencils

Create custom stencils

Edit existing stencils

Change order of shapes

Merging shapes

  • Use the union, subtract, combine, intersect and fragment commands

Background pages 

  • Create a background page
  • Assign a background page

Pictures and objects 

  • Insert a picture
  • Insert a file
  • Embed an object
  • Link an object

Hyperlinks

  • Add a hyperlink
  • Edit a hyperlink
  • Remove a hyperlink

Layers 

Create a layer

Assign a layer to a shape

Layer properties

Display individual layers

Remove a layer

Microsoft One Note

MS OneNote – Introduction level

Aims

This course is designed for those who.

Objectives

On completion of this course, attendees will be able to

Prerequisites

Courses are delivered in 2010, 2013, 2016.

Getting started

  • Getting to know what OneNote is used for
  • Understanding the OneNote Layout
  • The OneNote Environment

Creating a OneNote Notebook

  • Creating a New Notebook
  • Adding Sections, Pages and Subpages
  • Adding Content
  • Adding Text to Containers
  • Bulleted and Numbered Lists
  • Inserting Images
  • Using the Send to OneNote Tool
  • Screen Clipping
  • Send to OneNote
  • New Quick Note

OneNote Templates

  • Inserting Page Templates
  • Setting a Default Template
  • Modifying an Existing Template
  • Creating a Custom Template

OneNote with other applications

  • Linking and embedding files
  • Using Web Links
  • Adding Audio and Video Files
  • OneNote with Outlook Meetings and Tasks

Formatting and Organising Notebooks

  • Formatting Notebook Pages
  • Using Tags
  • Searching Notebooks
  • Module 6: Distributing Notebooks
  • Exporting Notebooks
  • Sending Notebooks
  • Printing Notebooks
  • Sharing Notebooks

Managing Notebooks

  • OneNote Recycle Bin
  • Deleting OneNote Items
  • Notebook Backups
  • Changing OneNote Options
  • Working with Drawing Tools (Tablets / Mobile Devices)

Microsoft Outlook

Aims

This course is designed for those who.

Objectives

On completion of this course, attendees will be able to

Prerequisites

Courses are delivered in 2010, 2013, 2016.

Getting Started

  • Outlook as a communication tool
  • Outlook environment
  • Screen layout
  • Customising the QAT
  • Working with ribbons
  • Collapsing and Expanding the ribbon

Working with emails

  • Customizing the screen view
  • Creating and sending emails
  • Replying and forwarding emails
  • Adding attachments and Items
  • Message options
  • Working with folders
  • Printing and deleting messages
  • Using the Out of Office assistant

Working with the Calendar

  • Customising the calendar screen
  • Creating appointments
  • Creating meetings
  • Using the Scheduling Assistant
  • Modifying appointments
  • Recurring appointments
  • Printing

Working with Contacts

  • Creating a new contact
  • Amending contacts
  • Creating a contact group

Working with Tasks

  • Creating a task using the To Do bar
  • Creating and editing tasks
  • Recurring tasks

Working with Notes

  • Creating notes
  • Modifying the notes appearance
  • Sending a note to others   

Refine-IT 2019 ©