Power Point Presentation to Accompany GO with Microsoft
- Slides: 31
Power. Point Presentation to Accompany GO! with Microsoft® Excel 2010 Chapter 3 Analyzing Data with Pie Charts, Line Charts, and What-If Analysis Tools with Microsoft® Excel 2010 © 2011 Pearson Education, Inc. Publishing as Prentice Hall 1
Objectives • Chart Data with a Pie Chart • Format a Pie Chart • Edit a Workbook and Update a Chart • Use Goal Seek to Perform What-If Analysis with Microsoft® Excel 2010 © 2011 Pearson Education, Inc. Publishing as Prentice Hall 2
Objectives • Design a Worksheet for What-If Analysis • Answer What-If Questions by Changing Values in a Worksheet • Chart Data with a Line Chart with Microsoft® Excel 2010 © 2011 Pearson Education, Inc. Publishing as Prentice Hall 3
Chart Data with a Pie Chart • Pie chart – Charts only one data series – Shows the size of items proportionally – Requires two ranges to be selected • One range contains the labels for each slice of the pie (Legend). • Other range contains the values that add up to a total (Do NOT include the total in the range. ). with Microsoft® Excel 2010 © 2011 Pearson Education, Inc. Publishing as Prentice Hall 4
Chart Data with a Pie Chart with Microsoft® Excel 2010 © 2011 Pearson Education, Inc. Publishing as Prentice Hall 5
Chart Data with a Pie Chart with Microsoft® Excel 2010 © 2011 Pearson Education, Inc. Publishing as Prentice Hall 6
Format a Pie Chart • Add chart title with Microsoft® Excel 2010 © 2011 Pearson Education, Inc. Publishing as Prentice Hall 7
Format a Pie Chart • Applying legends and data labels – Select Chart Tools, Layout tab, and then, in the Labels group, click the Legend button – In the Labels group, click the Data Labels button, and then More Data Label Options – In the Format Data Labels dialog box, select Label Options, and then Label Contains and then check Category Name and Percentage – Under Label Position, click Center option with Microsoft® Excel 2010 © 2011 Pearson Education, Inc. Publishing as Prentice Hall 8
Format a Pie Chart with Microsoft® Excel 2010 © 2011 Pearson Education, Inc. Publishing as Prentice Hall 9
Format a Pie Chart with Microsoft® Excel 2010 © 2011 Pearson Education, Inc. Publishing as Prentice Hall 10
Format a Pie Chart • Additional formatting – Rotate a pie slice with Microsoft® Excel 2010 © 2011 Pearson Education, Inc. Publishing as Prentice Hall 11
Format a Pie Chart • Additional formatting – Explode a pie slice with Microsoft® Excel 2010 © 2011 Pearson Education, Inc. Publishing as Prentice Hall 12
Format a Pie Chart • Inserting a Text Box in a chart – Click Layout tab, Insert group, and then click the Text Box button with Microsoft® Excel 2010 © 2011 Pearson Education, Inc. Publishing as Prentice Hall 13
Edit a Workbook and Update a Chart • Editing a workbook – Changing data in a workbook • Chart data markers adjust automatically to accurately reflect changes. – Insert Word. Art in a worksheet • Allows decorative effects, such as shadowed or mirrored text with Microsoft® Excel 2010 © 2011 Pearson Education, Inc. Publishing as Prentice Hall 14
Use Goal Seek to Perform What-If Analysis • What-If analysis – Process of changing the values in cells to see how those changes affect the outcome of formulas in a worksheet • Goal Seek – Excel tool that finds the input needed in one cell to arrive at the desired result in another cell with Microsoft® Excel 2010 © 2011 Pearson Education, Inc. Publishing as Prentice Hall 15
Use Goal Seek to Perform What-If Analysis • Goal Seek dialog box – On the Data tab, in the Data Tools group, click What-If Analysis, and then click Goal Seek with Microsoft® Excel 2010 © 2011 Pearson Education, Inc. Publishing as Prentice Hall 16
Use Goal Seek to Perform What-If Analysis with Microsoft® Excel 2010 © 2011 Pearson Education, Inc. Publishing as Prentice Hall 17
Design a Worksheet for What-If Analysis • Percentage rate of increase – The percent by which one number increases over another number – Amount of increase/base with Microsoft® Excel 2010 © 2011 Pearson Education, Inc. Publishing as Prentice Hall 18
Design a Worksheet for What-If Analysis • Excel order of operations – Expressions within parentheses first – Exponentiation, if present, before multiplication and division – Multiplication and division before addition and subtraction – Consecutive operators with the same level of precedence calculate left to right with Microsoft® Excel 2010 © 2011 Pearson Education, Inc. Publishing as Prentice Hall 19
Design a Worksheet for What-If Analysis • Calculate a value given the increase – The result when one number is increased a certain percentage • Base * (100% + percent increase) with Microsoft® Excel 2010 © 2011 Pearson Education, Inc. Publishing as Prentice Hall 20
Answer What-If Questions by Changing Values in a Worksheet with Microsoft® Excel 2010 © 2011 Pearson Education, Inc. Publishing as Prentice Hall 21
Answer What-If Questions by Changing Values in a Worksheet with Microsoft® Excel 2010 © 2011 Pearson Education, Inc. Publishing as Prentice Hall 22
Chart Data with a Line Chart • Line chart – Displays trends over time – Displays time along bottom axis – Connects data points with a line – Illustrates trends through curve and direction of line with Microsoft® Excel 2010 © 2011 Pearson Education, Inc. Publishing as Prentice Hall 23
Chart Data with a Line Chart with Microsoft® Excel 2010 © 2011 Pearson Education, Inc. Publishing as Prentice Hall 24
Chart Data with a Line Chart • Chart formatting capabilities – Format the category axis (x-axis) – Format the value axis (y-axis) – Format the chart area (Ex: Border Color, Border Styles, and Chart Elements) – Format the plot area (Ex: background) with Microsoft® Excel 2010 © 2011 Pearson Education, Inc. Publishing as Prentice Hall 25
Chart Data with a Line Chart with Microsoft® Excel 2010 © 2011 Pearson Education, Inc. Publishing as Prentice Hall 26
Chart Data with a Line Chart with Microsoft® Excel 2010 © 2011 Pearson Education, Inc. Publishing as Prentice Hall 27
Chart Data with a Line Chart with Microsoft® Excel 2010 © 2011 Pearson Education, Inc. Publishing as Prentice Hall 28
Covered Objectives • Chart Data with a Pie Chart • Format a Pie Chart • Edit a Workbook and Update a Chart • Use Goal Seek to Perform What-If Analysis with Microsoft® Excel 2010 © 2011 Pearson Education, Inc. Publishing as Prentice Hall 29
Covered Objectives • Design a Worksheet for What-If Analysis • Answer What-If Questions by Changing Values in a Worksheet • Chart Data with a Line Chart with Microsoft® Excel 2010 © 2011 Pearson Education, Inc. Publishing as Prentice Hall 30
All rights reserved. No part of this publication may be reproduced, stored in a retrieval system, or transmitted, in any form or by any means, electronic, mechanical, photocopying, recording, or otherwise, without the prior written permission of the publisher. Printed in the United States of America. Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall with Microsoft® Excel 2010 © 2011 Pearson Education, Inc. Publishing as Prentice Hall 31
- Things that belong to salvation
- Accompany chapter 1
- Median cubital vein
- Accompany
- Cara mengoperasikan powerpoint
- Notes pane in powerpoint
- Que es microsoft power point
- Microsoft power point 2010
- Topics for powerpoint presentation for class 4
- Power point presentation design west vancouver
- Real power formula
- Informsu
- Point point power
- Microsoft official academic course microsoft word 2016
- Microsoft official academic course microsoft excel 2016
- Edge startwarren theverge
- Spreadsheet adalah program microsoft
- Microsoft official academic course microsoft word 2016
- Occipital brow presentation
- Leopold maneuver
- Microsoft power bi stack
- Analyzing and visualizing data with microsoft power bi
- Power bi embed playground
- Microsoft word power
- Microsoft power automate grundkurs
- Power tools safety training ppt
- Point of view presentation
- The starting point in a presentation
- Solar power satellites and microwave power transmission
- Actual power
- Flex28024a
- Formula for dispersive power of grating