Excel 2016: advanced

Course Dates: 05/03/20 - 12/03/20
Time: 10:00 - 17:00
Location: KS - Keeley Street
Aurica Jalba

Learn advanced features of Excel 2016: linking, advanced sorting, filtering, formulae associated with logical, statistical, financial and mathematical operations, scenarios, data validation and audit spreadsheet, pivot tables and macros to create and work with complex spreadsheets. This course follows on from 'Excel: essentials' or Excel 2016 for the workplace, or it is suitable for students with equivalent knowledge and experience.


What is the course about?

It builds on the Excel Essential or Excel 2016 for the workplace course and introduces the more advanced features of the application.

What will we cover?

Advanced sorting of data
Advanced filtering of data
Conditional Formatting
More advanced linking of worksheets for calculations
More advanced formulas incorporating various functions (COUNTIF, SUMIF, VLOOKUP and HLOOKUP, DATE and TIME functions, PMT, PV, FV, DATABASE Functions).
Using pivot tables
Recording macros
Using data tables
Scenario Manger
Data Validation and Auditing Spreadsheets
Naming data ranges and using names in calculations.

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

Sort and filter data using specified criteria
Analyse data using pivot tables
Set up best/worst case scenarios
Produce calculations using formulas incorporating various functions (COUNTIF, SUMIF, VLOOKUP and HLOOKUP, DATE and TIME functions, Text, PMT, PV, FV, DATABASE Functions, and summerise values from different worksheets/workbooks
Automate tasks using macros
Work with large and more complicated worksheets with confidence.

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

This is an advanced course and you should have completed the Excel Essential or Excel 2016 for the workplace course, or have working knowledge or experience of using Excel.

You should also be able to follow spoken and written instructions and be comfortable carrying out mathematical calculations.

How will I be taught, and will there be any work outside the class?

Computers are provided for each student.
Presentations will be made using computers, whiteboard, overhead screen and printed notes.
Step by step instruction, with demonstrations where appropriate, will help you grasp the concepts.

Are there any other costs? Is there anything I need to bring?

Please bring a USB, notepad and pen. Course notes will be provided.

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

Further excel courses eg - Excel: expert, Excel: financial modelling, Introduction to VBA in Excel, Pivot Table a deeper Look, Excel: tables & charts, Data analytics with Power BI. Access 2016: Advanced. A beginner’s guide to SQL, Introduction to SQL and Microsoft SQL server. You might want to explore some programming languages like - Introduction to Python, introduction to C#, introduction to Java, Introduction to R programming.


Customer Reviews 10 item(s)

Write a review

Reviews below are by students who have attended this course, regardless of the course teacher. Please be aware you may not be booking onto a course with the same teacher.

This course was fantastic; well structured and delivered. The standard of teaching was excellent; engaging and informative. Materials and extra support enabled me to continue studying and learning outside of class. I can highly recommend this course!
Course Rating
Review by Anonymous / (Posted on 06/08/2019)
Rather intensive and feel that is best run over 5 sessions
Course Rating
Review by Anonymous / (Posted on 01/08/2019)
Really enjoyable course with lots of interaction. I came away with lots of tips, skills and very confident I will be able to apply what I have learned when doing excel at work.
Course Rating
Review by Anonymous / (Posted on 30/05/2019)
The best course provider with affordable and reasonable fee
Course Rating
Review by Daniel / (Posted on 16/04/2019)
Brilliant course
Course Rating
Review by Wahida / (Posted on 21/03/2019)
Go for it - great course, good tutor and excellent facilities
Course Rating
Review by CDR / (Posted on 06/03/2019)
Check that it is the right level for you. A couple of people struggled because it was too hard. At least one clearly found it boring because he knew everything already.
Course Rating
Review by Anonymous / (Posted on 17/02/2019)
This course will equip you with in depth knowledge of many features of Excel that will change the way you use this software. You will be able to complete tasks more efficiently, quickly and accurately safe in the knowledge that you have been taught how best to apply the most appropriate Excel's feature for your needs.
Course Rating
Review by Anonymous / (Posted on 06/12/2018)
Highly recommend
Course Rating
Review by Anonymous / (Posted on 25/11/2018)
Excellent course definitely develop your skill
Course Rating
Review by Anonymous / (Posted on 11/11/2018)
Tutor Biographies
We’re sorry. We don’t have a bio ready for the tutor of this class at the moment, but we’re working on it! Watch this space.

Book your place

Course Code: CEX28

Please choose a course date 

Thu, day, 05 Mar - 12 Mar '20

Duration: 2 sessions (over 2 weeks)

Full fee: £199.00
Senior fee: £159.00
Concession: £121.00

Or call to enrol: 020 7831 7831

Download form & post

Any questions? computing@citylit.ac.uk
or call 020 7492 2515

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.