ECDL advanced level 3 at your own pace: Excel

Course Dates: 22/05/19 - 24/07/19
Time: 18:00 - 21:15
Location: KS - Keeley Street

Do you want to know that you can work to an outstanding level in any work environment requiring an expertise in Excel? Do you want a qualification to prove these skills? This course will enable you to prepare for the Spreadsheet software unit within the Level 3 ECDL Award in and take the exam when you are ready. You can achieve all the units you need for the Award by taking our other courses in Word Processing and Presentation software. However, you may decide you just want to develop Level 3 spreadsheet skills without taking the exam or wait a while. Tat’s fine too! Whether you do the exam or not, by the end of the course you will have exceptional proficiency in using spreadsheets and have a high level of skill and practical experience in creating and maintaining complex spreadsheets, manipulating charts, creating and using scenarios, developing templates, linking cells, worksheets and workbooks, as well as using complicated functions of various types, and using data tables and databases in MS Excel 2016.

Description

What is the course about?

In this course you will learn the advanced skills needed in order to:-
• produce sophisticated reports;
• perform complex mathematical and statistical calculations;
• improve productivity using MS Excel; and
• pass the ECDL Advanced Spreadsheet Software Unit Test and gain 6 credits @ Level 3.

What will we cover?

What will we cover?
• Formatting – conditional formatting, paste special, transposing data, copying and moving sheets.
• Protection – worksheet and cell protection. Hiding rows, columns, worksheets and workbooks.
• Cell Comments – create, edit, delete and display cell comments
• Naming cells and using them in formulas
• Templates – creating, using and editing.
• Formulas – mixed references, custom number formats
• Outlines – creating and working with an outline
• Scenarios – creating, editing, deleting and scenario summary reports
• Linking and embedding data
• Importing delimited data
• Sorting – multiple column sorts
• Lists – advanced filtering, adding subtotals
• Pivot tables – creating, filtering, grouping and sorting
• Functions – date and time, lookups, mathematical, statistical, text, financial, database and nested
• Charts – formatting, modifying such as adding a secondary axis
• Data tables – one input and two input data tables
• Macros – recording and running
• Auditing – tracing precedents, dependents, errors and data validation
• Tracking changes – sharing and merging workbooks.

What will I achieve?
By the end of this course you should be able to...

By the end of the course you should be able to:-
• Apply advanced formatting options such as conditional formatting and customised number formatting and manage worksheets.
• Use functions such as those associated with logical, statistical, financial and mathematical operations.
• Create charts and apply advanced chart formatting.
• Work with tables and lists to analyse, filter and sort data.
• Create and use scenarios.
• Validate and audit spreadsheet data.
• Enhance productivity by working with named cell ranges and macros.
• Use linking, embedding and importing features to integrate data.
• Compare and merge spreadsheets.
• Apply spreadsheet security features.

What level is the course and do I need any particular skills?

You should be able to do the following in Excel:-
• Work with spreadsheets and save them in different file formats.
• Enter data into cells and use good practice in creating lists.
• Format numbers and text content in a spreadsheet and use available auto format/table styles.
• Select, copy, move and delete data.
• Sort data.
• Edit rows and columns in a worksheet.
• Copy, move, delete and appropriately rename worksheets.
• Create mathematical and logical formulas using standard spreadsheet functions.
• Use good practice in formula creation and recognize error values in formulas.
• Choose suitable charts, and create and format charts to communicate information meaningfully.
• Use available help resources, shortcuts and the go to tool to enhance productivity.

When I've finished, what course can I do next?



General information and advice on courses at City Lit is available from the Student Centre and Library on Monday to Friday from 12:00 – 19:00.
See the course guide for term dates and further details

Reviews

Check your level

Course Code: CEA2A

Wed, eve, 22 May - 24 Jul '19

Duration: 10 sessions (over 10 weeks)

Full fee: £289.00
Senior fee: £231.00
Concession: £145.00

Before booking on this course, we'll need you to log in or register with us if you're new. Please then contact us for a chat with our team to check that this course is the right level for you.
Why do I need an advice session?

Any questions? skills@citylit.ac.uk
or call 020 7492 2511

Please note: we offer a wide variety of financial support to make courses affordable. For more information visit our online Help Center. You can also visit the Information, Advice and Guidance drop-in service, open from 12 – 6.45, Monday to Friday.