Overview of Student Essential IT skills

These resources are created to provide you with information, in text and video formats, of the most common Microsoft Office (MS) 2010 Office applications, namely MS Word, Excel, and PowerPoint. The aim of these resource pages is to provide you with access to tutorials which help improve, both your efficiency and understanding of these applications when completing assignments. Therefore these pages are designed to give you an introduction into MS Office 2010, so you can become more proficient when using these applications.

On the right hand is a video from CELT Study that explains the structure of these MS Office 2010 tutorial pages, how to get the best from these resources and where to get any added help and information.

Essential ICT Skills - An overview


Common MS Office 2010 Interface Features

There are a number of interface elements that all the individual MS Office 2010 applications have in common. This screencast briefly explains what they are and where to find them. Below is a linked list of the topics covered in the screencast, these linked items will give you a deeper understanding on the topics. Where possible, these MS Office 2010 resources are screencast/video links.

New Features in MS Office 2010












There are several free (and paid subscription) online MS Office 2010 tutorial web resources, obviously some are better than others. Listed below are a few of the most comprehensive free online tutorials.

The website provides online learning opportunities to anyone who wants to improve their ICT, literacy and/or math skills to be successful in both work and in (student) life. View individual tutorials or complete whole courses on MS Office 2010.

Learn how to format your MS Office 2010 document,spreadsheets and presentations using Styles, add alternative text to images, and other tips to make your document easier for users and assistive technologies to navigate.

The aim of the ALISON site is simple: they attempt to enable you, wherever you are in the world, to learn and develop new skills – at your own pace – using their free, interactive, multimedia resources.

Their online MS Office 2010 materials will help you to develop your creativity, confidence and competence for completing assignments, and to be as contented and productive as you can be in the world of work.

This site offers full and free online computer courses for Microsoft Office 2007 to 2013. It is designed for complete beginners to intermediate users. There are no screencasts or videos with this course, it is purely text based and therefore is ideal for assistive technologies.

Although this company specialises in Search Engine Optimisation (SEO) so that websites are optimised to show up well in Google and the other search engines, they have a very information free screencasts courses on MS Office 2010. The courses consists of 18 screencasts that range from very basic tasks to more intermediate operations. Watching this range of screencasts will develop a foundation of understanding of MS Office that can lead to more advanced document creation.