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 | October 28, 2014

    Jill Owens: IMG Miriam Toews: The Powells.com Interview



    Some people are compelled by a restlessness from within; others are shaped by the unwieldy forces around them. In Miriam Toews's poignant new novel... Continue »

    spacer
Qualifying orders ship free.
$24.75
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
available for shipping or prepaid pickup only
Available for In-store Pickup
in 7 to 12 days
Qty Store Section
2 Remote Warehouse Personal Computers- Desktop Applications- Spreadsheets

Other titles in the Visual Blueprint series:

Microsoft Office Excel 2007 Data Analysis: Your Visual Blueprint for Creating and Analyzing Data, Charts, and PivotTables (Visual Blueprint)

by

Microsoft Office Excel 2007 Data Analysis: Your Visual Blueprint for Creating and Analyzing Data, Charts, and PivotTables (Visual Blueprint) Cover

 

Synopses & Reviews

Publisher Comments:

Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you'll discover step-by-step screen shots that demonstrate over 110 Excel data analysis techniques, including:

  • Identifying trends in your data
  • Sorting, filtering, and identifying lists

  • Creating, editing, and checking formulas

  • Calculating interest rates and depreciation

  • Performing simple sorts and filters

  • Hiding rows or columns in a PivotTable

  • Adding and removing chart data

  • Querying an Access database

  • Assigning digital signatures

  • Solving a formula with a data table

"I was stuck on an Excel problem for two days. Finally, I opened one of your books, and there was a macro to accomplish exactly what I needed! You made me look good to the boss."

—Rob L. Meerscheidt(The Woodlands, TX)

  • High-resolution screen shots demonstrate each task
  • Succinct explanations walk you through step by step

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

  • "Apply It" and "Extra" sidebars highlight useful tips

Synopsis:

Excel is a spreadsheet / data analysis tool attached to the Microsoft Office suite and is available in all Office offerings. Office holds 80-900f the market share for productivity suites. Though many consumers know the basics of using Excel, they may not know the full power of the program. With Excel, you can harness the power of your data, manipulate it to suite your needs, and achieve more by doing less work. Charts are interactive, allowing the consumer to tweak results with the click of a mouse. Pivot tables allow you to fuse data from several sources into one document. Excel has an enhanced Find function, allowing users to easily search entire workbooks, and search worksheets by cell format. Excel supports XML as a file format for easy importing or exporting of XML data. Excel also includes enhancements for saving files as Web pages, and enhancements to Pivot Tables.

About the Author

Denise Etheridge is a certified public accountant as well as the president and founder of Baycon Group, Inc. She publishes Web sites, provides consulting services on accounting-related software, and authors computer-related books.

Table of Contents

CHAPTER 1: GETTING STARTED.

CHAPTER 2: CREATING FORMULAS.

CHAPTER 3: CREATING AND USING FUNCTIONS.

CHAPTER 4: USING FINANCIAL FUNCTIONS.

CHAPTER 5: USING STATISTICAL FUNCTIONS AND TOOLS.

CHAPTER 6: ORGANIZING WORKSHEET DATA.

CHAPTER 7: WORKING WITH PIVOTTABLES.

CHAPTER 8: CHARTING DATA.

CHAPTER 9: WORKING WITH EXTERNAL DATA.

CHAPTER 10: USEFUL DATA ANALYSIS TOOLS AND TECHNIQUES.

CHAPTER 11: SHARING YOUR WORKBOOK WITH OTHERS.

CHAPTER 12: AUTOMATING WITH MACROS.

APPENDIX A: EXCEL KEYBOARD SHORTCUTS.

APPENDIX B: EXCEL FUNCTION QUICK REFERENCE.

APPENDIX C: FORMULA BASICS.

INDEX.

Product Details

ISBN:
9780470132296
Author:
Etheridge, Denise
Publisher:
Visual
Subject:
Spreadsheets - General
Subject:
Spreadsheets - Excel
Subject:
Computer software
Subject:
Business
Subject:
Business -- Computer software.
Subject:
Spreadsheet software
Subject:
Microsoft Excel
Subject:
Personal Computers-Applications
Subject:
Personal Computers-Desktop Applications-Spreadsheets
Copyright:
Edition Description:
WebSite Associated w/Book
Series:
Visual Blueprint
Series Volume:
54
Publication Date:
20110617
Binding:
TRADE PAPER
Language:
English
Illustrations:
Y
Pages:
304
Dimensions:
9.08x7.38x.77 in. 1.30 lbs.

Other books you might like

  1. Elements of Graphing Data New Hardcover $67.25
  2. The Seven Mysteries of Life: An...
    Used Trade Paper $6.95
  3. Methods for Statistical Data... Used Hardcover $4.50

Related Subjects

Computers and Internet » Personal Computers » Desktop Applications » Spreadsheets
Religion » Comparative Religion » General

Microsoft Office Excel 2007 Data Analysis: Your Visual Blueprint for Creating and Analyzing Data, Charts, and PivotTables (Visual Blueprint) New Trade Paper
0 stars - 0 reviews
$24.75 In Stock
Product details 304 pages Visual - English 9780470132296 Reviews:
"Synopsis" by , Excel is a spreadsheet / data analysis tool attached to the Microsoft Office suite and is available in all Office offerings. Office holds 80-900f the market share for productivity suites. Though many consumers know the basics of using Excel, they may not know the full power of the program. With Excel, you can harness the power of your data, manipulate it to suite your needs, and achieve more by doing less work. Charts are interactive, allowing the consumer to tweak results with the click of a mouse. Pivot tables allow you to fuse data from several sources into one document. Excel has an enhanced Find function, allowing users to easily search entire workbooks, and search worksheets by cell format. Excel supports XML as a file format for easy importing or exporting of XML data. Excel also includes enhancements for saving files as Web pages, and enhancements to Pivot Tables.
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.