Building on your existing knowledge of Excel, this course includes formulas that link worksheets together and linking workbooks, getting Excel to make decisions using the IF function and adding conditional formatting to highlight certain data. You will learn how to create templates for commonly used worksheets and protect data using the security features. You will gain an insight into data tables and use Excel lookup features to automate worksheets. This course will also enable you to create, build and customise graphs including plotting trend lines. You will learn how to use the new sparklines features and data bar enhancements.
This course is suitable for those who have attended the introductory course or have sufficient knowledge and understanding of the basics of Excel.