Prueba 1 Excel

In: Business and Management

Submitted By marcodelgado
Words 6379
Pages 26
Excel Tutorial to Improve Your Efficiency (2007 Version)
Introduction
My purpose with this Excel tutorial is to illustrate some Excel tips that will dramatically improve your efficiency. I make no attempt to be as encyclopedic as some of the 800-page Excel manuals available. I concentrate on common tasks, not every last thing that can be done in Excel. Also, I presume that you have some Excel knowledge. For example, I assume you know about rows and columns, values, labels, and formulas, relative and absolute addresses, and other basic Excel elements. If you know virtually nothing about Excel, you probably ought to work through an “Excel for Dummies” book and then work through this tutorial.
The style of this tutorial should be easy to follow. Main topics appear in bold black type. Specific direction headings are in yellow, and these are followed by detailed directions in red. Additional comments about the directions appear in blue. Then there are “Try it!” exercises in green. These “Try it!” exercises are a key feature of this tutorial. I have embedded numerous sample Excel spreadsheets so that you can try out the directions right away—without switching into Excel. When you double-click on one of these spreadsheets, you launch Excel, and the spreadsheet “comes alive.” The menus and toolbars even change to those for Excel. By clicking outside one of these spreadsheets, you’re back in Word.
The easiest way to maneuver around this tutorial is to switch to outline view. To do so, select Outline from Word’s View ribbon, which gives you an extra Outlining ribbon. From this ribbon, click on the Show Level dropdown. This lets you choose the level of the outline. You’ll get good results by choosing Level 2. This lets you see all first-level and second-level headings. Put your cursor on a heading of interest and then switch back to normal view by selecting Print Layout,…...

Similar Documents

Pruebas En Transformadores

...PRUEBAS DE TRANSFORMADORES Pruebas Eléctricas en Transformadores Para los transformadores de potencia existe una rutina de pruebas de mantenimiento predictivo que complementan los análisis fisicoquímicos y de cromatografía de gases que se realizan en el aceite dieléctrico aislante, estas pruebas son de tipo eléctrico y sirven para determinar si el transformador conserva sus características electromecánicas. Estas pruebas se realizan directamente sobre el transformador des-energizado con resultados inmediatos y permiten tomar decisiones sobre la necesidad de programar actividades de mantenimiento preventivo y/o correctivo antes de que ocurra una falla grave. Análisis Cromatográfico Los equipos eléctricos inmersos en aceite aislante como los transformadores de potencia, poseen en su constitución un conjunto de materiales que son en su mayoría compuestos orgánicos, estos materiales sometidos a defectos y/o fallas (térmicas, eléctricas o mecánicas) se descomponen formando gases. Así mismo, el análisis de estos gases permite identificar la ocurrencia del defecto y/o fallas asociadas a los materiales dieléctricos, y permite determinar la condición de operación del equipo. La cromatografía es una técnica de análisis de gas, capaz de procesar pequeñas muestras con gran sensibilidad y precisión, constituyéndose en un instrumento poderoso para la identificación de una falla incipiente. Mediante este análisis se detectan fallas incipientes o avanzadas como descargas......

Words: 2141 - Pages: 9

Excel

...ADVANCED EXCEL TRAINING Quality Management Objective  To provide the participants with an understanding of the advanced features of MS Excel Today is 7/22/2011 2 Advanced  ® EXCEL Topics Working with Data Lists Naming Cells and Ranges   Conditional Functions Lookup Functions   Pivot Tables Data Validation  Today is 7/22/2011 3 Naming Cells and Ranges Today is 7/22/2011 4 Name cells by using labels Name cells by using existing row and column labels Select the range you want to name, including the row or column labels. On In the Insert menu, point to Name, and then click Create. the Create names in box, designate the location that contains the labels by selecting the Top row, Left column, Bottom row, or Right column check box. Note A name created by using this procedure refers only to the cells that contain values and does not include the existing row and column labels. Today is 7/22/2011 5 Name a Cell or Range Using Names Box  1. Select the cell or range you want to name.  2. Click the Name box on the formula bar.  3. Type a name for the range. A range name can include uppercase or lowercase letters, numbers, and punctuation, but no spaces. Try to use a simple name that reflects the type of information in the range, such as BookTitle.  4. Press Enter. The range name will appear in the Name box whenever you select the range. Today is 7/22/2011 6 Conditional......

