This course will build on the skills you have learnt on our Essential Excel course or already posess and teach you the more advanced features of the application.  You will become familiar with lists, and sorting and filtering data.  You will learn how to create hyperlinks, create and modify charts, and look at the more advanced functions and formula.

 

Working with Graphs & Charts

·            Create Column, Line and Pie Charts

·            Edit & Format charts

·            Change the chart type

·            Update charts

·            Link charts to other worksheets

 

Advanced Formulae & Functions

·            Working with %

·            Absolute & Mixed Cell Referencing

·            Named Ranges

·            Conditional Formulae

·            IF statements

·            Sum IF, Count IF

 

Working with Lists

·            Sort Data Lists

·            Filtering Data

·            Create and Apply Advanced Filters

·            Creating custom lists

·            Introducing V Look Up

 

Linking Worksheets and Workbooks

·            Working with Hyperlinks

·            Link data from worksheets

·            Link data from workbooks

·            Export to Microsoft Word

 

Summarising Data

·            Pivot Tables

·            Pivot Charts

·            Data Consolidation

 

 

Data Worksheet Protection

·            Protect Cell Contents

·            Protect Workbook

·            Share workbooks

·            Inserting Comments

·            Revision Tracking

This will take your knowledge to an intermediate level

Sorry there are no upcoming dates for this course, please check back later

Understanding and developing “Brand You” is a hugely important step to take in order to achieve your career ambitions. In this course we will show you how developing your personal brand can have a significant positive impact on your job search.

Key elements of the course include:

• Developing Brand You: your skills, competencies and personality; a unique offering
• Promoting Brand You: how to write exceptional CVs, application forms and covering letters
• Your Job Search Strategy, On and Off-line: networking, adverts, and agencies
• Impression Management: managing the impression of your brand

 

Sorry there are no upcoming dates for this course, please check back later

Sorry there are no upcoming dates for this course, please check back later

Overview:

A 1 day Course designed to introduce you to Desk-Top Publishing aimed at developing and increasing your confidence in using Publisher. 

By the end of the course, you will be aware of the essential features of Publisher. You will be able to create and save documents more quickly. You will be able to arrange and present written information clearly and professionally

Who should attend?:

Anyone who has a good understanding of Microsoft Word, and has overall good general PC skills.

Outline:

Getting to know Publisher

• Starting Publisher
• Finding your way around Publisher
• Modifying the toolbar display
• Publisher templates
• Saving a document
• Getting help

Editing Documents

• Opening an existing document
• Selecting text
• Deleting text
• Inserting images
• Moving text
• Copying text

Creating Flyers

• Changing the appearance of templates
• Setting flyer options
• Changing colour scheme
• Grouping and ungrouping
• Changing the appearance of templates
• Setting Brochure options
• Multiple page spreads
• Including a logo

• Changing the appearance of templates
• Setting newsletter options
• Layout options
• Dealing with Headlines
• Dealing with Text overflow
• Shaded stories

• Previewing a document
• Understanding the print options
• Printing a document

Creating Brochures

Creating Newsletters

Printing Documents

Sorry there are no upcoming dates for this course, please check back later

Duration: ½ Day                                   

Overview:

This course is aimed at new users who have access to a PC at home, and would like to grow their skills in using the Internet for Browsing, Online Shopping, Networking and also getting to grips with Digital Photos, Music and Internet Security.

Who should attend: Anyone has access to a PC and the Internet.

Outline:

 

Getting Started	Music and Tv
Using the Keyboard & Mouse	Listening to the Radio Online
Making your computer fit	Watching TV Online
What is the Internet?	Downloading TV shows using I-Player
Getting to grips with the Terminology
Using the Internet	Working with Photos
Surfing the Web	Downloading pictures from your camera
Google	Picture enhancement
News Online	Sharing pictures
Wikipedia
Online Government Services
Social Networking	Shopping and Banking
Finding Friends	Shopping Online
Using Facebook	Managing your money Online
Other Networking Sites	Price Comparison Websites
Guide to Blogs	Booking Travel / Holidays Online
Games and Hobbies	Security and Safety
Online Games	Staying safe online
Family History	PC security
	How Safe are you?

 

Sorry there are no upcoming dates for this course, please check back later

Duration: ½ Day                                   

Overview:

This course is aimed at Intermediate users who have access to a PC at home, and would like to enhance their skills in using the Microsoft Office Applications for creating letters and sending emails, and creating documents to keep track of finances etc.  You will also learn about downloading music, working with digital photos and how to keep your PC secure.

Who should attend:

Anyone who would like to become more confident in using a PC and the Internet .

Outline:

 

