Microsoft Excel - A Practical Guide to using Excel Functions to Build Small Business

This course 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 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 date and will be able to selectively protect their application at the workbooks, 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.