1-Day Instructor-led classroom based training.
Excel 2016 Intermediate can be delivered as a scheduled open course, a company private closed course or as a one to one consultancy. We can run this course either at our training centre in Aberdeen, your premises or using our portable training school. Download full course profile below.
The skills and knowledge acquired in Microsoft Excel 2016 – Intermediate enables users to expand their knowledge and learn how to create more productive workbooks. It covers formulas and function techniques, advanced formatting and charting features and data manipulation tools like goal seeking.
At the completion of this course you should be able to:
Microsoft Excel 2016 Intermediate assumes the learner has the knowledge required to create, edit, print and chart simple worksheets. Understanding ranges and copying is also important.
Open Course: £210 per delegate per day (excl. VAT).
For alternative options and pricing please visit: http://www.solab.co.uk/training/pricing/
Our office is situated on the first floor of Bridge House, at 56-58 Bridge Street in Aberdeen. Parking is available at the multi-storey pay and display car park next to the nearby British Telecom building. From the car park, walk up College Street onto Bridge Street; Bridge House is located at the bottom of Bridge Street before the steps up to Crown Terrace. Solab’s office can be reached by taking either the lift or stairs to the first floor. Check location on Google Maps >>
Module 1: Working with Date Function
Module 2: Counting and Summing based on Criteria
Module 3: Defined Names
Module 4: Vlookup
Module 5: Flash Fill
Module 6: Freezing Rows and Columns
Module 7: Conditional Formatting
Module 8: Sorting and Filtering
Module 9: Protection
Module 10: Charts
Module 11: Chart Elements and Formatting
Module 12: Quick Analysis