Words: 1579 - Pages: 7

Week 1 Excel Bis 155

...Trust 123 Adams Street Pittsburgh, PA 15697 Huong Pham P.O. Box ABC Pittsburgh, PA 15697 Dear Huong: Thank you for your generous donation to the XYZ Corporation Charitable Trust Fundraiser. We are delighted to accept the following donation: Item: Restaurant Gift Certificate Item Value: $60.00 Enclosed you will find 1 the tickets you requested for this Fundraising event, which will take place on Friday, October 24, 2007. We will be looking forward to seeing you and giving our personal thanks. Thank you again for your support of the fund. The proceeds will support international animal rescue efforts. With special thinks, Jeoffrey McMillan Charitable Trust President XYZ Corporation 9/24/2007 XYZ Corporation Charitable Trust 123 Adams Street Pittsburgh, PA 15697 George Martin 555 Kaminini Street Pittsburgh, PA 15697 Dear George: Thank you for your generous donation to the XYZ Corporation Charitable Trust Fundraiser. We are delighted to accept the following donation: Item: Car Wash Card Item Value: $50.00 Enclosed you will find 1 the tickets you requested for this Fundraising event, which will take place on Friday, October 24, 2007. We will be looking forward to seeing you and giving our personal thanks. Thank you again for your support of the fund. The proceeds will support international animal rescue efforts. With special......

Words: 3113 - Pages: 13

Prueba

...La mini-guía para el Pensamiento crítico Conceptos y herramientas por Dr. Richard Paul y Dra. Linda Elder Fundación para el Pensamiento Crítico www.criticalthinking.org 707-878-9100 cct@criticalthinking.org Una mini-guía para el pensamiento crítico, conceptos y herramientas 2 ¿Por qué una mini-guía para el pensamiento crítico? Esta mini-guía se diseñó para administradores, profesores y estudiantes. Contiene los conceptos y herramientas esenciales en un formato de bolsillo cómodo. Para los profesores, incluye un concepto compartido de lo que es el pensamiento crítico. Para los estudiantes, provee un complemento a cualquier libro de texto. Los profesores pueden usar la guía en su diseño curricular, en las tareas y en las pruebas para los estudiantes de cualquier disciplina. Los estudiantes pueden usarla para mejorar su aprendizaje de cualquier área. Las destrezas incluidas pueden aplicarse a cualquier tema. Por ejemplo, aquel que piensa críticamente tiene un propósito claro y una pregunta definida. Cuestiona la información, las conclusiones y los puntos de vista. Se empeña en ser claro, exacto, preciso y relevante. Busca profundizar con lógica e imparcialidad. Aplica estas destrezas cuando lee, escribe, habla y escucha al estudiar historia, ciencia, matemática, filosofía y las artes así como en su vida personal y profesional. Cuando esta mini guía se usa como complemento a un libro de texto en varios cursos, los estudiantes empiezan a darse cuenta de la utilidad......

Words: 5356 - Pages: 22

Excel

