Excel Tutorial 2010 - Research Methods Excel Tutorial As a...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
DrRuth’s UGS 303: Excel tutorial Page (1) Fall 2010 Research Methods Excel Tutorial As a scientist, you will often have a lot of data that needs to be analyzed. Although most analyses can be done by hand, this is what computers were designed for – to do tedious repetitive tasks without error. (Any errors that are made are usually the fault of the user; either you entered some data incorrectly, or you set up the program incorrectly.) To analyze data you need a spreadsheet and the most commonly used spreadsheet is Microsoft Excel. You can buy Excel from the campus computer store for the price of the CD media (~$33). All spreadsheets sport the same basic interface. What you learn here will help in future with other spreadsheet programs. This tutorial is designed for the complete novice and will show you many features that you may find useful in later experiments. Although many of you will have used Excel before, you must complete this tutorial to ensure that you are familiar with all of the features of Excel covered here. If you are stuck at some point, try asking the people around you (or the TA) for some help. Although it may seem that you are spending a lot of time with your spreadsheet, once you become proficient spreadsheets will save you time, not only this semester, but for many other classes you will take in future. This assignment has been updated to show screenshots from the newest versions of MS Office for the PC (2010) and the Mac (2008) – see above for startup screens. Users of other versions of excel should still be able to follow along, even though they may look a little different. Other versions of Excel should have all the commands I have used, however the names of the menus, etc may have changed slightly. If there are any points where the directions cannot be followed, please inform me and I will notify all of the appropriate corrections. If you have any questions about this tutorial, you may email your TAs or myself ( DrRuth@mail.utexas.edu ). Any corrections, suggestions for improvements, etc are welcomed. One final hint: Save early Name of active cell This is cell “A1”. The coloured outline shows it is the active cell. Columns are denoted by letters Rows are denoted by numbers Click here to select all cells formula entry bar Click here for help Name of active cell This is cell “A1”. The coloured outline shows it is the active cell. Columns are denoted by letters Rows are denoted by numbers A workbook contains a number of sheets Click here to select all cells formula entry bar Click here for help
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
DrRuth’s UGS 303: Excel tutorial Page (2) Fall 2010 and save often! If you really screw something up, simply close the file you are working on ( without saving) and open up the last saved version. Problem 1 — An end-of-term grade report
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 13

Excel Tutorial 2010 - Research Methods Excel Tutorial As a...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online