ExcelHints

# ExcelHints - Excel Excel Hints and Cool Tricks ENGR102 Fall...

This preview shows pages 1–2. Sign up to view the full content.

Excel ENGR102 Fall 2006 Copyright, 2006 Gregory E. Ogden Excel Hints and Cool Tricks Remind students that excel is a cell-based program. It consists of cells that are aligned in rows and columns. Each column is referenced by a letter (a, b, c, etc.) and each row is referred to by a number. For example in the figure below, the cell B2 contains the number 6.25. While E1 has the number 0.001. The area highlighted below covers cells A1 through E5. Excel was created for accounting purposes. It is very easy to create tables of data (columns and columns). One can also perform simple and complex calculations on individual cells as well as copy data (numerical or words) and formulas from one cell (or range of cells) to another. Each file (called a worksheet) can have one or more spreadsheets, noted by the tabs on the bottom. Complex worksheets can use multiple spreadsheets and have inter-related formulas (between spreadsheets). You can create graphs in Excel and either place them on a spreadsheet (over the cells) or on it’s one chart page. Simple equations can be developed like Y = Mx + B. Where the cell you want the answer in (Y) is the cell you choose to create the equation. “x” can refer to another cell and the M and B can either be numbers or refer to other cells. To create a formula (in Cell B3 below), you first highlight that cell, then type in the dialog box above the spreadsheet what you want the formula to look like. In this case is it 3x+4. In this instance, I referred to the cell A3 for the value of X. Note that the equation in the dialog box reads: “=3*A3+4”. Here the cell A3 is highlighted in blue on the spreadsheet and the “A3” shows up in Yellow in the dialog box at the top. The “*” indicates multiplication.

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern