Training Course:ECDL advanced - ExcelSchool/Trainer:City Lit
London, United Kingdom
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Course Description:
'' Develop skills in advanced features of spreadsheets (logical and database) including: data consolidation, filtering, pivot tables, subtotals, scenarios, advanced chart filters, macros, linking with other workbooks and applications.You do not need to have attained the ECDL certificate to attend, but you will be expected to have sound knowledge (level 1) of the subject. This certificate is a valuable credential, recognised worldwide. Course fees include a non-refundable exam fee of £35.
What is the course about?
ECDL is a Europe-wide qualification with which you can prove your competence in a range of computing skills to employers. This course is a follow up from the ECDL certificate course and will cover the more advanced features of Excel.
--------------------------------------------------------------------------------
What level is the course?
All students are expected to have a passed the ECDL certificate course or have relevant experience of Excel.
--------------------------------------------------------------------------------
What will the course cover? (contents,themes,projects)
The following list is not exhaustive, but will give you an idea about the course topics and level.
Advanced functions such as financial functions, mathematical functions, logical functions, text functions, reference functions, database functions and nested functions.
Advanced formatting such as conditional formatting and paste special.
Named Scenarios and What If concept.
Linking spreadsheets and other applications.
Advanced sorting such as custom sort and filtering such as advanced filter.
Pivot tables and data analysis.
Advanced charts features.
Data tables such as one input and two input.
Macros and automating frequently used tasks.
Auditing and error messages.
Advanced formulae
Advanced formatting
Scenarios
Linking
Advanced sorting
Pivot tables
Functions
Advanced charts
Data tables
Macros
Auditing
--------------------------------------------------------------------------------
What can I expect to achieve?
By the end of this course you should be able to:
Use advanced functions in Excel
Apply condition formatting
Create pivot tables
Use advanced sort and filter
Create and use macros
On successful completion of Module exam you will be awarded with BCS ECDL Advanced Spreadsheet certificate.
...''
Please go to the school's official website for training price and schedule:
http://www.citylit.ac.uk
Phone:020 7831 7831
School Address:
City Lit, Keeley Street, London WC2B 4BA
Jobs & Resumes: London
Houses & Roommates: London
Other training courses offered by City Lit:
Stand-up comedy workshop
Theatre workshop
Drama foundation
Actors workshop
Access advanced
Access database project with Visual Basic
web design (HTML) and hosting
Apple Works OSX
Illustrator CS
ECDL advanced - Access
ECDL advanced - Word
ECDL certificate
QuarkXPress
Powerpoint
Microsoft Outlook
Networking
PC maintenance
FrontPage
Dreamweaver and Fireworks
Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
Tips:
Want to find a place to stay close to the school? Or homestay in a different country? Try the house rental message board where you can search for roommates and post shared rooms or apartments for rent. |
|
|
