Wintersalen Sale
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Tour our stores


    Recently Viewed clear list


    Interviews | September 2, 2014

    Jill Owens: IMG David Mitchell: The Powells.com Interview



    David Mitchell's newest mind-bending, time-skipping novel may be his most accomplished work yet. Written in six sections, one per decade, The Bone... Continue »

    spacer

Teach Yourself Visually Excel 2007

by

Teach Yourself Visually Excel 2007 Cover

 

Synopses & Reviews

Publisher Comments:

Are you a visual learner? Do you prefer instructions that show you how to do something — and skip the long-winded explanations? If so, then this book is for you. Open it up and you'll find clear, step-by-step screen shots that show you how to tackle more than 150 Excel 2007 tasks. Each task-based spread includes easy, visual directions for performing necessary operations, including:
  • Using the Ribbon and galleries
  • Entering data and resizing columns
  • Applying formulas and functions
  • Formatting worksheets
  • Adding clip art and 3D effects
  • Interpreting data with charts
  • Helpful sidebars offer practical tips and tricks
  • Succinct explanations walk you through step by step
  • Full-color screen shots demonstrate each task
  • Two-page lessons break big topics into bite-sized modules

Synopsis:

* This book illustrates the extensive changes in the new version of Excel such as new collaboration tools, an updated Excel Server, list functionality, and information protection as well as a new look with a redesigned UI

* Step-by-step instructions with practical examples and advice guide users through the world's most widely used spreadsheet application

* With gorgeous, full-color illustrations on every page, high-resolution graphics, and clear screen shots, this book is a solid reference for any Microsoft Excel user

* Features a totally redesigned interior that helps make information more accessible to readers

Synopsis:

* Two-page lessons break big topics into bite-sized modules

About the Author

Nancy C. Muir is an award-winning author who has written over 50 books on topics ranging from desktop applications to online safety and distance learning. She has also contributed articles to magazines on topics such as distance learning and home design. Prior to her freelance career, Nancy worked in both the software and publishing industries and has taught technical writing at the university level. She holds a certificate in distance learning design from the University of Washington.

Table of Contents

Chapter 1. Excel Basics.

An Introduction to Excel.

Start and Close Excel.

Navigate the Excel Program Window.

Understanding the Ribbon, Galleries, and Contextual Tools.

Change Views.

Customize the Quick Access Toolbar.

Display Task Panes.

Find Help.

Chapter 2. Workbook Fundamentals.

Start a New Workbook File.

Save a Workbook.

Publish a Workbook as an Excel Binary Workbook.

Open an Existing Workbook.

Close a Workbook.

Delete a Workbook.

Arrange Workbook Windows.

Protect a Workbook.

Hide or Show a Worksheet.

Chapter 3. Entering Data.

Enter Data.

Turn On Text Wrapping.

Resize Columns and Rows.

Select Cells.

Enter Data with AutoFill.

Work with AutoCorrect.

Edit Data.

Work with Smart Tags.

Check Spelling in a Worksheet.

Chapter 4. Working with Worksheets

Understanding Worksheet Structure.

Navigate Worksheets.

Name a Worksheet.

Add a Worksheet.

Delete a Worksheet.

Move a Worksheet.

Copy a Worksheet.

Format Worksheet Tab Color.

Protect Worksheet Data.

Chapter 5. Selecting Data with Formulas and Functions.

Understanding Formulas.

Create Formulas.

Reference Absolute and Relative Cells.

Copy Formulas.

Name Cells and Ranges.

Reference Ranges in Formulas.

Reference Cells from Other Worksheets.

Understanding Functions.

Apply a Function.

Total Cells with AutoSum.

Check for Formula Errors.

Audit a Worksheet for Errors.

Chapter 6. Rearranging Worksheet Data.

Move and Copy Data.

Delete Data or Cells.

Add Columns and Rows.

Delete Columns and Rows.

Center Data across Columns.

Transpose Columns and Rows.

Set Column Width and Row Height.

Hide Columns and Rows.

Freeze a Column or Row.

Split a Worksheet into Panes.

Find and Replace Data.

Chapter 7. Formatting Worksheets.

Apply Bold, Italics, and Underlining.

Change the Font and Size.

Change Number Formats.

Increase or Decrease Decimals.

Change Data Color.

Apply Workbook Themes.

Align Cell Data.

Rotate Cell Data.

Control Text Wrap.

Add Borders.

Add Background Color to Cells.

Assign a Background to a Worksheet.

Copy Cell Formatting.

Apply a Style.

Chapter 8. Enhancing Worksheets with Graphics.

