Excel PivotTables and PivotCharts
Your visual blueprint for creating dynamic spreadsheets
Book Details:
Publisher: | Visual |
Series: |
Wiley
|
Author: | Paul McFedries |
Edition: | 2 |
ISBN-10: | 0470591617 |
ISBN-13: | 9780470591611 |
Pages: | 304 |
Published: | Jun 28 2010 |
Posted: | Nov 19 2014 |
Language: | English |
Book format: | PDF |
Book size: | 38.61 MB |
Book Description:
Master two of the most powerful features of ExcelEven if you use Excel all the time, you may not be up to speed on two of Excel's most useful features. PivotTable and PivotChart turn long lists of unreadable data into dynamic, easy-to-read tables and charts that highlight the information you need most; you can tweak results with a click or easily fuse data from several sources into one document. Now you can learn how to tap these powerful Excel tools with this practical guide.Using a series of step-by-step tutorials and easy-to-follow screenshots, this book shows you in a visual way how to create and customize PivotTables and PivotCharts, use them to analyze business data, and ultimately achieve more with less work.Explains the benefits PivotTables and PivotCharts, two powerful features of Excel that allow users to create dynamic spreadsheetsCovers creating and customizing, analyzing business data, building custom calculations, linking to external data sources (including Access databases, Word tables, Web pages, XML data, SQL Server databases, and OLAP cubes), creating macros to automate tasks, and moreUses step-by-step tutorials and easy-to-follow screenshots, a "learn by seeing" approach for visual learnersPractical, visual, and packed with content, this is the book you need to ramp up your Excel skills with PivotTables and PivotCharts.
For Microsoft Word, Excel, PowerPoint and Outlook
Demonstrate your expertise with Microsoft Office 2010! This all-in-one guide is designed to help you practice and prepare for the four core Microsoft Office Specialist (MOS) exams. With the MOS 2010 Study Guide, you get full, objective-by-objective coverage for:Exam 77-881: Microsoft Word 2010 Exam 77-882: Microsoft Excel 2010 Exam 77-883: Microsoft PowerPoint 2010 Exam 77-884: Microsoft Outlook 2010 Use the book's easy-to-follow procedures and illustrations to review the essential skills measured by the MOS exams. And you can apply what you've learned hands-onusing the downloadable files for all the book's practice tasks....
For Dummies
2nd Edition
Put the power of Excel formulas and functions to work for you!Excel is a complex program. Mastering the use of formulas and functions lets you use Excel to compute useful day-to-day information, such as calculating the true cost of credit card purchases or comparing 15-year and 30-year mortgage costs. This fun and friendly book demystifies Excel's built-in functions so you can put them to work.You'll find step-by-step instructions on 150 of Excel's most useful functions, how they work within formulas, and how to use them to make your life easier.See how to use 150 of Excel's most useful functions, with real-world examples showing how each function is u...
For Dummies
3rd Edition
Learn to use Excel for practical, day-to-day calculationsExcel is a powerful program with more than 300 built-in functions that can be used to perform an almost infinite number of calculations. This friendly book shows you how to use the 150 most valuable ones in real-world situations: to compare the cost of buying vs. leasing a car, calculate classroom grades, or evaluate investment performance, for example. Another 85 specialized functions are also described. Detailed, step-by-step instructions help you understand how functions work within formulas and how you can use them to solve everyday problems.Excel is a complex tool, making it a perfect subjec...
2007 - 2021 © eBooks-IT.org