Excel 2016: advanced

Course Dates: 23/05/19 - 30/05/19
Time: 10:00 - 17:00
Location: KS - Keeley Street
Tutor: Abbott Katz

Learn advanced features: sorting, filtering, linking, formulae, pivot tables and macros to create and work with complex spreadsheets. This course follows on from 'Excel: essentials' or is suitable for students with equivalent knowledge and experience.

Description

What is the course about?

It builds on the Excel Beginners course and introduces the more advanced features of the application.

What will we cover?

Advanced sorting of data
Advanced filtering of data
More advanced linking of worksheets for calculations
More advanced formulas incorporating various functions
Using pivot tables
Recording macros
Using data tables
Scenarios
Auditing
Naming data ranges
VLOOKUP.

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 functions and 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 for beginners 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?

Each student has their own computer.
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?

No.

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

Further excel courses eg - Excel: expert, Excel: financial modelling, Introduction to VBA.

General information and advice on courses at Build 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

Customer Reviews 7 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.

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)

Book your place

Course Code: CEX17

Please choose a course date 

Thu, day, 23 May - 30 May '19

Duration: 2 sessions (over 2 weeks)

Full fee: £189.00
Senior fee: £151.00
Concession: £95.00

Note: Course starts today, check start time

Add to Basket

Or call to enrol: 222-66-889-99

Download form & post

Any questions? [email protected]
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 . You can also visit the Information, Advice and Guidance drop-in service, open from 12 – 6.45, Monday to Friday.

источник 3kovra.com.ua

www.dekorde.com/33-stoly