Insert Image Files.

Insert Clip Art.

View Clip Art with the Clip Organizer.

Download Clip Art from the Web.

Draw Shapes.

Add a WordArt Object.

Move and Resize Objects.

Rotate and Flip Objects.

Crop a Picture.

Add Shadow and 3-D Effects.

Format an Object.

Group and Ungroup Objects.

Chapter 9. Previewing and Printing. 

Add Headers and Footers.

Insert Page Breaks.

Preview a Worksheet.

Set Up Printing Options.

Print a Worksheet.

Define a Print Area.

Chapter 10. Communicating Information with Charts.

Understanding Excel Charts.

Create a Chart with Galleries.

Move and Resize Charts.

Change the Chart Type.

Change the Axes Titles.

Manipulate 3-D Charts.

Format Chart Objects.

Add Chart Objects.

Change the Chart Data.

Format Charts with Layouts and Styles.

Insert SmartArt Charts.

Chapter 11. Analyzing Worksheet Data.

Understanding Database Lists.

Create a Database Table.

Add Records Using a Data Form.

Edit Records.

Search for Records.

Identify Duplicate Values in a Table.

Set Data Validation Rules.

Sort Records.

Filter Data with AutoFilter.

Analyze Data with a PivotTable.

Chapter 12. Using Excel Tools.

Add a Watch Window.

Load Add-Ins.

Analyze Data with Add-In Tools.

Examine Alternatives with Goal Seek.

Create Scenarios.

Optimize Formulas with Solver.

Chapter 13. Sharing Excel Data.

Link Data.

Edit Linked Data.

Link Between Worksheets.

Embed Objects.

Enable Workbook Sharing.

Add a Comment.

Track and Review Workbook Changes.

Merge Workbooks.

E-mail a Workbook.

Import Data.

Export Data.

Chapter 14. Using Excel on the Web.

Add Web Tools to the Quick Access Toolbar.

Publish a Workbook as a Web Page.

Insert a Hyperlink.

Download a Stock Quote.

Copy Web Data to a Worksheet.

Run a Web Query.

Chapter 15. Improving Excel Efficiency

Personalize the Excel Program Window.

Change the Default Font.

Change the Default File Location.

Open Files in a Specified Folder Automatically.

Set Macro Security.

Record a Macro.

Create an Excel Template.

Apply an Excel Template.

Product Details

ISBN:
9780470045954
Author:
Muir, Nancy C
Publisher:
Visual
Author:
Muir, Nancy C.
Author:
Muir, Nancy
Subject:
Business
Subject:
Spreadsheets - Excel
Subject:
Electronic spreadsheets
Subject:
Spreadsheets - General
Subject:
Business -- Computer programs.
Subject:
Electronic spreadsheets -- Computer programs.
Subject:
Microsoft Excel
Subject:
Personal Computers-Applications
Subject:
Personal Computers-Desktop Applications-Spreadsheets
Copyright:
Series:
Teach Yourself VISUALLY (Tech)
Series Volume:
47
Publication Date:
November 2006
Binding:
Electronic book text in proprietary or open standard format
Grade Level:
General/trade
Language:
English
Illustrations:
Y
Pages:
304
Dimensions:
9.12x7.24x.68 in. 1.53 lbs.

Other books you might like

  1. Teach Yourself Visually Word 2007... Used Trade Paper $12.50
  2. Teach Yourself Visually PowerPoint... Used Trade Paper $13.00
  3. Teach Yourself Visually Microsoft... New Trade Paper $24.99
  4. Teach Yourself Visuallymicrosoft... Used Trade Paper $15.00
  5. Teach Yourself Visually Microsoft... Used Trade Paper $13.00

Related Subjects

Computers and Internet » Operating Systems » Microsoft Windows » Applications
Computers and Internet » Personal Computers » Desktop Applications » Spreadsheets

Teach Yourself Visually Excel 2007 Used Trade Paper
0 stars - 0 reviews
$12.50 In Stock
Product details 304 pages Visual - English 9780470045954 Reviews:
"Synopsis" by , * This book illustrates the extensive changes in the new version of Excel such as new collaboration tools, an updated Excel Server, list functionality, and information protection as well as a new look with a redesigned UI

* Step-by-step instructions with practical examples and advice guide users through the world's most widely used spreadsheet application

* With gorgeous, full-color illustrations on every page, high-resolution graphics, and clear screen shots, this book is a solid reference for any Microsoft Excel user

* Features a totally redesigned interior that helps make information more accessible to readers

"Synopsis" by , * Two-page lessons break big topics into bite-sized modules
spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.