ECOM Learning Course Outlines

Ecom Course Outlines - 2011 Onwards

1

COURSE OUTLINES 2011 OnwarDS a COMpLete LiSting OF aLL Our COurSeS putting yOur peOpLe FirSt

Tel: 029 2044 0010 Email: training@ecomlearning.co.uk Fax: 029 2044 0019

2

why chooSe ecoM aS your training partner?

A tutor-led training day/s– allowing you to explore your individual learning needs A detailed I.T. manual or copy of the tutor’s presentation – that you can refer to when you come to implement your learning

Ongoing support beyond the initial course – to answer any questions that may arise when you try to implement what you have learnt A fresh buffet lunch

“ECOM GIVE EXCELLENT SUPPORT. I BELIEVE THEY OFFER THE BEST SUPPORT ON THE MARKET TODAY.” JOHN SMITHAM, ESCALADE INTERNATIONAL

Ecom Course Outlines - 2011 Onwards

At Ecom, we have developed a reputation for delivering short courses in Cardiff that are fantastic value for money.

Our short courses can be tailor-made or delivered via our cost effective and comprehensive range of open short courses in Cardiff Bay.

we SpeCiaLiSe in: IT Courses Business Management Courses Leadership Development Courses Finance Courses

Ecom provides organizations and individuals in Cardiff and the surrounding areas with access to high quality short courses and learning solutions.

We provide short courses, certificated courses and courses that result in nationally recognized qualifications. Whatever you choose, all our training courses offer fantastic value for money and are all backed up by excellent customer service.

Tel: 029 2044 0010 Email: training@ecomlearning.co.uk Fax: 029 2044 0019

3

4

Ecom Course Outlines - 2011 Onwards

Section 2

Section 1

Business Management Courses

iCt Courses Key IT Skills

Report Writing

29

Keyboard Skills

06

Minute Taking

30

E-Type: Touch-Type Qualification

07

Delivering Customer Service

31

Sage ACT! Administrator/ Manager Level

08

Delegation Skills

32

Sage ACT! User Level

09

Train the Trainer

33

Reception & Telephone Skills

34

Recruitment Skills

35

Introduction to Management

36

Microsoft Office Microsoft Outlook

10

Microsoft Office 2007 Update

11

Introduction to Microsoft Word

12

Intermediate Microsoft Word

13

Advanced Microsoft Word

14

Introduction to Microsoft Excel

15

Intermediate Microsoft Excel

16

Advanced Microsoft Excel

17

Introduction to Microsoft PowerPoint

18

Intermediate/Advanced Microsoft Powerpoint

19

Microsoft Access Essentials 2003 / 2007 (day 1)

20

Microsoft Access Essentials 2003 / 2007 (day 2)

21

Advanced Microsoft Access 2003 / 2007

22

FLOOr pLan

Specialist IT Courses Introduction to Microsoft Project

23

Intermediate Microsoft Project

24

Microsoft Visio Essentials

25

Section 1

Microsoft Publisher

26

iCt Courses

Microsoft FrontPage

27

Introduction to VBA with Microsoft Excel

28

Section 3 Leadership Development Courses

Ecom Learning Solutions Ltd - Unit 4 Regents Court, Nettlefold Road, Ocean Park, Cardiff CF24 5JQ

5

Ecom Course Outlines - 2011 Onwards

Section 3

Section 4

Leadership Development Courses

Finance Courses

Assertiveness in the Workplace

37

Managing Budgets

49

Dealing with Difficult Customers

38

Managing Budgets with Excel

50

Time Management

39

Managing Budgets with Winforcast

51

Communication Skills

40

Credit Control

52

Negotiation Skills

41

Sage 50 Accounts Level 1

53

Basic Selling Techniques

42

Sage 50 Accounts Level 2

54

Chairing Meetings

43

Sage 50 Accounts Level3

55

Professional Presentation Skills

44

Sage 50 Payroll Level 1

56

Project Management

45

Sage 50 Payroll Level 2

57

Appraisal / Performance Interviewing

46

Introduction to Bookkeeping Certificate

58

Leading Teams

47

Bookkeeping Certificate Level 1

59

Finance for Non-Financial Managers

48

Bookkeeping Certificate Level 2

60

Section 2

Section 4

Business Management Courses

Finance Courses

Tel: 029 2044 0010 Email: training@ecomlearning.co.uk Fax: 029 2044 0019

6

Ecom Course Outlines - 2011 Onwards

Keyboard and Typing Skills Duration: 1/2 Day

Venue: Cardiff

Book Today Get to grips with your keyboard Overview This training course focuses on learning keyboard shortcuts to help you cut down on mouse usage and increase efficiency. You will learn the basic skills needed to make the most of your keyboard including how to use the QWERTY keyboard, shift keys and home keys as well as touch typing.

Who should attend?

This course is perfect for those who have little or no knowledge of how to use keyboard shortcuts to save time, relying instead on their mouse or those wishing to speed up their typing.

Content Introduction • Keyboard Skills Explained • Using the Task Pane • Standard and formatting toolbars • Using the QWERTY keyboard

What’s Next?

Shortcuts & Tools • Using the spell checker

• Minute Taking

• Home Keys

• Introduction to Microsoft Word

• Using Shift Keys • Entering numbers and symbols • Show / Hide facility • Auto-Correct • Auto Text • Inserting Header and Footers

Touch Typing

Book Now 029 2044 0010 training@ecomlearning.co.uk

• Developing Speed Techniques • Use firm key strokes without looking at the keyboard

Ecom Learning Solutions Ltd - Unit 4 Regents Court, Nettlefold Road, Ocean Park, Cardiff CF24 5JQ

Ecom Course Outlines - 2011 Onwards

E-Type Touch-Type Qualification Duration: 2 Days

Venue: Cardiff

Get a touch typing qualification Overview E-Type is a great typing qualification for those who struggle with constant mistakes whilst typing, only use two fingers or just want to speed up their work rate.

Study

The Benefits

You will attend 2 tutor led days before sitting your final exam.

We will also provide you with access to an online learning environment where you can practise between sessions to build up speed and accuracy.

There are many benefits to this skill including: • No longer looking down at your fingers whilst typing • No more frustrating typing errors to slow you down

Every learner will have access to a personal tutor for support as well as comprehensive learning materials.

• A much faster and more productive use of the computer, whether at work or at home • Better posture and reduced levels of stress • Gaining a qualification to enhance your career and job

The Grades

prospects

There are 3 grades which can be achieved: • Bronze: 20 words per minute at 98% accuracy

Costs

• Silver: 40 words per minute at 98% accuracy • Gold: 60 words per minute with 98% accuracy

• Unit - £175 + VAT (inc. of test fee) • Re-sits - £30 per unit Tests can be paid upfront or as you undertake them.(Testing will be invigilated at our training centre)

Book Now 029 2044 0010 training@ecomlearning.co.uk

Tel: 029 2044 0010 Email: training@ecomlearning.co.uk Fax: 029 2044 0019

7

8

Ecom Course Outlines - 2011 Onwards

SaGe acT! aDMiniStratOr/ Manager LeveL Duration: 1 Day Venue: Cardiff Book Today aNd iNcreaSe your kNowledGe of acT!

the COurSe This course will provide managers of ACT! databases with the

COntent •

Importing and Exporting Data

•

Setting Up Users and Teams

•

Creating and Managing Databases, Files & Data Storage

fields, layout and menus. This course will ensure the database

•

Customising ACT! for Efficiency

manager has a detailed understanding of how the database

•

Customising Fields and Layouts

knowledge to set team and individual access levels, control data security, import and export data lists as well as customizing the database to fit the organization’s requirements with regards to

functions.

whO ShOuLD attenD? This course is designed for those administrating the users of ACT!, this person is normally a manager or team leader.

Book Now 029 2044 0010 training@ecomlearning.co.uk

Ecom Learning Solutions Ltd - Unit 4 Regents Court, Nettlefold Road, Ocean Park, Cardiff CF24 5JQ

Ecom Course Outlines - 2011 Onwards

SaGe acT! uSer LeveL Duration: 1 Day Venue: Cardiff Book Today aNd iNcreaSe your kNowledGe of acT!

the COurSe

COntent

This course will guide learners through the key functions of ACT!

•

The reasons for holding meetings

•

Working with Contacts

•

Working with Groups and Companies

as Word and Excel in conjunction with ACT! The course will

•

Scheduling Activities and Managing Your Calendar

ensure all learners can use ACT! competently and confidently.

•

Managing Opportunities

•

Using Email with ACT!

•

Using Internet Services

•

Working with Documents

•

Producing Reports

•

Synchronising Databases

such as how to create, manage and update contacts, using with the calendar to manage workload, grouping customers with common characteristics as well as how to use applications such

whO ShOuLD attenD? This course is designed for those new to ACT! that will be using the system on a day to day basis and need to learn how to use and update their database.

what’S next?

• ACT! Manager/Administrator Level

Book Now 029 2044 0010 training@ecomlearning.co.uk

Tel: 029 2044 0010 Email: training@ecomlearning.co.uk Fax: 029 2044 0019

9

10

Ecom Course Outlines - 2011 Onwards

Microsoft Outlook Duration: 1/2 Day Venue: Cardiff Book Today Get Organised with MS Outlook Overview

This training course is designed for those managing and organising e-mail messages, schedules, tasks, notes, contacts, and other information. It will show you how Outlook 2003 innovations can be used to manage your communications, organise your work, and work better with others; all from one place.

Who Should attend?

Content

Those that need to organise their electronic communications,

Introduction to Outlook 2003

schedule meetings and tasks. Especially useful for those in an

• Different Outlook views

administrative or secretarial role, but equally applicable to any Outlook users.

• Use Outlook to maximise your time • Toolbars • Manage e-mails: Inbox, Sent & Deleted items • Open, close and save emails

What’s Next?

• Add attachments • Automatically spell check an email

• Time Management

• Create a signature

• Keyboard Skills

• Work with contacts; add / delete / find • Create and manage Folders Time Management • Create and manage folders • Out of Office Assistant • Meetings, appointments and events • Schedule a meeting Notes, Tasks and Journals • Tasks—create a ’To Do’ list

Book Now

• Using Notes and Journals

029 2044 0010 training@ecomlearning.co.uk

