In this introductory course to Excel, participants will explore Excel activities that go beyond the basic. After successful completion of this session, participants can expect to have the skills required to work efficiently in an existing worksheet and to also create new worksheets from a template and from scratch.
What you will learn
The course is aimed at fairly experienced Excel users whom need to learn more complex functions, nesting, data manipulation and protect data using the security features. You will gain an insight into data tables and using excel advanced look up features to automate worksheets and analysis tools to forecast figures based on a range of scenarios and use consolidation to bring together information. Find out how you can utilise advanced ‘If’ statements.