The Good, the Bad, and the Hungry Sale
 
 

Recently Viewed clear list


Original Essays | June 20, 2014

Lauren Owen: IMG The Other Vampire



It's a wild and thundery night. Inside a ramshackle old manor house, a beautiful young girl lies asleep in bed. At the window, a figure watches... Continue »

spacer
Qualifying orders ship free.
$39.99
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
2 Burnside - Bldg. 2 Microsoft Windows- Applications
15 Remote Warehouse Personal Computers- Desktop Applications- Spreadsheets

Excel 2013: The Missing Manual

by

Excel 2013: The Missing Manual Cover

 

Synopses & Reviews

Publisher Comments:

The worlds most popular spreadsheet program is now more powerful than ever, but its also more complex. Thats where this Missing Manual comes in. With crystal-clear explanations and hands-on examples, Excel 2013: The Missing Manual shows you how to master Excel so you can easily track, analyze, and chart your data. Youll be using new features like PowerPivot and Flash Fill in no time.

The important stuff you need to know:

  • Go from novice to ace. Learn how to analyze your data, from writing your first formula to charting your results.
  • Illustrate trends. Discover the clearest way to present your data using Excels new Quick Analysis feature.
  • Broaden your analysis. Use pivot tables, slicers, and timelines to examine your data from different perspectives.
  • Import data. Pull data from a variety of sources, including website data feeds and corporate databases.
  • Work from the Web. Launch and manage your workbooks on the road, using the new Excel Web App.
  • Share your worksheets. Store Excel files on SkyDrive and collaborate with colleagues on Facebook, Twitter, and LinkedIn.
  • Master the new data model. Use PowerPivot to work with millions of rows of data.
  • Make calculations. Review financial data, use math and scientific formulas, and perform statistical analyses.

Synopsis:

Excel is the worlds most popular spreadsheet program and the de facto standard for numerical analysis. But this complex program can take a lifetime to learn without the right guide. Thats where Excel 2013: The Missing Manual comes in. With crystal-clear explanations, hands-on examples, and lots of undocumented tips, tricks, and workarounds, this jargon-free book helps you master Excels raft of impressive features.

The important stuff you need to know:

  • Go from novice to ace. Learn everything from writing your first formula to analyzing data.
  • Perform a variety of calculations. Enter raw data and have Excel perform financial analyses, math operations, and statistical analyses
  • Illustrate trends. Bring your data to life using charting, summarizing, and data visualization options in the Quick Analysis feature
  • Examine your data. Summarize information and find hidden patterns with pivot tables and slicers
  • Pinpoint the data you need. Use the handy timeline filter to browse specific date ranges in a mass of pivot table data
  • Share your spreadsheets. Store Excel files on SkyDrive and collaborate with colleagues on Facebook, Twitter, and LinkedIn

About the Author

Matthew MacDonald is a science and technology writer with well over a dozen books to his name. Web novices can tiptoe out onto the Internet with him in Creating a Website: The Missing Manual. HTML fans can learn about the cutting edge of web design in HTML5: The Missing Manual. And human beings of all description can discover just how strange they really are in the quirky handbooks Your Brain: The Missing Manual and Your Body: The Missing Manual.

Table of Contents

The Missing CreditsIntroductionPart 1: Worksheet BasicsChapter 1: Creating Your First SpreadsheetChapter 2: Adding Information to WorksheetsChapter 3: Moving DataChapter 4: Managing WorksheetsChapter 5: Formatting CellsChapter 6: Smart Formatting TricksChapter 7: Viewing and Printing WorksheetsPart 2: Formulas and FunctionsChapter 8: Building Basic FormulasChapter 9: Math and Statistical FunctionsChapter 10: Financial FunctionsChapter 11: Manipulating Dates, Times, and TextChapter 12: Lookup, Reference, and Information FunctionsChapter 13: Advanced Formula Writing and TroubleshootingPart 3: Organizing Your InformationChapter 14: Tables: List Management Made EasyChapter 15: Grouping and Outlining DataChapter 16: TemplatesPart 4: Charts and GraphicsChapter 17: Creating Basic ChartsChapter 18: Formatting and Perfecting ChartsChapter 19: Inserting GraphicsChapter 20: Visualizing Your DataPart 5: Sharing Data with the Rest of the WorldChapter 21: Protecting Your WorkbooksChapter 22: Worksheet CollaborationChapter 23: Using Excel on the WebChapter 24: Exchanging Data with Other ProgramsPart 6: Advanced Data AnalysisChapter 25: Scenarios and Goal SeekingChapter 26: Pivot TablesChapter 27: Analyzing DatabasesChapter 28: Analyzing XML and Web DataPart 7: Programming ExcelChapter 29: Automating Tasks with MacrosChapter 30: Programming Spreadsheets with VBAPart 8: AppendixCustomizing the Ribbon

Product Details

ISBN:
9781449357276
Author:
Macdonald, Matthew
Publisher:
O'Reilly Media
Author:
MacDonald, Matthew
Subject:
Spreadsheets - General
Subject:
calculation;calculations;electronic ledger;excel;formula;formulas;microsoft;microsoft excel;microsoft office;office 2013;spreadsheet;sum;sums
Subject:
Personal Computers-Desktop Applications-Spreadsheets
Subject:
CourseSmart Subject Description
Copyright:
Edition Description:
Print PDF
Publication Date:
20130531
Binding:
TRADE PAPER
Language:
English
Pages:
1020
Dimensions:
9.19 x 7 in

Related Subjects

Computers and Internet » Computers Reference » Enterprise Applications » Business Intelligence Tools
Computers and Internet » Operating Systems » Microsoft Windows » Applications
Computers and Internet » Operating Systems » Microsoft Windows » Windows 95 » General
Computers and Internet » Personal Computers » Desktop Applications » Spreadsheets
Science and Mathematics » Mathematics » Software

Excel 2013: The Missing Manual New Trade Paper
0 stars - 0 reviews
$39.99 In Stock
Product details 1020 pages O'Reilly Media - English 9781449357276 Reviews:
"Synopsis" by ,

Excel is the worlds most popular spreadsheet program and the de facto standard for numerical analysis. But this complex program can take a lifetime to learn without the right guide. Thats where Excel 2013: The Missing Manual comes in. With crystal-clear explanations, hands-on examples, and lots of undocumented tips, tricks, and workarounds, this jargon-free book helps you master Excels raft of impressive features.

The important stuff you need to know:

  • Go from novice to ace. Learn everything from writing your first formula to analyzing data.
  • Perform a variety of calculations. Enter raw data and have Excel perform financial analyses, math operations, and statistical analyses
  • Illustrate trends. Bring your data to life using charting, summarizing, and data visualization options in the Quick Analysis feature
  • Examine your data. Summarize information and find hidden patterns with pivot tables and slicers
  • Pinpoint the data you need. Use the handy timeline filter to browse specific date ranges in a mass of pivot table data
  • Share your spreadsheets. Store Excel files on SkyDrive and collaborate with colleagues on Facebook, Twitter, and LinkedIn

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.