Ecom Learning Solutions Ltd - Unit 4 Regents Court, Nettlefold Road, Ocean Park, Cardiff CF24 5JQ

Ecom Course Outlines - 2011 Onwards

Microsoft Office 2007 Update Duration: 1 Day

Venue: Cardiff

Book Today Get to Grips with Office 2007 Overview

This course is designed for anyone new to Microsoft Office 2007. The course aims to provide you with the confidence to navigate and use the new features of Office 2007.

This course will examine both Microsoft Word and Microsoft Excel in detail but also will cover navigational changes which effect all Office 2007 software.

Word

Who Should attend?

• Add Preformatted Elements

Anyone who is upgrading from Microsoft Office 2003 to

• Smart Art High Impact Graphics

Microsoft Office 2007 or is unfamiliar with Microsoft Office

• Quick Styles and Themes

2007. This course is perfect for those being slowed down by

• Spelling

struggling to navigate the new software.

• Compare Documents • Document Inspector

What’s Next

• Track Changes • Mailings

• Microsoft Word 2007

Excel

• Microsoft Excel 2007

• More Row and More Columns

• Microsoft PowerPoint 2007 • Microsoft Access 2007

• Easier Access to Formulas • Quick Cell Formatting • Formula Bar

ContenTs

• Charts • Page Layout View

Office

• Conditional Formatting

• The Ribbon & Title Bar

• Data Sorting & Data Filtering

• Status Bar

• Pivot Tables

• Office Button

Digital Signatures

• Quick Access Toolbar

• What is a Digital Signature?

• Tabs & Contextual Tabs

• How can digital signatures be used in Office documents?

• Gallery Toolbars

• Add One or More Signature Lines to a Document • Sign the Signature Line in a Document • Add an Invisible Digital Signature to aDocument

Tel: 029 2044 0010 Email: training@ecomlearning.co.uk Fax: 029 2044 0019

11

12

Ecom Course Outlines - 2011 Onwards

Introduction to Microsoft Word Duration: 1 Day Venue: Cardiff Book Today Learn shortcuts and save time Overview

This course is designed for anyone new to Microsoft Word 2007. The course aims to give the learner practical knowledge of how to use this word processing software at a basic level. This course is full of practical examples of how Word 2007 can be used in a commercial environment.

Who Should attend?

Contents

Anyone who is upgrading from Microsoft Word 2003 to

Basic Navigation

Microsoft Word 2007 or is unfamiliar with Microsoft Word. This

Saving, Opening, Closing Documents

course is for the novice user.

Text Formatting • Inserting, Deleting, Undo and Redo • Insert and Overtype Mode • Copying & Cutting Text

What’s Next?

• Using the Clipboard Paragraph Formatting

• Intermediate Word • Introduction to Excel • Introduction to PowerPoint

• Paragraph marks • Soft paragraph (line break) marks • Aligning Text & Indenting Paragraphs • Line Spacing • Bullet Point & Numbered Lists • Adding Borders and Shading • Finding and Replacing Text • Tab & Styles Page Formatting • Margin, Breaks, Headers & Footers, Page Numbering & Cover Pages

Book Now 029 2044 0010 training@ecomlearning.co.uk

Tables Graphics • ClipArt, Shapes, Pictures, SmartArt Multiple Documents Proofing & Printing

Ecom Learning Solutions Ltd - Unit 4 Regents Court, Nettlefold Road, Ocean Park, Cardiff CF24 5JQ

Ecom Course Outlines - 2011 Onwards

Intermediate Microsoft Word Duration: 1 Day Venue: Cardiff Book Today Create Professional Documents Overview

This course is designed for anyone looking to update or develop their understanding of Microsoft Word 2007. The course aims to give the learner practical knowledge of how to competently use this word processing software. This course is full of practical examples of how Word 2007 can be used in a commercial environment.

Who Should attend?

CONTENTS

Anyone who is upgrading from Microsoft Word 2003 to

Customising Microsoft Word

Microsoft Word 2007 or is looking to develop their knowledge

Text & Paragraph Editing

of Microsoft Word. This course is for the everyday user.

• AutoCorrect • AutoFormat Options • Text Wrapping

What’s Next

• Paragraph Shading & Border Options

• Intermediate Excel

Styles & Templates

• Intermediate PowerPoint

• Applying, Modifying and Creating Styles

• Intermediate Access Essentials

Sections and Column Formatting

• Advanced Word

• Section Breaks and Columns Tables • Creating & Sorting a Table • Formulas • Merging & Splitting Cells Graphics • Reordering Graphics • Placing a Graphic In front or Behind Text • Modifying Colours & Borders • Textboxes

Book Now

Mail Merge

029 2044 0010 training@ecomlearning.co.uk

• Using the Mail Merge Wizard

Tel: 029 2044 0010 Email: training@ecomlearning.co.uk Fax: 029 2044 0019

13

14

Ecom Course Outlines - 2011 Onwards

Advanced Microsoft Word Duration: 1 Day Venue: Cardiff Book Today Become a Microsoft Word Expert Overview

On this course you will be taught some of the more advanced functions of MS Word allowing you to create and distribute the highest quality documentation. You will learn how to use macros, create a form and merge documents. You will also be shown how to work with master documents saving you both time and effort.

Who Should attend?

CONTENTS

This course is for those who require a higher level of awareness

Forms

in MS Word’s more technical functions. You will need a strong

• Create a Form, check boxes, drop-down lists

existing knowledge to of Word in order to attend this course.

This course is also suitable for anyone studying for the ECDL Advanced qualification.

• Protect a Form • Add a password to a document Macros • Record and edit a Macro

WHAT’s NEXT?

• Assign Macro to keyboard and toolbar

• Advanced Excel

Referencing

• Advanced PowerPoint

• Bookmarks and Captions

• Advanced Access

• Footnotes and Endnotes

• ECDL Advanced

• Create Cross-References and Indexes • Time Saving Features • Templates • Inserting Symbols • Using AutoFormat and Autocorrect • Spelling, grammar and language tools Document distribution • Email documents • Track changes

Book Now 029 2044 0010 training@ecomlearning.co.uk

• Compare and Merge documents • Mail Merge • Custom documents, headers and footers, page setup • Create Master Documents

Ecom Learning Solutions Ltd - Unit 4 Regents Court, Nettlefold Road, Ocean Park, Cardiff CF24 5JQ

Ecom Course Outlines - 2011 Onwards

Introduction to Microsoft Excel Duration: 1 Day Venue: Cardiff Book Today Get to Grips with the Basics Overview

This course is designed for anyone new to either Excel or Excel 2007. The course aims to give the learner practical knowledge of how to use Microsoft Excel 2007 at a basic level. The course is full of practical examples of how to use the application within a commercial environment.

Who Should attend?

CONTENTS

Anyone who is upgrading from Excel 2003 to Excel 2007 or is new

A First Look at Excel 2007

to Microsoft Excel. This course is for the novice user

• The New Ribbon and Menu Button • Creating, Opening, Closing, Saving Workbooks • Help Function

What’s Next

Selection Techniques

• Intermediate Excel

• Selecting a cell, row or column

• Introduction to Word

Manipulating Rows & Columns

• Introduction to Access

• Inserting, modifying and deleting rows or columns

• ECDL

• Modifying column widths or row heights Moving, Copying & Deleting Manipulating Worksheets • Renaming, Inserting, Copying, Moving & Deleting Worksheets Formatting • Font, Alignment & Number Formatting Formulas & Functions • Formulas • Relative, Mixed and Absolute Cell Referencing

Book Now

• Functions – Sum, Min, Max, Average

029 2044 0010 training@ecomlearning.co.uk

Using Charts Customizing Excel 2007 Printing

Tel: 029 2044 0010 Email: training@ecomlearning.co.uk Fax: 029 2044 0019

15

16

Ecom Course Outlines - 2011 Onwards

Intermediate Microsoft Excel Duration: 1 Day Venue: Cardiff Book Today Start using Excel more Efficiently Overview

This course is designed for anyone looking to develop their knowledge of Excel 2007.

The course aims to give the learner practical knowledge of how to use Microsoft Excel 2007 at an intermediate level. The course is full of practical examples of how to use the application within a commercial environment. This course can be used as underpinning knowledge if you are working toward the ECDL qualification.

Who Should attend?

CONTENTS

Anyone who is upgrading from Excel 2003 to Excel 2007 or needs

Manipulating Data & Named Ranges

to build upon their current knowledge of Microsoft Excel. This

• Paste Special techniques

course is for the everyday user.

• Importing a text file and delimit by comma, space or tab • Named ranges

WHAT’S NEXT

• Sub-totalling Templates

• Advanced Excel 2007

Formatting & Display Techniques

• Intermediate Word 2007

• Cell & Table Styles

• Microsofft Access Essentials

• Conditional Formatting • Custom number formats • Freezing row and column titles • Hiding and un-hiding rows and columns • Hiding / un-hiding worksheets Sorting and Querying Data • Sorting data by multiple columns • Custom sorts • Using AutoFilter • Using advanced query / filter options

Book Now 029 2044 0010 training@ecomlearning.co.uk

Linking & Consolidating Data • Linking data or a chart within a worksheet • Linking data or a chart between worksheets, word documents & spreadsheets

Ecom Learning Solutions Ltd - Unit 4 Regents Court, Nettlefold Road, Ocean Park, Cardiff CF24 5JQ

Ecom Course Outlines - 2011 Onwards

17

Advanced Microsoft Excel Duration: 1 Day Venue: Cardiff Book Today Become a Microsoft Excel Expert Overview

This course is designed for anyone looking to develop their knowledge of Excel 2007 to an advanced level. The course aims to give the learner practical knowledge of how to use Microsoft Excel 2007. The course is full of practical examples of how to use the application within a commercial environment. This course can be used as underpinning knowledge if you are working toward the ECDL Advanced qualification.

Who Should attend?

CONTENTS

Anyone who is upgrading from Microsoft Excel 2003 to Microsoft Excel 2007 or needs to build upon their current knowledge of Microsoft Excel. This course is for the advanced user.

Functions • Date & Time Functions: Today, Day, Month, Year • Mathematical Functions: SUMIF & ROUND • Text Functions: PROPER, UPPER, LOWER, CONCATENATE

WHAT’S NEXT

