COMPSCI 1BA3 Lecture Notes - Function Key, Microsoft Excel
This preview shows half of the first page. to view the full 2 pages of the document.
September 10-12, 2012
Dr. Nicole Wagner
- Excel files are called workbooks (.xlsx for 2010)
- A workbook s made up of sheets
- chart sheets
- Can have multiple workbooks and sheets open at once, the one you're working n is
- Rows and columns intersect at cells, which may be identified by their cell reference.
Creative effective Workbooks
- In practice, workbooks can be:
- Used and updated by many people
- Very complicated
- Multiple worksheets and chart sheets, extensive data
- Formulas may be used to populate cells
- One worksheet can be the source data for other worksheets or even
- Contain Macros (some programming code) to automate activities.
- These factors should be considered when planning a new book.
- Good practice:
- Plan out your workbook:
- What problem do you want to solve?
- What data is needed?
- What calculations are required?
- What form should the solution take?
- From these answers determine the worksheets required.
- Include a documentation sheet to describe your workbook.
Navigating in Excel
- There are generally multiple ways to do things in excel (mouse, keyboard shortcuts,
dialogue boxes, etc.)
- E.g. click tabs, Ctrl + PgDn
- E.g. go-to vs. name box
- The first function key F1 is a good tool (arrow) brings up the Help function, search for
shortcuts for things you do often.
Entering Text, Numbers & Dates
- There are three data types:
- Text: a combination of letters, numbers, and some symbols that form words and
- Number: any numerical value that can be used in a mathematical calculation
- Date and Time: commonly recognized formats for date and time values
You're Reading a Preview
Unlock to view full version