Excel.08

Excel.08 - COMPREHENSIVE Excel Tutorial 8 Developing an...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: COMPREHENSIVE Excel Tutorial 8 Developing an Excel Application XP XP Objectives Create, edit, and delete defined names for cells and ranges Paste a list of defined names as documentation Use defined names in formulas Add defined names to existing formulas Create validation rules for data entry Protect the contents of worksheets and workbooks New Perspectives on Microsoft Office Excel 2007 2 XP XP Objectives Add, edit, and delete comments Learn about macro viruses and Excel security features Create a macro using the macro recorder Edit a macro using the Visual Basic Editor Assign a macro to a keyboard shortcut and a button Save a workbook in macro enabled format Minimize the Ribbon New Perspectives on Microsoft Office Excel 2007 3 XP XP Planning an Excel Application An Excel application is a spreadsheet written or tailored to meet the users specific needs New Perspectives on Microsoft Office Excel 2007 4 XP XP Naming Cells and Ranges A defined name (often called simply a name ) is a word or string of characters associated with a single cell or a range Select the cell or range to which you want to assign a name Click in the Name box on the formula bar, type the name, and then press the Enter key (or in the Defined Names group on the Formulas tab, click the Define Name button, type a name in the Name box, and then click the OK button) Or Select the range with labels and blank cells in the top row or first column to which you want to assign a name In the Defined Names group on the Formulas tab, click the Create From Selection button Specify whether to create the ranges based on the top row, bottom row, left column, or right column in the list Click the OK button New Perspectives on Microsoft Office Excel 2007 5 XP XP Naming Cells and Ranges New Perspectives on Microsoft Office Excel 2007 6 XP XP Adding Defined Names to Existing Formulas In the Defined Names group on the Formulas tab, click the Define Name button arrow, and then click Apply Names (if the cell reference and defined name definition are in the same worksheet)...
View Full Document

This note was uploaded on 04/08/2008 for the course CIS 201 taught by Professor Mcmahon during the Spring '08 term at Bryant.

Page1 / 26

Excel.08 - COMPREHENSIVE Excel Tutorial 8 Developing an...

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

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