 In Part I, I discuss how you get data into Excel workbooks so that you can begin to analyze it. This is important stuff, but fortunately most of it is pretty straightforward. If you’re new to data analysis and not all that fluent yet in working with Excel, you definitely want to begin in Part I.
In the second part of this book, I cover what are perhaps the most powerful data analysis tools that Excel provides: its cross-tabulation capabilities using the PivotTable and PivotChart commands. No kidding, I don’t think any Excel data analysis skill is more useful than knowing how to create pivot tables and pivot charts.
|
|
Read more about this free ebooks:Wiley - Excel 2007 Data Analysis For Dummies
|
 One look at Excel 2007, with its new Office Button, Quick Access toolbar, and Ribbon, and you realize you’re not in Kansas anymore. Well, have no fear— Excel 2007 for Dummies is here! If you’ve never worked with a computer spreadsheet, or if you’ve had some experience with earlier versions of Excel but need help transitioning,here you’ll find everything you need to create, edit, format, and print your own worksheets (without sacrificing your sanity!). Excel 2007 for Dummies covers all the fundamental techniques, |
|
Read more about this free ebooks:Mircosoft office Excel 2007 For Dummies
|
 Part I MICROSOFT WORD TRICKS Chapter 1 Text Tricks Chapter 2 Formatting Tricks Chapter 3 Document Tricks Chapter 4 Page Layout Tricks Part II MICROSOFT EXCEL TRICKS Chapter 5 Formula and Function Tricks Chapter 6 Workbook and Worksheet Tricks |
|
Read more about this free ebooks:Tricks of the Microsoft Office 2007 Gurus (Business Solutions)
|
 Many experienced users may initially find Excel 2007 rather disorientating. But Excel 2007: Beyond the Manual will introduce those who are already familiar with Excel basics to more advanced features, like consolidation, what-if analysis, PivotTables, sorting and filtering, and some commonly used functions.Youll learn how to maximize your efficiency at producing professional-looking spreadsheets and charts and become competent at analyzing data using a variety of tools. The book includes practical examples to illustrate advanced features. It also covers new features of Excel 2007 along with ways to access old features. Youll even gain timesaving tips and shortcuts. |
|
Read more about this free ebooks:Mircosoft Excel 2007: Beyond the Manual
|
|
|
|
|
|
More computer ebooks