Microsoft Excel - How to Build Business Applications

Course details

This course will transform your ability to use Microsoft Excel as a business tool - not just as a great piece of software! It is aimed at students who have a basic knowledge of Microsoft Excel and who want to learn more advanced techniques in order to become expert in the key skills for using Excel as a business application. The course builds your skills in the use of key Excel formulas in a step-by-step manner, with practical exercises and solutions provided at each stage. On completion students will be expert in the use of IF, AND, OR to build complex business rules, will be able to Validate their data and will be able to selectively protect their application at the workbook, worksheet and cell level. They will have developed a small business application which will illustrate how to use these formulas in a practical and useful manner.