...Project Description: You are an analyst for an art gallery that is an authorized Greenwich Workshop® fine art dealer. You prepared a list of artwork by James Christensen and need to organize the data using an outline, subtotals, PivotTables, and PivotCharts to aid you in analyzing the data, which you will do in this project. Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible 1 Start Excel. Download, save, and open the file named Exploring_e05_Grader_EOC.xlsx. 0 2 Sort the data on the Subtotals worksheet first by the Type column, then by the Art column, both in alphabetical order. 4 3 Subtotal the data at each change in Type. Identify the highest issue price, estimated value, and percent increase. 10 4 Add an automatic outline to the Subtotals worksheet. Group the first and last name columns. Collapse the names columns, and then collapse columns created by the outline (G, H, and I). 7 5 Create a PivotTable on a new worksheet using the data on the Christensen worksheet in the range A1:J19. Use the Type, Est. Value, and Issue Price fields and use the default locations in the PivotTable Layout. 8 6 Modify the Issue Price and Est. Value values to determine the average issue price and average estimated market value by type. 6 7 Insert a calculated field named % Change in Value to determine the percent change in values by type. Format the values in the new column as percentages......

Words: 312 - Pages: 2

Excel

...Microsoft Excel 2010 Formulas & Functions  Table of Contents Excel 2010 Formulas & Functions ……………………………………………….….. o Formula Basics ……………………………………………….….. o Order of Operation ……………………………………………….….. Conditional Formatting ……………………………………………….….. Cell Styles ……………………………………………….….. Formulas & Functions ……………………………………………….….. Basic Formulas ……………………………………………….….. o Add the Values in Rows or Columns ……………………………………………….….. o Find the Average, Maximum, or Minimum ……………………………………………….….. Ranges & Individual Cells ……………………………………………….….. Copy a Formula ……………………………………………….….. o Using the Fill Handle ……………………………………………….….. o Using Traditional Copy & Paste ……………………………………………….….. Referencing Cells in Formulas ……………………………………………….….. o Relative References ……………………………………………….….. o Absolute References ……………………………………………….….. o Mixed References ……………………………………………….….. o References to Other Worksheets ……………………………………………….….. o Other Workbook References ……………………………………………….….. Quick Reference Guide ……………………………………………….….. o Add, Subtract, Multiple & Divide ……………………………………………….….. o Understanding Error Values ……………………………………………….….. Practical Purposes of Excel Formulas ……………………………………………….….. o Using Date & Time Formulas ……………………………………………….….. Commonly Used Functions & Formulas ……………………………………………….….. o Math & Trig Icon ……………………………………………….….. Logical Icon ……………………………………………….….. Lookup & Reference Icon ……………………………………………….….. Date & Time Icon ……………………………………………….….. AutoSum Icon ……………………………………………….…........

Words: 5629 - Pages: 23

Prueba Econometria

...REPASO PARA LA PRUEBA 1 1) ¿ Es !´!´!  un escalar? Razone su respuesta 2) ¿ Es !´!!  un escalar? Razone su respuesta. 3) Dados los siguientes datos X= 1 1 1 1 1 -1 0 1 2 1 !´ = [2    2    5    10    5] 47 −39 −33 19*(X´X) =   36 29 26 -1 2 2 0 -1 0 Dado el modelo  ! = !" + ! a) Estime el vector de parámetros del modelo. b) A partir de su respuesta a la pregunta anterior obtenga los valores ajustados y los residuos. Verifique con sus datos que ! ! ! ! ! !!! !! =0 , !!! ! = !!! ! c) Calcule el R2. d) Calcule la matriz de varianzas y covarianzas de los estimadores. e) Con estos datos, calcule el producto indicado en las preguntas 1) y 2). 4) Dado el modelo  ! = !" + ! a) Escriba el problema de minimización de los MCO. b) Derive las condiciones de primer orden. c) Derive las condiciones de segundo orden y establezca que se debe cumplir para obtener un mínimo. 5) Demuestre que los estimadores de MCO son insesgados y halle la matriz de varianzas y covarianzas. 6) Demuestre que el vector de estimadores de MCO tiene varianza mínima. 7) Dado el modelo  ! = !" + !, i=1,2, …….17, k=2 El vector de los estimadores de los parámetros es ! = 1,37 1,14 −0,83 También hemos obtenido la siguiente expresión escalar !´[! − !(!´!)!! !´]Y = 0,0028 y los elementos de la matriz (!´!)!! son 510,89 −254,35 0,42 132,70 −6,82 7,11 a) b) c) d)   8) Sea  ! = !(!´!)!! !   Demuestre que     Calcular !"# !! , !"# !! , !"# !! Contraste la hipótesis que !! = 1.......