Overview of Microsoft Word	Music and TV
How to create letters	Downloading music using Itunes
Standard templates	Listening to the Radio Online
Formatting documents	Watching TV Online
Printing and previewing documents	Downloading TV shows using I-Player
Overview of Microsoft Outlook	Working with Photos
Sending and receiving emails	Downloading pictures from your camera
Creating and using contacts	Using Picasa
Using the task list	Picture enhancement
Getting the most from your calendar	Scanning photos and documents
Creating a Hotmail account	Sharing pictures
Overview of Microsoft Excel	Security and Safety
Excel templates	Staying safe online
Basic calculations	PC security
Functions and formulae	Running Security Updates on your PC
How to format a spreadsheet	How safe are you?
Where to save your documents
Overview of Microsoft PowerPoint
Creating basic presentations
Running a presentation from your PC
Printing a presentation

 

Sorry there are no upcoming dates for this course, please check back later

A full day course giving you an insight into the role of the Private PA; highlighting the difference between working as a PA within the corporate sector and working within a private office or household, and giving you practical tips and an insider’s guide into getting your foot through the door.

Dispelling the general pre-conceptions about requiring the right look or being of the right ilk to get a job in this sector, the course will give you a practical and engaging introduction into the skills set, mentality and personality required to work as a Private PA to high net worth individuals, businessmen, entrepreneurs, celebrities and members of the upper echelons of the aristocracy, both domestic and internationally.

Sorry there are no upcoming dates for this course, please check back later

 

Getting Started

·            Why learn to touch type?

·            Position and posture

·            The “home” keys

 

Hands on Touch typing

·            Your KAZ account

·            Logging on at home

·            How to use KAZ

·            Touch typing exercises

 

Shortcuts

·            Using Keyboard shortcuts

·            Timesaving hints and tips

 

Course Review

·            Touch typing Speed Test

·            Increasing your typing speed

 

 

Sorry there are no upcoming dates for this course, please check back later

Presented by communications industry experts, the Kingstree Group in association with The Skills Academy, this course offers very specific training and guidance to ensure that you can approach interviews and face-to-face meetings with the confidence and conviction you need to maximise your chances of success and put yourself at the top of the shortlist.

Key elements of the course are:

• Achieving Excellence Face to Face: calm under pressure   
• Interview Preparation: getting your story across, achieving competitive edge   
• The Art of Active Listening: managing the interview itself   
• Handling the Toughest Interviews: dealing with difficult people   

Sorry there are no upcoming dates for this course, please check back later

 

Making long documents easier to use

·            How to navigate long documents quickly

·            Create a Table of Contents

·            Mark text for indexing

·            Create an Index

 

Creating forms

·            Add form fields to a document

·            Creating forms

·            Form protection

·            Limit form completion

 

Collaborating with others

·            Using comments

·            Send a document for review

·            Compare document changes

·            Accept document changes

·            Reject document changes

·            Merge document changes

·            Review a document

 

Document setup

·            Advanced page numbering

·            Working with templates

·            Standard templates

·            Creating templates

 

Document Security

·            Update document properties

·            Password protect documents

·            Creating read only documents

·            Limit formatting choices within a document

 

Using Word with other applications

·            Link a chart to excel data

·            Send a document outline to PowerPoint

·            Saving documents as different file formats

·            Send a document as an email attachment

 

Working with Macros

·            Creating macros within Word

·            Editing Macros

·            Running Macros

·            Creating and editing toolbars

 

 

 

Creating a document

·            The word environment

·            Selecting / Entering text

·            Navigating a document

·            Saving documents

·            Moving and copying text

·            Undoing changes

·            Creating documents using templates

 

Editing and formatting text

·            Creating autotext entries

·            Find and replace text

·            Change font and size

·            Apply font styles and effects

·            Change text colour

·            Copy formats using format painter

·            Clear formatting

 

Formatting Paragraphs

·            Set tabs

·            Change paragraph alignment

·            Indent paragraphs

·            Add borders and shading

·            Change paragraph spacing

·            Using lists and bullet points

·            Using columns

 

Using Tables

·            Create a table

·            Enter data in a table

·            AutoFormat a table

·            Convert text into a table

·            Adding columns and rows

·            Merge and split cells

 

Symbols and Graphics

·            Insert symbols and special characters

·            Insert clip art and graphics

·            Add a watermark

·            Resizing graphics

·            Inserting diagrams & charts

 

Controlling page appearance

·            Set page orientation

·            Changing page margins

·            Apply headers and footers

·            Inserting page and section breaks

·            Document properties

 

Mail Merges & printing

·            Create a mail merge letter

·            Creating labels

·            Importing data from other applications

·            Spell check and thesaurus

·            Print preview

·            Printing options