1. Open either Quicken or Excel. Quicken is another financial program similar to QuickBooks while Excel is a spreadsheet program packaged in the Microsoft Office platform.2. Select 'File,' 'Import,' then choose the QBB file you want to view.3. Click 'OK' and wait for the software to convert the QuickBook document into its own format standard. Once complete, the financial information appears on your computer scre...
Browse » Home » All posts
Wednesday, May 23, 2012
How to Learn Excel Spreadsheet
Free Excel Training from Microsoft1. Download and install a free trial version of the Microsoft Office suite that includes Excel and several other useful programs in a limited time, fully functional trial version.2. Click 'Start' at the Windows orb, 'All Programs' and 'Microsoft Office' to open the start menu group. Click 'Microsoft Excel 2010' to launch the software.3. Click 'File' and 'Help' to launch the interactive training series to learn basic and intermediate Excel functions and to find step-by-step guides to performing the most popular functions.Basic Excel Functions4. Click 'Start'...
Tuesday, May 22, 2012
How to Create Invoices in Microsoft Word From Excel 2007
1. From a new blank workbook in Excel, click the 'Office' button and then the 'New' icon to display the 'New Workbook' dialog box. Under the 'Microsoft Office Online' section, choose 'Invoices' to view the invoice templates that are available for free download. Filter out customer-submitted templates, if desired, by clicking on the 'Hide customer submitted templates' icon at the top of the screen.2. Preview the available templates by single-clicking on each one to view the template in the preview pane to the right. Click on the 'Download' button once you've selected the desired template....
How to Sort a Row or Column in Excel
1. Start Microsoft Excel and open the file you want to change.2. Drag over the two or more columns or rows that you want to sort.3. Open the Data menu and select Sort. The Sort dialog box appears.4. Select the Continue with the Current Selection option to sort a single column or row.5. Select the Expand the Selection option to sort a series of columns or rows.6. Choose Ascending or Descending to determine the sort order.7. Click the Options button in the Sort dialog box.8. Select 'Sort top to bottom' in the Sort Options dialog box to sort a column.9. Select 'Sort left to right'...
How to Change the Pivot Table Default Settings in Excel 2007
1. Open your Microsoft Excel 2007 application on your computer. Click on any cell in the range you want to use for your pivot table.2. Click on the 'Insert' tab and then click on the 'PivotTable' button from the Table group. Click on the 'Create PivotTable' button. The 'Create PivotTable' dialog box will then appear.3. Change any defaults in the 'Create PivotTable' dialog box. For instance, you can click on the 'Use an external data source' option. Click on 'OK' once you've finished changing any of the default selections.4. Continue to create your pivot table by clicking on any of the...
Monday, May 21, 2012
How to Add a Spell
1. Click the 'View' drop-down menu and then the 'Toolbars' submenu. Make sure that the toolbar that will hold the spell-check button is visible by verifying that there is a check mark next to it or selecting it, if there is no check mark, to make it visible.2. Click the 'Tools' drop-down menu and select 'Customize.'3. Select the 'Commands' tab in the 'Customize' dialog box.4. Select the 'Tools' category and scroll down until the 'Spelling' button is visible. The button will have the letters 'ABC' and a check mark on it.5. Click and drag the 'Spelling' button from the Customize dialog...
How to Insert a Date in Microsoft Excel
Excel 20071. Right click on the cell and choose 'Format Cells.'2. Click on the 'Number' tab.3. Click on 'Date' in the 'Category' list box.4. Choose the date format by clicking on one of the formats in the 'Type' box. For example, click on '3/14.'5. Press 'OK.'Excel 20036. Right click on the cell, the click on 'Format Cells.'7. Left-click on the 'Number' tab.8. Scroll to the 'Date' field and highlight it.9. Scroll to the date format you'd like to use in the 'Type' box.10. Click on 'O...
How to change the default font setting in Word 2003
1. Open Microsoft Word.2. Right-click your mouse in the blank document. The Font dialog box will display.3. Make any changes you want in this box. You can change the font, its style and size, as well as color and effects.4. Click the 'Default' button in the lower left corner of the Font dialog box when you are done.5. Click 'Yes' on the pop-up that appears. This will make your newly chosen settings the default for each future blank docume...
Sunday, May 20, 2012
How to Graph Two Lines in Excel 2007
Line Graph1. Open the Excel file that contains the data you need to graph. To make two lines using a line graph, you will need two columns of numerical data. If you want the data to have labels, you should include a header in the cell at the top of each column.2. Select the data that you want to include in the Line Graph. If your desired information is the only data in the two columns, you can simply click and hold the button on the letter above the first column, then move the mouse to the second column and release the button. If your data is not the only information in the column, click and...
How to Lock Unlock an Excel Spreadsheet
Locking1. Open the Excel spreadsheet you want to lock.2. Click the green 'File' tab on the ribbon.3. Click the large, square 'Protect Workbook' button.4. Select a permissions level. Choose 'Mark as Final' to make the spreadsheet read-only. This option does not require a password and only discourages, but does not prevent, editing.5. Choose 'Encrypt with Password' if you want to prevent anyone from opening the spreadsheet without a password. Type the password in the box and click 'OK.' Excel will prompt you to re-enter the password. Re-enter the password and click 'OK' again.6. Choose...
How to Convert Quattro Pro for Windows to Excel
1. Go to 'My Computer' and double-click on 'Control Panel.'2. Double-click on 'Add/Remove Programs' to open the list of installed programs on your PC. Wait for the list to be propagated before doing anything.3. Search for Microsoft Excel. If you installed Excel as part of an MS Office suite, look for Microsoft Office instead. Click on the program to bring up a list of options on the right side of the window.4. Click the 'Add/remove' button among the list of options. This opens up an installation wizard.5. Click on the 'Add or Remove Features' option in the window that appears to bring...
Saturday, May 19, 2012
How to Use the Inverse Log Function in Excel
1. Start Excel.2. Generate the inverse of a common -- base 10 -- logarithm in cell 'A1' by typing '=POWER(10,B1)' and entering the logarithm desired in cell 'B1.' You can replace the first 10 inside the parentheses with any base you choose.3. Generate the inverse of a natural logarithm -- base 2.8172 -- in cell 'A2' by typing '=EXP(B2)' and entering the logarithm desired in cell 'B...
How to Make a Cumulative Frequency Table
1. Construct your spreadsheet to have three columns. One of these columns will be your observation interval, the second will be the number of observations you make per interval, and the third will be the cumulative frequency column.2. Construct your table to contain as many rows as you have observation intervals (e.g., if you are going to make an observation every hour for one day, you will have 24 rows).3. Write your observation intervals down in the first column. As in the above example, if you are making an observation each hour for one day, your 24 rows in this column will be numbered...
How to VLookup Two Values in Excel 2007
1. Open the Excel 2007 file that contains the table you want to work with.2. Right-click on the column letter above the leftmost column on your table. Choose 'Insert' to create a new column.3. Select the top cell in your new column. Type '=XXYY' into the cell, where 'XX' equals the cell reference to the first cell in the first column you want to search through with VLookup, and 'YY' is the second column. Press 'Enter' and you will see the entries in those columns compressed together into the new column. For example, if 'here' was in the first column, and 'there' was in the second, your new...
How to Remove the Blanks from a Pivot Table Add
Remove Blank Cells1. Open Excel and open 'Pivot Table Options' in the Excel ribbon by clicking anywhere on the Pivot Table.2. Click 'Pivot Table Options' to open the options box so you can make changes to the Pivot Table settings.3. Click the 'Layout Format' tab and look to the 'Format' section.4. Uncheck the box next to 'For empty cells show:' and then click 'OK.' Blank cells will no longer show up in the Pivot Table add-in.Remove Blanks from Rows5. Click on the Pivot Table report to open 'Pivot Table Options' in the Excel ribbon.6. Look to the 'Active Field' section of the ribbon...
Subscribe to:
Posts (Atom)