MS Excel Ch 2 PPT

PowerPoint Presentation to AccompanyGO! with Microsoft® Excel 2010Chapter 2Using Functions, Creating Tables, and Managing Large Workbooks

ObjectivesUse the SUM, AVERAGE, MEDIAN, MIN, and MAX FunctionsMove Data, Resolve Error Messages, and Rotate TextUse COUNTIF and IF Functions and Apply Conditional Formatting

ObjectivesUse Date & Time Functions and Freeze PanesCreate, Sort, and Filter an Excel TableFormat and Print a Large Worksheet

ObjectivesNavigate a Workbook and Rename WorksheetsEnter Dates, Clear Contents, and Clear FormatsCopy and Paste by Using the Paste Options Gallery

ObjectivesEdit and Format Multiple Worksheets at the Same TimeCreate a Summary Sheet with Column SparklinesFormat and Print Multiple Worksheets in a Workbook

Use the SUM, AVERAGE, MEDIAN, MIN, and MAX FunctionsFunctionA predefined formula that Excel has already built for you.Example: SUM Statistical functions are useful to analyze a group of measurements.Examples: AVERAGE, MEDIAN, MIN, and MAX

Use the SUM, AVERAGE, MEDIAN, MIN, and MAX Functions

Move Data, Resolve Error Messages, and Rotate TextMoving dataData can be moved by drag and drop.The formulas references will be adjusted (relative or absolute).If the destination cell is not large enough, Excel will display # # # # #. Column width can be increased or data may be rotated to fit in the cell.

Move Data, Resolve Error Messages and Rotate Text

Use COUNTIF and IF Functions and Apply Conditional FormattingLogical functionsUse conditional tests, called criteria, to determine a true or false conditionIF function—Performs one of two actions depending upon the specified criteriaCOUNTIF function—Counts the number of cells within a range that meet the specified criteria

Use COUNTIF and IF Functions and Apply Conditional Formatting

Use Date & Time Functions and Freeze PanesNOW functionPlaces the system date and time in the selected cellIs updated each time the spreadsheet is opened, or by pressing “F9” keyFreeze PanesFreeze Panes button can be used to lock row and/or column labels in place so they will be displayed as the worksheet is scrolled.

Create, Sort, and Filter an Excel TableExcel TableSeries of rows and columns that contain related data that is managed independently Created by clicking the Insert Tab, then Tables group, and then Table button

Create, Sort, and Filter an Excel TableSorting and filteringSort data in ascending or descending orderFilter data to display the portion that meets the criteria specifiedData can be sorted or filtered by selecting the sorting arrow filtering arrow.

Create, Sort, and Filter an Excel Table

Format and Print a Large WorksheetPrint Titles commandSpecify rows and columns to repeat on each printed pageScale to Fit commandStretch or shrink the width, height, or both of printer output to fit a maximum number of pages

Format and Print a Large Worksheet

Navigate a Workbook and Rename WorksheetsNavigate to a sheet by clicking the sheet tabTwo ways to rename sheet tabs:Double-click to select the name, and then type a new nameRight-click on the Sheet tab, on the shortcut menu, click Rename, and then type a new nameChange color by right-clicking tab and then select Tab Color

Navigate a Workbook and Rename Worksheets

Enter Dates, Clear Contents, and Clear Formats

Copy and Paste by Using the Paste Options GalleryCopy data to clipboard by right-clicking selected data.

The Paste Options gallery is displayed by right-clicking target destination.Copy and Paste by Using the Paste Options Gallery

Edit and Format Multiple Worksheets at the Same TimeGrouping multiple worksheetsPress the Control key to select more than one tab, or right-click and select all tabs.[Group] displays in the title bar.Data entered or edited on the active sheet is reflected in all selected sheets.Formulas and formatting entered on the active sheet also are reflected in all selected sheets.

Edit and Format Multiple Worksheets at the Same Time

Create a Summary Sheet with Column SparklinesSummary sheetWorksheet where totals from other worksheets are displayedDetail sheetsWorksheets with details that affect the totals on the summary sheetSparklinesTiny charts that show a data trend

Create a Summary Sheet with Column Sparklines

Format and Print Multiple Worksheets in a WorkbookHeaders & FootersEach worksheet can have different formatting and different headers and footers.Use grouping to make all worksheets have the same headers and footers.PrintingBe sure [Group] displays on the title bar.Use the Backstage view to set Print options.

Covered ObjectivesUse the SUM, AVERAGE, MEDIAN, MIN, and MAX FunctionsMove Data, Resolve Error Messages, and Rotate TextUse COUNTIF and IF Functions and Apply Conditional Formatting

Covered ObjectivesUse Date & Time Functions and Freeze PanesCreate, Sort, and Filter an Excel TableFormat and Print a Large Worksheet

Covered ObjectivesNavigate a Workbook and Rename WorksheetsEnter Dates, Clear Contents, and Clear FormatsCopy and Paste by Using the Paste Options Gallery

Covered ObjectivesEdit and Format Multiple Worksheets at the Same TimeCreate a Summary Sheet with Column SparklinesFormat and Print Multiple Worksheets in a Workbook

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

MS Excel Ch 2 PPT

More Related Content

What's hot

Viewers also liked

Similar to MS Excel Ch 2 PPT

More from prsmith72

Recently uploaded

MS Excel Ch 2 PPT