image Full details Print Event Event List

EXCEL ADVANCED

This event is suitable for Ealing maintained schools and all other schools
Short URL https://schools.ealingcpd.org.uk/courses/bookings/c_detail.asp?cid=17858 
Event code SCH 21/252 
Event description
Excel Advanced  

Course objectives: To understand the advanced analysis tools in Excel; to calculate using logical functions; to create and use templates and record and run macros

Course duration One day virtual

Who is the course designed for? Regular Excel users who would like a better understanding of the analysis tools available and some

advanced functions

Required knowledge level Course attendees must be able to produce a calculated and formatted spreadsheet, and to use AutoFill and

AutoSum 
Training objectives To understand the adanced analysis tool in excel, using logical functions, to create and use templates and record and run macros

The following topics will be covered

Logical functions

· If, And, Or, Not functions

· Using conditional criteria

VLookup and HLookup functions

· Using the Lookup functions to find data

· Combining If with VLookup

Data Validation

· Controlling what data is input into a range of cells

· Creating drop-down lists

Group and Outline

· Displaying/hiding detail in a spreadsheet

Custom Views

· Creating different views of a spreadsheet

Pivot Tables and Charts

· Summarising data in reporting format

· Using Slicers and Timeline filters for filtering data

· Pivot Charts

Templates

· Creating worksheet templates

Macros

Short cuts for lengthy or repetitive tasks:

· Recording

· Storing

· Running from toolbar buttons and worksheet buttons

· Managing the macro list

What If features

Testing variables and results using:

· Goal Seek

· Data Tables

· Scenarios

· Solver 
Target Group More advanced users of Excel 
Key stages
EYFS image KS1 image KS2 image KS3 image KS4 image Post 16 image 
Subject areas Workforce reform and development
Target audience All school staff (teaching and non teaching)
OFSTED areas Personal development
Professional Standards
Venue via Microsoft Teams (online), ., . map
Admin contact Michelle Waters (watersm@ealing.gov.uk)
Event Commissioner Alison Bennett (abennett@ealing.gov.uk)
Tutor(s)/Facilitator(s)
Course Costs
Standard cost£125.00
SLAs
Workforce development SLA£95.00
Start date Thursday 4 February 2021
Times 09:30 - 16:30
Number of sessions 1