Home / Course

COURSE

BCS Advanced Excel module

Industry Certified • Level 3

BCS Advanced Excel module

Industry Certified • Level 3

Type of LearningTraining

Course CodeA2275

Awarded ByBCS, the Chartered Institute for IT

Location ByBurnley College

Have a question? Get in touch!

Or call us on 01282 733373

About the course

The course covers Excel at level 3 and includes: advanced formatting: conditional formatting and custom numbers and layouts; advanced formulas - date and time, mathematical, text, financial, lookups, database,nested ifs and statistical formula; advanced charting - combo charts with secondary axes, chart enhancement including using images, changing scales and chart elements; analysis of data through tables, pivot tables, sort, filter, advanced filter, scenarios and subtotals; validating and auditing data; using paste special and naming cells; linking, embedding and importing data: adding security to files with protection using passwords

Type of LearningTraining

Course CodeA2275

CostQuestion tooltip iconRead More

Awarded ByBCS, the Chartered Institute for IT

Location ByBurnley College

Entry requirements

To have completed the level 2 ITQ course or be using Word, Excel, PowerPoint and Access in a workplace setting up to level 2

Assessment

Exams are 45 mins long and a pass mark of 75% is required.

Careers & Progression

You could progress onto the otherindividual advanced ECDL units including PowerPoint, Word and Access or undertake the full level 3 ITQ Certificate

Have a question? Get in touch!

Or call us on 01282 733373