• Financial Functions: FV, NPV, PMT, PV, RATE

• Advanced PowerPoint

• Lookup Functions: HLOOKUP, VLOOKUP

• Advanced Word

• Logical Functions: IF, AND, OR, IS ERROR

• Advanced Access

• Database Functions: DSUM, DMIN, DMAX, DCOUNT

• ECDL Advanced

Using One-Input or Two-Input Data Tables / What-If Tables Pivot Tables • Creating a Pivot Table • Grouping and Modifying Data in a Pivot Table Scenarios • Scenario Manager Auditing

Book Now

Macros

029 2044 0010 training@ecomlearning.co.uk

Tel: 029 2044 0010 Email: training@ecomlearning.co.uk Fax: 029 2044 0019

18

Ecom Course Outlines - 2011 Onwards

Introduction to Microsoft PowerPoint Duration: 1 Day Venue: Cardiff Book Today Get to Grips with the Basics Overview

This course is designed for anyone new to Microsoft PowerPoint 2007. The course aims to give the learner practical knowledge of how to use Microsoft PowerPoint 2007 in a working environment. The course is full of practical examples of how to use the application within a commercial environment.

Who Should attend?

Anyone who is upgrading from Microsoft PowerPoint 2003 to Microsoft PowerPoint 2007 or is a complete beginner when it comes to Microsoft PowerPoint. This course is for the novice user.

Contents Basic Navigation Opening and Viewing Presentations Creating a Presentation • Inserting a New Slide • Saving a Presentation Manipulating Slides • Inserting Slides with a Particular Slide Layout • Modifying the Slide Layout • Changing Backgrounds Themes Textboxes Text Editing and Formatting

Book Now 029 2044 0010 training@ecomlearning.co.uk

• Selecting, copying moving, resizing and deleting text • Searching Your Presentation • Font & Paragraph Formatting Illustrations • Selecting, copying moving, resizing and deleting Illustrations • Inserting Illustrations • Formatting Shapes & Charts • Organisation Charts Moving, Copying and Deleting Slides Slide Shows Printing & Proofing Customising Microsoft Word Text & Paragraph Editing • AutoCorrect • AutoFormat Options • Text Wrapping • Paragraph Shading & Border Options Styles & Templates • Applying, Modifying and Creating Styles Sections and Column Formatting • Section Breaks and Columns Tables • Creating & Sorting a Table • Formulas • Merging & Splitting Cells Graphics • Reordering Graphics • Placing a Graphic In front or Behind Text • Modifying Colours & Borders • Textboxes Mail Merge

Ecom Learning Solutions Ltd - Unit 4 Regents Court, Nettlefold Road, Ocean Park, Cardiff CF24 5JQ

Ecom Course Outlines - 2011 Onwards

Intermediate / Advanced Microsoft PowerPoint Duration: 1 Day Venue: Cardiff Book Today Create Professional Presentations Overview

This training course will teach you how to create a more complex and technically sophisticated presentation from scanning in images to creating organisational charts.

You will learn how to link to other documents, insert movies and make use of sounds and narration. You will also be shown how to customise PowerPoint and make your presentations secure.

Who Should attend?

CONTENTS

This course is aimed at people with a working knowledge of how to use PowerPoint but want to make their presentations look and feel more professional by making use of some of PowerPoint’s more advanced features.

WHAT’S NEXT • Advanced PowerPoint • Advanced Word • Advanced Access • ECDL Advanced

Book Now 029 2044 0010 training@ecomlearning.co.uk

Introduction • PowerPoint Environment • Toolbars • Different Views Creating a Photo Album • Create and Format a Photo Album • Insert Photos from Scanner or File • Choose a Frame Shape • Rotate Shapes and Change Picture Order • Adjust Picture Brightness and Contrast • Insert Captions Organisation Charts and Diagrams • Insert an Organisation Chart • Use Diagram Types: Cycle, Venn, Radial, Pyramid and Target • Working with Diagrams: Insert, Delete, Change Direction and Autoformat Embedding and Linking Objects • The Drawing Toolbar • Linking to other Documents Manually or Automatically • Insert and Update Hyperlinks Applying Custom Animation • Object Animation • Slide Transitions, Timings and Rehearsals • Draw Motion Paths • Create Custom Shows Movies & Sounds • Insert Movies, Sounds and Voice Narrations Customising PowerPoint 2003 • Configuring PowerPoint Options: Save, Print and Security • Spelling and Style Options • Autocorrect and Autoformat Options

Tel: 029 2044 0010 Email: training@ecomlearning.co.uk Fax: 029 2044 0019

19

20

Ecom Course Outlines - 2011 Onwards

Microsoft Access Essentials (Day 1) Duration: 2 Days Venue: Cardiff Book Today Get to Grips with the Basics Overview

This comprehensive training course is designed to take a complete beginner through to a level 2 or intermediate level of knowledge. You will be taught the basics of how to use MS Access including opening and working with a database; using tables, queries, forms and reports. Practical exercises will allow you to fine tune your new skills. Day 2 will develop your knowledge further to include designing your own tables, queries, forms and reports as well as expression building and importing and exporting data.

Pivot tables and charts will also be covered. By the end of this course you will have the knowledge required to sit the ECDL Module 5 test.

WHAT’S NEXT? • Day 2

Contents (day 1) Introduction • Introduction to Access database concepts and terminology • Using the database toolbar • Using the Task Pane Tables • Creating and formatting tables • Field properties • Locating and filtering data • Relationships Queries • Using simpler queries • Creating calculated fields Forms • Introducing forms

Book Now 029 2044 0010 training@ecomlearning.co.uk

• Manipulating form controls Reports • Advanced report design • Using editing tools

Ecom Learning Solutions Ltd - Unit 4 Regents Court, Nettlefold Road, Ocean Park, Cardiff CF24 5JQ

Ecom Course Outlines - 2011 Onwards

Microsoft Access Essentials (Day 2) Duration: 2 Day Venue: Cardiff Book Today Learn shortcuts and save time

Who Should attend?

Content (day2)

This course has been created for new or existing users of

Designing Tables

Microsoft Access who wish to gain a better understanding of the

• Normalising data

software and may wish to use it in a commercial environment.

• Establishing relationships

This course will also provide the underpinning knowledge

• Indexes

required to sit the ECDL Module 5 test (databases).

Designing Queries • Action Queries • Parameter Queries

What’s next

• Calculated columns • Relationships

• Advanced MS Access

Designing Forms

• ECDL

• Working with form and sub-forms • Switchboards Designing Reports • Data Access Pages • Standard reports, pop-up reports Pivot Tables and Pivot Charts • Pivot tables and charts • Forms Export and Import Data Building Expressions • Expression builder

Book Now 029 2044 0010 training@ecomlearning.co.uk

Tel: 029 2044 0010 Email: training@ecomlearning.co.uk Fax: 029 2044 0019

21

22

Ecom Course Outlines - 2011 Onwards

Advanced Microsoft Access Duration: 1 Day Venue: Cardiff Book Today Become an Expert User

Overview

This training course is designed to give learners an advanced knowledge of Microsoft Access. You will be taught how to create an use Macros as well as being introduced to structured query language. You will also be introduced to visual basic concepts. By the end of this training you will have a confident and complex knowledge of Microsoft Access.

Who Should attend?

Content

This course has been created for competent users of Microsoft

Designing Tables

Access who wish to deepen their expertise of this software and

• Normalising data

learn useful hints and tips of using this software in a commercial environment.

Introducing Structured Query Language • SQL queries, sub-queries, commands and joins • Inserting, updating and deleting data Working with Macros

What’s next

• Creating Macros • Testing and Debugging Macros

• ECDL

• Modifying Macros

• ECDL Advanced

• Adding Macros to Forms and Reports Programming Access • Macros versus Visual Basic • Visual Basic Concepts Data Access Pages • Creating, Modifying and Sorting Data Access Pages • Editing and Protecting Converting Access Databases

Book Now

• Converting from Access ’97, 2000 to 2003

029 2044 0010 training@ecomlearning.co.uk

• Optimizing with Table Analyser, Performance

Managing and Maintaining Analyser and Documenter Analyser

Ecom Learning Solutions Ltd - Unit 4 Regents Court, Nettlefold Road, Ocean Park, Cardiff CF24 5JQ

Ecom Course Outlines - 2011 Onwards

23

Introduction to Microsoft Project Duration: 1 Day Venue: Cardiff Book Today Control your Project Costs

Overview

This course will provide you with a detailed understanding of how to use Microsoft Project to manage and plan project activity. From the basics of setting up a new project through to creating a Gantt chart of activity and allocating resources, we will teach you how to streamline projects so that waste is kept to a minimum and resources are not overstretched. Microsoft Project can ensure that you can bring the project in on time and on budget.

Who Should attend?

COntent

This course would suit anyone new to Microsoft Project that needs a tool for planning, monitoring and controlling projects or contracts. No previous knowledge of the package is necessary but familiarity with Microsoft Applications will be required.

What’s next • Project Management Skills • Intermediate Microsoft Project 2003

Book Now 029 2044 0010 training@ecomlearning.co.uk

Introduction • Creating a New Project • Start and Finish Dates • Project Calendar Tasks • Overlapping and Delaying Tasks • Editing Tasks • Task Constraints • Organising Tasks with Outline • Linking Tasks Resources • Resource Calendar • Resources • Controlling when a Resource starts work on a Task • Assigning Costs to Tasks and Resources • Assigning a Fixed Cost to a Resource • Accruing Costs Tools • Formatting the Gantt Chart • Combining Views • Tracking the Progress of the Project • Filters • Evaluating and Adjusting the Schedule Printing • Printing the Schedule

Tel: 029 2044 0010 Email: training@ecomlearning.co.uk Fax: 029 2044 0019

24

Ecom Course Outlines - 2011 Onwards

Intermediate Microsoft Project Duration: 1 Day Venue: Cardiff Book Today Control your Projects

Overview

This course will provide you with a detailed understanding of how to use Microsoft Project to manage and plan project activity. You should already have an understanding of how to use the basic functions of MS Project. We will teach you how to manage multiple projects, address issues of over allocation and adjust your project forecast to keep it on track.

Microsoft Project can ensure that you can bring the project in on time and on budget.

Who Should attend?

COntent

This course would suit anyone familiar with Microsoft Project

