Books » Software Books

OpenOffice Calc is the most powerful and widespread open source spreadsheet application in existence. It is the only real alternative to Excel. Jacek Artymiak is widely regarded as the authority on OpenOffice Calc.He takes you, tutorial by tutorial, from theinterface and handling Calc files to working with data sources small and large.Artymiak then extendsthe reader's skillset to data visualization, writingcomplex formulas and performing statistical analysis. Beginning OpenOffice Calc allows you to gain confidence in the considered use of statisticalformulas, but does notassume familiarity with another spreadsheet application. Artymiak takes special care to introduce you to the presentation, formatting, and visualization of data. Even interacting with other applicationsfor instance Google apps and Excelis covered in detail. Richly illustrated, Beginning OpenOffice Calc is the one-stop shop for OpenOffice Calc. Tutorial-based introduction to Calc from spreadsheet setup to statistical formulas Teaches the complete spreadsheet skill set, including data visualization and presentation What youll learn Work with large sets of data Process and format data Imitate Excel's pivot tables Write complex formulas using array functions Use charts to visualize data Collaborate on OpenOffice.org Calc files with the users of Calc, Excel and other spreadsheet software Who this book is for This is a book for spreadsheet beginners as much as for anyone who would like start using open source applications in an office environment. Whether someone has used Excel in the past and wants to convert to Calc, or just wants to start using spreadsheets, this is the book for you.

PowerPivot comprises a set of technologies for easy access to data mining and business intelligence analysis from Microsoft Excel and SharePoint. Power users and developers alike can create sophisticated, online analytic processing (OLAP) solutions using PowerPivot for Excel, and then share those solutions with other users via PowerPivot for SharePoint. Data can be pulled in from any of the leading database platforms, as well as from spreadsheets and flat files. PowerPivot for Business Intelligence Using Excel and SharePointis your key to mastering PowerPivot. The book takes a scenario-based approach to showing you how to collect data, to mine that data through insightful analysis, and to draw conclusions that drive business performance. Each chapter in the book is focused on a specific challenge that youll encounter when using PowerPivot. Each chapter takes you through a solution technique thats been proven in the real world. Covers the leading technology for bringing data analytics to the desktop Presents real-world solutions to real-world scenarios Written by a Microsoft Virtual Technical Specialist (VTS) for business intelligence What youll learn Install and verify the PowerPivot software Integrated existing, available data to deliver business intelligence Leverage Time Intelligence to report change over time Write Data Analysis Expressions (DAX) to create custom measures Identify and implement solutions for role-playing dimensions Recognize and work-around PowerPivots missing features Who this book is for PowerPivot Solutions for Excel and SharePoint is aimed at information workers and data analysts who typically use Excel to drive business decisions. The book shows how you can apply PowerPivot to problems typically addressed through complicated and arcane spreadsheet techniques. Business people without the time and interest in learning Excel arcane will especially appreciate how PowerPivot enables them to easily create models and perform analysis far in advance of anything they could do using Excel alone. Table of Contents Getting Started with PowerPivot for Excel Hello World, PowerPivot Style Combining Data Sources Data Analysis Expressions A Method to the Madness Installing PowerPivot for SharePoint Collaboration, Version Control, and Management PowerPivot As a Data Source PowerPivot and SQL Server Reporting Services PowerPivot and Predictive Analytics Tips, Tricks, and Traps

The updated guide to the newest graphing calculator from Texas InstrumentsThe TI-Nspire graphing calculator is popular among high school and college students as a valuable tool for calculus, AP calculus, and college-level algebra courses. Its use is allowed on the major college entrance exams. This book is a nuts-and-bolts guide to working with the TI-Nspire, providing everything you need to get up and running and helping you get the most out of this high-powered math tool.Texas Instruments TI-Nspire graphing calculator is perfect for high school and college students in advanced algebra and calculus classes as well as students taking the SAT, PSAT, and ACT examsThis fully updated guide covers all enhancements to the TI-Nspire, including the touchpad and the updated software that can be purchased along with the deviceShows how to get maximum value from this versatile math toolWith updated screenshots and examples, TI-Nspire For Dummies provides practical, hands-on instruction to help students make the most of this revolutionary graphing calculator.

This book explains how computer software is designed to perform the tasks required for sophisticated statistical analysis. For statisticians, it examines the nitty-gritty computational problems behind statistical methods. For mathematicians and computer scientists, it looks at the application of mathematical tools to statistical problems. The first half of the book offers a basic background in numerical analysis that emphasizes issues important to statisticians. The next several chapters cover a broad array of statistical tools, such as maximum likelihood and nonlinear regression. The author also treats the application of numerical tools; numerical integration and random number generation are explained in a unified manner reflecting complementary views of Monte Carlo methods. The book concludes with an examination of sorting, FFT and the application of other "fast" algorithms to statistics. Each chapter contains exercises that range in difficulty as well as examples of the methods at work. Most of the examples are accompanied by demonstration code available from the author's home page.

