Pages

▼
Showing posts with label Excel 2007. Show all posts
Showing posts with label Excel 2007. Show all posts
Wednesday, September 26, 2012

Understand Ranges in Microsoft Excel

›
Two Types of Range There are two types of ranges in Excel -- contiguous and noncontiguous. These are described below: Contiguous Rang...
Monday, May 2, 2011

Customize the Layout - XIII

›
Split a Worksheet You can split a worksheet into multiple resizable panes for easier viewing of parts of a worksheet. To split a worksheet...

Page Properties and Printing - XII

›
Set Print Titles The print titles function allows you to repeat the column and row headings at the beginning of each new page to make read...

Developing a Workbook - XI

›
Format Worksheet Tab You can rename a worksheet or change the color of the tabs to meet your needs. To rename a worksheet: Open the sheet ...

Formatting a Worksheet - XI

›
Convert Text to Columns Sometimes you will want to split data in one cell into two or more cells.  You can do this easily by utilizing the...

Charts - X

›
Charts allow you to present information contained in the worksheet in a graphic format. Excel offers many types of charts including: Column...

Graphics - IX

›
Adding a Picture To add a picture: Click the  Insert  tab Click the  Picture  button Browse to the picture from your files Click the  n...

Sort and Filter - VIII

›
Sorting and Filtering allow you to manipulate data in a worksheet based on given set of criteria. Basic Sorts To execute a basic descendin...

Macros - VII

›
Macros are advanced features that can speed up editing or formatting you may perform often in an Excel worksheet. They record sequences of ...

Performing Calculations - VI

›
Excel Formulas A formula is a set of mathematical instructions that can be used in Excel to perform calculations.  Formals are started in t...

Modifying a Worksheet - V

›
Insert Cells, Rows, and Columns To insert cells, rows, and columns in Excel: Place the cursor in the row below where you want the new row,...

Manipulating Data - IV

›
Excel allows you to move, copy, and paste cells and cell content through cutting and pasting and copying and pasting. Select Data To selec...

Working with a Workbook - III

›
Create a Workbook To create a new Workbook: Click the  Microsoft Office Toolbar Click  New Choose  Blank Document

Customize Excel - II

›
Excel 2007 offers a wide range of customizable options that allow you to make Excel work the best for you.  To access these customizable op...

Getting Started - I

›
Getting started with Excel 2007 you will notice that there are many similar features to previous versions.  You will also notice that there...