Microsoft Office Excel 2007 In Business, Core with Microsoft Office Excel 2007 In Business, Core Student Resource DVD
Published on 7. May 2014
Book
Mixed media product
978-0-13-713344-4 (ISBN)
Description
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
-0131743449: Microsoft Office Excel 2007 In Business, Core
-0131743457: Microsoft Office Excel 2007 In Business, Core Student Resource DVD
More details
Language
English
Place of publication
Upper Saddle River
United States
Publishing group
Pearson Education (US)
Target group
Professional and scholarly
Weight
816 gr
ISBN-13
978-0-13-713344-4 (9780137133444)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Content
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
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