Excel Tutorial 1

This week we will be focusing on using Microsoft’s Excel. Excel is a spreadsheet package. Microsoft Excel is a spreadsheet program which allows one to enter numerical values or data into the rows or columns of a spreadsheet, and to use these numerical entries for such things as calculations, graphs, and statistical analysis.

This tutorial was designed both for users who are new to Excel or have very little experience using the functionality of Excel. It assumes that you have at least some familiarity with operating Microsoft office applications, for example opening and closing documents and using toolbars. Although it uses what is now the most recent version of MS Excel, you will most likely find that the lessons in this tutorial will work on earlier versions.
Excel offers an enormous number of possible functions, tools and options for use. Because there are so many things to learn about Excel, the approach of this tutorial is to give you a solid understanding of the basic functionality of Excel, show you a few essential tools and then explain some specific uses that you might find helpful for completing tasks and operations related to the library and information science field.

By using this tutorial you will learn how to:

1. understand spreadsheets and their range of application.
2. design spreadsheets for a range of tasks
3. create spreadsheets from design specification(s)
4. utilise a wide range of functions, including macros and other functions
5. create a spreadsheet, according to a given brief, under time constraints

You are required to study the following the complete 12 Excel Tutorials carefully. Once you have completed each tutorial you should then email a copy to your Lecturer, you should also request a return email to ensure that your Lecturer has recieved a copy of your tutorial. Okay, lets begin.



Once you complete the first session, dont forget to email you work to your lecturer and continue with the next training session.

Thanks,
John.