Thursday, July 25, 2013

How to Add Comments to an Excel Worksheet

1. Open the Excel spreadsheet you wish to change.2. Select the cell into which you'll write your comment.3. Choose Comment under the Insert menu.4. Type your comment into the resulting box.5. Finish typing and click outside the box to save your comme...
Read more ►

How to Make a Gantt Chart in Excel

1. Open a new Excel worksheet. For the purposes of this article, enter 'Task' in cell A1, 'Start Date' in cell B1 and 'Length' in cell C1. Type in a few lines of chart data under the appropriate headings. The first column names the tasks, the second column provides a start date, and the third column lists the number of days each task is expected to take.2. Select the data table by clicking the first cell and dragging across all the cells you typed data into. Go to the Insert tab and select 'Bar' from the Chart panel. Click on 'Stacked Bar' under the 2D heading as the chart subtype.3. Click...
Read more ►

How to Create a Template in Excel 2007

1. Open Microsoft Excel 2007 on the computer.2. Click the 'Microsoft Office' button from the main program menu, and then click 'Open.' Browse to and double-click the existing Excel workbook or worksheet that you want to use as a template. If you don't have an existing spreadsheet, click 'New' to create a new Excel document to use as a template.3. Enter the information and add the elements that you want to include in the Excel template. This should include all the data, graphics, text, macros and formulas that the template requires to work properly.4. Click the 'Microsoft Office' button...
Read more ►

How to Expand a Row in Excel 2003

1. Click the Windows 'Start' button and select 'All Programs.' Click 'Microsoft Office,' then click 'Microsoft Excel' to open the software.2. Click 'File,' then click 'Open.' Double-click the Excel file with the rows you want to edit. The file loads in the Excel editor.3. Hover the mouse over the line below the row you want to expand. Notice the cursor displays an arrow. Click the row's grid line and expand the height.4. Click the 'Save' button to save the changes. Repeat these steps for each row you want to ed...
Read more ►

How to Print in Excel 2007

Print Whole Worksheet1. Open your document in Microsoft Excel. Click on a cell within the table to activate it.2. Click the Microsoft Office button at the top of the worksheet. The Microsoft Office button will appear as a light blue circle with the Office logo inside. Click 'Print' or use the keyboard shortcut 'Ctrl' and 'P,' followed by 'OK.'3. Click 'Table' under the 'Print What' option that will appear. Clicking 'Table' will print the entire chart.Print Part of a Worksheet4. Click on a cell and drag your mouse cursor to the rest of the table you wish to print. The table will highlight...
Read more ►

Wednesday, July 24, 2013

How to Use Security Features in Excel

1. Enable security alerts from suspicious website links. Click the Microsoft Office button and choose 'Excel Options.' Choose 'Trust Center,' then click 'Trust Center Settings' and select 'Privacy Options.' Make sure you have 'Check Office documents that are from or link to suspicious Web sites' checked.2. Select 'Enable Content' on the message bar if your workbook has external content. Choose to unblock the external content when the security dialog box appears.3. Access the Trust Center to view your security and privacy settings for Active-X controls, add-ins and macros. Click on the Microsoft...
Read more ►

How to Include Grand Totals in Excel Pivot Charts

1. Open the PivotChart.2. Click the 'Field List Button' image on the PivotChart toolbar if the Field List Button is not showing.3. Click the field and go to 'Totals.'4. Click 'Row Area' to add the grand total to the row area and 'Column Area' to add it to the colu...
Read more ►

How to Insert a Template in Excel 2007

1. Hold the 'Windows' key down and press 'E' to open Windows Explorer.2. Navigate to where you saved the template you want to insert into Excel.3. Open another Windows Explorer window, type 'C:\Users\USERNAME\AppData\Roaming\Microsoft\Templates' in the top address field and press 'Enter.' When typing the address, change 'USERNAME' to your Windows username, which is listed beneath your picture on the 'Start' menu.Do not try to navigate into this folder by clicking folders. If you maintain Windows 7's default settings, you will not find the 'AppData' folder because it is a hidden system folder....
Read more ►

How to Upgrade Microsoft Excel

