x

Our Privacy Policy has changed. By using this site, you agree to the Privacy Policy.

Your Office Microsoft Excel 2013, Comprehensive

ISBN-10: 0133143228
ISBN-13: 9780133143225
Edition: 2014
List price: $135.00 Buy it from $8.41
eBook available
This item qualifies for FREE shipping

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

30 day, 100% satisfaction guarantee

If an item you ordered from TextbookRush does not meet your expectations due to an error on our part, simply fill out a return request and then return it by mail within 30 days of ordering it for a full refund of item cost.

Learn more about our returns policy

Description: For use in the Office Applications course or  for individuals who would like to master Microsoft Excel 2013Make Microsoft Office, Your Office The Your Office series teaches readers the way Microsoft Office works in the real world, not just in a  More...

New Starting from $153.73
eBooks Starting from $61.99
Rent
Buy
what's this?
Rush Rewards U
Members Receive:
coins
coins
You have reached 400 XP and carrot coins. That is the daily max!
You could win $10,000

Get an entry for every item you buy, rent, or sell.

Study Briefs

Limited time offer: Get the first one free! (?)

All the information you need in one place! Each Study Brief is a summary of one specific subject; facts, figures, and explanations to help you learn faster.

Add to cart
Study Briefs
Business Ethics Online content $4.95 $1.99
Add to cart
Study Briefs
Business Law Online content $4.95 $1.99
Add to cart
Study Briefs
Management Online content $4.95 $1.99

Customers also bought

Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading

Book details

List price: $135.00
Copyright year: 2014
Publisher: Prentice Hall PTR
Publication date: 6/17/2013
Binding: Mixed Media
Pages: 832
Size: 9.50" wide x 11.25" long x 1.75" tall
Weight: 3.828
Language: English

For use in the Office Applications course or  for individuals who would like to master Microsoft Excel 2013Make Microsoft Office, Your Office The Your Office series teaches readers the way Microsoft Office works in the real world, not just in a classroom. With Your Office, readers will learn to use Office to make decisions and solve problems in a business context. Your Office bridges the gap between skill and application, and empowers students to master Office 2013 as a tool to solve problems and make decisions.Modular Structure Promotes Concept Retention: Provides a strong foundation for readers to practice in each workshop and then synthesize the objectives covered over two workshops—effectively challenging students to really retain what they learned as opposed to learning, and then forgetting soon after.Case Progression Promotes Concept Mastery: Readers progress from learning the skills in each Office Application to using the applications as tools to make business decisions.Realistic Series Scenario Provides Business Context: Readers gain a solid understanding of how an organization works as they see how individuals in all facets of a business interact with tools like Microsoft Office and use information to make decisions.Engaging Features Help Students Make Microsoft Office Their Own: Videos, Visual Summaries, and Real-World Advice boxes are among the features that help readers master Office to make decisions and solve problems in a business contex

Amy S. Kinser Tim O'Keefe Nathan Stout Diane Lending Dee Piziak Lynn S. Hogan Barbara S. Stover Patti Hammerle

