Microsoft Access is a relational database system. That simply means that in the one file you can have multiple tables, forms, queries, and reports. It is pretty much like when you were back in junior high school and you kept all of your notes in a three-ringed binder with different sections for each of your […]
The IPMT function allows you to work out the Interest payment based on the set criteria as outlined in the syntax below. Syntax IPMT(rate,per,nper,pv,fv,type) Rate is the interest rate per period. Per is the period for which you want to find the interest and must be in the range 1 to nper. Nper is the […]
PPMT Financial Function in Excel 2010 The PPMT function allows you to work out the principal payment based on the set criteria as outlined in the syntax below. Syntax PPMT (rate,per,nper,pv,fv,type) Rate is the interest rate per period. Per specifies the period and must be in the range 1 to nper. Nper is the total […]
Get the lastest currency rates automatically updated in your spreadsheet! And they use the data within charts, functions and more… Select the DATA tab on your excel 2010 ribbon and select EXISITING CONNECTIONS Select the option MSM MONEYCENTRAL INVESTOR CURRENCY RATES Its as easy as that! Give excel a few moment and you will have the […]
To add a background to your spreadsheet simply follow the following procedure; On your ribbon select the tab PAGE LAYOUT Click on the BACKGROUND button Select the image you wish to have as your background Its as simple as that.
Calculate the percentage if you know the total and amount For example, if you score 42 points correctly out of 50, what is the percentage of correct answers? Example The example may be easier to understand if you copy it to a blank worksheet. Create a blank workbook or worksheet. Select the example in the […]
We usually maintain the data in multiple worksheets to check the data for each instance and to view them individually but it would be great to merge all the data from different worksheets in Excel spreadsheet to analyze it. Consolidate feature in Excel 2010, lets you to pull-each record from the worksheet in to one […]
Slicers you will be able to depict the datasheet fields more comprehensively. Excel 2010 include this feature for the first time, which lets you to slice your data by showing you only the element stored in the tables. Real usage of Slicers can be seen with pivot table. Unlike Pivot table, which pivots down the […]
For those of you who like bulleted lists and are frustrated that you can’t insert one in a cell, there is a way to insert bullet points in a cell to emulate such a thing. Just keep in mind that this isn’t a true list, so you can’t generate more bulleted lines by inserting a […]
If the Watch Window toolbar (toolbar: A bar with buttons and options that you use to carry out commands. To display a toolbar, press ALT and then SHIFT+F10.) is not displayed, on the Formulas tab, in the Formula Auditing group, click Watch Window. Select the cells that you want to remove. To select multiple cells, […]
Select the cells that you want to watch. To select all cells on a worksheet with formulas, on the Home tab, in the Editing group, click Find & Replace, click Go To Special, and then click Formulas. On the Formulas tab, in the Formula Auditing group, click Watch Window. Click Add Watch . Click Add. […]
When cells are not visible on a worksheet, you can watch those cells and their formulas (formula: A sequence of values, cell references, names, functions, or operators in a cell that together produce a new value. A formula always begins with an equal sign (=).) in the Watch Window toolbar (toolbar: A bar with buttons […]
There are several ways to exchange data between Microsoft Office Access and Microsoft Office Excel. To bring data into Excel from Access, you can copy data from an Access datasheet and paste it into an Excel worksheet, connect to an Access database from an Excel worksheet, or export Access data into an Excel worksheet. To […]
You can use Excel 2007’s Subtotals feature to subtotal data in a sorted list. To subtotal a list, you first sort the list on the field for which you want the subtotals, and then you designate the field that contains the values you want to be summed — these don’t have to be the same […]
Opening a file in Excel 2003 (Video)
The simplest way to adjust the width of the column is to simply drag it from the corners. Additionally it can also be done by going to the Home menu and Format > Column Width option.
In many cases, you don’t need any particular column, here are the steps to remove any column(s) from your Excel worksheet. Select the columns, right click and choose Delete.
In the column header, select the number of columns that you wish to add to your excel sheet, if you want to add 2 columns then select two columns, right click and choose Insert, you will find 2 new columns added to your spreadsheet.
Right-click the column, adjacent to which you wish to add another column, and choose Insert, a new column will be inserted to the left of the selected column.
In large tables or summaries in Excel 2010 it can be useful to be able to hide rows. In this guide we will run through how to hide rows. This is what you do: 1. Select the rows you want to hide. 2. Right click the selection. 3. Click Hide.
Merge Cells in Excel 2010; Study the spreadsheet below: If you look at Row 1, you’ll see that the “Shopping Bill” heading stretches across three cells. This is not three separate cells, with a colour change for each individual cell. The A1, B1 and C1 cells were merged. To merge cells, do the following. Type […]
This article describes the formula syntax and usage of the AND function (function: A prewritten formula that takes a value or values, performs an operation, and returns a value or values. Use functions to simplify and shorten formulas on a worksheet, especially those that perform lengthy or complex calculations.) in Microsoft Office Excel. Description Returns […]
The COUNT function counts the number of cells that contain numbers, and counts numbers within the list of arguments. Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers. For example, you can enter the following formula to count the numbers in […]
The COUNTA function counts the number of cells that are not empty in a range (range: Two or more cells on a sheet. The cells in a range can be adjacent or nonadjacent.). Syntax COUNTA(value1, [value2], …) The COUNTA function syntax has the following arguments (argument: A value that provides information to an action, an […]
Countif Counts the number of cells within a range that meet the given criteria. Syntax COUNTIF(range,criteria) Range is the range of cells from which you want to count cells. Criteria is the criteria in the form of a number, expression, cell reference, or text that defines which cells will be counted. For example, criteria can be expressed […]
Let’s look at an example using a formula that provides a total amount. In the total row, we want to display the sum of all household expenditure. Make sure that the cell you want to contain the total is active and then click Home > Editing > AutoSum. Because the active cell is positioned directly […]
Microsoft Excel 2010 normally copies all the information in the range of cells you select when you paste the data. Use Excel’s Paste Special command to specify other options, such as pasting only the cell contents (without the formatting) or only the formatting (without the cell contents). To paste particular parts of a cell selection, […]
Here I have a table with employees work hours spread over a 7 day week. The employees are on the rows and the days of the week in the columns. I have created two criteria cells, one for the employee and one for the days. I then created another cell which is where I will enter […]
The following examples use the INDEX and MATCH worksheet functions in excel 2010 to find a value based on multiple criteria. Example 1: Data in Columns Method 1 Start Excel. Type the following data into a new worksheet: A1: Part B1: Code C1: Price D1: Find Part E1: Find Code A2: x B2: 11 C2: […]
Above is an example of a standard pivot table in Microsoft Excel 2010. It is set up with financial quaters as column headers and products as Row labels. I’m interested in seeing the results for the combined sales for the first half and the second half of the year. As you can see I have […]