Excel Notes - Block #3

57 %
43 %
Information about Excel Notes - Block #3
Education

Published on March 10, 2014

Author: atellezf

Source: slideshare.net

Campus Lago de Guadalupe Excel Microsoft Student’s Notebook Block #3 M. Alejandro Téllez Flores

Campus Lago de Guadalupe Student’s Notebook Excel Student’s notebook rules: 1. You must pay attention, in order to take notes. 2. These slides won’t be published on OneDrive 3. You must create your own Student’s Notebook 4. You may work in teams with a maximum of 4 members 5. The team must deliver their notebook by email, in order to earn the corresponding grade.

Campus Lago de Guadalupe Student’s Notebook Excel Student’s notebook rules: 6. The team must deliver a professional look document. 7. You’re free to use any tool you want to take notes. 8. Evaluation will be according to every lecture block 9. Each block consists of 10 credits 10.The team must earn 30 credits at the end of each evaluation period.

Campus Lago de Guadalupe Student’s Notebook Excel Student’s notebook rules: 11.Team leaders will be chosen by your teacher. 12.Each leader is entitled to choose up to 3 members 13.Each team leader is responsible of delivering the student’s book by email. 14.Each team leader is responsible of his/her team. 15.If any team member does not behave in a proper way, the team shall be penalized each time with 1 credit less.

Campus Lago de Guadalupe Student’s Notebook Excel Formulas Formulas are always preceded by the equal sign, it’s the way to differentiate between an operation and regular text. A B C 1 VAT 16% 2 Subtotal $ 1,245.00 3 Taxes $ 199.20 4 Total $ 1,444.20 5 6 =B3×$C$2 =B3+B4

Campus Lago de Guadalupe Student’s Notebook Excel Functions Functions are written inside a formula. Functions in a spreadsheet, are like functions in mathematics, they receive parameters as input, a process, and an output value. Review documentation for each function. A B C 1 NAME ATTENDANCE GRADE 2 John 25 73 3 Abigail 24 98 4 Charles 18 60 5 Cinthya 23 89 6 90 80 =AVERAGE(C3:C6) =SUM(B3:B6)

Campus Lago de Guadalupe Student’s Notebook Excel Function Categories Database functions Date and time functions Engineering functions Financial functions Information functions Logical functions Lookup and reference functions Math and trigonometry functions Statistical functions Text functions

Campus Lago de Guadalupe Student’s Notebook Excel Formulas between spreadsheets Now it’s time to create a spreadsheet with expenses from the first quarter. A B 1 PRODUCT COST 2 Screwdriver $ 4.25 3 Spanner $ 6.00 4 Hammer $ 8.00 5 Chisel $ 5.42 6 JANUARY A B 1 PRODUCT COST 2 Screwdriver $ 4.65 3 Spanner $ 6.50 4 Hammer $ 8.35 5 Chisel $ 5.00 6 FEBRUARY A B 1 PRODUCT COST 2 Screwdriver $ 4.20 3 Spanner $ 6.30 4 Hammer $ 8.00 5 Chisel $ 6.00 6 MARCH

Campus Lago de Guadalupe Student’s Notebook Excel Formulas between spreadsheets =JANUARY!B2 + FEBRUARY!B2 + MARCH!B2 A B 1 PRODUCT COST 2 Screwdriver $ 13.10 3 Spanner $ 18.80 4 Hammer $ 24.35 5 Chisel $ 16.42 6 2014Q1 =JANUARY!B3 + FEBRUARY!B3 + MARCH!B3 =JANUARY!B4 + FEBRUARY!B4 + MARCH!B4 =JANUARY!B5 + FEBRUARY!B5 + MARCH!B5

Campus Lago de Guadalupe Student’s Notebook Excel Formulas between spreadsheets A B 1 MONTH EXPENSES 2 January $ 4.65 3 February $ 6.50 4 March $ 8.35 5 $ 5.00 6 2014Q1 =SUM(JANUARY!B2:B5) =SUM(FEBRUARY!B2:B5) =SUM(MARCH!B2:B5) =SUM(B2:B5)

Campus Lago de Guadalupe Student’s Notebook Excel Excel Named Ranges A name that represents a cell, range of cells, formula, or constant value. You can create your own defined name, and Microsoft Office Excel sometimes creates a defined name for you