Introduction

and is looking to develop their knowledge to achieve closer

• Critical and Slack Time

control over one or multiple projects. This course is perfect for existing project managers who already use MS Project.

• Adjusting Outline Options • Interrupting Work on a Task • Keeping Track of Your Project • Adjusting the Project to Keep it on Track

What’s next

• Tracking Project Costs • Creating a Project by using a Project Template

• Project Management Skills

• Managing Several Projects at the Same Time • Creating a Work Space • Effort Driven Scheduling and Task Types Resources • Resource Calendar • Resources • Controlling when a Resource starts work on a Task

Book Now 029 2044 0010 training@ecomlearning.co.uk

• Assigning Costs to Tasks and Resources • Assigning a Fixed Cost to a Resource • Accruing Costs • Resolving Resource Over Allocations • Sharing Resources Among Projects

Ecom Learning Solutions Ltd - Unit 4 Regents Court, Nettlefold Road, Ocean Park, Cardiff CF24 5JQ

Ecom Course Outlines - 2011 Onwards

Microsoft Visio Essentials Duration: 1 Day Venue: Cardiff Book Today Pull your Designs together with MS Visio

Overview

This training course is designed to give learners the ability to transfer information; usually presented as text, into visually rich versatile diagrams. It will also teach you how to generate diagrams from a diverse range of data and allow you to put complex concepts and processes into context. A common use of Microsoft Office Visio is to illustrate business processes.

Who Should attend?

COntent

This course is perfect for those who have little or no knowledge of how to use keyboard shortcuts to save time, relying instead on their mouse.

Book Now

Introduction • Creating a New Project Commands available in Visio • The Visio work area • Visio toolbars Create a diagram from a selected template • Overview of templates, stencils and objects Create new drawings • Using the drawing task pane • Creating and opening drawings • Managing drawings • Working with templates • Working with stencils, shapes and connectors Format drawings • Formatting text and shapes • Using snap and glue and layers • Inserting Pictures • Editing Pages Share drawings • Sending Drawings • Printing Drawings Customise Visio • Configuring Visio • Configuring AutoCorrect Options • Customising Toolbars

029 2044 0010 training@ecomlearning.co.uk

Tel: 029 2044 0010 Email: training@ecomlearning.co.uk Fax: 029 2044 0019

25

26

Ecom Course Outlines - 2011 Onwards

Microsoft Publisher Duration: 1 Day Venue: Cardiff Book Today Design your own Publications

Overview

This training course is designed to give you the ability to use this sophisticated desktop publishing tool to create professional looking publications such as newsletters, brochures, flyers and labels. This course will cover the basics before moving onto more advanced functions giving you a comprehensive overview of how to use MS Publisher.

Who Should attend?

This course is aimed at people with either no or very little experience in using MS Publisher. The course is perfect for those looking for a cost effective way of producing promotional literature or documents. Past delegates have included marketing assistants, business owners and administrators.

what’s next • Microsoft FrontPage

Book Now 029 2044 0010 training@ecomlearning.co.uk

COntent Introduction • MS Publisher Environment • Toolbars • Help Features Working with Publications • New Publication Task Pane • Create a Publication from Design Templates • Colour and Font Schemes Task Panes • Styles and Formatting Task Panes • Using Backgrounds Designing a Page • Page Layout, Insert and Delete Pages • Rulers and Guides • Master Pages • Adding Headers and Footers Text Tools • Creating and Linking Text Boxes • Search and Replace • Spell Check and Language Options • Cut, Copy and Paste • Clipboard Task Pane Printing • Send Publication to an Email Recipient • Print Preview • Printing Publications

Ecom Learning Solutions Ltd - Unit 4 Regents Court, Nettlefold Road, Ocean Park, Cardiff CF24 5JQ

Ecom Course Outlines - 2011 Onwards

Microsoft FrontPage Duration: 1 Day Venue: Cardiff Book Today Get to Grips with Web Design Overview

This course will introduce you to Microsoft FrontPage provide you with the skills to produce professional marketing, e-commerce websites and intranets. You will learn the basic principles of good site design and learn how to use this package to create a web presence.

COntent

Who Should attend?

This course is for the complete beginner, new users of Microsoft

• FrontPage and the Internet

Web Design including those with no previous experience of

• Creating a First Website

creating web pages.

• Basic Formatting Techniques • Manipulating Tables Within FrontPage • FrontPage - Pictures & Multimedia

what’s next

• Hyper-linking, Bookmarks & Image Maps • Introducing FrontPage “Components”

• Microsoft Visio Essentials

• FrontPage and Frames • Managing Your Website • Good Site Design, Publishing & Publicizing • Importing a Website

Book Now 029 2044 0010 training@ecomlearning.co.uk

Tel: 029 2044 0010 Email: training@ecomlearning.co.uk Fax: 029 2044 0019

27

28

Ecom Course Outlines - 2011 Onwards

Introduction to VBA with Microsoft Excel Duration: 1 Day Venue: Cardiff Book Today Automate Repetitive Tasks Overview

The objective of this course is to provide you with the knowledge and confidence to write Visual Basic Code in the Excel environment. The course is structured so that the you produce code quickly and are aware of the application’s requirements, limitations and security implications. Emphasis is placed on writing well structured and effective code.

This is an intensive course and a basic knowledge of Excel is required.

Who Should attend?

Building Formal Control Structures • Comparison Operators

This course is for experienced users of Microsoft Excel who

• If .. Then Decision Structures

need to automate repetitive tasks and write their own Macros

• For loops / Do Loops

or formulas. You must be an experienced user of Excel to attend

• Select Case Decision Structures

this course.

The Excel Object Model • Objects

what’s next • Intermediate VBA with Excel

• Collections • Referring to Objects and Collections in Code • Properties • Methods Visual Basic Functions • InputBox Function

COntent Introduction • Security • Creating a Personal Workbook • The Visual Basic Editor • Subroutines • Range Object • The Active Cell

• MsgBox Function Triggering Code to Run • Using the Menu Bar • Using a Shortcut Key on the Keyboard • Using a Toolbar Icon • Using a ActiveX Control Button • On an Area, Hot Spot, or Graphic Object (Shape) • More about the Macro Window • Write an Excel Add-in

• Operators • Variables • Triggering Code to Run

Ecom Learning Solutions Ltd - Unit 4 Regents Court, Nettlefold Road, Ocean Park, Cardiff CF24 5JQ

Ecom Course Outlines - 2011 Onwards

Report Writing Duration: 1 Day Venue: Cardiff Book Today Are you Structuring your Reports Correctly?

Overview

This course will provide you with a fundamental grasp of how to write clear, well structured reports. It will identify a time-efficient process and logical report structure to equip you with the building blocks to construct sound business (and less formal) reports.

You will be given the opportunity to practise the techniques you learn.

Who Should attend?

Content

This course has been popular with managers, marketing

• A time efficient drafting process

executives, administrators and personal assistants. This course

• Who will receive the report?

has attracted delegates from across both private and public sector organisations and is one of our most popular courses.

What is their understanding/need?

• Building the right structure • Keeping it simple • Practice in drafting a report • Sharing of, and feedback on, drafts

what’s next

• Planning post-workshop development activity

• Minute Taking

Book Now 029 2044 0010 training@ecomlearning.co.uk

Tel: 029 2044 0010 Email: training@ecomlearning.co.uk Fax: 029 2044 0019

29

30

Ecom Course Outlines - 2011 Onwards

Minute Taking Duration: 1 Day Venue: Cardiff Book Today Take Minutes at Speed

Overview

This course will teach you how to take concise minutes and produce an accurate record of meetings as well as exploring the relationship between the minute taker and the chair.

You will be taught how to take notes at speed that can be typed up and circulated to all attendees. You will also have the opportunity to share best practise in minute taking and develop a greater understanding of your responsibilities as minute taker.

Who Should attend?

content

This course is great for those who find it difficult to take notes

• What are meetings for?

especially when the chair and attendees speak so fast. Anyone

• What’s the recipe for a good meeting?

responsible for taking minutes should attend this course, past attendees have included personal assistants, administrators and managers.

• The Agenda …what to include.

• How do you take notes when everyone speaks so fast?

• Why Minutes?

• Responsibilities of the minute taker

whats next • Report Writing

• What do they look like? And why?

• Putting it into practice

• Certificate in Meetings

Book Now 029 2044 0010 training@ecomlearning.co.uk

Ecom Learning Solutions Ltd - Unit 4 Regents Court, Nettlefold Road, Ocean Park, Cardiff CF24 5JQ

Ecom Course Outlines - 2011 Onwards

31

Delivering Customer Service Duration: 1 Day Venue: Cardiff Book Today Add Value to your Customer Relations

Overview

This course provides an understanding of how customers can be influenced at every point of contact and how building trust and goodwill is as vital as the products and services you provide. The course will teach you how to project a positive image of your organisation, how to identify customers real needs and how to handle difficult or problematic customers correctly without losing their business.

Who Should attend?

CONTENT

This course is great for front line and support staff that have

• How do we get treated as customers?

regular contact with customers and need to recognise that

• What would you expect as a customer?

their actions play a significant part in their company’s image and success. Past attendees have included secretary’s, PA’s, receptionists, customer service advisors and account managers

• Who are your customers?

• How to establish their needs and how to deal with them effectively • Why is customer care important?

what’s next

• What are the issues for us in dealing with customers?

• Dealing with Difficult Customers

• How to present the right image

• Reception & Telephone Skills

• What is customer care?

• Communication Skills

• Techniques for dealing with difficult situations

Book Now 029 2044 0010 training@ecomlearning.co.uk

Tel: 029 2044 0010 Email: training@ecomlearning.co.uk Fax: 029 2044 0019

32

Ecom Course Outlines - 2011 Onwards

Delegation Skills Duration: 1 Day Venue: Cardiff Book Today Unlock your Time

Overview

Do you find there just aren’t enough hours in the day to get work done? Are you managing a team as well as performing your own tasks? Good delegation skills will ensure that tasks are completed quicker and will free your own time to focus on more important tasks. This course identifies both good and bad delegation as well as exploring how trust functions in the manager-employee relationship.

Who Should attend?

content

Traditionally this course has been attended by managers who

• What is delegation?

need to learn the skill of delegating tasks so that they can use

