Overview

This package contains the following components: -0131743449: Microsoft Office Excel 2007 In Business, Core -0131743457: Microsoft Office Excel 2007 In Business, Core Student Resource DVD

Full Product Details

Author:   Joseph J. Manzo
Publisher:   Pearson Education (US)
Imprint:   Prentice Hall
Dimensions:   Width: 22.90cm , Height: 1.40cm , Length: 27.70cm
Weight:   0.816kg
ISBN:  

9780137133444

ISBN 10:   0137133448
Publication Date:   07 May 2014
Audience:   Professional and scholarly ,  Professional & Vocational
Format:   Mixed media product
Publisher's Status:   Out of Print
Availability:   Out of stock  

Table of Contents

Excel Core Table of Contents Chapter 1 Introduction What is Excel? Why Are We Here? A Decision-Making Tool An Overview of Excel Ribbons, Tabs, and Icons The File Menu Excel 97-2003 File Format Right Click and Control Keys Settings and Status Bar Excel Help Chapter 2 Excel Basics Data Management Data Entry Auto Fill Adjusting Columns and Rows Hiding Columns and Rows Copy and Paste Sorting Data (Single Level) Sorting Data (Multiple Levels) Formatting Data Formats Data Alignment Number Formats Borders (Line Formats) Cell Colors (Fill Color) Editing Editing Data in a Cell Moving Data Deleting Columns and Rows Deleting Worksheets Inserting Columns and Rows Inserting, Moving, and Renaming Worksheet Tabs Printing Page Setup Printing a Worksheet Chapter 3 Calculating Data: Formulas and Functions Formulas Basic Formulas Copy and Pasting Formulas (Relative Reference and Paste Special) Complex Formulas Auditing Formulas Basic Functions Basic Statistical Functions AutoSum Absolute References (Turning Off Relative References) Financial Functions The Future Value Function The Payment Function The Function Library Chapter 4 Evaluating Data Logical Functions (The IF Function) IF Function Nested IF Function Logical Functions (AND OR) AND Function OR Function Combining AND, OR, and IF Functions Lookup Functions VLookup Function HLookup Function Chapter 5 Presenting Information with Charts Creating Charts Column Charts (Data Comparisons) Stacked Column Charts (Percent to Total Over Time) Line Charts (Trends Over Time) Pie Charts (Percent to Total) Formatting Charts Titles and Legends Plot Area and Data Series X- and Y-Axes Labels Adding Annotations and Objects Advanced Chart Options Defining the X- and Y-Axes Manually The Scatter Plot Chart Pasting Charts into PowerPoint and Word Chapter 6 Applying Core Competency Skills: Financial Planning and Accounting Linking Data Linking Worksheets and Workbooks Updating Workbook Links SUMIF Function Financial Planning Financial Assumptions Freeze Panes Financial Data Cash Analysis (The NPV Function) Financial Accounting T-Accounts Journals Ledgers Trial Balance and Work Sheets Statements

Reviews

Author Information

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions