Microsoft Office 2007 in Business, Core

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.  

Microsoft Office 2007 In Business Core
Table of Contents



PowerPoint 

Chapter 1 - Introduction

Business Communication, Influence, and Decision Making

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

 

Chapter 2 - Creating a Basic Presentation

Designing Your Presentation

Creating a New Presentation
Slide Themes
Slide Layouts

Building Your Presentation

Adding New Slides and Text

Using the Outline View

Bullets and Numbered Lists

Presenting Qualitative and Quantitative Information and Objects

Shapes and Lines

Tables and Charts

Smart Art

Graphics, Audio, and Video

 

Chapter 3 - Enhancing Your Presentation

Formatting Your Slides

Clipboard Options

Font Group

Paragraph Panel

WordArt

Modifying Slide Masters

Sharing Content between Presentations

Slide Sorter View

Deleting and Rearranging Slides

Merging Presentations

Checking your Slides

Review Tab

Find and Replace

Print Preview

 

Chapter 4 - Delivering Your Presentation

Basic Presentation Options

On-Screen (Electronic) Delivery

Web Delivery

Hard Copy Presentations

 

Chapter 5 - Applying the Core Skills

Converting Documents into Presentations

Develop a Roadmap

Assemble Your Presentation

Reuse Word and Excel Objects

Effective Delivery Techniques

Word

Chapter 1 - Introduction to Word Basics

What is Word? 

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        

 

Chapter 2 - Creating a Basic Report

Paragraph and Text Formatting 

Introduction to Styles    

Using Styles to Change 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         

Page Formatting           

Page Margins   

Inserting Page Numbers          

Headers and Footers    

Inserting Fields into the Footer   

Creating a Cover Page 

 

Chapter 3 - Word Document Enhancements

Inserting and Working with Tables         

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          

The Power of Find and Replace

Finding Text     

Replacing Text 

More on Find   

Finding and Replacing Invisible Codes    

Complex Headers, Footers, and Page Numbers (Sections)          

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

 

Chapter 4 - Word Sharing Objects and Adding References

Pictures and Graphics   

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         

Inserting Slides, Spreadsheets, Charts, and Query Results           

Inserting a PowerPoint Slide     

Inserting Excel Chart    

Inserting Excel Spreadsheet      

Inserting the Results of an Access Query          

Footnotes and Endnotes           

Adding an Endnote       

Adding a Footnote        

Converting Endnotes to Footnotes and Vice Versa          

 

Excel
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

 

Access

Chapter 1 - Introduction

What is Access?

Databases

Business Decisions and Databases

Creating a New Access Database

Navigation Pane and Access Objects

File Formats and Other Access Settings

Access Help

Using versus Creating Databases

 

Chapter 2 - The Database Table

Creating Tables

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

Editing Tables

Changing Data Types and Field Properties

Changing the Sequence of Field

Editing Data and Field Names

Inserting Fields

Deleting Fields and Records

Importing and Linking Data

Importing Data

Linking Data

Printing Tables

 

Chapter 3 - Selecting and Summarizing Data from Tables

Know Your Data

Getting Started

Single Field Primary Key Tables

Multiple Field Primary Key Tables

Fundamental Query Techniques (The Select Query)

Creating a New Query

Adding Fields and Adjusting Columns

Query Name and Properties

Defining Basic Criteria (OR AND)

Formatting and Sorting Data

Editing Queries

Exporting Queries to Excel

Advanced Queries

Grouping Data

Mathematical Summaries (Aggregate Functions)

Nested Queries

Crosstab Queries

 

Chapter 4 - Applying Calculations to Data

Formulas

Custom Fields

Calculated Fields

The Expression Builder

IIF Function

Basic IIF Function

Nested IIF Functions

Financial Functions

Future Value

Payment Function

Help with Functions

 

Chapter 5 - Reports

Fundamental Report Techniques

Creating a New Report

Setting the Dimensions of a Report

Report Header

Page Header  

Detail

Page Footer

Report Footer

Advanced Report Techniques

Grouping Data

Sorting Data

Calculated Fields

Conditional Formatting

Group and Report Totals

Lines

Dates

 

Chapter 6 - Applying Core Competency Skills

Using Multiple Tables in Queries

Joining Tables

Inner Joins

Outer Joins

Defining Table Relationships

Comprehensive Access Project

Selecting Tables

Adding and Joining Tables in a Select Query

Creating a Parameter Query

Adding Calculations

Constructing the Final Report