Words: 404 - Pages: 2

Excel

...New Perspectives Excel 2013 Tutorial 3: SAM Project 1a Spring Software ENHANCE A TIMESHEET Project Goal M Project Name Project Goal New Perspectives Excel 2013 Tutorial 3: SAM Project 1a Spring Software ENHANCE A TIMESHEET Project Goal M Project Name Project Goal PROJECT DESCRIPTION Devon Hastings is the human resources director for Spring Software, a software development company in Cambridge, Massachusetts. He has created a workbook for employees to use in recording the hours they work. He would like your help finishing the timesheet. GETTING STARTED * Download the following file from the SAM website: * NP_Excel2013_T3_P1a_FirstLastName_1.xlsx * Open the file you just downloaded and save it with the name: * NP_Excel2013_T3_P1a_FirstLastName_2.xlsx * Hint: If you do not see the .xlsx file extension in the Save file dialog box, do not type it. Excel will add the file extension for you automatically. * With the file NP_Excel2013_T3_P1a_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. If cell B6 does not display your name, delete the file and download a new copy from the SAM website. PROJECT STEPS 1. On the Employee List worksheet, select cells A1:B1 and then use the Format Painter copy the format only to the range A2:B9. 2. In cell B1 enter bs001, in cell B2 enter cg001, in cell B3 type dh001, and then use Flash......

Words: 790 - Pages: 4

Bis 155 Week 1 : Excel Fundamentals and Charting – Quiz

...BIS 155 Week 1 : Excel Fundamentals and Charting – Quiz http://homeworkfy.com/downloads/bis-155-week-1-excel-fundamentals-and-charting-quiz/ BIS 155 Week 1 : Excel Fundamentals and Charting – Quiz BIS 155 Week 1 Quiz 1. (TCO 1) Which of the following describes the function of the Formula Bar (as it applies to Excel 2010)? (Points : 2) 2. (TCO 1) Which of the following best describes a cell address? (Points : 2) 3. (TCO 1) If you wanted to insert the current date into an active cell, which of the following would you use? (Points : 2) 4. (TCO 1) In Excel a Formula is _______. (Points : 2) 5. (TCO 1) Which of the following describes the Auto Fill in Excel 2010? (Points : 2) 6. (TCO 1) Ribbon Commands with arrows indicate_____. (Points : 2) 7. (TCO 1) The three types of data that can be entered in a cell in an Excel worksheet are __________. (Points : 2) 8. (TCO1) In Excel, a border ________. (Points : 2) 9. (TCO 3) A data series is a group of related ____________. (Points : 2) 10. (TCO 3) A __________ is usually the most effective way to display proportional relationships, such as market share data, where the individual data values represent parts of a whole. (Points : 2) 11. (TCO 3) When creating a chart in Excel, a single data series _____. (Points : 2) 12. (TCO 3) To display similar data in a single column, with each series of data distinguished by a different color, use a: (Points : 2) 13. (TCO 3) To provide your viewers with an explanation of the......

Words: 312 - Pages: 2

Prueba de Chi Cuadrado

