Muutke küpsiste eelistusi

Succeeding in Business with Microsoft Office Excel 2007: A Problem-Solving Approach [Pehme köide]

3.29/5 (14 hinnangut Goodreads-ist)
, ,
  • Formaat: Paperback / softback, 705 pages, kõrgus x laius x paksus: 246x189x20 mm, kaal: 1040 g
  • Ilmumisaeg: 10-Sep-2007
  • Kirjastus: Course Technology Inc
  • ISBN-10: 1423906055
  • ISBN-13: 9781423906056
Teised raamatud teemal:
  • Pehme köide
  • Hind: 101,79 €*
  • * saadame teile pakkumise kasutatud raamatule, mille hind võib erineda kodulehel olevast hinnast
  • See raamat on trükist otsas, kuid me saadame teile pakkumise kasutatud raamatule.
  • Kogus:
  • Lisa ostukorvi
  • Tasuta tarne
  • Lisa soovinimekirja
Succeeding in Business with Microsoft Office Excel 2007: A Problem-Solving ApproachSuurem pilt
  • Formaat: Paperback / softback, 705 pages, kõrgus x laius x paksus: 246x189x20 mm, kaal: 1040 g
  • Ilmumisaeg: 10-Sep-2007
  • Kirjastus: Course Technology Inc
  • ISBN-10: 1423906055
  • ISBN-13: 9781423906056
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9781423906056.html
Märksõnad:
Succeeding in Business with Microsoft Excel 2007: A Problem-Solving Approach prepares users to analyze data and solve real-life business problems using Microsoft Excel as a tool. Moving beyond the basic ?point and click? focus of most computer applications texts, it challenges you to use critical thinking and analysis to find efficient and effective solutions to real-life situations.
Preface xiv
The Succeeding in Business Instructor Resources xv
Succeeding in Business Series Walk-Through xvii
About the Authors xx
Author Acknowledgements xxi
New Features in Excel 2007
2(16)
Introduction
2(16)
Starting Excel 2007
2(1)
Using the Office Button and Quick Access Toolbar
3(1)
Opening and Closing Files in Excel 2007
3(2)
Saving Files in Excel 2007
5(1)
Taking Advantage of the New Worksheet Size
5(1)
'Adding and Renaming Worksheets
6(1)
Using the Ribbon
6(4)
Using the Keyboard to Make Selections
10(1)
Adding Commands to the Quick Access Toolbar
11(2)
Working in Page Layout View
13(1)
Using Formula AutoComplete
14(1)
Creating Charts
15(1)
Using Live Preview
16(1)
Getting Help
16(1)
Chapter Summary
17(1)
Introduction to Problem Solving and Decision Making with Microsoft Office Excel 2007
18(632)
About This Book and Microsoft Office Excel 2007
19(1)
The Relationship Between Problem Solving and Decision Making
20(2)
Information Overload
20(1)
Which Comes First: The Problem or the Decision?
21(1)
A Problem-Solving Process
22(6)
Problem Recognition
23(1)
Analyzing the Problem
23(1)
Problem Statement
24(1)
Solution
24(4)
Problem Solving in This Book
28(1)
Case Scenario
29(3)
The Company
29(1)
The Brand
29(1)
Key Players
29(1)
Company Goal: Expand the Product Line
30(1)
How Is Excel Used at TheZone?
30(2)
Chapter Summary
32(1)
Conceptual Review
33(1)
Applying Fundamental Excel Skills and Tools in Problem Solving
34(54)
Level 1: Identifying and Correcting Common Errors in Formatting and Formulas
36(18)
Examining a Basic Worksheet for Errors
36(1)
Correcting Formatting Problems
37(1)
Modifying Column Width and Row Height
38(1)
Checking Error Messages
38(1)
Formatting Numbers
39(2)
Inserting and Aligning a Title
41(2)
Inserting Columns
43(1)
Correcting Errors in Formulas
44(2)
Checking Simple Formulas for Accuracy
46(1)
Using Formulas and Cell References Instead of Values
46(1)
Determining Order of Precedence
47(1)
Understanding Precision vs. Display
48(3)
Checking Accuracy in Formula Updates
51(1)
Steps to Success: Level 1
52(2)
Level 2: Calculating and Comparing Data Using Simple Functions
54(10)
Working with Multiple Worksheets
54(1)
Calculating Totals using the Sum Function
55(2)
Calculating Quickly with AutoSum
57(1)
Calculating Average, Minimum, and Maximum Values
58(3)
Calculating the Number of Values Using the Count and Counta Functions
61(1)
Steps To Success: Level 2
62(2)
Level 3: Analyzing Cell References When Writing and Copying formulas
64(15)
Creating a Budget Workbook
64(1)
Organizing the Workbook
65(3)
Understanding Relative Cell Referencing
68(2)
Understanding Absolute and Mixed Cell Referencing
70(4)
Naming a Cell or Cell Range
74(1)
Writing a Formula to Subtotal the Cost of Goods Sold
74(1)
Writing a Formula to Calculate Selling Expense
74(1)
Writing a Formula to Calculate Projected Earnings
75(1)
Completing the Budget Workbook
76(1)
Steps To Success: Level 3
77(2)
Chapter Summary
79(9)
Conceptual Review
80(2)
Case Problems
82(1)
Level 1 - Purchasing a Computer for Grusee & Associates
82(2)
Level 2 - Compiling Relocation Information for Devcon Finn, Inc.
84(1)
Level 3 - Analyzing Regional Sales Information for CKG Auto
85(3)
Solving Problems with Statistical Analysis Tools
88(72)
Level 1 Using Statistical Functions to Compare Data Values
90(23)
Understanding Fundamentals of Statistics
90(4)
Controlling the Precision of Data Using the Round Function
94(3)
Rounding Values to the Nearest Hundredth
97(3)
Using Paste Special to Copy and Paste Data
100(3)
Calculating the Mean, Median, Mode, and Standard Deviation
103(2)
Managing Large Worksheets by Freezing Panes and Splitting the Window
105(2)
Comparing Current Values to Historical Values
107(2)
Calculating the Difference Between Two Sets of Data
109(1)
Calculating the Percent Difference Between Two Sets of Data
109(2)
Steps To Success: Level 1
111(2)
Level 2 Organizing and Evaluating Different Data Groupings
113(18)
Determining a Rank for Each Value in a Data Set
113(3)
Determining the Highest and Lowest Values in a Data Set
116(1)
Determining the Highest Value with the LARGE Function
116(2)
Determining the Lowest Value with the SMALL Function
118(1)
Determining the Number of Items that Meet Specified Criteria
119(5)
Determining a Total Value for Items that Meet Specified Criteria
124(6)
Steps To Success: Level 2
130(1)
Level 3 Extending the Analysis with What-if, Goal Seek, and Simulation
131(20)
Evaluating a Larger Data Set
131(2)
Specifying a Custom Number Format
133(1)
Understanding Custom Formatting Codes
134(3)
Considering Alternatives: What-if Analysis and Goal Seek
137(1)
Performing What-if Analysis
138(1)
Using the Goal Seek Tool to Work Backward
139(3)
Combining Countif and Sumif to Analyze Data in Specific Categories
142(2)
Analyzing Data Through Simulation
144(2)
Randomly Assigning a Number Between Two Values Using the RANDBE-TWEEN Function
146(1)
Assigning a Random Value Using the RAND Function
146(1)
Calculating Probable Costs Using a ROUND Function
147(2)
Completing the Cost-Benefit Analysis
149(1)
Steps to Success: Level 3
149(2)
Chapter Summary
151(9)
Conceptual Review
151(2)
Case Problems
153(1)
Level 1 - Analyzing Sales for Cremes Ice Cream
153(2)
Level 2 - Analyzing Demographic Data for La Rosa Restaurant
155(2)
Level 3 - Determining Inventory Levels for CKG Auto
157(3)
Determining Effective Data Display with Charts
160(54)
Level 1 Visualizing Data
162(18)
Effective Charting in Excel
166(1)
Determining the Appropriate Chart Type and Chart Options
166(13)
Steps To Success: Level 1
179(1)
Level 2 Evaluating Chart Sub-types
180(18)
Examining Sub-types for Various Chart Types
180(1)
Adding Things Up: Stacked Chart Options
180(1)
Summing to 100%: Alternatives to Pie Charts
181(2)
Slicing the Pie Too Thin: Summarizing Too Much Detail in Pie Charts
183(5)
Monitoring a Business with Stock Charts
188(8)
Steps To Success: Level 2
196(2)
Level 3 Exploring More Advanced Chart Types
198(11)
Evaluating the Effectiveness of Radar, Bubble, and Dashboard Charts
198(1)
Understanding Radar Charts
198(3)
Understanding Bubble Charts
201(4)
Creating a Management Dashboard
205(3)
Steps To Success: Level 3
208(1)
Chapter Summary
209(5)
Conceptual Review
211(1)
Case Problems
212(1)
Level 1 - Illustrating Travel Data for the Indiana Department of Tourism
212(1)
Level 2 - Analyzing Stock Performance for Universal Investments
212(1)
Level 3 - Illustrating Patterns in Gas Prices for CKG Auto
213(1)
Applying Logic in Decision Making
214(70)
Level 1 Analyzing Data Using Relational Operators and Boolean Logical Functions
216(28)
Reviewing Financial Criteria Related to Credit
216(4)
Using Relational Operators to Compare two Values
220(2)
Using Boolean Logical Functions to Evaluate a List of Values and Determine a Single True or False Value
222(2)
Using the OR Function to Evaluate Criteria
224(3)
Using the AND Function to Evaluate Criteria
227(3)
Using the NOT Function to Evaluate Criteria
230(1)
Applying Conditional Formatting to a Worksheet
231(1)
Applying Preset Conditional Formatting Features
232(3)
Applying Conditional Formatting Based on Cell Value
235(3)
Applying Conditional Formatting Based on the Results of a Formula
238(4)
Steps To Success: Level 1
242(2)
Level 2 Analyzing Data Using if Functions and Nested Functions
244(15)
Introduction to if Functions and Nested Functions
244(1)
Writing Simple if Functions
244(2)
Writing an IF Function with a Logical Test That Evaluates TRUE/FALSE Values
246(1)
Writing an IF Function with a Logical Test That Performs a Simple Calculation
247(3)
Writing if Functions with Nested Functions
250(2)
Constructing a Simple Nested if Function
252(3)
The Order of Logical Tests for Nonmutually Exclusive Criteria
255(1)
The Order of Logical Tests for Mutually Exclusive Criteria
256(1)
The Order of Logical Tests for Criteria Between a Range of Values
256(1)
Steps To Success: Level 2
257(2)
Level 3 Creating Complex Logical Constructs for Solving Problems
259(14)
Evaluating more Complex Criteria
259(2)
Using an if Function to Combine Sets of Criteria
261(2)
Using the None of Construct
263(2)
Using the only Construct
265(3)
Nesting Boolean Logical Operators to Analyze Criteria
268(1)
Completing the Complex Nested if Formula
269(3)
Steps To Success: Level 3
272(1)
Chapter Summary
273(11)
Conceptual Review
274(2)
Case Problems
276(1)
Level 1 - Evaluating Job Applicants for Winston, Winston & Coombs
276(2)
Level 2 - Estimating Painting Job Costs for RJ Construction
278(3)
Level 3 - Analyzing Dealership Promotions for CKG Auto
281(3)
Retrieving Data for Computation, Analysis, and Reference
284(72)
Level 1 Performing Basic Lookups to Calculate and Evaluate Data
286(16)
Working with Lookup Tables
286(1)
Retrieving Data from a Vertical Lookup Table
287(2)
Looking Up Unit Prices Using a VLOOKUP
289(1)
Examining the VLOOKUP Rules
290(3)
Retrieving an Exact Match
293(3)
Retrieving Data from a Horizontal Lookup Table
296(4)
Steps To Success: Level 1
300(2)
Level 2 Performing more Complex Lookups Involving Multiple Worksheets and Multidimensional Tables
302(17)
Retrieving Data from Multiple Worksheets
302(1)
Using VLOOKUP with Multiple Worksheets
303(3)
Looking Up Data in a One-Row or One-Column Range
306(3)
Retrieving Data from Multidimensional Tables
309(1)
Using the INDEX Function with a Two-Dimensional Table
310(3)
Using the INDEX Function with a Three-Dimensional Table
313(4)
Steps To Success: Level 2
317(2)
Level 3 Nesting Lookup and Reference Functions to Retrieve and Calculate Data
319(27)
Refining the Order form
319(4)
Preventing Errors in Data Retrieval
323(1)
Using the ISBLANK Function
324(3)
Nesting Lookup Functions to Calculate the Price per unit
327(1)
Nesting VLOOKUP in an IF Function to Determine the lookup_value
328(1)
Using the CHOOSE Function to Determine the table_array
329(2)
Determining the col_index_num
331(1)
Determining the range_lookup
332(1)
Creating the Nested VLOOKUP Formula
333(1)
Calculating Totals
334(1)
Calculating the Discount Amount
335(1)
Calculating the Shipping Costs Using Match and Index Functions
336(3)
Determining the Reference Argument of the INDEX Function
339(1)
Determining the row_num of the INDEX Function
339(1)
Determining the column_num of the INDEX Function by Using the MATCH Function
339(2)
Determining the area_num of the INDEX Function
341(1)
Creating the Complex INDEX Formula and Completing the Worksheet
342(2)
Steps To Success: Level 3
344(2)
Chapter Summary
346(10)
Conceptual Review
347(2)
Case Problems
349(1)
Level 1 - Evaluating Tax Rates for the Arlington Group
349(2)
Level 2 - Calculating Travel Costs at America Travels
351(2)
Level 3 - Creating a Cost Estimate Form for CKG Auto
353(3)
Evaluating the Financial Impact of Loans and Investments
356(66)
Level 1 Calculating Values for Simple Financial Transactions
358(18)
Understanding How Interest is Calculated
358(1)
Calculating Simple Interest
358(1)
Calculating Compound Interest
359(1)
Reviewing Alternative Financing Options
360(1)
Using the Pmt Function to Determine a Loan Payment
361(1)
The Arguments of the PMT Function
362(1)
Understanding Cash Flow (Inputs and Outputs)
363(1)
Specifying Consistent Units of Time
364(1)
Determining the Value of the Loan Payment
364(1)
Using a Financial Function with Cell Referencing
365(1)
Using the Rate, NPER, PV, and FV Functions
366(1)
Determining the Future Value of a Financial Transaction
366(3)
Determining the Present Value of a Financial Transaction
369(1)
Determining the Interest Rate of a Financial Transaction
370(1)
Determining the Number of Periods of a Financial Transaction
371(2)
Selecting a Financing Option
373(1)
Steps To Success: Level 1
374(2)
Level 2 Creating a Projected Cash Flow Estimate and Amortization Table
376(21)
Designing the Cash Flow Estimate Worksheet
376(1)
Identifying the Missing Data Elements
377(2)
Setting up an Amortization Table
379(1)
Calculating Principal and Interest Payments
380(3)
Calculating Principal and Interest Payments Between Two Periods
383(3)
Calculating Depreciation Using the SLN Function
386(4)
Alternative Depreciation Options Provided in Excel
390(1)
Calculating Taxes
391(2)
Completing the Analysis
393(2)
Steps To Success: Level 2
395(2)
Level 3 Evaluating the Financial Viability of Alternative Project Options
397(16)
Setting up a Worksheet to Analyze Profitability
397(3)
Calculating Net Present Value
400(1)
Entering the NPV Function
400(1)
Setting Up a Table of Hurdle Rates
401(2)
Calculating the Internal Rate of Return
403(2)
Creating a Chart Showing the Hurdle Rate vs. NPV
405(1)
Calculating the Return on Investment
405(1)
Determining the Payback Period
406(2)
Setting up the Worksheet for the Low Capital Option
408(3)
Evaluating the Results of the Analysis
411(1)
Steps To Success: Level 3
411(2)
Chapter Summary
413(9)
Conceptual Review
413(2)
Case Problems
415(1)
Level 1 - Evaluating Loan Options for Flowers By Diana
415(2)
Level 2 - Creating a Mortgage Calculator for TriState Savings & Loan
417(2)
Level 3 - Analyzing Purchasing vs. Leasing Options for CKG Auto
419(3)
Organizing Data for Effective Analysis
422(62)
Level 1 Importing and Structuring Text Data in Excel Worksheets
424(21)
Working With Text Data
424(2)
Combining Text Using the CONCATENATE Function
426(1)
Extracting Characters from a Text String
427(1)
Removing Spaces from a Text String
428(2)
Determining the Position of a Character Within a Text String
430(1)
Sorting and Removing Invalid Data
430(3)
Working with Nonnumeric Data
433(1)
Labeling and Sorting Data
434(2)
Analyzing Data by Creating Subtotals
436(2)
Creating and Working with an Excel Table
438(2)
Sorting an Excel Table
440(1)
Filtering an Excel Table
441(2)
Adding Data to an Excel Table
443(1)
Removing an Excel Table Definition
443(1)
Steps To Success: Level 1
444(1)
Level 2 Analyzing Data Imported from a Database and Organizing Data with a Pivottable Report
445(21)
Importing Data from a Database Into Excel
445(2)
Importing an Access Table into Excel
447(1)
Using the Microsoft Query Wizard to Select Data from a Database
448(3)
Making Calculations with Date and Time Data
451(3)
Analyzing Data Using a Pivottable Report
454(1)
Creating a PivotTable Report
455(1)
Analyzing Data Using the Row, Column, and Value Areas
456(3)
Adding Fields to the Report Filter Area
459(2)
Evaluating Data Using a Pivotchart Report
461(2)
Importing Information from the Web into Excel
463(2)
Steps To Success: Level 2
465(1)
Level 3 Importing and Exporting XML Data
466(13)
Understanding Markup Languages and XML
466(2)
XML Documents
468(1)
Analyzing XML Data with Excel
469(1)
Importing XML Data as an XML Table
469(3)
Adding an XML Map to a Workbook
472(2)
Exporting XML Data
474(3)
Steps To Success: Level 3
477(2)
Chapter Summary
479(5)
Conceptual Review
479(2)
Case Problems
481(1)
Level 1 - Importing and Analyzing Data for Johnson Equipment
481(1)
Level 2 - Analyzing Manager Performance at Home Station
482(1)
Level 3 - Creating a Loan Application and Amortization for CKG Auto
483(1)
Using Data Tables and Excel Scenarios for What-lf Analysis
484(62)
Level 1 Using Data Tables to Perform Break-Even and Sensitivity Analysis
486(21)
Conducting Break-Even and Sensitivity Analyses
486(2)
Analyzing What-If Results with Data Tables
488(1)
Preparing a Worksheet for Data Tables
489(3)
Varying One Value in a What-lf Analysis
492(1)
Setting Up a One-Variable Data Table's Structure
493(1)
Completing a One-Variable Data Table
494(2)
Interpreting One-Variable Data Tables
496(3)
Varying Two Values in a What-lf Analysis
499(1)
Setting Up a Two.-Variable Data Table's Structure
500(1)
Completing a Two-Variable Data Table
501(2)
Interpreting Two-Variable Data Tables
503(3)
Steps To Success: Level 1
506(1)
Level 2 Using Scenarios to Perform What-lf Analysis
507(23)
Comparing the Results of Complex Analyses
507(1)
Planning Scenarios
508(1)
Preparing the Inputs
508(2)
Preparing the Outputs
510(1)
Setting Up a Scenario
511(1)
Preparing a Worksheet for Scenarios
512(2)
Adding Scenarios to a Worksheet
514(3)
Viewing and Analyzing Scenarios
517(4)
Editing and Deleting Scenarios
521(2)
Generating Scenario Reports
523(1)
Creating Scenario Summaries
523(2)
Creating Scenario PivotTable Reports
525(2)
Creating Scenario PivotChart Reports
527(1)
Steps To Success: Level 2
528(2)
Level 3 Using Excel's Data Tables to Create a Simulation
530(11)
Understanding Simulation in Business
530(1)
Preparing a Worksheet for a Simulation Using a Data Table
531(3)
Developing a Simulation with a Two-Variable Data Table
534(1)
Structuring a Two-Variable Data Table for a Simulation
534(1)
Completing a Two-Variable Data Table for a Simulation
535(2)
Calculating Simulation Statistics
537(2)
Interpreting Simulation Results
539(1)
Steps To Success: Level 3
539(2)
Chapter Summary
541(5)
Conceptual Review
541(1)
Case Problems
542(1)
Level 1 - Estimating Travel Expenses for Customers of Executive Transport, Inc.
542(1)
Level 2 - Evaluating Expansion Financing Options for Granite City Books
543(1)
Level 3 - Analyzing Health Insurance Plan Options for CKG Auto
544(2)
Enhancing Decision Making with Solver
546(50)
Level 1 Solving Product Mix Questions Using Goal Seek and Solver
548(17)
The Other Side of What-If Analysis
548(1)
Performing What-if Analysis Using Goal Seek
549(1)
Creating a Solver Model
550(8)
Adding or Changing a Constraint in a Solver Model
558(3)
Saving a Solver Solution as a Scenario
561(1)
Analyzing Data Using a Solver Report
562(1)
Steps To Success: Level 1
563(2)
Level 2 Enhancing the Production Plan with Solver
565(11)
Adding Time Variables to the Production Plan
565(1)
Adding Formulas and Constraints to the Solver Model
565(3)
Troubleshooting an Infeasible Solution
568(1)
Troubleshooting an Unbounded Solution
568(1)
Identifying a Feasible Solution
569(1)
Visualizing the Constraints in a Solver Model
570(3)
Finding an Optimal Solution
573(2)
Steps To Success: Level 2
575(1)
Level 3 Managing Transportation Problems with Solver
576(15)
Developing a Distribution Plan Using Solver
576(1)
Setting Up a Worksheet for the Distribution Plan
577(4)
Saving a Solver Model
581(4)
Using Solver when Demand Exceeds Supply
585(1)
Assigning Contracts by Using Binary Constraints
586(2)
Evaluating Assignment Problems with Too Many Resources
588(2)
Steps To Success: Level 3
590(1)
Chapter Summary
591(5)
Conceptual Review
591(1)
Case Problems
592(1)
Level 1 - Creating a Production Plan for ATC Inc.
592(1)
Level 2 - Managing Purchases for Brightstar Toy Company
593(2)
Level 3 - Assigning Specialists to Teams at CKG Auto
595(1)
Troubleshooting Workbooks and Creating Excel Applications
596(54)
Level 1 Preparing Error-Free Workbooks
598(21)
Planning an Excel Application
598(1)
Controlling Data-Entry Errors
599(2)
Validating Data Using the Data Validation Tool
601(6)
Circling Invalid Data
607(1)
Protecting Workbooks
608(1)
Locking and Unlocking Cells
609(1)
Protecting a Worksheet
610(2)
Hiding and Displaying Rows and Columns
612(1)
Protecting a Workbook
613(1)
Documenting Workbooks
614(2)
Providing a Thorough Documentation Worksheet
616(1)
Including Comments in a Worksheet
616(2)
Steps To Success: Level 1
618(1)
Level 2 Preventing Errors in Formulas
619(13)
Auditing Formulas
619(1)
Using the Formula Auditing Tools
620(1)
Tracing and Solving Formula Errors
621(2)
Tracing Errors
623(1)
Identifying and Correcting Errors
624(2)
Tracing Precedent Cells
626(1)
Tracing Dependent Cells
627(3)
Setting Error-Checking Options
630(1)
Steps To Success: Level 2
631(1)
Level 3 Automating Excel Tasks
632(13)
Understanding Macros
632(2)
Recording a Macro
634(2)
Running a Macro
636(2)
Creating a Macro Button
638(1)
Editing a Macro in the Visual Basic Editor
639(5)
Steps To Success: Level 3
644(1)
Chapter Summary
645(5)
Conceptual Review
645(1)
Case Problems
646(1)
Level 1 - Troubleshooting Formulas and Data Entry for a Payroll Data Workbook for Irene's Scrapbooking World
646(1)
Level 2 - Troubleshooting Formulas for a Job Invoicing Workbook for David's Computer Repair
647(2)
Level 3 - Projected Sales and Commissions for CKG Auto
649(1)
Glossary 650(11)
Index 661