- Excel 2007 tutorial with exercises pdf#
- Excel 2007 tutorial with exercises install#
- Excel 2007 tutorial with exercises mac#
Reading 1.1.1: An Introduction to Excel 2007, by Patricia Kwan Readings / Tutorials / Activities / ExercisesĬells, sheets, references, and formatting
Remember where you saved it, open Excel (or Word), choose File->Open from the menu, navigate to the folder in which you saved the file, and open it that way. If you click on a link to one of the exercises and it doesn't open into Excel (or Word), try right clicking on the link and taking the ‘Save Link As’ option from the context menu. Sometimes computers ‘forget’ things, like which program to use to open a particular type of file. Opening the links to the self assessment exercises
Excel 2007 tutorial with exercises mac#
You can do the formatting in Linux or on the Mac using either OpenOffice or MS Office, but the scoring button which lets you know how you are doing won’t work. However, because of differences in the programming language ‘behind the scenes’ the self assessment tools will only run on Windows machines. It runs on all three major operating system (Windows, OSX and Linux), is free, and can be downloaded here.įor what we will be doing here it is identical in terms of spreadsheet and document functionality to MS Office. If you don’t want to use MS Office, you can use OpenOffice, an open source project started by Sun and now looked after by the Apache Foundation. However, you can achieve the same results using older versions of MS Office like Office 2003, or if you have Mac Office 2010 or Office 2008 for Mac. This training module has been tailored towards Office 2007 because it is on all of the college computers. The most recent version was released in 2010, but the 2007 version, the version installed on all the College of Business computers, is very similar in terms of function and the look and feel of the user interface (UI). The most widely installed set of business productivity tools is Microsoft Office.
Excel 2007 tutorial with exercises install#
In Linux and OSX, software comes with the operating system to do this in Windows you may need to install Acrobat Reader (it's free) from this URL.
Excel 2007 tutorial with exercises pdf#
You will need to be able to open PDF files. Should you need help, Li HuiXin will be there on Wednesday mornings from 10:30-11:45 to assist you with any MS Office related problems you may have. If you get stuck and need some help, try the Tutorial Center. On the third floor of the classroom building is open from 7am to 10pm and is a good place to go if you don’t have Microsoft Office. The links below will take you to a variety of self-study material including some ‘hands-on’ exercises in which you can put what you learn into use. If you prefer a book, a very good textbook to accompany this on-line set of tutorials is “Business Productivity Tools”, Second Edition. Access to these tools is fairly limited (to 20 concurrent users), but they are well worth taking a look at if you are just beginning to learn these tools. In addition to the material set out below, we suggest trying these on-line courses offered through the library. We suggest you try to work through the numbered exercises below in order (1.1.1, 1.1.2, 1.1.3, 1.2.1.).