"With this full color, no-nonsense guide, you'll learn the quickest ways to solve a problem or learn a skill with Microsoft Excel 2010. Easy-to-follow steps and concise, straightforward language make learning plain and simple!"--Resource description page.

If you are serious about getting up to speed with Excel 2010, this clear, concise guide is the ideal companion for fast and efficient learning. The author illustrates the main functions of Excel 2010, explaining everything you need to know in plain, jargon-free English with full-colour screen shots and numbered, step-by-step instructions. The simple, yet elegant design features a multitude of images as well as tips & tricks to make this a perfect reference for all ages - just follow the instructions on your own PC. Whether you are a beginner or an experienced user in need of a quick grip on the updates in Excel 2010, read on for: Excel 2010 basics workbook fundamentals formatting worksheets and enhancing them with graphics analysing data and communicating results with charts and PivotTables Packed with advice and illustrations, this visual tutorial is excellent value for money. Learn something new today – read it, try it and become your own expert with Simply Excel 2010!

Use Excel 2013’s statistical tools to transform your data into knowledge Conrad Carlberg shows how to use Excel 2013 to perform core statistical tasks every business professional, student, and researcher should master. Using real-world examples, Carlberg helps you choose the right technique for each problem and get the most out of Excel’s statistical features, including recently introduced consistency functions. Along the way, he clarifies confusing statistical terminology and helps you avoid common mistakes. You’ll learn how to use correlation and regression, analyze variance and covariance, and test statistical hypotheses using the normal, binomial, t, and F distributions. To help you make accurate inferences based on samples from a population, this edition adds two more chapters on inferential statistics, covering crucial topics ranging from experimental design to the statistical power of F tests. Becoming an expert with Excel statistics has never been easier! You’ll find crystal-clear instructions, insider insights, and complete step-by-step projects—all complemented by extensive web-based resources. Master Excel’s most useful descriptive and inferential statistical tools Tell the truth with statistics—and recognize when others don’t Accurately summarize sets of values Infer a population’s characteristics from a sample’s frequency distribution Explore correlation and regression to learn how variables move in tandem Use Excel consistency functions such as STDEV.S() and STDEV.P() Test differences between two means using z tests, t tests, and Excel’s Data Analysis Add-in Use ANOVA to test differences between more than two means Explore statistical power by manipulating mean differences, standard errors, directionality, and alpha Take advantage of Recommended PivotTables, Quick Analysis, and other Excel 2013 shortcuts

Provides a step-by-step guide to using Visual Basic for Applications (VBA) and macros to import data and produce reports in Microsoft Excel 2010.

Discusses the use of Microsoft's free PowerPivot add-in to analyse data in Excel 2010. Describes how to import and integrate data; analyse multiple tables together; format, sort and filter data; add calculated columns using Data Analysis Expression (DAX) functions; and create and format PowerPivot reports.

The most comprehensive guidebook available on the most popular spreadsheet program, fully updated to include all-new "X" features Written by the leading Excel guru known as "Mr. Spreadsheet," John Walkenbach, who has written more than thirty books and 300 articles on related topics and maintains the popular Spreadsheet Page at www.j-walk.com/ss The definitive reference book for beginning to advanced users, featuring expert advice and hundreds of examples, tips, techniques, shortcuts, work-arounds, and more Covers expanded use of XML and Web services to facilitate data reporting, analysis, importing, and exporting information Explores Excel programming for those who want advanced information CD-ROM includes all templates and worksheets used in the book, as well as sample chapters from all Wiley Office "X" related Bibles and useful third party software, including John Walkenbach's Power Utility Pak Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Get the most out of Excel 2010 with Excel 2010 Made Simple—learn the key features, understand what’s new, and utilize dozens of time-saving tips and tricks to get your job done. Over 500 screen visuals and clear-cut instructions guide you through the features of Excel 2010, from formulas and charts to navigating around a worksheet and understanding Visual Basic for Applications (VBA) and macros. Excel 2010 Made Simple takes a practical and highly effective approach to using Excel 2010, showing you the best way to complete your most common spreadsheet tasks. You'll learn how to input, format, sort, and filter your data to find out what you want to know. You'll see how to place your data in tables and named ranges for easy access, all of which will get you working efficiently and productively. Excel 2010 Made Simple also covers the new features introduced in Excel 2010. For instance, it shows you how to use Sparklines for data comparison and the Backstage view for printing and sharing your spreadsheets, so you can carry out your tasks with minimum fuss. The hands-on focus on tasks means you'll see how to actually use Excel 2010 to suit your needs.