What's it all about?

Any proficient Microsoft Excel user will agree that MS Excel is a very powerful analytical tool. Wouldn't it be great to learn how to effectively use all the advanced Excel features at your disposal? In this practical and information-packed course, you'll see how to maximise Excel's functions and capabilities.

Most organisations rely heavily on Microsoft Excel to consolidate, analyse, and report financial information. Your company is probably no exception. By learning these advanced techniques, you can become more valuable to your organisation. Your ability to generate information with increased accuracy, timeliness, and usefulness will lead you and others to better decision-making.

Over the next six weeks, you'll see how to use the additional analytical tools provided by Excel add-ins. You'll become skilled in the use of validation to protect the integrity of your worksheets from other, less experienced users. You'll impress your coworkers by learning how to add functional and eye-catching controls to any worksheet and how to use scenarios and data tables to quickly perform multiple what-if analyses. You'll discover advanced techniques for PivotTables, such as creating calculated fields and calculated items. You'll become adept at consolidating and importing data from other sources, and you'll master the art of conditional formatting to highlight duplicate entries and other common worksheet problems. Learn how Excel 2007 table tools take the complexity out of table creation and management. As you become proficient at nesting functions within other functions, you'll be able to accomplish just about anything Microsoft Excel has to offer!

Courses are delivered to you through expertly executed lessons, online instruction and interaction with like-minded students. Our courses are designed to deliver all of the benefits of studying in a classroom whilst giving you the flexibility to study at a time and place to suit your needs. You can access your classroom 24/7 from any device with an internet connection.

New sessions of each course start monthly and last for six weeks. You’ll gain access to two lessons a week (for a total of 12 lessons) helping you pace your learning. There are no set times for you to study, you can log in and out within the 8 week access period at any time and complete the course at your own pace. Your expert tutor will guide and facilitate your course, answering any questions you have and providing guidance and feedback. You’ll complete comprehensive lessons, quizzes and assignments before submitting your final exam at the end of the course to achieve your certificate.

Session start dates are listed below. Has the start date already passed? Don’t worry, you can join a class up to 2 weeks after the start date!