Common Features
The Common Features of Microsoft Office
Prepare Case: Painted Paradise Resort and Spa Employee Training Preparation
Working with the Office Interface
Understand Office Applications and Accounts
Start Office Programs and Manipulate Windows
Use the Office Ribbon, Contextual Tools, and Other Menus
Manipulating Files and Finding Help in Office
Manage Files in Office
Get Help
Understanding the Cloud and Touch Integration
Use Windows SkyDrive
Use Touch Mode, Gestures, and Reading Mode
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Problem Solve
Problem Solve Case 1
Perform
Perform in Your Career
Perform in Your Life
Excel Module 1-Understanding the Fundamentals
Navigate, Manipulate, and Print Worksheets
Prepare Case: Red Bluff Golf Course and Pro Shop Golf Cart Purchase Analysis
Excel Worksheets-What If Data and Information Could Speak?
Understand Spreadsheet Terminology and Components
Navigate Worksheets and Workbooks
Document Your Work!
Enter and Edit Data
Manipulate Cells and Cell Ranges
Manipulate Columns and Rows
Printing Worksheets and Manipulating Workbooks
Preview and Print Worksheets
Manipulate Worksheets and Workbooks
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Problem Solve
Problem Solve Case 1
Perform
Perform in Your Career
Formatting, Functions, and Formulas
Prepare Case: Red Bluff Golf Course & Pro Shop Sales Analysis
Worksheet Formatting
Format Cells, Cell Ranges, and Worksheets
Creating Information for Decision Making
What Is a Function?
What Is a Formula?
Decision Making
Documenting Your Work
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Problem Solve
Problem Solve Case 1
Perform
Perform in Your Life
EXCEL Module 1 Capstone
More Practice
More Practice Case 1
Problem Solve
Problem Solve Case 1
Problem Solve Case 2
Perform
Perform in Your Life
Perform in Your Career
Perform in Your Team
How Others Perform
Excel Module 2-Conducting Business Analysis
Cell References, Named Ranges, and Functions
Prepare Case: Painted Paradise Resort and Spa Wedding Planning
Cell References and Named Ranges
Types of Cell References
Naming a Cell Range
Functions
Function Structure and Construction
Common Math and Statistical Functions
Common Date and Time Functions
Text Functions and Flash Fill
Financial and Lookup & Reference Functions
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Problem Solve
Problem Solve Case 1
Perform
Perform in Your Life
Effective Charts
Prepare Case: Turquoise Oasis Spa Sales Reports
Designing a Chart
Exploring Chart Characteristics: Types, Layouts, and Styles
Chart Locations
Chart Types
Laying out a Chart
Chart Layouts, Styles, and Data
Editing and Formatting Charts
Strategic Statements with Charts
Recognizing and Correcting Confusing Charts
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Problem Solve
Problem Solve Case 1
Perform
Perform in Your Career
EXCEL Module 2 Capstone
More Practice
More Practice Case 1
Problem Solve
Problem Solve Case 1
Problem Solve Case 2
Perform
Perform in Your Life
Perform in Your Career
Perform in Your Team
How Others Perform
Excel Module 3- Integrating Complex Functions into Business Analysis
Complex Conditional and Retrieval Functions
Prepare Case: Red Bluff Golf Course & Pro Shop Sales Analysis
Integrating Logical Functions
Preview the Data
Use IF Functions
Build Nested IF Functions
Integrate Conjunction Functions into IF Functions
Using Conditional Aggregate Functions
Use Conditional Statistical Functions
Use Conditional Math Functions
Construct Database Functions
Retrieving Data Using LOOKUP and Reference Functions
Explore LOOKUP Functions
Retrieve Data Using MATCH, INDEX, and INDIRECT
Handle Errors with the IFERROR Function
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Problem Solve
Problem Solve Case 1
Perform
Perform in Your Life
Analyze Data using Tables
Prepare Case: Golf Course Marketing Strategies
Organizing Data with Tables
Work with Data and Information
Work with Data and Information in Data Tables
Use the SUBTOTAL Function and Filters in Data Tables
Organizing and Analyzing with PivotTables and PivotCharts
Develop and Customize PivotTables
Develop and Customize PivotCharts
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Problem Solve
Problem Solve Case 1
Perform
Perform in Your Career
EXCEL Module 3 Capstone
More Practice
More Practice Case 1
Problem Solve
Problem Solve Case 1
Problem Solve Case 2
Perform
Perform in Your Life
Perform in Your Career
Perform in Your Team
How Others Perform
Excel Module 4-Building an Application with Multiple Worksheets and Workbooks
Multiple Worksheets, Workbooks, and Templates
Prepare Case: Turquoise Oasis Spa Therapist Sales and Service Analysis
Working with Multiple Worksheets
Group Worksheets
Create Summary Worksheets
Using Multiple Workbooks
Work with Multiple Workbooks
Collaborate Using Multiple Workbooks
Using and Creating Templates
Use Existing Templates
Create Templates from an Existing Workbook
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Problem Solve
Problem Solve Case 1
Perform
Perform in Your Life
Refine an Excel Application
Prepare Case: Turquoise Oasis Spa Application
Auditing Formulas
View Formula Precedents and Dependents
Evaluate Formulas
Correct Circular References
Use the Watch Window
Creating Data Validation Rules
Control Data Entry with Data Validation
Developing User-Friendly Excel Applications
Create and Use Macros
Change How to Navigate a Workbook
Protect Workbooks and Worksheets
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Problem Solve
Problem Solve Case 1
Perform
Perform in Your Career
EXCEL Module 4 Capstone
More Practice
More Practice Case 1
Problem Solve
Problem Solve Case 1
Problem Solve Case 2
Perform
Perform in Your Life
Perform in Your Career
Perform in Your Team
How Others Perform
Manipulating Data Sets for Decision Making
Organize, Import, Export, and Cleanse Data Sets
Prepare Case: Red Bluff Golf Course & Pro Shop Data Integration
Working with Data Sets
Understand the Importance of External Data Sets
Working with XML Data and Text Files
Connect to an Access Database
Making Data Useful
Clean Imported Data
Use Flash Fill to Cleanse Data
Separate Data Using Text Functions and Wizards
Clean Date-Related Data
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Problem Solve
Problem Solve Case 1
Perform
Perform in Your Life
Data Tables, Scenario Manager, and Solver
Prepare Case: The Red Bluff Golf Course & Pro Shop Business Planning Analysis
Examining Cost-Volume-Profit Relationships
Perform Break-Even Analysis
Analyze Variables in Formulas Through the Use of Data Tables
Use Goal Seek
Using the Scenario Manager
Use the Scenario Manager to Create Scenarios
Create Scenario Reports
Using Solver
Understand the Use of the Solver Add-In
Solve Complex Problems Using Solver
Generate and Interpret Solver Answer Reports
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Problem Solve
Problem Solve Case 1
Perform
Perform in Your Career
EXCEL Module 5 Capstone
More Practice
More Practice Case 1
Problem Solve
Problem Solve Case 1
Problem Solve Case 2
Perform
Perform in Your Life
Perform in Your Career
Perform in Your Team
How Others Perform
Building Financial and Statistical Models
Loan Amortization, Investment Analysis, and Asset Depreciation
Prepare Case: The Turquoise Oasis Spa Financial Analysis
Constructing a Financial Analysis on Loans
Construct a Loan Analysis with PMT, RATE, and NPER
Calculate Cumulative Interest and Principal Using CUMIPMT and CUMPRINC
Create an Amortization Schedule Using PPMT and IPMT
Constructing a Financial Analysis of Investments
Analyze Bonds Using PV and FV
Analyze Investments Using NPV, XNPV, IRR, and XIRR
Calculating the Depreciating Value of Business Assets
Calculate the Depreciation of Assets Using the SLN, DB, and DDB Functions
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Problem Solve
Problem Solve Case 1
Perform
Perform in Your Life
Business Statistics and Regression Analysis
Prepare Case: The Turquoise Oasis Spa: Using Statistics in Decision Making
Applying Basic Statistical Methods to Business
Understand the Language of Statistics
Understand the Basic Types of Data
Conduct Basic Statistical Analyses in Excel
Generate Descriptive Statistics and Other Analyses Using the Analysis ToolPak
Applying Probability Distributions to Business
Predict Business Outcomes Using Probability Distribution Functions
Finding Relationships in Data
Find Relationships in Data Using COVARIANCE.S and CORREL
Determine Relationships Between Multiple Variables Using a Correlation Matrix
Use Regression Analysis to Predict Future Values
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Problem Solve
Problem Solve Case 1
Perform
Perform in Your Career
EXCEL Module 6 Capstone
More Practice
More Practice Case 1
Problem Solve
Problem Solve Case 1
Problem Solve Case 2
Perform
Perform in Your Life
Perform in Your Career
Perform in Your Team
How Others Perform
Enabling Decisions with Data Visualization and VBA
Excel's Data Model, PowerPivot, and Power View
Prepare Case: The Red Bluff Golf Course & Pro Shop Dashboards, KPIs, and Data Visualizations
Exploring the Importance of Business Intelligence
Understand the Basics of Dashboard Design
Explore the New Data Model
Create Advanced Data Models Using PowerPivot
Create PivotTables and PivotCharts with PowerPivot
Use Apps for Office for Data Visualizations
Prepare a Dashboard for Production
Exploring the Benefits of Personalized Business Intelligence
Generate Visual Reports with Power View
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Problem Solve
Problem Solve Case 1
Perform
Perform in Your Life
Visual Basic for Applications
Prepare Case: The Red Bluff Golf Course & Pro Shop Spreadsheet Enhancement with Form Controls and VBA
Enhancing the Readability and Interactivity of Dashboards
Enhance Spreadsheets with Form Controls
Leveraging the Power of Visual Basic for Applications (VBA)
Understand the Components of VBA
Create Custom Functions with VBA
Improve Readability of VBA with Formatting and Structure
Troubleshoot VBA
Create and Use Loops in VBA
Assign VBA Procedures to Events
Protect and Secure a Workbook
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Problem Solve
Problem Solve Case 1
Perform
Perform in Your Career
EXCEL Module 7 Capstone
More Practice
More Practice Case 1
Problem Solve
Problem Solve Case 1
Problem Solve Case 2
Perform
Perform in Your Life
Perform in Your Career
Perform in Your Team
How Others Perform
Appendix: Efficient Interaction with a Touchscreen
Prepare Case: Painted Paradise Resort and Spa Works with Touch Features
Interacting with a Windows 8 Tablet PC
Understand Variations in Tablets
Understand Methods for Interacting with a Tablet PC
Using the Touch-Screen Interface
Use Flick, Touch, and Bezel Gestures
Use Office 2013 Touch Gestures
Use Other Touch Features
Concept Check
Key Terms

×
Free shipping on orders over $35*

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

Learn more about the TextbookRush Marketplace.

×