Saturday IT: Improve your Excel Skills

UPDATED 20161220 10:21:12

Functions and Formulas, and pivot tables, pivot charts and V lookups.Perform calculations in Excel using functions and formulae. Get to grips with the most commonly used functions in Excel as well as creating your own basic formulae. You will learn how to use built-in functions to perform calculations along with designing your own formulae to analyse data more effectively. There will be real life examples of the functions and an opportunity to practise using them in class.You will also learn how to summarise large amounts of Excel data effectively using Pivot Tables and use that data to create charts, as well as using Excel's VLookUp function data to insert data from one table into another.This short course includes an introduction to Pivot Tables and Pivot Charts along with the VLookUp function. Pivot tables are an invaluable tool to analyse large amounts of data and can provide an excellent snapshot of that data. The VLookUp function looks for a value in the left-hand column of a table and then returns a value in the same row from another column that you specify, into a separate table of data. This is a practical course in an IT suite which will provide you with basic skills in Excel. You will learn how to:Use common Excel functions including SUM, AVERAGE, MIN, MAX and COUNTCreate formulae to subtract, multiply and divide in combinations of your own choosingUse relative and absolute cell references, Also Create and format Pivot TablesManipulate data and add calculated fieldsSort and filter dataCreate and format Pivot ChartsUse the VLookUp function to populate data NA one day course No

Course information

Name: Saturday IT: Improve your Excel Skills Qualification title: Non regulated Community Learning provision, Other ICT Skills Qualification type: Other regulated/accredited qualification Assessment Informal, ongoing observation of your progress by the tutor. Awarding Generic award - no awarding body Created 20161220 10:21:12 Updated 20161220 10:21:12

Entry requirements

None

Provider

Bromley Adult Education College
enquiries@baec.ac.uk
n/a

Address

Kentwood Centre
Kingsdale Road Town: Penge County:London