{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Dr. Cotter's Excel Tutor

# Dr. Cotter's Excel Tutor - Old Dominion University...

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

1 Old Dominion University Introduction to Microsoft Excel © T. Steven Cotter, Ph.D. Engineering Management and Systems Engineering © Old Dominion University, 2009 Norfolk, Virginia

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

View Full Document
2 Old Dominion University Introduction to Microsoft Excel © Contents Chapter Title Page 1 The Excel Environment – Office 2007 3 2 Building Worksheets 12 3 Creating Formulas and Performing Data Analysis 31 4 Creating and Formatting Charts 42 5 Working with Functions 50
3 Old Dominion University Introduction to Microsoft Excel © Chapter 1: The Excel Environment – Microsoft Office 2007 © The Workbook Window A new workbook, shown in Figure 1 as a floating window, is made up of a number of components. Figure 1: Workbook components. Column heading letters ranging from A to IV (after column Z comes AA through AZ, BA through BZ, etc.). Row headings range from 1 through 65,536. The currently selected cell is referred to as the active cell.

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

View Full Document
4 Old Dominion University Introduction to Microsoft Excel © When a range of cells is selected, only the upper left corner cell is active. The headings for the columns and rows of a range of selected cells are highlighted, making it easier to identify the location of the selected cells. A worksheet can contain up to 256 columns and 65,536 rows or more than 16 million cells. However, the number of cells that can be used in any given worksheet is limited to (1) the amount of computer memory and (2) the number of bytes of information in the worksheet. Be default, a new workbook contains 3 worksheets. The default setting can be changed by clicking on the Office Button, selecting Excel Options, and changing the default number of worksheets per workbook in the Options properties window. Otherwise, new worksheets can be added by left clicking on the “New Worksheet” tab.
5 Old Dominion University Introduction to Microsoft Excel © Worksheets can be renamed by double left clicking on the tab name and typing a new name. Click anywhere in the worksheet to return active control to the sheet and register the new worksheet name.

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

View Full Document
6 Old Dominion University Introduction to Microsoft Excel © Right clicking on the title bar, a scroll box, a worksheet tab, or an active cell opens a context sensitive shortcut menu of commands.
7 Old Dominion University Introduction to Microsoft Excel © Menus Microsoft Excel’s main menus provide worksheet editing, layout, and formatting functionality. The “Home” menu provides the most used functionality. The “Insert” menu provides the means to insert tables, graphics objects, charts, hyperlinks, or text objects into a worksheet. The “Page Layout” provides formatting options for printed page output. The “Formulas” menu provides the capability to insert pre-defined formulas into cells from Excel’s Function Library, define range names for reference in formulas and macros, troubleshoot formula reference traces with Formula Auditing, or set worksheet recalculation to automatic or manual options.

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