Notes de cours excel.docx

18 Pages

Business Technology Management
Course Code
BTM 481

This preview shows pages 1,2,3,4. Sign up to view the full 18 pages of the document.
1INTRODUCTION TO EXCEL What Is a SpreadsheetIntroduction to SpreadsheetsRegardless of what type of quantitative analysis you need to do you can use a spreadsheet to help you maintain data and perform calculations A spreadsheet is an electronic file that contains a grid of columns and rows used to organize related data and to display results of calculations enabling interpretation of quantitative data for decision making A spreadsheet program is a computer application such as Microsoft Excel that you use to create and modify electronic spreadsheetsPlanning for Effective Workbook and Worksheet DesignA worksheet is a single spreadsheet that typically contains descriptive labels numeric values formulas functions and graphical representations of dataA workbook is a collection of one or more related worksheets contained within a single file By default new workbooks contain three worksheetsAn input area is a range of cells containing values for variables used in formulasAn output area is a range of cells containing results based on manipulating the variablesExploring the Excel WindowExcel elements The Name Box is an identifier that displays the address of the cell currently used in the worksheet You can use the Name Box to go to a cell assign a name to one or more cells or select a functionCancel appears to the right of the Name Box when you enter or edit data Click Cancel to cancel the data entry or edit and revert back to the previous data in the cell if any Cancel disappears after you click itEnter appears to the right of the Name Box when you enter or edit data Click Enter to accept data typed in the active cell and keep the current cell active The Enter check mark disappears after you enter the dataInsert Function Click to display the Insert Function dialog box which enables you to search for and select a function to insert into the active cellThe Formula Bar the area that appears below the Ribbon and to the right of Insert Function shows the contents of the active cell You can enter or edit cell contents here or directly in the active cell Drag the bottom border of the Formula Bar down to increase the space of the Formula Bar in order to display large amounts of data or a long formula contained in the active cellSelect All The square at the intersection of the row and column headings in the topleft corner of the worksheet Click it to select everything contained in the active worksheetColumn headings The letters above the columns such as A B C and so onRow headings The numbers to the left of the rows are row headings such as 1 2 3 and so onSheet tabs located at the bottomleft corner of the Excel window show the names of the worksheets contained in the workbook Three sheet tabs initially named Sheet1 Sheet2 and Sheet3 are included when you start a new Excel workbook You can rename sheets with more meaningful names To display the contents of a particular worksheet click its sheet tabSheet Tab Navigation buttons If your workbook contains several worksheets Excel may not show all the sheet tabs at the same time Use the buttons to display the first previous next or last worksheetStatus bar Located at the bottom of the Excel window below the sheet tabs and above the Windows taskbar the status bar displays information about a selected command or operation in progress For example it displays Select destination and press ENTER or choose Paste after you use the Copy commandIdentify columns rows and cellsThe intersection of a column and row is a cell a total of over 17 billion cells are available in a worksheet Each cell has a unique cell address identified first by its column letter and then its row numberNavigate In and Among WorksheetsThe active cell is the current cellNavigate through cells with the scroll buttons or the mouse Navigate among worksheets with the sheet tabEntering and Editing Cell DataThe four types of data that you can enter in a cell in an Excel worksheet are text values dates and formulas including functionsEnter TextText is any combination of letters numbers symbols and spaces not used in calculationsAligns to the leftEnter ValuesValues are numbers that represent a quantity or a measurable amountValues align to the rightEnter datesYou can enter dates and times in a variety of formats in cells such as 9152012 91512 September 15 2012 or 15Sep12 You can also enter times such as 130 PM or 1330 You should enter a static date to document when you create or modify a workbook or to document the specific point in time when the data were accurate such as on a balance sheet or income statementDates are values and align to the rightEnter FormulasFormulas are the combination of cell references arithmetic operations values andor functions used in a calculation For Excel to recognize a formula you must start the formula with an equal sign 2MATHEMATICS AND FORMULASUsing Symbols and the Order of PrecedenceAddition SubtractionMultiplicationDivisionExponentiation Start a formula by typing the equal signfollowed by the arithmetic expression Do not include a space before or after the arithmetic operator To add the contents of cells A2 and A3 enter A2A3 The result appears in the cell instead of the formula itself You can see the formula of the active cell by looking at the Formula BarYou should use cell addresses instead of values as references in formulas where possible You may include values in an input areasuch as dates salary or coststhat you will need to reference in formulas Referencing these cells in your formulas instead of typing the value of the cell to which you are referring keeps your formulas accurate if the values changeControl the Results with the Order of PrecedenceThe order of precedence also called order of operations is a rule that controls the sequence in which arithmetic operations are performed which affects the results of the calculation Excel performs mathematical calculations left to right in this order Parentheses Exponentiation Multiplication or Division and finally Addition or Subtraction Please Excuse My Dear Aunt SallyUsing Auto FillAuto Fill enables you to copy the contents of a cell or a range of cells by dragging the fill handle a small black square appearing in the bottomright corner of a cell over an adjacent cell or range of cellsCopying Formulas with Auto Fill After you enter a formula in a cell you can duplicate the formula down a column or across a row without retyping it by using Auto Fill Excel adapts each copied formula based on the type of cell references in the original formulaCompleting Sequences with Auto Fill You can also use Auto Fill to complete a sequence January510Displaying Cell FormulasYou might want to display the formulas instead of the calculated results in the cells The quickest way to display cell formulas is to press Ctrl and the grave accentkey sometimes referred to as the tilde key in the topleft corner of the keyboard below Esc You can also click Show Formulas in the Formula Auditing group on the Formulas tab to show and hide formulas This is a toggle feature do the same step to redisplay formula results3WORKBOOK AND WORKSHEET MANAGEMENTManaging WorksheetsYou should rename the worksheet tabs to reflect the sheet contents so that you and anyone with whom you share your workbook will be able to find dataYou can also change the worksheet tab colour to make it stand out You can Insert Delete Move and Copy WorksheetsManaging Columns and RowsInsert Cells Columns and RowsAfter you construct a worksheet you might need to insert cells columns or rows to accommodate new data When you insert cells rows and columns cell addresses in formulas adjust automaticallyExcel inserts new columns to the left of the current column and new rows above the current rowDelete Cells Columns and RowsIf you no longer need a cell column or row you can delete it In these situations you are deleting the entire cell column or row not just the contents of the cell to leave empty cells As with inserting new cells any affected formulas adjust the cell references automatically
More Less
Unlock Document

Only pages 1,2,3,4 are available for preview. Some parts have been intentionally blurred.

Unlock Document
You're Reading a Preview

Unlock to view full version

Unlock Document

Log In


Join OneClass

Access over 10 million pages of study
documents for 1.3 million courses.

Sign up

Join to view


By registering, I agree to the Terms and Privacy Policies
Already have an account?
Just a few more details

So we can recommend you notes for your school.

Reset Password

Please enter below the email address you registered with and we will send you a link to reset your password.

Add your courses

Get notes from the top students in your class.