• Barriers To Delegation

their own time more productively. Anyone supervising a team or an individual would benefit from this course.

• The Trust - Control Dilemma • Symptoms Of Poor Delegation • The Need For Delegation

what’s next

• How To Delegate

• Communication Skills • Negotiation Skills • Time Management

Book Now 029 2044 0010 training@ecomlearning.co.uk

Ecom Learning Solutions Ltd - Unit 4 Regents Court, Nettlefold Road, Ocean Park, Cardiff CF24 5JQ

Ecom Course Outlines - 2011 Onwards

Train the Trainer Duration: 2 Days Venue: Cardiff Book Today Start your Career in Learning & Development

The COurse

This course is designed to ensure as a, Trainer, you are equipped with the skills and knowledge needed to create an effective learning environment for adults. There is a strong emphasis on the importance of interactive delegate-centred learning and you will have the opportunity to deliver a short training session and receive constructive feedback.

WHo should attend?

COntent

This course is for those trainers relatively new to their position or

Day 1

looking to consolidate their experience and for those who may

• What is training?

be required from time to time to deliver training as part of a

• The knowledge, skills and attitude needed to be a GREAT

wider role.

trainer • Understanding and using icebreakers • Training Cycle – overview of TNA methods/objective setting /delegate assessment and evaluation methods

what’s next

• Adult Learning • Kolb’s Learning Cycle

• Appraisal / Performance Interviewing

• Learning styles – overview and selfassessment

• Leading Teams

• Applying learning styles • Structuring a training course • Preparing and using visual aids Day 2 • Making training memorable • Left/right Brain • Dealing with challenging behaviour • Planning and writing trainer’s notes

Book Now

• Individual preparation

029 2044 0010 training@ecomlearning.co.uk

• Practical session • Feedback

Tel: 029 2044 0010 Email: training@ecomlearning.co.uk Fax: 029 2044 0019

33

34

Ecom Course Outlines - 2011 Onwards

Reception & Telephone Skills Duration: 1 Day Venue: Cardiff Book Today Start Projecting a Positive Image

The COurse

This course will provide you with a comprehensive knowledge of how to deal with people in a receptionist role. The course will teach you how to create a positive customer perception through your appearance, tone of voice, customer service and communication style. Telephone call handling will also be explored to give you all the skills you need to become a great shop window for your organisation.

WHo should attend?

COntent

This course is perfectly suited to new and existing receptionists,

The Person:

secretaries or administrators. Anyone who is greeting or dealing

• Image – Looking and feeling part

with customers either on your premises or via the telephone.

• The positive approach • Two-way communication • Handling and taking over at break • Handling the awkward person • Greeting visitors • Keeping visitors waiting • Appearance The Telephone: • Basic ground rules – The Do’s and Don’ts!

• Call introduction – external and internal calls • Call ending • Achieving “Two Way Communication” • Handling difficult callers • Voice • Effective speaking

Book Now 029 2044 0010 training@ecomlearning.co.uk

• Your responsibilities • Message taking and relaying • Barriers to perfection • Helpful and hindering mannerisms

Ecom Learning Solutions Ltd - Unit 4 Regents Court, Nettlefold Road, Ocean Park, Cardiff CF24 5JQ

Ecom Course Outlines - 2011 Onwards

35

Recruitment Skills Duration: 1 Day Venue: Cardiff Book Today Recruit the Right People

The COurse

Recruiting the right people for your business can mean the difference between success and failure. Having a robust recruitment process will weed out unwanted candidates and identify those that can add the right skills to your business. This course will teach you how to do that from writing the job description and person specification to the interview process and questioning techniques. This course will ensure your business can prosper through the people it employs and help keep staff turnover to a minimum.

WHo should attend?

COntent

This course has been attended by managers, team leaders, HR

• The recruitment process

and Personnel staff as well as business owners. The course is

• Relevant legislation

perfect for those unfamiliar with recruitment or needs to formalise their recruitment processes.

• Job descriptions and person specifications • Establishing selection criteria • The interviewing process

what’s next

• Team’ selection issues • Questioning techniques

• Appraisal Interviewing • Leading Teams

Book Now 029 2044 0010 training@ecomlearning.co.uk

Tel: 029 2044 0010 Email: training@ecomlearning.co.uk Fax: 029 2044 0019

36

Ecom Course Outlines - 2011 Onwards

Introduction to Management Duration: 2 Days Venue: Cardiff Book Today Develop your Career in Management

The COurse

This course will give you a comprehensive overview of the skills and responsibilities required of a manager. You will learn the difference between being a team leader and a manager, what makes a good manager and the different leadership styles you can use.

This will be followed by an in depth look at how to motivate staff, build trust and delegate effectively.

WHo should attend?

COntent

This course is for those entering management for the first time,

Day 1

for someone newly promoted from team leader or supervisor. It

• Understanding leadership & its importance in the

is perfect for those with little management experience or those who need a better understanding of the differences between eading and managing people and processes.

workplace.

• Good / Bad Leadership Traits • The difference between the leader and the manager • The characteristics and style of effective leadership

what’s next • Communication Skills • Project Management • Chairing Meetings

• Effective delegation skills Day 2 • Motivating staff effectively • Understanding and achieving team work • Gaining Feedback • Setting SMART Objectives • Coaching Models • An introduction to grievance and discipline handling

Book Now 029 2044 0010 training@ecomlearning.co.uk

Ecom Learning Solutions Ltd - Unit 4 Regents Court, Nettlefold Road, Ocean Park, Cardiff CF24 5JQ

Ecom Course Outlines - 2011 Onwards

37

Assertiveness in the Workplace Duration: 1 Day Venue: Cardiff Book Today Take Control Now

Overview

It is essential to communicate well at work. Being assertive is a highly effective way of getting points across and building mutual respect. It involves expressing honest thoughts, feelings, perceptions, needs, opinions and wishes in ways which promote positive responses. On this course delegates will learn the essential skills of being assertive and how to distinguish between aggressive and submissive behaviour.

Who Should attend?

content

This course is perfect for managers or leaders that need to be more assertive with their staff, strategies and communication style. Many managers find being assertive difficult and even unnatural but assertiveness is not to be confused with aggression. Even the most laid back management style can incorporate an element of assertiveness.

• Introduction to Assertiveness • Understanding aggressive, assertive and non-assertive behaviour • Stressful effects non-assertive behaviour • produces • Danger & Demons

what’s next

• Understanding your rights and beliefs • Making and refusing requests

• Delegation Skills • Introduction to Management

• Thinking Straight

• Communication Skills

• First Steps • Skills Inventory • Difficult Situations and People • Action Plan

Book Now 029 2044 0010 training@ecomlearning.co.uk

Tel: 029 2044 0010 Email: training@ecomlearning.co.uk Fax: 029 2044 0019

38

Ecom Course Outlines - 2011 Onwards

Dealing with Difficult Customers Duration: 1 Day Venue: Cardiff Book Today Keep your Customers

Overview

Do you get frustrated by those customers who get irate, complain about everything but still buy your product or service? This course will teach you how to handle such customers without losing their business. You will be taught how to handle customer’s expectations in an effort to prevent misunderstanding, what to do when things have gone wrong and techniques for calming rude or angry customers.

Who Should attend?

This course is for those who regularly deal with customers whether that be by email, telephone or face-to-face and need to learn how to deal with impatient, rude or outright aggressive customers whilst maintaining a cool and collected approach to securing their business and maintaining the organisation’s integrity.

content • What is Customer Care?

• Who are your customers and what are their expectations?

• Dealing effectively with the telephone and face to face callers • Asking the right questions to meet their needs expectations

what’s next • Delivering Customer Service • Reception & Telephone Skills

• An insight into dealing with more difficult customers • Techniques for dealing with: the Rude Customer, the Impatient Customer and the ANGRY Customer

Book Now 029 2044 0010 training@ecomlearning.co.uk

Ecom Learning Solutions Ltd - Unit 4 Regents Court, Nettlefold Road, Ocean Park, Cardiff CF24 5JQ

Ecom Course Outlines - 2011 Onwards

39

Time Management Duration: 1 Day Venue: Cardiff Book Today Keep your Customers

Overview

Time Management is actually self management and this course is designed to give you the knowledge to increase your work effectiveness and give you greater control over your daily activities. You will learn how to prioritise and organise your time to incorporate a number of tasks, and explore how effective time management can lead to the achievement of business objectives. The ultimate aim of this course is to show you how organising your time can lead to a more productive day or week.

Who Should attend?

content

This course is for people who struggle to find enough time in their working day, are poorly organised or would need to develop their self-management. Time management is a great

• What is Time Management?

• Time Management Approach

course for new managers or those with responsibility for others

• Organise Yourself

as your organisation could be affecting your team’s productivity.

• Making a Structured List • Positive Active Tasks & Reactive Tasks • Establish Priorities

what’s next

• Importance & Urgency • Schedule your Time

• Delegation Skills

• Positive Active Tasks & Reactive Tasks

• Communication Skills

• Organise Others through Delegation

Book Now 029 2044 0010 training@ecomlearning.co.uk

Tel: 029 2044 0010 Email: training@ecomlearning.co.uk Fax: 029 2044 0019

40

Ecom Course Outlines - 2011 Onwards

Communication Skills Duration: 1 Day Venue: Cardiff Book Today Forge Stronger Working Relationships

Overview

This course will help you identify your own communication style whilst understanding how we communicate with others through verbal and visual signs. Once you have understood and identified your communication style you will be shown how to adapt it in different situations. This will lead to stronger working relationships essential both, internally amongst staff and externally with customers.

Who Should attend?

This course has catered for a wide variety of people all of which need to understand and improve their personal communications skills, whether that be to understand buying signs, get your

Content • How do you communicate?

• The barriers to successful communication

point across to your staff or whether you need to deliver a

• Methods of communication

presentation. This course have a wide range of uses.

• The essentials of communication • Listening skills • Improve your skills at gaining information

What’s Next?

• Telephone & Reception Skills • Basic Selling Skills • Delegation Skills

• Prepare communications more effectively to gain the desired outcome • Identifying individual styles • Adapting our styles to others • Making the communication relevant

Book Now 029 2044 0010 training@ecomlearning.co.uk