A practical guide to selecting and applying the most appropriate model for analysis of cross section data using EViews."This book is a reflection of the vast experience and knowledge of the author. It is a useful reference for students and practitioners dealing with cross sectional data analysis ... The strength of the book lies in its wealth of material and well structured guidelines ..." Prof. Yohanes Eko Riyanto, Nanyang Technological University, Singapore"This is superb and brilliant. Prof. Agung has skilfully transformed his best experiences into new knowledge ... creating a new way of understanding data analysis." Dr. I Putu Gede Ary Suta, The Ary Suta Center, JakartaBasic theoretical concepts of statistics as well as sampling methods are often misinterpreted by students and less experienced researchers. This book addresses this issue by providing a hands-on practical guide to conducting data analysis using EViews combined with a variety of illustrative models (and their extensions). Models having numerically dependent variables based on a cross-section data set (such as univariate, multivariate and nonlinear models as well as non-parametric regressions) are concentrated on. It is shown that a wide variety of hypotheses can easily be tested using EViews.Cross Section and Experimental Data Analysis Using EViews:Provides step-by-step directions on how to apply EViews to cross section data analysis - from multivariate analysis and nonlinear models to non-parametric regressionPresents a method to test for all possible hypotheses based on each modelProposes a new method for data analysis based on a multifactorial design modelDemonstrates that statistical summaries in the form of tabulations are invaluable inputs for strategic decision makingContains 200 examples with special notes and comments based on the authors own empirical findings as well as over 400 illustrative outputs of regressions from EViewsTechniques are illustrated through practical examples from real situationsComes with supplementary material, including work-files containing selected equation and system specifications that have been applied in the bookThis user-friendly introduction to EViews is ideal for Advanced undergraduate and graduate students taking finance, econometrics, population, or public policy courses, as well as applied policy researchers.

Get the critical, in-depth information you need to administer SharePoint 2010. Led by SharePoint MVPs and featuring insights from the SharePoint community and members of the SharePoint Team at Microsoft, you'll discover how to plan, design, deploy, and manage strategic solutions using SharePoint 2010, Microsoft SQL Server, Windows PowerShell, and other key technologies. The two books included in this kit are:9780735627222 SharePoint 2010 Administrators Pocket Consultant 9780735627208 SharePoint 2010 Administrators Companion

hundreds of timesaving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Let the experts help you become at ease and proficient with every program in the Office family.Create great-looking documents using expert formatting tips. Build spreadsheets for complex calculations and data analysis. Save notes, clippings, web pages, and more in a notebook. Create dynamic slides and video-powered presentations. Expertly manage your inbox and business information. Protect your security and safeguard private information. Collaborate with Windows Live SkyDrive and SharePoint.

This book gives an overview of the research and application of speech technologies in different areas. One of the special characteristics of the book is that the authors take a broad view of the multiple research areas and take the multidisciplinary approach to the topics. One of the goals in this book is to emphasize the application. User experience, human factors and usability issues are the focus in this book.

Clarity PPM Fundamentalsprovidesan overview of CA Technologies' flagship Clarity PPM (short for project portfolio management). The bookis organized bythe Clarity modules independently, making it ideal for users whose needs are often defined by their current working module. It provides industry best practices for utilizing the Clarity product. With just a basic understanding of project management, you'll be able to understand all this book has to offer, from user to system administratorunveiling hidden tricksand lessons from real implementation scenarios.The authors bring their extensive experience to bear to give you the best insights into making Clarity more powerful and useful for you. What youll learn Use Clarity to manage project life cycles in your organization Navigate through and personalize Clarity The ins and outs of Clarity reporting capabilities The value provided by the basic components of Clarity Clarity security best practices How an organizational breakdown structure is built and best practices for using partitions Utilizing different setups possible in Clarity Who this book is for The book is directed at end users, but is a first volume and will be quite helpful to all Clarity users, implementers, and administrators.

The best of the best from the bestselling authors of Excel, Word, and PowerPoint Bibles!Take your pick of applications from the Office 2010 suite and your choice of leading experts to show you how to use them. This Office 2010 Bible features the best-of-the-best content from the Excel 2010 Bible, by "Mr. Spreadsheet" John Walkenbach; the Word 2010 Bible by Microsoft MVP Herb Tyson; the PowerPoint 2010 Bible, by PowerPoint expert Faithe Wempen; and coverage of Access 2010 from Microsoft MVP Michael Alexander. If you want to quickly and effectively begin using Office 2010, start in the experts' corner with this must-have book.Gives you the best-of-the-best content on Office 2010 from the leading experts, authors, and contributors to our Excel, Word, PowerPoint, and Access BiblesIncludes content from John Walkenbach, aka "Mr. Spreadsheet"; Word expert and Microsoft MVP Herb Tyson; PowerPoint expert Faithe Wempen; and Excel and Access expert and Microsoft MVP Michael AlexanderTakes you beyond creating simple text documents, spreadsheets, and presentations to help you use multiple Office applications at once to conquer critical business tasksHones in with expert coverage of the topics within each application that you need to know mostCovers even more from Outlook and other key Office topicsGet the best of four books in one with this power-packed reference!