Microsoft Office Excel 2007 In Business, Core
Published on 7. June 2007
Book
Spiral bound
336 pages
978-0-13-174344-1 (ISBN)
More details
Language
English
Place of publication
United States
Publishing group
Pearson Education (US)
Target group
Professional and scholarly
Dimensions
Height: 224 mm
Width: 274 mm
Thickness: 15 mm
Weight
706 gr
ISBN-13
978-0-13-174344-1 (9780131743441)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its 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