What's it all about?

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

Most organizations rely heavily on Excel to consolidate, analyze, and report financial information. Your company is probably no exception. By learning these advanced techniques, you can become more valuable to your organization.

You'll see how to work with the additional analytical tools provided by Excel add-ins and become skilled in using validation to protect the integrity of your worksheets from less experienced users. Impress your coworkers by learning how to add functional and eye-catching custom controls to any worksheet and how to use scenarios and data tables to quickly perform what-if data analyses. You'll discover advanced techniques for PivotTables, such as creating calculated fields and calculated items. Become adept at consolidating and importing external data, and master the art of conditional formatting to highlight duplicate entries and other common worksheet problems.

Learn how Excel 2010 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!