Microsoft Office 2007 in business
著者
書誌事項
Microsoft Office 2007 in business
Prentice Hall , Pearson Education [distributor], 2009
2nd ed
- : pbk
- タイトル別名
-
Core
注記
Previous ed.: 2008
Includes index
内容説明・目次
内容説明
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.
目次
- 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
「Nielsen BookData」 より