How to use microsoft excel 2007 uwmadison chemistry. In this video you can see how to protect a excel file with password. Microsoft office excel 2007 basics getting started the excel window 1 quick access toolbar stores shortcuts for commonly used tools such as save, undo, and print. Left click on value field settings option which launches the value field setting dialog box.
Select the range of cells, columns or rows hover your. Essential microsoft office 2007 tutorials for teachers. How to use microsoft excel 2007 updated by rachael steller summer 2008 6 using autofill with a numeric series you can also use autofill to quickly enter numeric patterns e. There are a set number of cells within a microsoft excel worksheet. Microsoft excel for beginners university of florida. In this basic course excel video tutorial, you get the overview of the application screen, cell.
All rights reserved x lesson 6 mail merge and related operations 167. Tutorials for teachers copyright bernard john poole, 2007. An easy to follow stepbystep tutorial outlining everything you need to know for the corporate environment on excel. In this basic course excel video tutorial, you get. Microsoft excel 20 course download free microsoft office excel 20 file under 505 pages,step by step to learn excel and build your skills, course tutorial training on pdf by curtis d. They usually come in the form of a textbook and you will get access to a knowledge data base that is useful even for people with some it knowledge. Password protect excel file is a file that anyone can not open this file without your permission. Downloading free computer courses and tutorials in pdf. Click on the cell where you want the data to be stored, so that the cell becomes active.
The purpose of this course is to provide a basic guide for student who wants to be familar with the basics of microsoft excel 2007. Right click on your mouse which launches an option dialog box. Introduction to ms excel 2007 9 2009 centre for educational technology, university of cape town data entry cell by cell to enter either numbers or text. Excel 2007 tutorial for beginners this is a microsoft excel 2007 basic tutorial for beginners. Excel 2007 tutorial for beginners how to use excel part. Press enter to move to the next row, or tab to move to the next column. How to protect a excel file with password full course. In the value field settings dialog box, select the number format button on the bottom left corner. In the ribbon versions 2007 and later there are 16,384 columns and 1,048,576 rows.