![]() Limit data entry and build complex models with Lookup functions.Build complex calculations with advanced functions.Course Outline Functions and Formulasīook your place today: Daria Choromanska – – 0 ADVANCEDĬourse Description: This course exposes several advanced features of Excel for What-if analysis, database analysis and how to build calculations using advanced functions as well as how to automate processes. ![]() Utilise Conditional Formatting to change cell appearanceĬourse prerequisites: Participants will need to have attended or be familiar with the topics covered in the Microsoft Excel Introduction course.Organise a database list by advanced filtering and subtotalling.Understand and utilise Absolute Referencing.Understand and use a range of common worksheet functions.Course Outline Overviewīook your place today: Daria Choromanska – – 0Ĭourse Description:This course has been developed for people wanting to utilise Excel to perform calculations using a variety of common worksheet functions, filter, sort and summarise database lists, format and modify charts, and conditionally format cells. Calculate and manage multiple worksheetsĬourse prerequisites: Participants will need to be familiar with Microsoft Windows and basic Windows techniques such as opening, closing and saving files. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |