x

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

Your Office Microsoft Excel 2010 Comprehensive

ISBN-10: 0132610442
ISBN-13: 9780132610445
Edition: 2012
List price: $87.99 Buy it from $3.00
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: Your Office is ideal for introductory computer courses on Microsoft Office 2010 or courses in computer concepts with a lab component for Microsoft Office 2010 applications. Your Office is the Office Applications textbook written for instructors who  More...

Used Starting from $64.38
eBooks Starting from $32.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!

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
Periodic Table Online content $4.95 $1.99
Add to cart
Study Briefs
SQL Online content $4.95 $1.99
Add to cart
Study Briefs
MS Excel® 2010 Online content $4.95 $1.99
Add to cart
Study Briefs
MS Word® 2010 Online content $4.95 $1.99

Customers also bought

Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading

Book details

List price: $87.99
Copyright year: 2012
Publisher: Pearson Education, Limited
Publication date: 9/28/2011
Binding: Comb Bound 
Pages: 736
Size: 8.00" wide x 11.00" long x 0.75" tall
Weight: 3.146

Your Office is ideal for introductory computer courses on Microsoft Office 2010 or courses in computer concepts with a lab component for Microsoft Office 2010 applications. Your Office is the Office Applications textbook written for instructors who want more than a 'skill & drill' book that enables students to learn discreet tasks but fails to illustrate the big picture of how these skills work together. Your Office bridges the gap between skill and application, and empowers students to master Office 2010 as a tool to solve problems and make decisions. The cases progress students from learning the skills in each Office Application to using the applications as tools to make business decisions. The unique modular structure provides a strong foundation for students through practice in each workshop and then synthesizes the objectives covered over two workshops, challenging students to really retain what they learned as opposed to learning and then forgetting soon after. The series scenario introduces a large global business (the resort and spa) made up of smaller businesses (golf pro shop, spa, restaurants, event planning, etc) featured in the cases that run throughout all four applications. This approach gives students a solid understanding of how an organization works by exposing them to how individuals in all facets of a business interact with tools like Microsoft Office and use information to make decisions.

