WordPress.com



Beginners ExcelLearning Outcome ChecklistName:OutcomeAdditional training neededCell referencesFormatting numbers (currency, integers, %)Basic formulae (*,+,-,/)Basic functions (SUM)Replicate functionLayout (column widths, fonts, text wrapping)Open, save, closeCell references-6715749931300Cell references is a term that refers to the exact location or contents of any specific cell(s) that are located in the spreadsheetFor example cell ‘C7’ would be located on the 7th row of the excel spreadsheet and in the C column, which is the 3rd column from the left of the spreadsheet as shown in the above image.Cell references are highly important when utilising formulae, where it is imperative to address the contents of specific cells when committing calculations, such as A4*B7 for instance. Formatting numbersleft12234900Excel also includes built-in features to change the format in which information in a cell can be displayed: The example below is for displaying numbers in currency formatRight click on the specific cells you wish to modify and select ‘Format cells’left46569200On the category list, select Currency, which will display an array of options form displaying currency in the cell, you are able to select the type of currency from a list available. In addition it is also possible to configure the number of decimal places in the currency value for more accurate value representations left102160500Finally the currency options include additional options for representing the value, including encapsulating it into brackets, as a negative value. When you are finished configuring the Currency formatting, press OK, and the setting should be applied to any number value applied to the configured cell. There are also different cell formats that are available other than currency: General: the normal or default settings of the cell and applies no special properties for its contents3400687762000Dates: Allows for the time of date to be displayed in various ways, including methods available in other countries such as the American date format.29379551206500Numbers: Like currency allows additional decimal points to be added to numbers, be displayed as positive or negative, and use separators to ease reading of very large numbers. Basic formulae:A basic Walkthrough of simplistic formulae calculations that can be executed in Excel: when utilising Basic formulae in Excel, you need to use cell references to target the specific cell you wish to use in the calculation. left1079500To start a formula, use the ‘=’ sign in the cell you wish the formula to be displayed in, and then specify the cell references of the cell contents you want to use in the calculation, excel will automatically add the cells referenced into the calculation for you. For example: =A4+A5 will add the contents of both of the specified cells and display the answer in the cell that formula is contained in.left2413000In addition, this will work with any of the 4 basic arithmetic functions: “+” for Addition, “-“ for Subtraction, “*” for Multiplication, and “/” for Division and there is no upper limit to the amount of cells that can be referenced and added to the calculationBasic functions:Functions are used, unlike formulas to compare the contents of various cell references in various ways, In this, only Sum and Average will be discussedleft102743000right5112300To access Functions, select the cell you wish the function results to be displayed in and press the Fx button adjacent to the formula bar to the left, which will show a options window allowing for a specific function to be specified by the user. Source: the desired function has been selected, an addition Function arguments window will appear showing in the Number1 Bar which cell references will be included in the calculation. right1778000By selecting the red arrow icon to the right of the number1 bar will allow specific cells to be selected and included in the function. This can simply be achieved by left clicking and dragging a selection area over which cell you need to be addressed by the function. When you are satisfied the correct cell are being referenced, press the Esc button on the keyboard to return to the function arguments window. right61150500You can also specify more than one selection of cells by executing the same series of steps but instead with the number2 bar below. In addition, Excel will generate more of these additional range Boxes for you to use, with Excel allowing for up to 255 cell reference selections to be made.Once this is done, the results of the function will be displayed in the cell you selected initially. left1229100Finally, here is a simple explanation of some of the functions available for use in this manner:Sum: Adds the contents off all specified cells and displays the answer in the target cellAverage: calculates the mean average off all selected cells Replicate functionleft1968500The replicate function refers to the ability to copy cell contents from one location to another.left104965500This is a very simple feature to use, select the cell that you wish to copy by pressing left click and selecting the required cells, and then right clicking the selection and selecting ‘copy’92990284313200Then select the cell where you wish to place the copied cells and using the right click menu, hover over paste, which will show you how the copied cells will be shown in the spreadsheet. Once you are content with the location, press paste fully to complete the replication. Layout (column widths, fonts, text wrapping)-10908129179900The sizes of cells can also be adjusted. In terms of column sizes, by hovering between the boundaries of a spreadsheets column, the mouse cursor will change into a width symbol. By left clicking the size of the column can be increased or decreased with extreme ease, allowing spreadsheets to become asymmetrical. The font can also easily be changed by selecting written text in one or more cells, and changing the font type by using the font selection menu near the top: left26748700left63365400In addition, the text wrapping can also be changed in the top menu on the screen, including text alignment and whether it is centred to the left right or centreOpen, save, closeTo open a document while Excel is active, click the file option on the top left of the screen, and in the file menu select open. To find a file on the computer, select computer, and navigate to the files location by clicking browser and finding and selecting the excel file you wish to open. To Save the currently open file, lick the file menu again in the top left, and in the file menu press save, or if you wish to save the file under a new name, select save as. 427323329An alternative method of doing this is to select the Save icon at the top of the screen, or by Holding the Ctrl button on the keyboard and pressing S ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download