...PRUEBAS NO PARAMÉTRICAS Distribución chi-cuadrada ( 2) Las aplicaciones más comunes de la distribución chi-cuadrada son (1) pruebas de bondad de ajuste y (2) pruebas de independencia. 1.- Pruebas de bondad de ajuste Medidas sobre qué tan cerca se ajustan los datos muestrales observados a una forma de distribución particular planteada como hipótesis. Si el ajuste es razonablemente cercano, puede concluirse que si existe la forma de distribución planteada como hipótesis. Prueba chi-cuadrada donde k: k = m-1: grados de libertad donde m es el número de parámetros o productos a estimar. EJEMPLO. Juan Pérez, director de Mercadeo de Pasta Dental, tiene la responsabilidad de controlar el nivel de existencias para cuatro tipos de Productos distribuidos por su fábrica. En el pasado, ha ordenado nuevos productos bajo la premisa de que los cuatro tipos son igualmente populares y la demanda de cada tipo es la misma. Sin embargo, recientemente las existencias se han vuelto más difíciles de controlar, y Juan considera que debería probar su hipótesis respecto a una demanda uniforme. Sus hipótesis son: H0: La demanda es uniforme para los cuatro tipos de productos. H1: La demanda no es uniforme para los cuatro tipos de productos. La Tabla 1.1 muestra la expectativa uniforme para una muestra de 48 pastas vendidas en los últimos seis meses todos los valores en......

Words: 606 - Pages: 3

Excel

...Supplementary Material Professor: Daniel Egger October 14, 2015 1 1.1 Binary Classification Diagram of Confusion Matrix with Basic Definitions In the confusion matrix, you have two classifications, “Positive” or “Negative,” with the underlying, true conditions being either “+” or “-”. Examples of Binary Conditions: Radar - Enemy Bomber/No Enemy Bomber Diagnostics - Cancer/No Cancer Credit Scoring - Borrower defaults/does not default Outcome Y Table 1: Confusion Matrix. Classification/Test,X “Test Positive” “Test Negative” c d “+” a e f “-” b g h Where, (a,b) is the Marginal Probability Distribution of Condition p(Y ). Note that the rarer of the two is traditionally assigned to “+” and the probability p(a) is called the “incidence” of a. (c,d) is the Marginal Probability Distribution of the Classification p(X) (e,f,g,h) is the Joint Probability Distribution of the Condition and the Classification, p(X, Y ). Another way of representing the confusion matrix is: 1 Outcome 1.2 Table 2: Confusion Matrix, another representation. Classification/Test,X “Test Positive” “Test Negative” c d ”+” a ”True Positive” (TP) ”False Negative” (FN) Y ”-” b ”False Positive” (FP) ”True Negative” (TN) Important Measures of the Confusion Matrix True Positive (TP) Rate: The conditional probability that someone with the condition has a positive test. e = p(T estP ositive|+) a False Negative (FN) Rate: The conditional probability that...

Words: 4475 - Pages: 18

Prueba

...TOLEDO. This documentation contains proprietary information of METTLER TOLEDO. It may not be copied in whole or in part without the express written consent of METTLER TOLEDO. METTLER TOLEDO reserves the right to make refinements or changes to the product or manual without notice. COPYRIGHT METTLER TOLEDO® is a registered trademark of Mettler-Toledo, LLC. All other brand or product names are trademarks or registered trademarks of their respective companies. METTLER TOLEDO RESERVES THE RIGHT TO MAKE REFINEMENTS OR CHANGES WITHOUT NOTICE. FCC Notice This device complies with Part 15 of the FCC Rules and the Radio Interference Requirements of the Canadian Department of Communications. Operation is subject to the following conditions: (1) this device may not cause harmful interference, and (2) this device must accept any interference received, including interference that may cause undesired operation. This equipment has been tested and found to comply with the limits for a Class A digital device, pursuant to Part 15 of FCC Rules. These limits are designed to provide reasonable protection against harmful interference when the equipment is operated in a commercial environment. This equipment generates, uses, and can radiate radio frequency energy and, if not installed and used in accordance with the instruction manual, may cause harmful interference to radio communications. Operation of this equipment in a residential area is likely to cause harmful......

Words: 37056 - Pages: 149

Excel