Ecom Learning Solutions Ltd - Unit 4 Regents Court, Nettlefold Road, Ocean Park, Cardiff CF24 5JQ

Ecom Course Outlines - 2011 Onwards

Negotiation Skills Duration: 1 Day Venue: Cardiff Book Today Get more from your Sales

Overview

This course will allow you to explore the negotiation process, how to prepare for a meeting and how to get the result you want. You will learn how to handle negative situations as well as how to set yourself structured goals for the meeting. Various conclusions will be explored and you will leave having fine tuned your new skills through role-play and case studies.

Who Should attend?

Content

This course has attracted a range of attendees including managers, business owners, contract managers and sales people.

Anyone who liaises with customers, suppliers or clients in an

• Communication Barriers • Preparing for Negotiations

effort to secure business or control costs would benefit from

• Techniques for handling difficult situations

this course.

• Negotiation Frameworks • Win – Win Situations • Win – Lose Situations

What’s Next?

• Lose – Lose Situations • Role Play & Case Study Exercises

• Communication Skills

• Setting SMART and SMARTER objectives

• Professional Selling Techniques

Book Now 029 2044 0010 training@ecomlearning.co.uk

Tel: 029 2044 0010 Email: training@ecomlearning.co.uk Fax: 029 2044 0019

41

42

Ecom Course Outlines - 2011 Onwards

Basic Selling techniques Duration: 1 Day Venue: Cardiff Book Today Improve your Sales Figures

The COurse

This course focuses around the point of sale whether that be via the telephone or faceto-face. You will gain a clear understanding of the sales process with emphasis given to identifying and meeting customer’s needs. You will explore a variety of closing techniques as well as open and closed questioning which you will have the opportunity to practice before leaving the course. After-sales and customer service will also feature prominently.

WHo should attend?

This course is for anyone new to sales or needs to improve an aspect of their sales pitch. This course is not suited to sales professionals (please see our professional selling techniques

Content • The reasons for holding meetings • Identifying your pre-meeting essential needs

course) but for those looking for a non-pressurised selling

• Understanding the sales process

technique. Past attendees have included customer service

• The telephone in the sales process

advisors and account managers who contribute to the sales process.

• Questions to identify client’s real needs • Making more effective proposals

what’s next • Professional Selling Skills

• Managing and overcoming client’s concerns • Closing the sale effectively • Managing the after-sales environment

• Delivering Customer Service

Book Now 029 2044 0010 training@ecomlearning.co.uk

Ecom Learning Solutions Ltd - Unit 4 Regents Court, Nettlefold Road, Ocean Park, Cardiff CF24 5JQ

Ecom Course Outlines - 2011 Onwards

43

Chairing Meetings Duration: 1 Day Venue: Cardiff Book Today Learn how to run an Effective Meeting

The COurse

This course will equip you with the knowledge and understanding you need to effectively chair meetings. You will explore the qualities, role, and responsibilities of a successful Chairperson as well as the effects of different Chairing ‘styles’. You will be provided with all the tools necessary to construct and deliver an effective meeting whilst considering the needs of your minute taker.

WHo should attend?

COntent

This course is aimed at anyone who is about to assume (or renew after a long absence) the role of Chair of a group or committee.

Past attendees have included senior managers, committee

• The reasons for holding meetings • Essential elements for successful outcomes • Role, responsibilities and qualities of a successful Chair

members and business owners.

• Committee / Group development issues • The route to successful Chair / Secretary Relationships

what’s next

• Building the Agenda – the blueprint to success • Essential Chairing Styles

• Communication Skills

• Types of meetings

• Professional Presentation Skills

• Managing behaviors encountered

Book Now 029 2044 0010 training@ecomlearning.co.uk

Tel: 029 2044 0010 Email: training@ecomlearning.co.uk Fax: 029 2044 0019

44

Ecom Course Outlines - 2011 Onwards

Professional Presentation Skills Duration: 2 Days Venue: Cardiff Book Today Deliver the Best Presentations The COurse

This course will teach you how to deliver a great presentation whether it be for your managers, monthly sales meeting, clients or a job interview. You will learn how to prepare both you presentation and yourself prior to the big day, how to structure your presentation and how to read your audience. You will be taught the importance of using visual aids as opposed to text as well as how to engage with your audience. This course will conclude with all delegates presenting to the group.

WHo should attend?

This course has a wide audience including sales people, job seekers, managers and account managers. The skills learnt on this course are equally applicable to any industry you might work in.

COntent • Your Unique Selling Point • How to Relax Prior to Presentations

Whether your new to presentations or find you get very nervous

• Preparing a Presentation

before delivering one then this course can help you.

• Structuring a Presentation • Opening a Presentation

what’s next • Communication Skills • Professional Presentation Skills

• Avoiding the Bore Zone • Closing a Presentation • Using Visual Aids • Improving Your Delivery

Book Now 029 2044 0010 training@ecomlearning.co.uk

Ecom Learning Solutions Ltd - Unit 4 Regents Court, Nettlefold Road, Ocean Park, Cardiff CF24 5JQ

Ecom Course Outlines - 2011 Onwards

Project Management Duration: 2 Days Venue: Cardiff Book Today Deliver Projects on Time & within Budget The COurse

Project management requires a diverse rage of skills and covers a wide range of activities from planning to delegation; management to evaluation. This course covers all aspects of project management in detail and will give you the knowledge to confidently start your own project. In addition to project management theory, MS Project will be explored as a planning and management tool and how it can make your projects run more smoothly.

WHo should attend?

COntent

This course is perfectly suited to new or aspiring project

• The key to successful projects

managers looking for a comprehensive insight into project

• Planning, communication and commitment

management techniques and processes. Whether you are looking to manage a large or small project this course will give you the knowledge you require.

• Define and set project objectives • Allocate work of the project into phases • Appraise financial viability of projects • Plan and schedule project activities • Progress and control projects

what’s next

• Using MS Project

• Introduction to Microsoft Project 2003

• Survival tips for project managers

• Delegation Skills

Book Now 029 2044 0010 training@ecomlearning.co.uk

Tel: 029 2044 0010 Email: training@ecomlearning.co.uk Fax: 029 2044 0019

45

46

Ecom Course Outlines - 2011 Onwards

Appraisal / Performance Interviewing Duration: 1 Day Venue: Cardiff Book Today Increase Staff Retention and Moral

The COurse

This practical workshop will prepare you for conducting performance interviews with your staff. You will take an in depth look at how and why appraisals take place, how to prepare for an interview and the questioning techniques available to you. You will gain advice on how to make the most of an interview and have the opportunity to practise the skills and techniques required to run an effective appraisal process.

WHo should attend?

This course has been created for anyone responsible for an organisation’s recruitment and appraisal process. It’s perfect for those delivering their first appraisal interview or any organisation that would like to become better at recognising and rewarding best practise which can lead to improved staff motivation and performance.

what’s next • Writing for Business • Assertiveness in the Workplace

COntent • Understanding the need and uses of staff appraisal • Understand the principles of successful interviewing • The skills for conducting successful staff appraisal interviews • Essential preparation for the interview • Reviewing job descriptions / person specifications • Techniques for feeding back to staff • Questioning techniques • Setting SMART and SMARTER objectives

Book Now 029 2044 0010 training@ecomlearning.co.uk

Ecom Learning Solutions Ltd - Unit 4 Regents Court, Nettlefold Road, Ocean Park, Cardiff CF24 5JQ

Ecom Course Outlines - 2011 Onwards

47

Leading Teams Duration: 1 Day Venue: Cardiff Book Today Lead your Team to Success

The COurse

This course will provide you with a toolkit of techniques and knowledge that will enhance your leadership qualities and make you a better team leader. An overview of leadership qualities will be followed by the identification of why teams fail to perform or hit targets.

From this knowledge a coaching strategy is explored to allow detailed feedback and planning.

WHo should attend?

COntent

Team leaders, supervisors, line managers and general managers can

• What are the characteristics of a high performance team?

all benefit from attending this course. Anyone who needs

• What is good leadership?

to enhance their leadership qualities, better understand what it takes to lead a team or just wants to gain best practise in this diverse field. Equally relevant to sales as office based team leaders.

• The 7 habits of a successful leader • Explore the reasons why we don’t perform • Giving and receiving feedback • What is a 360 review

what’s next

• How it can be used

• Communication Skills

• Planning for change

• GROW model of coaching, theory and practice

• Delegation Skills • Dealing with Difficult Customers

Book Now 029 2044 0010 training@ecomlearning.co.uk

Tel: 029 2044 0010 Email: training@ecomlearning.co.uk Fax: 029 2044 0019

48

Ecom Course Outlines - 2011 Onwards

Finance for Non-Financial Managers Duration: 2 Days

Venue: Cardiff

Book Today Finance made Easy and Engaging

The COurse

To function effectively, managers of today are under increasing pressure to understand finance and financial systems. They can be presented with Financial Statements which claim to monitor their department or company performance. However, these statements are often designed by accountants and in many cases can only be understood by accountants.

ECOM has developed a 2-Day Finance Programme specifically for the nonfinancial manager that cuts through typical accountancy jargon and explains the fundamental principals of finance systems in laymen’s terms.

WHo should attend?

Although these programmes are run by qualified accountants with years of practical experience in the Manufacturing and Service industries, the programme has been targeted towards Managers with no financial control experience.

COntent • Financial control within a business • Understanding financial statements • Interpretation of accounts and evaluating risk using ratios • Budgeting Control & Capital Budgets • Capital and revenue expenditure • Investment appraisal

what’s next • Managing Budgets

• Monitoring and controlling the use of resources by using different costing techniques and or budgetary control • The use of computers in management accounting

• Sage 50 Accounts • Sage 50 Payroll • Credit Control

Book Now 029 2044 0010 training@ecomlearning.co.uk

Ecom Learning Solutions Ltd - Unit 4 Regents Court, Nettlefold Road, Ocean Park, Cardiff CF24 5JQ

Ecom Course Outlines - 2011 Onwards

49

Managing Budgets Duration: 1 Day Venue: Cardiff Book Today Get the most out of your Budget

The COurse

One of the ways in which organisations attempt to achieve their strategic objectives is by preparing budgets, then monitoring actual performance against them. A budget can be described as a plan set out in monetary terms, prepared and approved prior to a defined period of time, and usually showing either or both the planned income to be generated and the expenditure to be incurred during that time period. This course explores how you prepare, create and monitor a budget.

