Excel
Pages - Menu
(Move to ...)
Home
▼
Saturday, April 28, 2012
How to Replace All in Excel VBA
›
1. Open the Excel workbook where you want to enter your VBA code. Press 'Alt' and 'F11' to open up the VBA console. 2. D...
How to Filter Duplicates in Excel
›
1. Click 'Start' then 'All Programs.' Open Excel 2010 by clicking 'Microsoft Office Excel 2010.' 2. Click 'F...
How to Add (or Subtract) in a Spreadsheet like Excel
›
1. Open the Excel worksheet. 2. Enter the values in a row or column. 3. Click a cell to the right of the row of values or click a cell...
Friday, April 27, 2012
How to Convert the Date to Text in Excel
›
1. Open in Excel the workbook that has the dates you want converted to text. If that file isn't available, populate date data into a s...
How to Calculate Empty Cells Using Excel
›
1. Add the following numbers and blank cells in the first column of your Excel 2007 document. For example, add the numbers 2,3,leave blank...
Thursday, April 26, 2012
How to Build a Savings Interest Calculator in Excel
›
1. Open a new spreadsheet in Excel. 2. Label row 1 as follows: A1 is 'Date,' B1 is 'Balance,' C1 is 'Additional depo...
How to Make a Relative Frequency Histogram on Excel 2007
›
1. Create a column for your independent variables (your x-values). For example, if you are comparing the performance of salespersons, writ...
How to Calculate the Time Difference Between Two Times in Excel 2003
›
1. Open Excel 2003, and select a workbook that contains columns with time information. Click 'File' on the menu bar, and select ...
Wednesday, April 25, 2012
How to Use MegaStat in Excel 2007
›
1. Create a new spreadsheet in Excel 2007. 2. Open MegaStat. 3. Click the 'Add-Ins' menu option at the top-right of the screen...
Tuesday, April 24, 2012
How Do I Create a Color Drop Down Box in Excel?
›
Create Lookup List With Background Color 1. Go to a section of unused cells in the spreadsheet. 2. Type the choices that will appear in ...
How to Create Conditional Formats in Excel 2007
›
1. Open an existing Microsoft Excel document in which to create these conditional formats. Double click on the 'My computer' optio...
How to Make Mailing Labels in Excel 2007
›
1. Open the Excel 2007 worksheet containing the list you want to use to make mailing labels. If you do not yet have a list, open a blank w...
How to Put Excel Data Into a Pie Chart
›
1. Open a new worksheet in Microsoft Excel. Add headings in the first column down the left side of the page. For instance, if you are maki...
Monday, April 23, 2012
How to Merge Excel Worksheets Into a Workbook
›
1. Open Microsoft Excel. Press and hold the 'Ctrl' key on your computer's keyboard and press the 'O' key to start the ...
How to Delete Cells in MS Office 2003
›
1. Open an existing worksheet in Microsoft Excel. 2. Select the cell (or cells) you want to delete from your worksheet. To select an ind...
‹
›
Home
View web version