In previous Excel courses, you would have learnt to write formulas and functions to perform calculations using a variety of techniques. This course takes function writing to the next level and teaches you many more functions within Microsoft Excel. It introduces you to additional keyboard commands, shortcuts and features related to writing functions. This course is suitable for users of Microsoft Excel 2007, 2010, 2013 and 2016.
This course is designed for people who want to get the most out of their data by learning various analysis functions. Whether you are an account manager, an IT worker or someone who needs to regularly manipulate Microsoft Excel worksheet data, this course will show many functions and their capabilities
To ensure your success, we recommend the following courses have been undertaken, or equivalent knowledge gained:
Please Note: If you attend a course and do not meet the prerequisites you may be asked to leave.
Dual monitor setup is required for when attending this course via the QA Attend from Anywhere delivery method.
At the end of this course you will be able to:
Module 1 - Introduction and Welcome
Module 2 - Function Writing Review
Module 3 - The IF Functions
Module 4 - Nested Functions
Module 5 - Array Functions
Module 6 - Lookup and Reference Functions
Module 7 - The Aggregate Function
Module 8 - Date and Time Functions
Module 9 - Working with Text Functions
Sınıf eğitimlerimizi İstanbul, Ankara ve Londra ofislerimizde düzenlemekteyiz. Kurumunuza özel eğitimleri ise, dilediğiniz tarih ve lokasyonda organize edebiliriz.