WHo should attend?

COntent

Individuals who need to understand the importance of setting,

• What is a budget?

controlling and presenting budgets.

• Budget preparation • Zero-based budgeting (ZBB) • Calculation and analysis of variances • Flexible budgets • Presentation of budgets • Using spreadsheets

what’s next

• Business plans and the role of budgeting • The mechanics of budget preparation including ZBB

• Credit Control

• Budgetary responsibility within organisations

• Finance for Non Financial Managers

• How budgets are used by organisations throughout their life cycle • Variance analysis: calculation, interpretation and corrective action • How to prepare and use flexible budgets • Budget presentation

Book Now 029 2044 0010 training@ecomlearning.co.uk

Tel: 029 2044 0010 Email: training@ecomlearning.co.uk Fax: 029 2044 0019

50

Ecom Course Outlines - 2011 Onwards

Managing Budgets with Excel Duration: 1 Day Venue: Cardiff Book Today Design and Manage your own Budget

The COurse

One of the ways in which an organisation attempts to achieve their strategic objectives is by preparing and managing budgets them monitoring actual performance against them.

This course will provide you with a knowledge of Budgeting principles and concepts as well as how to present a budget whilst exploring how Microsoft Excel can help you achieve this.

WHo should attend?

COntent

This course is aimed at people either currently working with

• What is a Budget?

budgets, or need to set a budget for your business. Anyone

• Budget Preparation

unfamiliar with budgeting concepts will benefit from this course.

A working knowledge of Excel is needed for this course.

• Flexible Budget Plans • Analysis of Variances • Interpretation and Corrective action • What is Microsoft Excel • Data Entry on to an Excel Spreadsheet

what’s next

• Creating Formulas and Functions • Spreadsheet Formatting

• Credit Control

• Printing and Saving

• Advanced Excel 2003 / 2007

• Using Percentages

• Sage 50 Accounts / Certification

• Absolute Addresses • Linking Worksheets within an Excel Workbook

Book Now 029 2044 0010 training@ecomlearning.co.uk

Ecom Learning Solutions Ltd - Unit 4 Regents Court, Nettlefold Road, Ocean Park, Cardiff CF24 5JQ

Ecom Course Outlines - 2011 Onwards

Managing Budgets Win forcast Duration: 1 Day Venue: Cardiff Book Today Design and Manage your own Budget

The COurse

One of the ways in which an organisation attempts to achieve their strategic objectives is by preparing and managing budgets them monitoring actual performance against them.

This course will provide you with a knowledge of Budgeting principles and concepts as well as how to present a budget whilst exploring how Microsoft Excel can help you achieve this.

WHo should attend?

COntent

This course is aimed at people either currently working with

• What is a Budget?

budgets, or need to set a budget for your business. Anyone

• Budget Preparation

unfamiliar with budgeting concepts will benefit from this course.

A working knowledge of Excel is needed for this course.

• Flexible Budget Plans • Analysis of Variances • Interpretation and Corrective action • What is WIn Forcast • Data Entry on to an Winforcast • Formatting

what’s next

• Printing and Saving

• Credit Control

• Using Percentages

• Advanced Excel 2003 / 2007

• Linking Winforcast with Excell

• Sage 50 Accounts / Certification

• Linking Sage with Winforcast

Book Now 029 2044 0010 training@ecomlearning.co.uk

Tel: 029 2044 0010 Email: training@ecomlearning.co.uk Fax: 029 2044 0019

51

52

Ecom Course Outlines - 2011 Onwards

Credit Control Duration: 1 Day Venue: Cardiff Book Today Control your Company Finances

The COurse

This course will take you through the processes and legalities of credit control whilst teaching you how to manage your contracts or invoices on a day-to-day basis. You will explore risk assessments, how to draft and understand terms and conditions as well as how to legally enforce them. This course will equip you with the knowledge needed to confidently take control of your organisation’s cash flow and credit situation. This course will use case studies and practical examples throughout.

WHo should attend?

COntent

This course is perfect for those with little or no Credit Control

• Importance of Managing Cash Flow Case Study

experience who need a comprehensive introduction or are

• Outline of Risk Assessment, Contracts, Terms & Conditions,

entering a new Credit Control role. Those needing to refine their understanding of Credit Control procedures would also benefit from this course. Past attendees have included small business owners, financial assistants and credit controllers.

what’s next • Managing Budgets

Systems, Follow Up Procedures and Legal Action • Risk Assessment – Balance Sheet Case Study • Contracts – Terms and Conditions • Systems • Follow Up Procedures Exercises • Legal Enforcement • Prepayments and Accruals

• Finance for Non Financial Managers • Bookkeeping Certificate L1 / L2

Book Now 029 2044 0010 training@ecomlearning.co.uk

Ecom Learning Solutions Ltd - Unit 4 Regents Court, Nettlefold Road, Ocean Park, Cardiff CF24 5JQ

Ecom Course Outlines - 2011 Onwards

SaGe 50 aCCOuntS 2010 - LeveL 1 Duration: 1 Day Venue: Cardiff Book Today learN how To uSe SaGe’S world reNowN packaGe

the COurSe

Our Sage Line 50 course is designed to help you work comfortably and efficiently with the system by providing a comprehensive study of the features, functions and uses of this world renown system. You will look at common day to day procedures such as producing invoices and sales order processing with emphasis placed on practical uses of the accounting system to ensure that participants maximise workloads and are in control of the system. whO ShOuLD attenD?

COntent

The course is aimed at both system operators and managers.

•

Nominal accounts

•

Bank transactions

Typically people have attended several weeks after purchasing

•

Customer accounts

•

Invoices

the software.

•

Create supplier accounts

•

Customer receipts

•

Opening balances

•

Supplier payments

•

Password security

•

Error correction

•

Journals

what’S next

OptiOnaL Sage CertiFiCatiOn

• Sage Accounts Level 1 Certification

Certification provides:

• Sage 50 Accounts Level 2

•

Proof that you are a competent Sage user

•

Credibility for potential employers

•

Career advancement

•

Increased earning potential

•

Competitive advantage – it sets you apart in the job market

•

Book Now

Identify individual skills

029 2044 0010 training@ecomlearning.co.uk

Tel: 029 2044 0010 Email: training@ecomlearning.co.uk Fax: 029 2044 0019

53

54

Ecom Course Outlines - 2011 Onwards

SaGe 50 aCCOuntS 2010 - LeveL 2 Duration: 1 Day Venue: Cardiff Book Today eNhaNce your SkillS uSiNG SaGe 50 accouNTS

the COurSe

Our Sage Line 50 course is designed to help you work comfortably and efficiently with the system by providing a comprehensive study of the features, functions and uses of this world renown system. You will look at common day to day procedures such as producing invoices and sales order processing with emphasis placed on practical uses of the accounting system to ensure that participants maximise workloads and are in control of the system.

whO ShOuLD attenD? The course is aimed at both system operators and managers.

Typically those who have some experience and understanding of accounts either from the workplace or via training.

COntent • • • • • •

what’S next • Sage Accounts Level 2 Certification • Sage 50 Accounts Level 3

Book Now

Bank Reconciliation Search Credit Control Customer statements and overdue letters Dispute invoices Write Offs and VAT Element

• • • • • •

Recurring Entries Fixed Asset Register Prepayments and Accruals Multiple Chart of Accounts Management Reporting Statutory Reporting

OptiOnaL Sage CertiFiCatiOn Certification provides: •

Proof that you are a competent Sage user

•

Credibility for potential employers

•

Career advancement

•

Increased earning potential

•

Competitive advantage – it sets you apart in the job market

•

Identify individual skills

029 2044 0010 training@ecomlearning.co.uk

Ecom Learning Solutions Ltd - Unit 4 Regents Court, Nettlefold Road, Ocean Park, Cardiff CF24 5JQ

Ecom Course Outlines - 2011 Onwards

SaGe 50 aCCOuntS 2010 - LeveL 3 Duration: 1 Day Venue: Cardiff Book Today BecoMe a SaGe Super uSer

the COurSe

Our Sage Line 50 course is designed to help you work comfortably and efficiently with the system by providing a comprehensive study of the features, functions and uses of this world renown system. You will look at common day to day procedures such as producing invoices and sales order processing with emphasis placed on practical uses of the accounting system to ensure that participants maximise workloads and are in control of the system. whO ShOuLD attenD?

COntent

The course is aimed at both system operators and managers interested in learning about the advanced features of Sage Accounts. Candidates will have experience using Sage Accounts either from the workplace or via training.

• • • • • • •

what’S next

Stock Products Opening Balances Sales & Purchase Order Processing Stock Taking Period End for Stock Delivery Address

• • • • • •

Bill of Materials Discounting Product Invoices and Credits Quotations Recurring Entries Foreign Currency

OptiOnaL Sage CertiFiCatiOn Certification provides: • Proof that you are a competent Sage user • Credibility for potential employers • Career advancement • Increased earning potential • Competitive advantage – it sets you apart in the job market • Identify individual skills

• Sage Accounts Level 3 Certification • Sage 50 Payroll

Book Now 029 2044 0010 training@ecomlearning.co.uk

Tel: 029 2044 0010 Email: training@ecomlearning.co.uk Fax: 029 2044 0019

55

56

Ecom Course Outlines - 2011 Onwards

SaGe 50 payrOLL - LeveL 1 Duration: 1 Day Venue: Cardiff Book Today Save TiMe, learN To auToMaTe your payroll

the COurSe

Our Sage 50 Payroll Level 1 course is designed to help you Get to grips with the basic principles of Sage 50 Payroll. From navigation through to creating and amending the company and employee records, to getting started with pay elements and YTD figures and controlling user access.

whO ShOuLD attenD? As Sage Payroll is an accounting programme this course is aimed at

COntent •

Accounting or Human Resource personnel responsible for payroll activities. This course is suitable for those with little or no knowledge of Sage Payroll.

• • • •

what’S next • Sage Payroll Level 1 Certification

•

Navigating around Sage 50 Payroll Access rights Setting up legislation and company details Setting up pay elements Setting up employee records, personnel records and global changes Entering year to date values

• Sage 50 Payroll Level 2

• • • • • • •