1. Insert the install CD or DVD into the disk drive.2. Enter your product key when prompted. This will occur after the install screen has popped up. If the install screen does not come up automatically, then navigate to your CD/DVD drive through 'My Computer' and double click on the Microsoft Office disk icon. The product key can be found on a sticker on the CD case inside your Microsoft Office box.3. Accept the Microsoft License agreement.4. Select 'Install Now' or 'Customize.' 'Install Now' will upgrade all previous versions of the Microsoft Office program that correspond to your recently...
Read more ►

Tuesday, July 23, 2013

How to Make a Basic Bookkeeping Spreadsheet in Excel

1. Examine your personal or business finances to determine the best way to use Excel. Different options are keeping track of accounts receivable and payable, including payroll, rent or utilities and any raw materials used in the production process.2. Open Excel on your computer and create a new spreadsheet by clicking on the blank page icon at the top left of your screen.3. Orient yourself with Excel's format. The page is made up of a grid which creates boxes. Information can be typed into each box.4. Title the headings for your spreadsheet's rows and columns. For example, you may choose...
Read more ►

How to Paste Into PowerPoint and Remove Gridlines

1. Select the text, image or object that you want to include in your PowerPoint presentation. For example, highlight a range of cells in an Excel spreadsheet. Press 'Ctrl C' on your computer's keyboard.2. Press 'Ctrl M' in PowerPoint to create a new slide and then press 'Ctrl V' to paste the object. If you copied a spreadsheet, for instance, it will paste in as a spreadsheet object. Note, that you can link or embed things such as spreadsheets, charts and Word documents.3. Click on the 'View' tab in PowerPoint and click in the check box next to 'Gridlines' to remove the gridlines from the...
Read more ►

How to Assign a Macro to a Cell in Excel

1. Right-click the sheet tab you want the change to happen in. The sheet tabs are at the very bottom of the worksheet.2. Click 'View Code.'3. Cut and post the following code into the worksheet:Private Sub Worksheet_SelectionChange(ByVal Target As Range)If Target.Address = '$A$1' ThenRange('A10') = 'Your text here'End IfEnd Sub4. Change the code to suit your needs. The above code writes 'Your text here' into cell 'A10' when cell 'A1' is clicked. Change the 'A1' in 'Target.Address = '$A$1'' to the cell you want to click, then change Range('A10') = 'Your text here' to indicate the cell you...
Read more ►

Monday, July 22, 2013

How to Create Frequency Relative Frequency on Excel Using a Pivot Table

1. Gather all of your data and compile it into a list on Microsoft Excel. Select and highlight the entire list of data points. Right click it and choose the option 'Sort from smallest to largest.' Now that the data points are in numerical order, the task of creating a frequency distribution table will be much easier.2. Determine the interval size and the number of classes that will be used for your distribution table. For example you may have something like 5 classes of intervals: 1-5, 5-10, 10-15, 15-20, and 20-25. These classes will be used to organize the data points.3. Start setting...
Read more ►

How to Open Excel Templates

1. Open Excel. Click 'File' if you are using Excel 2010 or click the 'Office' button if you are using Excel 2007. The Office menu will open.2. Click 'New' on the Office menu. A window called 'New Workbook' will open. You can search for and open Excel templates here.3. Look to the 'Templates' section on the 'New Workbook' menu. You can view recently used or installed templates here.4. Click one of the Excel template categories to view an Excel template. Categories you can choose from are 'Blank and Recent' and 'Installed Templates.'5. Select the template you want to open and click...
Read more ►

How to Compare Workbooks

Comparing Numeric Values1. Open a new workbook, and name it CompareWorkbooks.xls.2. Look at the values that you want to compare in both workbooks. For example, you may wish to compare cells B2 to F7.3. In cell B2 (or the upper left cell) of the CompareWorkbooks workbook, insert the formula '=[Workbook1.xls]Sheet1!A1-[Workbook2.xls]Sheet1!A1.' If the Workbooks or sheets are named differently, change the formula as appropriate.4. Copy the formula from that cell into all of the applicable cells in the CompareWorkbooks workbook. A '0' in a cell means that the cells in the two compared workbooks...
Read more ►

Blogger news