Practice Plus Learning Hub – EXCEL TRAINING 29th May

For all enquires please contact rebecca.mahood@easternfsu.co.uk

Out of stock

EXCEL Training for Practice Managers

Wednesday 29th May, 1.30pm-4.30pm, Eastern FSU Offices, 1 Bradford Court, Belfast, BT8 6RB

Target Audience: Practice Managers / Business Managers

Cost: 

This course will provide a comprehensive overview of how to use both basic and intermediate level of EXCEL in your workplace. The course is delivered by our in-house EXCEL expert Elly McGinn, Elly has been supporting staff with her knowledge on EXCEL for years. From elaborate dashboards on that will automatically update figures into graphs and colourful charts, to simply saving you time and making your life more convenient, we are sure you will benefit from Ellys knowledge on this basic and intermediate level course.

Course Aims & Objectives

EXCEL Basics

Using Fill Series (Months)

Copying & Pasting (Names, Paste Specials)

Inserting Column (Cost per point)

Inserting Rows (Using shortcut menu)

Formatting: cell type

Formatting: colour & borders (format painter)

Using Autofilter & Sorting

Viewing your window (Zoom, Freeze)

Basic Forumlas

Placing information in multiple cells simultaneoulsy

Resizing cells

Inserting a chart & Contextual Tabs

Printing your worksheet

Worksheets vs Workbook (adding/colour tabs)

Find & Replace

Hiding, Deleting rows and columns

Absolute References (F4)

Merging, centre across section, remove blanks (F5)

EXCEL INTERMEDIATE

Using Tables

Data Validation Lists

Conditional Formatting Rules

Pivot Tables

Functions – COUNTIF, COUNTA, VLOOKUP, TEXT

Viewing your window (Zoom, Freeze, Remove Gridlines)

Remove page break lines

Mail Merging

Highlighting Duplicate values

Splitting Cell Text (change forename surname to separate columns

Sparklines

Payment Method – Participants will be invoiced after booking their place. 

Costs charged for Practice Plus Learning Hub events are organised on a cost neutral basis to cover the costs of speakers time, venue / lunch, staff time, any surplus funding will be reinvested into training activities.

Cancellation Fee

We appreciate sometimes it may be necessary to cancel your place, please note cancellation fees below may apply.

2 weeks’ notice – 100% refundable, admin fee £20

3 working days’ notice – 50% refundable

Less than 3 working days – non-refundable