Manual payroll processing Standard payroll processing Reset payments and timesheet entry New starters, leavers Backup, rollback and restore Pay reviews and variance settings Advance holiday pay, holidays and absences

OptiOnaL Sage CertiFiCatiOn

Book Now 029 2044 0010 training@ecomlearning.co.uk

Certification provides: • Proof that you are a competent Sage user • Credibility for potential employers • Career advancement • Increased earning potential • Competitive advantage – it sets you apart in the job market • Identify individual skills

Ecom Learning Solutions Ltd - Unit 4 Regents Court, Nettlefold Road, Ocean Park, Cardiff CF24 5JQ

Ecom Course Outlines - 2011 Onwards

SaGe 50 payrOLL - LeveL 2 Duration: 1 Day Venue: Cardiff Book Today eNhaNce your SkillS uSiNG SaGe payroll

the COurSe

Our Sage 50 Payroll Level 2 course deals with handling the day-to-day operation of Sage 50 Payroll, including payslip production, processing statutory payments and adhering to HMRC legislation. whO ShOuLD attenD?

COntent

As Sage Payroll is an accounting programme this course is aimed at Accounting or Human Resource personnel responsible for payroll activities. This course is most suited to those who have experience with Sage Payroll.

what’S next

• • • • • • • • • • • • •

• Sage Payroll Level 2 Certification • Sage 50 Accounts

Nominal link to Sage 50 Accounts Exporting data to files Importing data into Sage 50 Payroll Microsoft integration and Sage 50 Payroll task reminders Attachment of earnings orders Student loans SSP, SMP, SAP and SPP The payroll tax month end process BACS payments via e-banking in Sage 50 Payroll Processing over the tax year end and working with historical data The payroll tax year end The audit trail and HMRC inspection reports E-submissions

OptiOnaL Sage CertiFiCatiOn Certification provides: • Proof that you are a competent Sage user • Credibility for potential employers • Career advancement • Increased earning potential • Competitive advantage – it sets you apart in the job market • Identify individual skills

Book Now 029 2044 0010 training@ecomlearning.co.uk

Tel: 029 2044 0010 Email: training@ecomlearning.co.uk Fax: 029 2044 0019

57

58

Ecom Course Outlines - 2011 Onwards

Introduction to Bookkeeping Certificate Duration: 3 Days

Venue: Cardiff

Book Today Take your Skills Further with an LCCI Qualification

The COurse

Our aim is to broaden your knowledge and understanding of general financial concepts and documentation. This course will introduce you to some of the technical language and basic principals of bookkeeping such as preparing and recording invoices, credit notes and other source documents.

WHo should attend?

This qualification is suitable for candidates who may wish to gain some relevant basic book-keeping knowledge and skills before progressing to another financial qualification.

what’s next • Credit Control • Bookkeeping certificate Level 1

COntent Syllabus Topics: • Introduction to Book-keeping • Trade documents • Recording sales and purchases transactions • Banking documents • Calculating wages Course Programme: Day 1 – Book-keeping Course Day 2 – Wages Day 3 – Revision + Online Test

• Sage 50 Accounts / Certification Assessment: Assessment is in the form of a test, which is a 1-hour examination with 20 questions, some of which will have multiple parts. Candidates are expected to answer all of the questions.

Book Now 029 2044 0010 training@ecomlearning.co.uk

Ecom Learning Solutions Ltd - Unit 4 Regents Court, Nettlefold Road, Ocean Park, Cardiff CF24 5JQ

Ecom Course Outlines - 2011 Onwards

59

Bookkeeping Certificate - Level 1 Duration: 5 Day Venue: Cardiff Book Today Develop your Career in Finance The COurse

This course will give you an understanding of the basic principals underlying the recording of business transactions enabling you to maintain the books of, and prepare final accounts for Sole Traders.

WHo should attend?

This qualification is suitable for candidates who work or wish to work in areas of business that will involve the recording of financial transactions. It builds on and extends the knowledge and skills developed at the introductory level and is a good progression route.

what’s next • Credit Control • Bookkeeping certificate Level 2 • Sage 50 Accounts / Certification

COURSE PROGRAMME Day 1 - Book-keeping

Day 4 - Bank reconciliation (½ Day)

Day 2 - Book-keeping

Day 5 - Revision + Examination

Day 3 - Control Accounts

Our Awarding Body EDI is an accredited Awarding Body and leading international education company with a wide range of products and services including vocational and professional qualifications both within the UK and internationally through LCCI, Goal online assessments for schools, approved training programmes for employers, an electronic assessment delivery system, electronic portfolio package and specialist business broadband service.

COntent Syllabus Topics: • The Accounting Equation and the basis of double entry book-keeping • Recording transactions through double entry • Balancing accounts • Purchases / sales / returns • The ledger: its subdivision • Day books • Bank facilities/methods of payment or receipt • Cash book and cash discount • Bank reconciliation • Petty cash book and the imprest system • Trial balance • Adjusting for accruals and prepayments in final accounts • Depreciation of fixed assets • The entries relating to bad debts • The journal • Capital and revenue expenditure • Errors in the accounts and their correction • Effect of profit (or loss) and drawings upon capital • Trading and profit and loss accounts • The balance sheet • Control accounts – an introduction Assessment: Candidates are assessed by a 2.5 hour paperbased examination.

The examination paper consists of four questions, with at least two questions on key topics as detailed in the syllabus.

Candidates must do all four questions. The answers required will be predominantly of a quantitative nature but candidates will be expected to demonstrate their understanding of the subject at an appropriate level.

Ecom Learning Solutions Ltd - Unit 4 RegentsTel: Court, 029 2044 Nettlefold 0010 Road, Email:Ocean training@ecomlearning.co.uk Park, Cardiff CF24 5JQ Fax: 029 2044 0019

60

Ecom Course Outlines - 2011 Onwards

Bookkeeping Certificate - Level 2 Duration: 5 Day

Venue: Cardiff

Book Today Develop your Career in Finance

The COurse

This course will enable you to prepare and interpret accounts for Sole Traders, Partnerships, Non-trading Organisations and Limited Companies.

WHo should attend?

what’s next

As a progression route from Level 1 Bookkeeping, this

• Credit Control

qualification builds on the knowledge and skills developed at

• Sage 50 Accounts / Certification

that level.

• Sage 50 Payroll / Certification

The qualification is targeted at candidates who are working, or preparing to work, in an accounting environment where they will be expected to maintain financial records and prepare accounts with some level of autonomy. Successful candidates at this level can progress to the LCCI Level 3 Accounting /Accounting (IAS) qualifications.

Book Now 029 2044 0010 training@ecomlearning.co.uk

Ecom Learning Solutions Ltd - Unit 4 Regents Court, Nettlefold Road, Ocean Park, Cardiff CF24 5JQ

Ecom Course Outlines - 2011 Onwards

COURSE PROGRAMME

COntent

Day 1 - Book-keeping

Syllabus Topics: • Advanced aspects of the syllabus for Level 1 Bookkeeping • Partnerships • Limited liability companies • Incomplete records • Manufacturing accounts • Stock valuation • Non-trading organisations • Control accounts • Suspense accounts • Calculation and interpretation of ratios • Preparation, by the use of ratios, of simple financial statements

Day 2 - Book-keeping Day 3 - Control Accounts Day 4 - Bank reconciliation (½ Day) Day 5 - Revision + Examination

Our Awarding Body EDI is an accredited Awarding Body and leading international education company with a wide range of products and services including vocational and professional qualifications both within the UK and internationally through LCCI, Goal online assessments for schools, approved training programmes for employers, an electronic assessment delivery system, electronic portfolio package and specialist business broadband service.

Assessment: Candidates are assessed by a 3 hour paperbased examination, consisting of five questions from which the candidate will need to answer any four; there are no compulsory questions. At least two questions will come from key topics as detailed in the syllabus.

The answers required will be predominantly of a quantitative nature, but candidates will be expected to demonstrate their knowledge and understanding of the syllabus topics at the appropriate level as well as their ability to analyse and interpret data.

Tel: 029 2044 0010 Email: training@ecomlearning.co.uk Fax: 029 2044 0019

61

cuSToMiSed COurSeS Ecom provide a customised course service allowing you to tell us what you want to focus on.

you chooSe! urses give o c d e is m o t ose: Ecom’s cus o h c o t y it n u ort you the opp

t

n e t n o c e s r u o c Your Your location

u o y s t i u s t a h At a time t

caSe STudieS Below are some examples of how Ecom have tailored courses in the past

customer care course for an NHS Doctors Surgery international finance course for Oil Company in Kuwait

“ENJOYED THE COURSE, FOUND THE LEARNING ENVIRONMENT FRIENDLY AND THE TUITION PROFESSIONAL AND MANAGED TO GET A DISTINCTION IN THE BOOKKEEPING EXAM” PAFILIA DEVELOPMENTS, CYPRUS

64

Ecom Course Outlines - 2011 Onwards

COntaCt uS Email: training@ecomlearning.co.uk Tel: 029 2044 0010 Fax :029 2044 0019 Or visit www.ecomlearning.co.uk

GY gi] Cd

aZkVgY YZ CVciZh 7dj

6)&+&

8VgY^[[ FjZZch HigZZi GV^a

Ea VcY ;^ioa

GY dgi le Z C

6),%

6),%

kZ \Z 6 Zdg Y < Aadn

EZ cV gi] GY

Vn Vc L DXZ

6)&+%

aa Hi cYV : In

A^c` igVa 8Zc

8VgY^[[ 8ZcigVa GV^a

aa Hi cYV : In

Z Hi 7ji

Hi gnh BV Hi

Hi dY Ld

Y ^h G AZl

GY hdg cY L^

I]Z BV\^X GdjcYVWdji

Vn Vc L DXZ

GY dgY iZa[ i Z C

6),%

eCOM Learning SOLutiOnS LtD Unit 4 Regents Courts, Nettlefold Road, Cardiff, CF24 5JQ

CaLL uS nOw 029 2044 0010 to arrange a free no obligation consultation. We will asses which of our services will best suit your business. You will have the opportunity to establish whether we are the appropriate partner to help you take control of your accounts.

business solutions

testing centre

Ecom Learning Solutions Ltd - Unit 4 Regents Court, Nettlefold Road, Ocean Park, Cardiff CF24 5JQ