...staying within budget (Total Cash Available) Changing Cells: The # to Make of each piece (cells D6:D8) Constraints: 1. Total Cost must be less than or equal to the budget/total cash available 2. Computing Radiography machines (use D6 for cell reference) should be greater than or equal (>=) to 28% of the total machines produced (constraint entry: d9*28%); also enter a constraint for less than or equal to 32%. Examples of how both of these constraints should be entered is shown below: a. Cell reference entry: D6 / Operator: >= / Constraint entry: d9*28% b. Cell reference entry: D6 / Operator: <= / Constraint entry: d9*32% 3. Laser Imaging machines (D7) should be greater than or equal to 28% of the total machines produced (d9*28%); also enter a constraint for less than or equal to 32% (d9*32%) 4. Magnes machines (D8) should be greater than or equal to 38% of the total machines produced (d9*38%); also enter a constraint for less than or equal to 42% 5. Number to make (D6:D8) must be whole units (use int) Verify that all parameters have been entered (set objective, changing cells and constraints), Solve and create an Answer Report. Resave your practice exam. This will still be a macro-enabled file. If you want feedback on your practice exam, please upload your file to Oncourse / Assignment 2 / Excel Case Practice link. On test day you will submit your completed exam to the Oncourse Assignment2 link....

Words: 1218 - Pages: 5

Excel

...Terms Definitions The First step in creating an effective workseet is to make sure you __________. Understand what is required In Excel, a number can contain the charaters ________. 0 1 2 3 4 5 6 7 8 9 The cell being copied is called the source area (copy area). The range of cells recieving the copy is called the ________. receiving range You ________ a worksheet to emphasize certain entires and make the worksheet easier to read and understand. Format Pressing the _________ keyboard shorcut key(s) selects cell A1. CTRL + HOME How many chart types does Excel offer? 11 Which of the following keys is an alternative to double-clicking the cell to edit it? F2 Which of the following Opton buttons gives options for filling cells following a fill operation? Auto Fill Options A ________ cell in Excel has a numerical value of zero. Blank The ________ AutoComplete list contains those functiond that akohabetically match the letters you type following thr equal sign. Formula The most popular background color is _______. White ________ text often provides a strong visual appeal. Underlined To open the format cells dialog box with the Alignment sheet active, click the Format Cells ________. Dialog Box Launcher Which of the following is an extension of the fill patten Sunday, Tuesday? Thursday, Saturday, Monday Which of the following formula contains the absolute cell reference? =$B$4 A(n) _______ chart provides a simple way to show trends and variatons in a range of data...

Words: 423 - Pages: 2

Prueba

...Mauricio Beltran Zepeda 787719 Liderazgo y comportamiento organizacional Capitulo 2 y 3 Capitulo 2. Entender las diferencias individuales Resultados ¿Cuáles son su valores Culturales? Valor 1 = 19 Puntos Valor 2 = 23 PuntoS Valor 3 = 7 Puntos Valor 4 = 23 puntos Valor 5 = 5 Puntos ¿Cual es su coeficiente de inteligencia emocional? Valor 1 = 40 Empatia Social = 17 Automotivacion = 27 Habilidades sociales = 17 Interpretación ¿Cuáles son su valores Culturales? Soy una persona que no me gusta dejar nada al azar y tener leyes o normas de trabajo para asegurarme que las cosas se realicen de forma correcta trato de que no exista la incertidumbre en mi trabajo. De acuerdo a mis resultados me gusta trabajar en equipo y pienso que el éxito en equipo esta antes de mis metas individuales. Por otro lado creo que se debe de externar a tus superiores tus opiniones y propuestas de cambio, me resulta difícil entender una distribución desigual del poder y más aun una preferencia hacia el trabajo de un hombre por encima de la mujer. Coeficiente de inteligencia Emocional Soy una persona que reconozco los efectos que tengo en otras personas y las emociones que tratan de expresar con sus diferentes actitudes, por el resultado del ejercicio me importa lo que piense y sientas las demás personas aunque considero que me falta un poco de mas empática con los compañeros de trabajo. De acuerdo a los resultados tengo una capacidad de controlar mis emociones, tener la...

Words: 524 - Pages: 3