Fees: Standard £ 142 Conc £No conc. Full £142 * Enrol online for standard fee payers only
|Wednesday||09:30 - 17:00||1||MAC||03/04/2019||03/04/2019||TD2045|
This course covers areas of Excel to enable you to gain the skill sets necessary for calculating data using functions and formulas, sorting and filtering data, using PivotTables and Pivot Charts for analysing data, and customizing workbooks.
This intermediate course will build on your basic Excel skills and show you more complex formulae, linking data and using sort and filter techniques.
Before starting this course, students are recommended to have taken Excel 2010 Level 1 or have equivalent knowledge.
After the course you will be able to: - use templates to create consistency in your workbooks - use Logical and Lookup functions - use Names and Labels - use links for more efficient workbooks - apply filters and sort your data more quickly - create a simple Pivot Table and Pivot Chart
This is a 1 day course and the tutor will go through the features of Excel on screen. You will be given time to practice using the application through set exercises.
Continuous assessment by the tutor and a certificate of attendance.
Excel 2010 Level 3 Data Analysis
Paper and pen to take notes.
If you need support please speak to your tutor