Train & Grow programmes provide training solutions that help business improve performance and competitiveness in the global market. Because organisational pressures often make it difficult to be away from the workplace our bite-size training workshops are designed to provide short, intensive yet practical sessions that require you to only be away from your business or job role for a short period of time.If you use Excel to manage and manipulate data such as customer lists and output to primarily text based reports or mailshots this workshop will be of benefit. Learn how to import data from Word, clean up formatting and use conditional tests (IF statements) to meet the needs of customers.This course takes the Learner beyond simple formulas towards successfully managing the input, manipulation and output of text (as opposed to figures).At the end of the course you will be able to:Use Data Validation to ensure accurate and consistent entry of data.Nest IF statements to allow for multiple conditional tests.Use OR in conditional tests.Use AND in conditional tests.Import text from WORD and use formulas to clean up the formatting.Manipulate date fields.Prepare data for mail merge.You will be training on Microsoft Office 2010. Those responsible for managing text within Excel (e.g. database of clients, records management etc.). Attendance of Introduction to Formulas and/or a very good working knowledge of simple Excel formulas.This workshop is also perfect for new business owners or people considering starting their own business. Subsequently you may be interested in the following courses:Managing FiguresExcel: Presenting DataOther courses may be offered by Skills & Learning or other local providers.
Name: Excel - Managing Text - Intermediate Qualification title: Non regulated Community Learning provision, ICT Practitioners Qualification type: Assessment There are no qualifications or examinations attached to this course. Awarding Generic award - no awarding body Created 20160708 15:27:30 Updated 20160708 15:27:30
None
Skills&Learning; Bournemouth, Dorset and Poole
Academy 16-19 Converter
infopal@poole.gov.uk
01202 262300
http://www.skillsandlearningbdp.co.uk
Oakdale Centre
Wimborne Road
Town:
Poole
County:Dorset
Title: Non regulated Community Learning provision, ICT Practitioners Qualification: Non regulated Community Learning provision, ICT Practitioners Classification: Information and Communication Technology