Free Excel Tutorial at GCFGlobal.
Looking for:
Microsoft office excel 2007 user guide pdf free.Microsoft 365 Training |
Microsoft office excel 2007 user guide pdf free.Microsoft Office XP
- Microsoft office excel 2007 user guide pdf free
You will look at different techniques for ensuring that your spreadsheet appears as intended both on screen and when printed. There is more information microsoft office excel 2007 user guide pdf free charts and calculations in the companion pd, Intermediate Excel Prerequisites The exercises below assume that you are familiar with the use of a computer keyboard and mouse and have a working knowledge of Offuce Windows.
Contents 1. Introduction 1 2. Laying out a spreadsheet 3 3. Calculations 6 ofvice. Amending the worksheet 8 5. Formatting the Worksheet 9 6. Suer is an extremely complex and powerful tool, but the main functions are fairly straightforward to pick up. Can contain more than one worksheet by default there are 3 in microsoft office excel 2007 user guide pdf free workbook The area you useer see on screen, where you input data and perform calculations etc.
Appear at the bottom of the screen, allowing you to jump from one worksheet to another Each box on the screen is known as a cell. It is usually referred to by its address e. A1 is the cell at the top left of the worksheet The cell that has a dark border around it is active that is where anything you type will appear All the cells in one horizontal line, marked by the numbers on the left odf the screen All the cells /1741.txt one vertical line, marked by the uxer at the top of the screen Column Row Active cell 1.
Moving around the cells is arguably easiest with the arrow keys; left one cell up one row right one cell down one row Birkbeck IT Services 1. You will then be moved down to excle next line. You may enter data in a row by using the TAB key to move across adobe flash cs5 free spreadsheet. You may also move around using the arrow keys 1. To do so, guuide may use the keyboard. Move to the first top left offic you wish to select Hold down the SHIFT key there are two, both have an upward arrow printed on them Use the arrow keys to increase the size of the area selected Experiment micrrosoft using the page up and page down keys.
The HOME key will move the selected area over читать статью the first column If you exccel data in your spreadsheet, pressing the END key followed by an arrow key takes you to the end of microsoft office excel 2007 user guide pdf free data area When you have jicrosoft selecting an area, let go of the SHIFT key Note: this also works in Word and other Windows applications 1.
Excel will try to complete a frwe of data for you. To tell it to do so, use the drag handle at the bottom right corner microsoft office excel 2007 user guide pdf free the input box Clear all data from your spreadsheet Figure Type the micosoft January into cell B1 Put the cursor over the handle it will turn 20077 a thin black cross Drag the handle out to the right until all the months of the year appear what happens if you go beyond December?
If you drag too far, drag to the mlcrosoft to remove entries Excel also understands abbreviated forms of the months Jan, Feb and so on. The same technique works for simple sequences of numbers, though you will need to enter and select more than one e.
Figure Entering a block of data We now need to enter some information into the remaining cells Enter 1, 2 and 4 in the cells next to Materials which should be B4-D4 Select the three cells Right-click on the drag handle and drag it across to cell M4 A menu will pop up choose Growth Trend, as shown in Yser Excel will continue the trend, doubling each value in the next cell Figure Entering data into a block We will fill in random data for the remaining microsoft office excel 2007 user guide pdf free.
You may do so by using the arrow or TAB keys to move around the worksheet, but there is another technique, allowing you to enter information in a fres of cells, which will help.
If you 2007 to fdee information in a block wider than one column you may find it easiest to select the whole fuide using the mouse or microsoft office excel 2007 user guide pdf free. You may then enter information, pressing return after each value. Excel will move you through the cells, and up to the top of the next column when you reach the end of the current one.
Be careful not to overtype the contents! Birkbeck IT Services 5. Calculations Objectives Method To set the нажмите чтобы увидеть больше up to perform calculations on the data we have input Use the autosum function to setup cells that perform calculations Comments The autosum function can be used for a variety of calculations 3.
The sum of the selected area and other common functions, such as the highest number and average is displayed at the bottom of the screen, on the right. This is one advantage of pre-selecting the area to be filled, as in больше информации. Select a few of the cells on your spreadsheet Note the Sum, shown at the bottomright of your screen This is, of course, адрес страницы only for an immediate check of the total.
Excel is clever enough to understand на этой странице if you copy and paste a 6 Birkbeck IT Services. It also works for formulae Fres on the drag handle in the total for row E Usee it across until all узнать больше здесь rows have their totals calculated Figure Excel will automatically update the totals - change some of the values to test it out.
Birkbeck IT Services microsoft office excel 2007 user guide pdf free. Amending the worksheet Objectives To add another expense to our budget Method Use the commands on the Insert menu to перейти to micosoft worksheet Comments Excel microsoft office excel 2007 user guide pdf free automatically update the calculations to take account of the inserted information 4.
Excel will allow us to insert a column or row Click into any cell in row 7 At the top of the screen, click the lower-half of the Insert button Click Insert Sheet Rows A new row is pvf, and all those to the right of it are re-labelled You may insert columns similarly.
Microsoft office excel 2007 user guide pdf free Click into any cell ffree column B Click Insert Click Insert Sheet Columns A new column is inserted Note that, despite the commands referring to columns and rows, only one will be entered unless you have selected multiple rows or columns. With any item selected, /16802.txt the top-half of the Insert button will insert another of the same so with a cell selected, it will adobe illustrator cs5 crack vn zoom free a cell, selecting a row by clicking on its number on the left will insert a row and selecting a column by clicking on its letter heading will make the Insert button add a column.
The row and column labels at the edge of the worksheet A,B,C; 1,2,3 etc allow you to ecel a whole row or column. Formatting the Worksheet Objectives To enhance the layout of the spreadsheet Method Use Excel s formatting options to control the layout and appearance of the cells within the worksheet Comments The old-style Format-Cells dialogue may be accessed through the icon next to the Alignment group on the Home Ribbon the popup is useful as it combines many different layout options in one place 5.
To fix it click on the A at the pdt of the column to select the entire column Click on the Format icon and select Autofit column width You may also manually scale the column. To do so it is not necessary to select the entire column first. Birkbeck IT Services 9. It would look a little too busy if added to every cell, however, so we will just apply it to the Total row Select the row containing totals Click on the Accounting Number Format icon note that clicking the arrow on its right allows you to choose different ghide We may apply other formatting using the Adobe cc 2017 free Ribbon Select the row above the totals In the Font group, click on the micrisoft icon shown Select the Bottom Double Border style from the menu You may also change the font size from this tool group.
Note that displayed in a cell, as in Figuredenotes a column width too narrow for the information contained therein widen the column to display the data. Figure Figure Click away from the selected cells to see the effect of your changes 5.
Choose one of the Headingx options The text is still aligned with the bottom of the cells to change that we should use the Format Cells dialogue box. That box is accessible from several different icons on the Home Ribbon.
Click the icon in the Alignment group and change the vertical alignment to Center Note the other options on this tab, allowing you to orient text at a different angle. Both wrap text and merge cells have their own icon on the Home На этой странице. Select several cells and then click the merge and centre icon to turn them into one cell and align gude heading.
Birkbeck IT Services In normal usage you will probably need to switch between the two for best effect 6. Pdg are selfexplanatory see the screenshot above. Use the Orientation button to change the Page use to Landscape Click guive icon on the Scale to 20077 tool group Нажмите для продолжения Page Setup dialogue appears Click the radio button next to Fit to Click the Print Preview button The spreadsheet is scaled to fit onto one page, which works well with our example, as it does not need to be reduced by much and is still legible.
With larger amounts of data, of guidd, there is the danger of creating a printout too small to read. Figure Centre the Data The options on the Margins tab allow you to change print margins, and also to centre your microsoft office excel 2007 user guide pdf free on the page when printing. You may also use the dedicated Margins icon on the Page Layout Ribbon.
Click on the Margins tab on the Page Setup dialogue box use the icon to show it if you have closed the window Tick the boxes under Center on page, as shown in Figure Birkbeck IT Services Figure Birkbeck IT Services. As we детальнее на этой странице just seen, pasting a formula into a selected block allows quick replication of that calculation across rows or columns. Inserting a chart Objectives Method To insert a chart into our workbook Select the data to use, источник статьи use Excel frwe chart wizard to choose the type and layout microsoft office excel 2007 user guide pdf free the graph 8.
We will look at how to insert a chart based on the data we select. Select January s expenses and the headings, as shown in Figure Note that you may need to adjust the figure for staffing and others so that they are not too different from each other Selecting the data tells Excel which information it should create a chart from Figure On the Insert Ribbon, click on Pie and choose a type Figure Options The chart is immediately added to your spreadsheet.
Click and drag the white background area of the chart to move it around the sheet Click into the chart s title to amend it Figure Birkbeck IT Services.
Excel A Beginners Guide Beginner Introduction The aim of this document microsoftt to introduce some basic techniques for using Excel to enter data, perform calculations and produce simple charts based on. Ribbon menu The Ribbon menu system with tabs for various Excel commands. This Ribbon system replaces the traditional menus used with Excel Above the Ribbon in kicrosoft upper-left corner is the Microsoft. Excel Basics Learning Guide Exploring Excel At first glance, the new Excel interface may seem a bit unsettling, with fat bands called Ribbons replacing cascading text menus and task bars.
Basic Microsoft Excel The biggest difference between Excel and its predecessors is the new layout. All of the old functions are still kicrosoft with some new additionsbut they are microsoft office excel 2007 user guide pdf free located.
You can use Excel to create and format workbooks a collection of spreadsheets in order to analyze data and. Intro to Excel spreadsheets What are the objectives of this document?
The objectives of document are: 1. Familiarize offcie with what a spreadsheet is, how it works, and what its capabilities are; 2. Introduction 1. Starting Publisher 2. Create a Poster Template 5. Aligning your images and text 7. Apply a background Add text to your poster Microsoft office excel 2007 user guide pdf free pictures offoce your poster Add graphs. Activity Card Create a How will you ensure that your expenses do not exceed what you planned to invest or spend?
You can microsoft office excel 2007 user guide pdf free a budget to plan your expenditures and earnings. As нажмите чтобы увидеть больше family, you can plan. Introduction To Microsoft Office Excel Больше информации is a stock? A stock is a share in the ownership of a corporation, a large business organization. A stock, also, represents.
Working with Tables in Microsoft Word The purpose of this document is to lead you through mucrosoft steps of creating, editing and deleting tables and parts of tables. This document follows a tutorial format. A worksheet is a grid, made up of columns, which are. Introduction Excel Level Two This workshop introduces you to formulas, functions, moving and copying data, using autofill, relative and absolute references, and formatting cells.
Comments
Post a Comment