Campus Lago de Guadalupe Student’s Notebook Excel Excel Named Ranges 1. Select the range you desire. 2. In the name box type the desired name Easy way • In this way, names are registered in the workbook scope • Names always start with letters, and can’t use white spaces

Campus Lago de Guadalupe Student’s Notebook Excel Excel Named Ranges 1. Select the range that you want to name, including the row or column labels. 2. On the Formulas tab, in the Defined Names group, click Create from Selection. 3. In the Create Names from Selection dialog box, designate the location that contains the labels by selecting the Top row, Left column, Bottom row, or Right column check box. Define a name by using a selection of cells in the worksheet

Campus Lago de Guadalupe Student’s Notebook Excel Excel Named Ranges 1. On the Formulas tab, in the Defined Names group, click Define Name. 2. In the New Name dialog box, in the Name box, type the name that you want to use for your reference. 3. To specify the scope of the name, in the Scope drop-down list box, select Workbook or the name of a worksheet in the workbook. 4. In the Refers to box, do one of the following: a. Cell reference b. Constant c. Formula Define a name by using the New Name dialog box

Campus Lago de Guadalupe Student’s Notebook Excel Excel Named Ranges Use the Name Manager dialog box to work with all of the defined names and table names in the workbook. ! In this dialog box, you can also sort and filter the list of names, and easily add, change, or delete names. ! To open the Name Manager dialog box, on the Formulas tab, in the Defined Names group, click Name Manager. Manage names by using the Name Manager dialog box

Campus Lago de Guadalupe Student’s Notebook Excel Excel Named Ranges • Valid characters The first character of a name must be a letter, an underscore character (_), or a backslash (). Remaining characters in the name can be letters, numbers, periods, and underscore characters. • Cell references disallowed Names cannot be the same as a cell reference, such as Z$100 or R1C1. • Spaces are not valid Spaces are not allowed as part of a name. Use the underscore character (_) and period (.) as word separators; for example, Sales_Tax or First.Quarter. • Name length A name can contain up to 255 characters. • Case sensitivity Names can contain uppercase and lowercase letters. Excel does not distinguish between uppercase and lowercase characters in names. Syntax rules for names

Campus Lago de Guadalupe Student’s Notebook Excel Excel Named Ranges Using Named Ranges

Campus Lago de Guadalupe Student’s Notebook http://1drv.ms/1cEzlA8 For further information,

Add a comment

Related presentations

Related pages

Notes on Excel Calculations - Fuqua School of Business

Notes on Excel Calculations EXCEL REVIEW 2007 . ... 3 Excel’s formula operators specify the type of calculation to perform on the elements of a formula.
Read more

Excel Training Notes - College of Micronesia

Excel Training Day One ... These notes are designed to be used in a workshop environment in ... Excel 97 ONLY: This is step 3 in Excel 97 and the dialog ...
Read more

Excel VBA File Notes: Macro Basics - Fontstuff Ltd.

Title: Excel VBA File Notes: Macro Basics Author: Martin Green (martin@fontstuff.com) Last modified by: Martin Green Created Date: 4/3/2002 10:48:00 AM
Read more

Excel VBA Course Notes: 2 - Fontstuff Ltd.

Title: Excel VBA Course Notes: 2 Author: Martin Green (martin@fontstuff.com) Last modified by: Martin Green Created Date: 3/23/2001 1:54:00 PM Other titles
Read more

Microsoft Excel training notes - SchoolNet SA

Title: Microsoft Excel training notes Author: Richard Shotton Last modified by: bsingh Created Date: 11/6/2004 4:26:00 PM Company: RM Network: Build 12
Read more

How to Add Comments to an Excel Worksheet Cell

How to Add Comments to an Excel Worksheet Cell. ... Excel 2010 and Excel 2013. Comments are basically notes that can be inserted into any cell in Excel.
Read more

Using Excel - Economics

1.3 Using Excel for Calculations 1.3.1 Arithmetic operations 1.3.2 Mathematical functions 1.4 Excel Files for Principles of Econometrics
Read more

Excel Formula Notes Software - WinSite

Excel Formula Notes, free excel formula notes software downloads, Page 3.
Read more

IM340 - Excel Notes - Western Illinois University

3. HEADINGS with name, ... Saving Excel Worksheet Files: ... IM340 - Excel Notes Author: Lawrence L. Andrew Last modified by:
Read more