Workshop 1: Understanding and Manipulating Microsoft Excel
Prepare Case: Red Bluff Golf Club Golf Cart Purchase Analysis
Excel Worksheets-What if Data and Information could speak?
Understanding Spreadsheet terminology and components
Starting Excel
What is a Workbook?
Opening a Workbook
Saving and renaming a Workbook
Cells, Rows, and Columns
Worksheet Navigation
Scrolling
Keyboard Navigation
Go To
Navigating among Worksheets
Documentation
Failing to plan is planning to fail
Enter and Edit Data
Text, Numbers, Dates, and Times
How Excel really stores Date and Time Data
Text Wrapping and Hard Returns
Manipulate Cells and Ranges
Selecting Cells and Cell Ranges
Drag and Drop
Cut/Copy and Paste
Series (AutoFill)
Modifying Cell Information
Inserting Cells
Deleting Cells
Merge & Center vs. Center Across
Manipulate Columns and Rows
Select Contiguous and Noncontiguous Columns and Rows
Rows
Inserting Columns and Rows
Column Width and Row Height
Changing Column Widths using AutoFit
Delete vs. Clear
Inserting Columns that contain Data
Printing Worksheets and Manipulating Workbooks
Preview and Print Worksheets
Worksheet Views
Print Preview, Printer Selection, and Print
Print Titles
Print Headers/Footers
Page Margins
Page Orientation
Scaling
Manipulate Worksheets and Workbooks
Name a Worksheet
Insert or Delete a Worksheet
Move a Worksheet
Deleting a Worksheet
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Practice Case 2
Workshop 2: Formatting, Formulas, and Functions
Prepare Case: Red Bluff Golf Club Golf Pro Shop Sales Analysis
Worksheet Formatting
Format Cells, Cell Ranges, and Worksheets
Copying a document from one Workbook to another
Numbers
Formats
Negative Values and Color
Dates and Times
Cell Alignment
Content Orientation
Fill Color
Cell Borders
Copying Formats
Paste Options/ Paste Special
Built-in Cell Styles
Table Styles
Workbook themes
Creating Information for Decision Making
What is a Function?
AutoSum Functions
SUM()
COUNT()
AVERAGE()
Min() and Max()
What is a Formula?
Operators
Order of Operations
Hiding Information in a Worksheet
Show Functions and Formulas
Decision Making
Conditional Formatting
Removing Conditional Formatting
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Practice Case 2
Capstone
More Practice
Problem Solve
Problem Solve Case 1
Problem Solve Case 2
Problem Solve Case 3
Perform
Perform in Your Life
Perform in Your Career
Perform in Your Career
How Others Perform
Workshop 3: Conducting Excel Analysis through Functions and Charts
Prepare Case: Massage Table Analysis
Cell References and Formula Basics
Reference Cells within Formulas or Functions
Absolute Cell Reference
Mixed Cell Reference
Working with Named Ranges
Creating Named Ranges in the Name Box
Creating Named Ranges from Selections
Modifying Named Ranges
Using Named Ranges
Creating Formulas Using Named Ranges
Functions
Understanding the Syntax of a Function
Function Structure
Function Construction with Function Arguments Dialog Box
Function Construction with the Formula Bar
Common Functions
Date and Time Functions
Math and Trig Functions
Statistical Functions
COUNTA
Financial Functions
Logical Functions
Adding an IF Function to an existing Formula
Editing and Troubleshooting Functions
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Practice Case 2
Workshop 4: Using Charts
Prepare Case: Turquoise Oasis Spa Sales Report
Designing a Chart
Exploring Chart Characteristics-Types, Layouts, and Styles
Navigating a Chart
Chart Locations
Creating Charts in an existing Worksheet
Modifying a Chart's Position
Placing Charts on a Chart Sheet
Chart Types
Pie Charts
Line Charts
Column Charts
Bar Charts
Scatter Charts
Area Charts
Chart Layout, Styles, and Data
Laying out a Chart
Inserting Objects
Working with Labels
Titles for the Chart and Axes
Working with the Legend and Labeling the Data
Modifying Axes
Changing Gridlines
Analysis with Trendlines
Editing and Formatting Charts
Colorizing Objects
Working with Text
Exploding Pie Charts
3-D Charts and Rotation of Charts
Effectively Using Charts
Strategic Statements with Charts
Emphasizing Data
Sparklines
Data Bars, Color Scales, and Icon Sets
Recognizing and Correcting Confusing Charts
Correcting a Line Chart
Changing the Chart Type and Legend
Preparing to Print and Copy
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Practice Case 2
Capstone
More Practice
Problem Solve
Problem Solve Case 1
Problem Solve Case 2
Problem Solve Case 3
Perform
Perform in Your Life
Perform in Your Career
Perform in Your Career
How Others Perform
Workshop 5: Integrating Complex Functions into Excel Analysis
Prepare Case: Red Bluff Pro Shop Sales Analysis
Integrating Logical Functions
Using Nested IF Functions
Using Conjunction Functions in IF Functions
Using Conditional Aggregate Functions
Using Conditional Statistical Functions
The COUNTIF and COUNTIFS Functions
The AVERAGEIF and AVERAGEIFS Functions
Using Conditional Math Functions
The SUMIF Function
The SUMIFS Function
The DSUM Function
Retrieving Data Using LOOKUP and Reference Functions
Using LOOKUP Functions
Retrieving Data with MATCH, INDEX, and INDIRECT
The MATCH function
The Index Function
The INDIRECT Function
Handling Errors with the IFERROR Function
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Practice Case 2
Workshop 6: Analyzing Data Using Data
Prepare Case: Golf Course Marketing Strategies
Organizing Data with Tables
Working with Tables of Data
Organizing Data Sets
Organizing a Data Set within a Table
Filtering Data Sets
Using the Advanced Filter Feature
Using the SUBTOTAL Function and Filters with Tables
Organizing and Analyzing with PivotTables and PivotCharts
Developing PivotTables
Creating PivotTables
PivotTable Options
Adding a Slicer to the PivotTable
Design options within PivotTables
Updating and Sharing Data in PivotTables
Creating PivotCharts
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Practice Case 2
Capstone
More Practice
Problem Solve
Problem Solve Case 1
Problem Solve Case 2
Problem Solve Case 3
Perform
Perform in Your Life

×
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.

×