Microsoft Office 2007 In Business Core
2nd Edition
Published on 10. March 2009
Book
Paperback/Softback
1088 pages
978-0-13-507320-9 (ISBN)
Description
For courses on Microsoft Office 2007 with an emphasis on Business, or a course on Office Applications for Business.
Microsoft Office is the industry standard in business software. Learn how to make Office 2007 work for you!
As part of the In Business System, Microsoft Office 2007 In Business Core is the only Office 2007 book that prepares students expressly for core business courses such as Accounting, Economics, Marketing, Finance, and Business Statistics by providing exposure to real business files that meet professional standards, useful references that can be used in later courses, an understanding of how to use the software as a tool to accomplish business goals, and coverage of the core Office skills needed in business.
The second edition includes several new features that reinforce the primary mission of the series, which is to illustrate how Microsoft Office is used to accomplish both personal and professional business objectives.
Microsoft Office is the industry standard in business software. Learn how to make Office 2007 work for you!
As part of the In Business System, Microsoft Office 2007 In Business Core is the only Office 2007 book that prepares students expressly for core business courses such as Accounting, Economics, Marketing, Finance, and Business Statistics by providing exposure to real business files that meet professional standards, useful references that can be used in later courses, an understanding of how to use the software as a tool to accomplish business goals, and coverage of the core Office skills needed in business.
The second edition includes several new features that reinforce the primary mission of the series, which is to illustrate how Microsoft Office is used to accomplish both personal and professional business objectives.
More details
Edition
2nd edition
Language
English
Place of publication
United States
Publishing group
Pearson Education (US)
Target group
Professional and scholarly
Dimensions
Height: 250 mm
Width: 280 mm
Thickness: 55 mm
Weight
2372 gr
ISBN-13
978-0-13-507320-9 (9780135073209)
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
Other editions
Previous edition
Joseph J. Manzo | Dee Piziak | Christine J. Rhoads
Microsoft Office 2007 in Business, Core
Book
05/2007
Pearson
€43.39
Article exhausted; check for reprint
Persons
Joseph M. Manzo
In Business series editor and author of Microsoft Office Excel 2007 In Business and Microsoft Office Access 2007 In Business
Joseph began his career in a family-owned business in the garment center of New York City where he managed production plans for knitted textiles sold in the domestic market. Since then, he has worked with several U.S. corporations in the manufacturing, retailing, consulting, and finance industries. He has held positions in Strategic Planning, Information Systems, and Merchandise Planning and Buying. The use of Microsoft Excel and Access was an integral part of managing information and making decisions throughout his career. He developed a high level of expertise in these applications and eventually trained business professionals as a manager in the information systems division of a multibillion dollar retail corporation.
Today, Joseph is a teacher and independent consultant. After practicing business for several years, he moved his career into academia by developing and teaching the Excel competency program at Lehigh University's prestigious College of Business and Economics. He also teaches the Introduction to Business class for first-year business students at Lehigh. In his consulting practice, Joseph develops strategic plans for new businesses, and develops desktop IT solutions for business performance reporting and analysis. He received an MBA with a concentration in Information Systems Management from Lehigh University and attended Rutgers University for his undergraduate degree.
Dee R. Piziak
Author of Presenting with Microsoft Office PowerPoint 2007 In Business
Dee Piziak is an adjunct faculty member at the University of Wisconsin-Milwaukee and at Concordia University. She teaches various information systems courses at both the undergraduate and graduate level.
Dee holds a B.S. in Computer Information Science from the University of Florida and an M.S. in Computer Science from the University of Wisconsin-Milwaukee.
In addition to teaching, Dee is an Information Technology professional. She has held sales and marketing positions at IBM Corporation, Ameritech, and EMC Corporation. She is currently an Assistant Director for Field Development Systems at Northwestern Mutual in Milwaukee, Wisconsin.
Chris J. Rhoads
Author of Communicating with Microsoft Office Word 2007 In Business
Dr. Rhoads ("CJ") is President and CEO for ETM Associates, Inc., which specializes in helping companies make better decisions regarding business management and information technology. She is also Associate Professor in the College of Business at Kutztown University, where she shares her knowledge in a variety of graduate and undergraduate courses. CJ is a dynamic speaker and sought-after guru on improving business through information technology. She has been widely published, including several instructional manuals, and is a regular columnist for several business publications.
CJ developed her extensive knowledge through a combination of startups and Fortune 500 companies in the financial industry. Prior to starting ETM Associates, she served as Chief Technology and Operations Officer for CommerceLinks.Net, a startup specializing in Live Video Customer Service technologies. During the height of the Internet bubble, she utilized her talents as Chief Technology Officer of Millstar, an E-commerce software development company specializing in online catalogues of highly complex product sets for click and mortar companies. Her large company experience was garnered as Vice President of First USA and MBNA, where she provided internal consult to senior management on technology decision-making topics.
CJ started her career by building Computer Educational Services, a highly successful computer training and consulting firm that eventually merged into Verso Technologies, a publicly traded company. She has a doctorate in Educational Technology from Lehigh University and a Master's degree from Temple University.
In Business series editor and author of Microsoft Office Excel 2007 In Business and Microsoft Office Access 2007 In Business
Joseph began his career in a family-owned business in the garment center of New York City where he managed production plans for knitted textiles sold in the domestic market. Since then, he has worked with several U.S. corporations in the manufacturing, retailing, consulting, and finance industries. He has held positions in Strategic Planning, Information Systems, and Merchandise Planning and Buying. The use of Microsoft Excel and Access was an integral part of managing information and making decisions throughout his career. He developed a high level of expertise in these applications and eventually trained business professionals as a manager in the information systems division of a multibillion dollar retail corporation.
Today, Joseph is a teacher and independent consultant. After practicing business for several years, he moved his career into academia by developing and teaching the Excel competency program at Lehigh University's prestigious College of Business and Economics. He also teaches the Introduction to Business class for first-year business students at Lehigh. In his consulting practice, Joseph develops strategic plans for new businesses, and develops desktop IT solutions for business performance reporting and analysis. He received an MBA with a concentration in Information Systems Management from Lehigh University and attended Rutgers University for his undergraduate degree.
Dee R. Piziak
Author of Presenting with Microsoft Office PowerPoint 2007 In Business
Dee Piziak is an adjunct faculty member at the University of Wisconsin-Milwaukee and at Concordia University. She teaches various information systems courses at both the undergraduate and graduate level.
Dee holds a B.S. in Computer Information Science from the University of Florida and an M.S. in Computer Science from the University of Wisconsin-Milwaukee.
In addition to teaching, Dee is an Information Technology professional. She has held sales and marketing positions at IBM Corporation, Ameritech, and EMC Corporation. She is currently an Assistant Director for Field Development Systems at Northwestern Mutual in Milwaukee, Wisconsin.
Chris J. Rhoads
Author of Communicating with Microsoft Office Word 2007 In Business
Dr. Rhoads ("CJ") is President and CEO for ETM Associates, Inc., which specializes in helping companies make better decisions regarding business management and information technology. She is also Associate Professor in the College of Business at Kutztown University, where she shares her knowledge in a variety of graduate and undergraduate courses. CJ is a dynamic speaker and sought-after guru on improving business through information technology. She has been widely published, including several instructional manuals, and is a regular columnist for several business publications.
CJ developed her extensive knowledge through a combination of startups and Fortune 500 companies in the financial industry. Prior to starting ETM Associates, she served as Chief Technology and Operations Officer for CommerceLinks.Net, a startup specializing in Live Video Customer Service technologies. During the height of the Internet bubble, she utilized her talents as Chief Technology Officer of Millstar, an E-commerce software development company specializing in online catalogues of highly complex product sets for click and mortar companies. Her large company experience was garnered as Vice President of First USA and MBNA, where she provided internal consult to senior management on technology decision-making topics.
CJ started her career by building Computer Educational Services, a highly successful computer training and consulting firm that eventually merged into Verso Technologies, a publicly traded company. She has a doctorate in Educational Technology from Lehigh University and a Master's degree from Temple University.
Content
Table of Contents
Preface
PowerPoint
Chapter 1 I Introduction
PowerPoint in Practice Anecdote I My Role as a Sales Engineer
Business Communication, Influences, and Decision Making I Skill Set
High-Impact Communication and Decision Making
PowerPoint: The Electronic Flip Chart and Transparency
PowerPoint Concepts and Terminology
Plan First, Validate, Then Create
The PowerPoint Tour
Video Workshop I Communication and Decision Making
Why Do I Need This? I Planning a Presentation
What's Wrong with This Presentation?
PowerPoint in Practice Anecdote I Solution
Review Questions
Skills Exam
Challenge Questions
Above and Beyond: Running Skills Exam
Above and Beyond: Challenge Questions
Chapter 2 I Creating a Basic Presentation
Designing Your Presentation I Skill Set
Creating a New Presentation
Slide Themes
Slide Layouts
Video Workshop I Designing Your Presentation
Why Do I Need This? I Designing Your Presentation
What's Wrong with This Presentation?
Building Your Presentation I Skill Set
Adding New Slides and Text
Using the Outline Tab
Bullets and Numbered Lists
Video Workshop I Building Your Presentation
Why Do I Need This? I Building Your Presentation
What's Wrong with This Presentation?
Presenting Qualitative and Quantitative Information and Objects I Skill Set
Shapes and Lines
Tables and Charts
SmartArt
Graphics, Audio, and Video
Video Workshop I Presenting Qualitative and Quantitative Information and Objects
Why Do I Need This? I Presenting Qualitative and Quantitative Information and Objects
Why Do I Need This? I Presenting Qualitative and Quantitative Information
What's Wrong with This Presentation?
PowerPoint in Practice Anecdote I Solution
Review Questions
Skills Exam
Challenege Questions
Above and Beyond: Running Skills Exam
Above and Beyond: Challenge Questions
Chapter 3 I Enhancing Your Presentation
PowerPoint in Practice Anecdote I My Role as a Global Account Manager
Formatting Your Slides I SKill Set
Clipboard Options
Font Group
Paragraph Panel
WordArt
Modifying Slide Masters
Video Workship I Formatting Your Slides
Why Do I Need This? I Formatting a Presentation for a Consulting Firm
What's Wrong with This Presentation?
Sharing Content between Presentations I Skill Set
Slide Sorter View
Deleting and Rearranging Slides
Merging Presentations
Why Do I Need This? I Creating a Single Presentation from a Team of People
What's Wrong with This Presentation?
Checking Your Slides I Skill Set
Review Tab
Find and Replace
Print Preview
Video Workshop I Checking for Accuracy
Why Do I Need This? I Creating a Shell
What's Wrong with This Presentation?
PowerPoint in Practice Anecdote I Solution
Review Questions
Skills Exam
Challenge Questions
Above and Beyond: Running Skills Exam
Above and Beyond: Challenge Questions
Chapter 4I Delivering Your Presentation
PowerPoint in Practice Anecdote I My Role as a Senior Manager
Basic Presentation Options I Skill Set
On-Screen (Electronic) Delivery
Web Delivery
Hard-Copy Presentations
Video Workshop I Basic Presentation Options
Why Do I Need This? I Customizing a Slide Show
What's Wrong with this Presentation?
PowerPoint in Practice Anecdote I Solution
Review Questions
Skills Exam
Challenge Questions
Above and Beyond: Running Skills Exam
Above and Beyond: Challenge Question
Chapter 5 I Applying the Core Skills
PowerPoint in Practice Anecdote I My Role as the "RFP Guru"
Converting Documents into Presentations I Skill Set
Develop a Road Map
Assemble Your Presentation
Reuse Word and Excel Objects
Effective Delivery Techniques
Video Workshop I Converting Documents into Presentations
Why Do I Need This? I Turning the Road Map into a Project Plan
What's Wrong with This Presentation?
PowerPoint in Practice Anecdote I Solution
Review Questions
Skills Exam
Challenge Questions
Above and Beyond: Running Skills Exam
Above and Beyond: Challenge Questions
Word
Chapter 1 I Introduction to Word Basics
Word in Practice Anecdote I My Role as a Technology Consultant
What is Word? I Skill Set
Why Are We Here?
An Overview of Word
Ribbon, Tabs, and Icons
File Menu
Word 97-2007 File Format
Right-Click, Alt Keys, and Control Keys
Word Help
Settings and the Normal Template
Business Writing
Creating, Writing, and Saving a Word Document
Copy and Paste
Save the Document
The Ruler
Video Workshop I Introduction to Word
Why Do I Need This? I An Introduction to Creating an Outline
What's Wrong with This Document?
Word in Practice Anecdote I Solution
Review Questions
Skills Exam
Challenge Questions
Above and Beyond: Running Skills Exam
Above and Beyond: Challenge Questions
Chapter 2 I Creating a Basic Report
Word in Practice Anecdote I My Role as VP at a Fortune 500 Financial Firm
Paragraph and Text Formatting I Skill Set
Introduction to Styles
Using Styles to Change an Outline into Headings
Creating New Styles
About Paragraph Formatting, Fonts, and Font Sizes
Applying New Styles
Design Rules: Serifs, Consistency, and Whitespace
Paragraph Marks and Styles
Modifying a Style
Video Workshop I Paragraph and Text Formatting
Why Do I Need This? I Formatting Letters
What's Wrong with This Document?
Page Formatting I Skill Set
Page Margins
Inserting Page Numbers
Headers and Footers
Inserting Fields into the Footer
Creating a Cover Page
Video Workshop I Headers and Footers
Why Do I Need This? I Creating a Decision Recommendation Report
What's Wrong with This Document
Word in Practice Anecdote I Solution
Review Questions
Skills Exam
Challenge Questions
Above and Beyond: Running Skills Exam
Above and Beyond: Challenge Questions
Chapter 3 I Word Document
Enhancements
Word in Practice Anecdote I My Role as Enterprise Network Management Consultant
Inserting and Working with Tables I Skill Set
Inserting Tables
Changing Column Widths
Selecting Components of a Table
Inserting or Deleting Rows or Columns
Splitting and Merging Cells
Modifying Borders and Shading on a Table
Repeating Table Headers
Converting Text to Table
Video Workshop I Inserting Tables
Why Do I Need This? I Creating a Consulting Proposal
What's Wrong with This Document?
The Power of Find and Replace I Skill Set
Finding Text
Replacing Text
More on Find
Finding and Replacing Invisible Codes
Video Workshop I The Power of Find and Replace
Why Do I Need This? I Creating a Comparison Table from a Download
What's Wrong with This Document
Complex Headers, Footers, and Page Numbers (Sections) I Skill Set
Review Headers, Footers, and Fields
Inserting a Section Break
Understanding Sections and Headers/Footers
Integrating Page Numbers into Header or Footer
Inserting Table of Contents Field
Table of Contents-Updating and Styles
Video Workshop I Complex Headers, Footers, Page Numbering, and Table of Contents
Why Do I Need This? I Formatting Program Description Documents
What's Wrong with This Document?
Word in Practice Anecdote I Solution
Review Questions
Skills Exam
Challenge Questions
Above and Beyond: Running Skills Exam
Above and Beyond: Challenge Questions
Chapter 4 I Word Sharing Objects and Adding References
Word in Practice Anecdote I My Role as Chief Technology Officer of an E-Commerce Software Developer
Pictures and Graphics I Skill Set
About Graphics
Inserting a Photo
Inserting a Caption
About Picture Size and Placement
Resizing a Graphic
Cropping a Graphic
Compressing Pictures When Saving
Moving a Graphic and Text Wrapping Choices
Moving a Graphic with Cut and Paste
Moving a Graphic with Drag and Drop
Using a Text Box
Video Workshop I Pictures and Graphics
Why Do I Need This? I Consultants Workshop Press Release
What's Wrong with This Document?
Inserting Slides, Spreadsheets, Charts, and Query Results I Skill Set
Inserting a PowerPoint Slide
Inserting an Excel Chart
Inserting an Excel Spreadsheet
Inserting the Results of an Access Query
Video Workshop I Inserting Slides, Spreadsheets, Charts, and Query Results
Why Do I Need This? I Integrating Information from a Variety of Sources to Persuade
What's Wrong with This Document?
Footnotes and Endnotes I Skill Set
Adding an Endnote
Adding a Footnote
Converting Endnotes to Footnotes and Vice Versa
Video Workshop I Footnotes and Endnotes
Why Do I Need This? I Making a Case for a Recommendation
What's Wrong with This Document?
Word in Practice Anecdote I Solution
Review Questions
Skills Exam
Challenge Questions
Above and Beyond: Running Skills Exam
Above and Beyond: Challenge Questions
Excel
Chapter 1 I Introduction
Excel in Practice Anecdote I Excel in Business
What Is Excel? I Skill Set
Why Are We Here?
A Decision-Making Tool
An Overview of Excel
Ribbon, Tabs, and Icons
The File Menu
Excel 97-2003 File Format
Right Click and Control Keys
Settings and Status Bar
Excel Help
Video Workshop I Introduction to Excel
Why Do I Need This? I An Introduction to Cell Referencing
Excel in Practice Anecdote I Solution
Review Questions
Skills Exam
Challenge Questions
Above and Beyond; Running Skills Exam
Above and Beyond: Challenge Questions
Chapter 2 I Excel Basics
Excel in Practice Anecdote I The Role of a Production Planning Manager
Data Management I Skill Set
Data Entry
Auto Fill
Adjusting Columns and Rows
Hiding Columns and Rows
Copy and Paste
Sorting Data (Single Level)
Sorting Data (Multiple Levels)
Video Workshop I Data Management Skills
Why Do I Need This? I Creating Merchandise Sales Reports
What's Wrong with This Spreadsheet?
Formatting I Skill Set
Data Formats
Data Alignment
Number Formats
Borders (Line Formats)
Cell Color (Fill Color)
Video Workshop I Formatting
Why Do I Need This? I Creating a Store Performance Report
What's Wrong with This Spreadsheet?
Editing I Skill Set
Editing Data in a Cell
Moving Data
Deleting Columns and Rows
Deleting Worksheets
Inserting Columns and Rows
Inserting, Moving, and Renaming Worksheet Tabs
Video Workshop I Editing
Why Do I Need This? I Editing Store Sales Reports
What's Wrong with This Spreadsheet?
Printing I Skill Set
Page Setup
Printing a Worksheet
Video Workshop I Printing
Excel in Practice Anecdote I Solution
Review Questions
Skills Exam
Challenge Questions
Above and Beyond: Running Skills Exam
Above and Beyond: Challenge Questions
Chapter 3 I Calculating Data: Formulas and Functions
Excel in Practice Anecdote I My Role as a Merchandise Analyst
Formulas I Skill Set
Basic Formulas
Copying and Pasting Formulas (Relative Reference and Paste Special)
Complex Formulas
Auditing Formulas
Video Workshop I Formulas
Why Do I Need This? I Startup Costs for a New Business
What's Wrong with This Spreadsheet?
Basic Functions I Skill Set
Basic Statistical Functions
AutoSum
Absolute References (Turning Off Relative References)
Video Workshop I Statistical Functions
Video Workshop I Absolute References
Why Do I Need This? I Evaluating a Transportation Business
What's Wrong with This Spreadsheet?
Financial Functions I Skill Set
The Future Value Function
The Payment Function
The Function Library
Video Workshop I Future Value Function
Video Workshop I Payment Function
Video Workshop I The Function Library
Why Do I Need This? I Financial Planning for Retirement
What's Wrong with This Spreadsheet?
Excel in Practice Anecdote I Solution
Review Questions
Skills Exam
Challenge Questions
Above and Beyond: Running Skills Exam
Above and Beyond: Challenge Questions
Chapter 4 I Evaluating Data
Excel in Practice Anecdote I Managing Retail Store Expansion
Logical Functions ( The IF Function ) I Skill Set
IF Function
Nested IF Functions
Video Workshop I IF Functions
Why Do I Need This? I Price Management
What's Wrong with This Spreadsheet?
Logical Functions (AND OR) I Skill Set
AND Function
OR Function
Combining AND, OR, and IF Functions
Video Workshop I AND and OR Functions
Why Do I Need This? I Managing Product Shipments
What's Wrong with This Spreadsheet?
Lookup Functions I Skill Set
VLookup Function
HLookup Function
Video Workshop I The VLookup Function
Video Workshop I The HLookup Function
Why Do I Need This? I Personal Investment Strategies
What's Wrong with This Spreadsheet?
Excel in Practice Anecdote I Solution
Review Questions
Skills Exam
Challenge Questions
Above and Beyond: Running Skills Exam
Above and Beyond: Challenge Questions
Chapter 5 I Presenting Information with Charts
Excel in Practice Anecdote I My Role as a Consultant
Creating Charts I Skill Set
Column Charts (Data Comparisons)
Stacked Column Charts (Percent to Total Over Time)
Line Charts ( Trends Over Time)
Pie Charts (Percent to Total)
Video Workshop I Creating Charts
Why Do I Need This? I Analyzing Industry Statistics
What's Wrong with This Spreadsheet?
Formatting Charts I Skill Set
Titles and Legends
Plot Area and Data Series
X- and Y-Axes Labels
Adding Annotations and Objects
Video Workshop I Formatting Charts
Why Do I Need This? I Charting Stocks versus the Dow Jones Industrial Average
What's Wrong with This Spreadsheet?
Advanced Chart Options I Skill Set
Defining the X-and Y-Axes Manually
The Scatter Plot Chart
Pasting Charts into PowerPoint and Word
Video Workshop I Scatter Plot Charts
Video Workshop I Pasting Charts into Word
Why Do I Need This? I Analyzing Supply and Demand
What's Wrong with This Spreadsheet?
Excel in Practice Anecdote I Solution
Review Questions
Skills Exam
Challenge Questions
Above and Beyond: Running Skills Exam
Above and Beyond: Challenge Questions
Chapter 6 I Applying Core Competency Skills: Financial Planning and Accounting
Excel in Practice Anecdote I My Role as a Strategic Planning Manager
Linking Data I Skill Set
Linking Worksheets and Workbooks
Updating Workbook Links
SUMIF Function
Video Workshop I Linking Data
Video Workshop I SUMIF Function
Why Do I Need This? I Store Construction Plans
What's Wrong with This Spreadsheet?
Financial Planning I Skill Set
Financial Assumptions
Freeze Panes
Financial Data
Cash Analysis (The NPV Function)
Video Workshop I NPV Function
Video Workshop I Financial Plans
Why Do I Need This? I Evaluating Business Initiatives Using Net Present Value
What's Wrong with This Spreadsheet?
Financial Accounting I Skill Set
T-Accounts
Journals
Ledgers
Trial Balance and Work Sheets
Statements
Video Workshop I Financial Accounting
Why Do I Need This? I Analyzing Adjusting Entries and Net Income
What's Wrong with This Spreadsheet?
Excel in Practice Anecdote I Solution
Review Questions
Skills Exam
Challenge Questions
Above and Beyond: Running Skills Exam
Above and Beyond: Challenge Questions
Access
Chapter 1 I Introduction
Access in Practice Anecdote I Access in Business
What is Access? I Skill Set
Databases
Business Decisions and Databases
Navigation Pane and Access Objects
File Formats and Other Access Settings
Access Help
Using versus Creating Databases
Video Workshop I Introduction to Access
Why Do I Need This? I How Companies Use Databases
What's Wrong with This Database?
Access in Practice Anecdote I Solution
Review Questions
Skills Exam
Challenge Questions
Above and Beyond: Running Skills Exam
Above and Beyond: Challenge Questions
Chapter 2 I The Database Table
Access in Practice Anecdote I Merchandise Planning in the Fashion Industry
Creating Tables I Skill Set
Creating a New Table
Field Names, Data Types, and Field Properties
Indexing and Primary Keys
Entering and Formatting Data
Adjusting and Hiding Columns and Rows
Copying and Pasting Data
Sorting and Filtering Data
Video Workshop I Creating an Access Table
Why Do I Need This? I Collecting Customer Data for Marketing Promotions
What's Wrong with This Database?
Editing Tables I Skill Set
Changing Data Types and Field Properties
Changing the Sequence of Fields
Editing Data and Field Names
Inserting Fields
Deleting Fields and Records
Video Workshop I Editing a Table
Why Do I Need This? I Managing Transportation Data
What's Wrong with This Database?
Importing and Linking Data I Skill Set
Importing Data
Linking Data
Printing Tables
Video Workshop I Linking and Importing Tables
What's Wrong with This Database?
Access in Practice Anecdote I Solution
Review Questions
Skills Exam
Challenge Questions
Above and Beyond: Running Skills Exam
Above and Beyond: Challenge Questions
Chapter 3 I Selecting and Summarizing Data from Tables
Access in Practice Anecdote I Databases in Practice
Know Your Data I Skill Set
Getting Started
Single Field Primary Key Tables
Multiple Field Primary Key Tables
Video Workshop I Evaluating Tables
Why Do I Need This? I Analyzing a Call Center Database
What's Wrong with This Database?
Fundamental Query Techniques (The Select Query) I Skill Set
Creating a New Query
Adding Fields and Adjusting Columns
Query Name and Properties
Defining Basic Criteria (OR AND)
Formatting and Sorting Data
Editing Queries
Exploring Queries to Excel
Video Workshop I Basic Queries
Why Do I Need This? I Analyzing Transportation Data
What's Wrong with This Database?
Advanced Queries I Skill Set
Grouping Data
Mathematical Summaries (Aggregate Functions)
Nested Queries
Advanced Queries
Crosstab Queries
Video Workshop I Advanced Queries
Why Do I Need This? I Analyzing Merchandise Sales Trends
What's Wrong with This Database?
Access in Practice Anecdote I Solution
Review Questions
Skills Exam
Challenge Questions
Above and Beyond: Running Skills Exam
Above and Beyond: Challenge Questions
Chapter 4 I Applying Calculations to Data
Access in Practice Anecdote I My Role as an Information Systems Advisor
Formulas I Skill Set
Custom Fields
Calculated Fields
The Expression Builder
Video Workshop I Formulas
Why Do I Need This? I Stock Analysis
What's Wrong with This Database?
IIF Function I Skill Set
Basic IIF Function
Nested IIF Function
Video Workshop I IIF Functions
Why Do I Need This? I Developing a Promotion Strategy
What's Wrong with This Database?
Financial Functions I Skill Set
Future Value
Payment Function
Help with Functions
Video Workshop I Future Value Function
Video Workshop I Payment Function
Why Do I Need This? I Assessing the Value of Real Estate
What's Wrong with This Database?
Access in Practice Anecdote I Solution
Review Questions
Skills Exam
Challenge Questions
Above and Beyond: Running Skills Exam
Above and Beyond: Challenge Questions
Chapter 5 I Reports
Access in Practice Anecdote I My Role as a Retail Store Analyst
Fundamental Report Techniques I Skill Set
Creating a New Report
Setting the Dimensions of a Report
Report Header
Detail
Page Footer
Report Footer
Video Workshop I Fundamental Report Skills
Why Do I Need This? I Human Resource Status Report
What's Wrong with This Database?
Advanced Report Techniques I Skill Set
Grouping Data
Sorting Data
Calculated Fields
Conditional Formatting
Group and Report Totals
Lines
Dates
Video Workshop I Advanced Report Skills
Why Do I Need This? I Industry and Company Performance Report
What's Wrong with This Database?
Access in Practice Anecdote I Solution
Review Questions
Skills Exam
Challenge Questions
Above and Beyond: Running Skills Exam
Above and Beyond: Challenge Questions
Chapter 6 I Applying Core Competency Skills
Access in Practice Anecdote I Managing a Strategic Alliance
Using Multiple Tables in Queries I Skill Set
Joining Tables
Inner Joins
Outer Joins
Defining table Relationships
Video Workshop I Joining Tables
Video Workshop I Table Relationships
Why Do I Need This? I Evaluating Marketing Strategies and Sales
What's Wrong with This Database?
Comprehensive Access Project I Skill Set
Selecting Tables
Adding and Joining Tables in a Select Query
Creating a Parameter Query
Adding Calculations
Constructing the Final Report
Video Workshop I Comprehensive Project
Why Do I Need This? I Wealth Management Investment Reports
What's Wrong with This Database?
Access in Practice Anecdote I Solution
Review Questions
Skills Exam
Challenge Questions
Above and Beyond; Running Skills Exam
Above and Beyond: Challenge Questions
Quick Reference Guide
Glossary
Index
Preface
PowerPoint
Chapter 1 I Introduction
PowerPoint in Practice Anecdote I My Role as a Sales Engineer
Business Communication, Influences, and Decision Making I Skill Set
High-Impact Communication and Decision Making
PowerPoint: The Electronic Flip Chart and Transparency
PowerPoint Concepts and Terminology
Plan First, Validate, Then Create
The PowerPoint Tour
Video Workshop I Communication and Decision Making
Why Do I Need This? I Planning a Presentation
What's Wrong with This Presentation?
PowerPoint in Practice Anecdote I Solution
Review Questions
Skills Exam
Challenge Questions
Above and Beyond: Running Skills Exam
Above and Beyond: Challenge Questions
Chapter 2 I Creating a Basic Presentation
Designing Your Presentation I Skill Set
Creating a New Presentation
Slide Themes
Slide Layouts
Video Workshop I Designing Your Presentation
Why Do I Need This? I Designing Your Presentation
What's Wrong with This Presentation?
Building Your Presentation I Skill Set
Adding New Slides and Text
Using the Outline Tab
Bullets and Numbered Lists
Video Workshop I Building Your Presentation
Why Do I Need This? I Building Your Presentation
What's Wrong with This Presentation?
Presenting Qualitative and Quantitative Information and Objects I Skill Set
Shapes and Lines
Tables and Charts
SmartArt
Graphics, Audio, and Video
Video Workshop I Presenting Qualitative and Quantitative Information and Objects
Why Do I Need This? I Presenting Qualitative and Quantitative Information and Objects
Why Do I Need This? I Presenting Qualitative and Quantitative Information
What's Wrong with This Presentation?
PowerPoint in Practice Anecdote I Solution
Review Questions
Skills Exam
Challenege Questions
Above and Beyond: Running Skills Exam
Above and Beyond: Challenge Questions
Chapter 3 I Enhancing Your Presentation
PowerPoint in Practice Anecdote I My Role as a Global Account Manager
Formatting Your Slides I SKill Set
Clipboard Options
Font Group
Paragraph Panel
WordArt
Modifying Slide Masters
Video Workship I Formatting Your Slides
Why Do I Need This? I Formatting a Presentation for a Consulting Firm
What's Wrong with This Presentation?
Sharing Content between Presentations I Skill Set
Slide Sorter View
Deleting and Rearranging Slides
Merging Presentations
Why Do I Need This? I Creating a Single Presentation from a Team of People
What's Wrong with This Presentation?
Checking Your Slides I Skill Set
Review Tab
Find and Replace
Print Preview
Video Workshop I Checking for Accuracy
Why Do I Need This? I Creating a Shell
What's Wrong with This Presentation?
PowerPoint in Practice Anecdote I Solution
Review Questions
Skills Exam
Challenge Questions
Above and Beyond: Running Skills Exam
Above and Beyond: Challenge Questions
Chapter 4I Delivering Your Presentation
PowerPoint in Practice Anecdote I My Role as a Senior Manager
Basic Presentation Options I Skill Set
On-Screen (Electronic) Delivery
Web Delivery
Hard-Copy Presentations
Video Workshop I Basic Presentation Options
Why Do I Need This? I Customizing a Slide Show
What's Wrong with this Presentation?
PowerPoint in Practice Anecdote I Solution
Review Questions
Skills Exam
Challenge Questions
Above and Beyond: Running Skills Exam
Above and Beyond: Challenge Question
Chapter 5 I Applying the Core Skills
PowerPoint in Practice Anecdote I My Role as the "RFP Guru"
Converting Documents into Presentations I Skill Set
Develop a Road Map
Assemble Your Presentation
Reuse Word and Excel Objects
Effective Delivery Techniques
Video Workshop I Converting Documents into Presentations
Why Do I Need This? I Turning the Road Map into a Project Plan
What's Wrong with This Presentation?
PowerPoint in Practice Anecdote I Solution
Review Questions
Skills Exam
Challenge Questions
Above and Beyond: Running Skills Exam
Above and Beyond: Challenge Questions
Word
Chapter 1 I Introduction to Word Basics
Word in Practice Anecdote I My Role as a Technology Consultant
What is Word? I Skill Set
Why Are We Here?
An Overview of Word
Ribbon, Tabs, and Icons
File Menu
Word 97-2007 File Format
Right-Click, Alt Keys, and Control Keys
Word Help
Settings and the Normal Template
Business Writing
Creating, Writing, and Saving a Word Document
Copy and Paste
Save the Document
The Ruler
Video Workshop I Introduction to Word
Why Do I Need This? I An Introduction to Creating an Outline
What's Wrong with This Document?
Word in Practice Anecdote I Solution
Review Questions
Skills Exam
Challenge Questions
Above and Beyond: Running Skills Exam
Above and Beyond: Challenge Questions
Chapter 2 I Creating a Basic Report
Word in Practice Anecdote I My Role as VP at a Fortune 500 Financial Firm
Paragraph and Text Formatting I Skill Set
Introduction to Styles
Using Styles to Change an Outline into Headings
Creating New Styles
About Paragraph Formatting, Fonts, and Font Sizes
Applying New Styles
Design Rules: Serifs, Consistency, and Whitespace
Paragraph Marks and Styles
Modifying a Style
Video Workshop I Paragraph and Text Formatting
Why Do I Need This? I Formatting Letters
What's Wrong with This Document?
Page Formatting I Skill Set
Page Margins
Inserting Page Numbers
Headers and Footers
Inserting Fields into the Footer
Creating a Cover Page
Video Workshop I Headers and Footers
Why Do I Need This? I Creating a Decision Recommendation Report
What's Wrong with This Document
Word in Practice Anecdote I Solution
Review Questions
Skills Exam
Challenge Questions
Above and Beyond: Running Skills Exam
Above and Beyond: Challenge Questions
Chapter 3 I Word Document
Enhancements
Word in Practice Anecdote I My Role as Enterprise Network Management Consultant
Inserting and Working with Tables I Skill Set
Inserting Tables
Changing Column Widths
Selecting Components of a Table
Inserting or Deleting Rows or Columns
Splitting and Merging Cells
Modifying Borders and Shading on a Table
Repeating Table Headers
Converting Text to Table
Video Workshop I Inserting Tables
Why Do I Need This? I Creating a Consulting Proposal
What's Wrong with This Document?
The Power of Find and Replace I Skill Set
Finding Text
Replacing Text
More on Find
Finding and Replacing Invisible Codes
Video Workshop I The Power of Find and Replace
Why Do I Need This? I Creating a Comparison Table from a Download
What's Wrong with This Document
Complex Headers, Footers, and Page Numbers (Sections) I Skill Set
Review Headers, Footers, and Fields
Inserting a Section Break
Understanding Sections and Headers/Footers
Integrating Page Numbers into Header or Footer
Inserting Table of Contents Field
Table of Contents-Updating and Styles
Video Workshop I Complex Headers, Footers, Page Numbering, and Table of Contents
Why Do I Need This? I Formatting Program Description Documents
What's Wrong with This Document?
Word in Practice Anecdote I Solution
Review Questions
Skills Exam
Challenge Questions
Above and Beyond: Running Skills Exam
Above and Beyond: Challenge Questions
Chapter 4 I Word Sharing Objects and Adding References
Word in Practice Anecdote I My Role as Chief Technology Officer of an E-Commerce Software Developer
Pictures and Graphics I Skill Set
About Graphics
Inserting a Photo
Inserting a Caption
About Picture Size and Placement
Resizing a Graphic
Cropping a Graphic
Compressing Pictures When Saving
Moving a Graphic and Text Wrapping Choices
Moving a Graphic with Cut and Paste
Moving a Graphic with Drag and Drop
Using a Text Box
Video Workshop I Pictures and Graphics
Why Do I Need This? I Consultants Workshop Press Release
What's Wrong with This Document?
Inserting Slides, Spreadsheets, Charts, and Query Results I Skill Set
Inserting a PowerPoint Slide
Inserting an Excel Chart
Inserting an Excel Spreadsheet
Inserting the Results of an Access Query
Video Workshop I Inserting Slides, Spreadsheets, Charts, and Query Results
Why Do I Need This? I Integrating Information from a Variety of Sources to Persuade
What's Wrong with This Document?
Footnotes and Endnotes I Skill Set
Adding an Endnote
Adding a Footnote
Converting Endnotes to Footnotes and Vice Versa
Video Workshop I Footnotes and Endnotes
Why Do I Need This? I Making a Case for a Recommendation
What's Wrong with This Document?
Word in Practice Anecdote I Solution
Review Questions
Skills Exam
Challenge Questions
Above and Beyond: Running Skills Exam
Above and Beyond: Challenge Questions
Excel
Chapter 1 I Introduction
Excel in Practice Anecdote I Excel in Business
What Is Excel? I Skill Set
Why Are We Here?
A Decision-Making Tool
An Overview of Excel
Ribbon, Tabs, and Icons
The File Menu
Excel 97-2003 File Format
Right Click and Control Keys
Settings and Status Bar
Excel Help
Video Workshop I Introduction to Excel
Why Do I Need This? I An Introduction to Cell Referencing
Excel in Practice Anecdote I Solution
Review Questions
Skills Exam
Challenge Questions
Above and Beyond; Running Skills Exam
Above and Beyond: Challenge Questions
Chapter 2 I Excel Basics
Excel in Practice Anecdote I The Role of a Production Planning Manager
Data Management I Skill Set
Data Entry
Auto Fill
Adjusting Columns and Rows
Hiding Columns and Rows
Copy and Paste
Sorting Data (Single Level)
Sorting Data (Multiple Levels)
Video Workshop I Data Management Skills
Why Do I Need This? I Creating Merchandise Sales Reports
What's Wrong with This Spreadsheet?
Formatting I Skill Set
Data Formats
Data Alignment
Number Formats
Borders (Line Formats)
Cell Color (Fill Color)
Video Workshop I Formatting
Why Do I Need This? I Creating a Store Performance Report
What's Wrong with This Spreadsheet?
Editing I Skill Set
Editing Data in a Cell
Moving Data
Deleting Columns and Rows
Deleting Worksheets
Inserting Columns and Rows
Inserting, Moving, and Renaming Worksheet Tabs
Video Workshop I Editing
Why Do I Need This? I Editing Store Sales Reports
What's Wrong with This Spreadsheet?
Printing I Skill Set
Page Setup
Printing a Worksheet
Video Workshop I Printing
Excel in Practice Anecdote I Solution
Review Questions
Skills Exam
Challenge Questions
Above and Beyond: Running Skills Exam
Above and Beyond: Challenge Questions
Chapter 3 I Calculating Data: Formulas and Functions
Excel in Practice Anecdote I My Role as a Merchandise Analyst
Formulas I Skill Set
Basic Formulas
Copying and Pasting Formulas (Relative Reference and Paste Special)
Complex Formulas
Auditing Formulas
Video Workshop I Formulas
Why Do I Need This? I Startup Costs for a New Business
What's Wrong with This Spreadsheet?
Basic Functions I Skill Set
Basic Statistical Functions
AutoSum
Absolute References (Turning Off Relative References)
Video Workshop I Statistical Functions
Video Workshop I Absolute References
Why Do I Need This? I Evaluating a Transportation Business
What's Wrong with This Spreadsheet?
Financial Functions I Skill Set
The Future Value Function
The Payment Function
The Function Library
Video Workshop I Future Value Function
Video Workshop I Payment Function
Video Workshop I The Function Library
Why Do I Need This? I Financial Planning for Retirement
What's Wrong with This Spreadsheet?
Excel in Practice Anecdote I Solution
Review Questions
Skills Exam
Challenge Questions
Above and Beyond: Running Skills Exam
Above and Beyond: Challenge Questions
Chapter 4 I Evaluating Data
Excel in Practice Anecdote I Managing Retail Store Expansion
Logical Functions ( The IF Function ) I Skill Set
IF Function
Nested IF Functions
Video Workshop I IF Functions
Why Do I Need This? I Price Management
What's Wrong with This Spreadsheet?
Logical Functions (AND OR) I Skill Set
AND Function
OR Function
Combining AND, OR, and IF Functions
Video Workshop I AND and OR Functions
Why Do I Need This? I Managing Product Shipments
What's Wrong with This Spreadsheet?
Lookup Functions I Skill Set
VLookup Function
HLookup Function
Video Workshop I The VLookup Function
Video Workshop I The HLookup Function
Why Do I Need This? I Personal Investment Strategies
What's Wrong with This Spreadsheet?
Excel in Practice Anecdote I Solution
Review Questions
Skills Exam
Challenge Questions
Above and Beyond: Running Skills Exam
Above and Beyond: Challenge Questions
Chapter 5 I Presenting Information with Charts
Excel in Practice Anecdote I My Role as a Consultant
Creating Charts I Skill Set
Column Charts (Data Comparisons)
Stacked Column Charts (Percent to Total Over Time)
Line Charts ( Trends Over Time)
Pie Charts (Percent to Total)
Video Workshop I Creating Charts
Why Do I Need This? I Analyzing Industry Statistics
What's Wrong with This Spreadsheet?
Formatting Charts I Skill Set
Titles and Legends
Plot Area and Data Series
X- and Y-Axes Labels
Adding Annotations and Objects
Video Workshop I Formatting Charts
Why Do I Need This? I Charting Stocks versus the Dow Jones Industrial Average
What's Wrong with This Spreadsheet?
Advanced Chart Options I Skill Set
Defining the X-and Y-Axes Manually
The Scatter Plot Chart
Pasting Charts into PowerPoint and Word
Video Workshop I Scatter Plot Charts
Video Workshop I Pasting Charts into Word
Why Do I Need This? I Analyzing Supply and Demand
What's Wrong with This Spreadsheet?
Excel in Practice Anecdote I Solution
Review Questions
Skills Exam
Challenge Questions
Above and Beyond: Running Skills Exam
Above and Beyond: Challenge Questions
Chapter 6 I Applying Core Competency Skills: Financial Planning and Accounting
Excel in Practice Anecdote I My Role as a Strategic Planning Manager
Linking Data I Skill Set
Linking Worksheets and Workbooks
Updating Workbook Links
SUMIF Function
Video Workshop I Linking Data
Video Workshop I SUMIF Function
Why Do I Need This? I Store Construction Plans
What's Wrong with This Spreadsheet?
Financial Planning I Skill Set
Financial Assumptions
Freeze Panes
Financial Data
Cash Analysis (The NPV Function)
Video Workshop I NPV Function
Video Workshop I Financial Plans
Why Do I Need This? I Evaluating Business Initiatives Using Net Present Value
What's Wrong with This Spreadsheet?
Financial Accounting I Skill Set
T-Accounts
Journals
Ledgers
Trial Balance and Work Sheets
Statements
Video Workshop I Financial Accounting
Why Do I Need This? I Analyzing Adjusting Entries and Net Income
What's Wrong with This Spreadsheet?
Excel in Practice Anecdote I Solution
Review Questions
Skills Exam
Challenge Questions
Above and Beyond: Running Skills Exam
Above and Beyond: Challenge Questions
Access
Chapter 1 I Introduction
Access in Practice Anecdote I Access in Business
What is Access? I Skill Set
Databases
Business Decisions and Databases
Navigation Pane and Access Objects
File Formats and Other Access Settings
Access Help
Using versus Creating Databases
Video Workshop I Introduction to Access
Why Do I Need This? I How Companies Use Databases
What's Wrong with This Database?
Access in Practice Anecdote I Solution
Review Questions
Skills Exam
Challenge Questions
Above and Beyond: Running Skills Exam
Above and Beyond: Challenge Questions
Chapter 2 I The Database Table
Access in Practice Anecdote I Merchandise Planning in the Fashion Industry
Creating Tables I Skill Set
Creating a New Table
Field Names, Data Types, and Field Properties
Indexing and Primary Keys
Entering and Formatting Data
Adjusting and Hiding Columns and Rows
Copying and Pasting Data
Sorting and Filtering Data
Video Workshop I Creating an Access Table
Why Do I Need This? I Collecting Customer Data for Marketing Promotions
What's Wrong with This Database?
Editing Tables I Skill Set
Changing Data Types and Field Properties
Changing the Sequence of Fields
Editing Data and Field Names
Inserting Fields
Deleting Fields and Records
Video Workshop I Editing a Table
Why Do I Need This? I Managing Transportation Data
What's Wrong with This Database?
Importing and Linking Data I Skill Set
Importing Data
Linking Data
Printing Tables
Video Workshop I Linking and Importing Tables
What's Wrong with This Database?
Access in Practice Anecdote I Solution
Review Questions
Skills Exam
Challenge Questions
Above and Beyond: Running Skills Exam
Above and Beyond: Challenge Questions
Chapter 3 I Selecting and Summarizing Data from Tables
Access in Practice Anecdote I Databases in Practice
Know Your Data I Skill Set
Getting Started
Single Field Primary Key Tables
Multiple Field Primary Key Tables
Video Workshop I Evaluating Tables
Why Do I Need This? I Analyzing a Call Center Database
What's Wrong with This Database?
Fundamental Query Techniques (The Select Query) I Skill Set
Creating a New Query
Adding Fields and Adjusting Columns
Query Name and Properties
Defining Basic Criteria (OR AND)
Formatting and Sorting Data
Editing Queries
Exploring Queries to Excel
Video Workshop I Basic Queries
Why Do I Need This? I Analyzing Transportation Data
What's Wrong with This Database?
Advanced Queries I Skill Set
Grouping Data
Mathematical Summaries (Aggregate Functions)
Nested Queries
Advanced Queries
Crosstab Queries
Video Workshop I Advanced Queries
Why Do I Need This? I Analyzing Merchandise Sales Trends
What's Wrong with This Database?
Access in Practice Anecdote I Solution
Review Questions
Skills Exam
Challenge Questions
Above and Beyond: Running Skills Exam
Above and Beyond: Challenge Questions
Chapter 4 I Applying Calculations to Data
Access in Practice Anecdote I My Role as an Information Systems Advisor
Formulas I Skill Set
Custom Fields
Calculated Fields
The Expression Builder
Video Workshop I Formulas
Why Do I Need This? I Stock Analysis
What's Wrong with This Database?
IIF Function I Skill Set
Basic IIF Function
Nested IIF Function
Video Workshop I IIF Functions
Why Do I Need This? I Developing a Promotion Strategy
What's Wrong with This Database?
Financial Functions I Skill Set
Future Value
Payment Function
Help with Functions
Video Workshop I Future Value Function
Video Workshop I Payment Function
Why Do I Need This? I Assessing the Value of Real Estate
What's Wrong with This Database?
Access in Practice Anecdote I Solution
Review Questions
Skills Exam
Challenge Questions
Above and Beyond: Running Skills Exam
Above and Beyond: Challenge Questions
Chapter 5 I Reports
Access in Practice Anecdote I My Role as a Retail Store Analyst
Fundamental Report Techniques I Skill Set
Creating a New Report
Setting the Dimensions of a Report
Report Header
Detail
Page Footer
Report Footer
Video Workshop I Fundamental Report Skills
Why Do I Need This? I Human Resource Status Report
What's Wrong with This Database?
Advanced Report Techniques I Skill Set
Grouping Data
Sorting Data
Calculated Fields
Conditional Formatting
Group and Report Totals
Lines
Dates
Video Workshop I Advanced Report Skills
Why Do I Need This? I Industry and Company Performance Report
What's Wrong with This Database?
Access in Practice Anecdote I Solution
Review Questions
Skills Exam
Challenge Questions
Above and Beyond: Running Skills Exam
Above and Beyond: Challenge Questions
Chapter 6 I Applying Core Competency Skills
Access in Practice Anecdote I Managing a Strategic Alliance
Using Multiple Tables in Queries I Skill Set
Joining Tables
Inner Joins
Outer Joins
Defining table Relationships
Video Workshop I Joining Tables
Video Workshop I Table Relationships
Why Do I Need This? I Evaluating Marketing Strategies and Sales
What's Wrong with This Database?
Comprehensive Access Project I Skill Set
Selecting Tables
Adding and Joining Tables in a Select Query
Creating a Parameter Query
Adding Calculations
Constructing the Final Report
Video Workshop I Comprehensive Project
Why Do I Need This? I Wealth Management Investment Reports
What's Wrong with This Database?
Access in Practice Anecdote I Solution
Review Questions
Skills Exam
Challenge Questions
Above and Beyond; Running Skills Exam
Above and Beyond: Challenge Questions
Quick Reference Guide
Glossary
Index