зарубежная компьютерная литература

программы

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 used within a formula Learn to calculate the costs of leasing versus buying a car, compute classroom grades, create an amortization table, or evaluate investment performance Fully updated for Excel 2010, but the principles will work with earlier versions of Excel as well Includes essential coverage of an additional 85 functions In the ever-popular, non-threatening For Dummies style, Excel Formulas and Functions For Dummies, 2nd Edition makes Excel's power accessible to you.

прикладная литература

газеты

Excel Formulas and Functions For Dummies

Targets beginning to intermediate Excel users seeking real-world examples of how they can use Excel's powerful built-in functions Shows readers how to use Excel functions in formulas to help them decide between buying and leasing a car, calculate mortgage costs, compute grades, evaluate investment performance, figure college expenses, and more Gives explanations and examples of real-world situations Provides an abbreviated discussion of an additional 200 functions Excel commands nearly 90 percent of the market for spreadsheet applications; although this book is written for Excel 2003, the functions described are in earlier versions as well 

Devoted entirely to PivotTables and PivotCharts, this book shows you how to take full advantage of these powerful tools, which enable you to pull meaningful information from masses of seemingly meaningless data. Loaded with illustrations and real-world examples, it takes you step by step through creating a PivotTable; formatting, filtering, and grouping data; creating PivotCharts from those data; and more. You’ll learn to work with multidimensional data, how to create and manipulate PivotTables using VBA, and—most importantly—you’ll discover what these tools can do for you. 

современная зарубежная литература

книги на азербайджанском языке

Excel 2007 PivotTables and PivotCharts

Make Excel do the math and make sense of your data Use the Insert Function dialog box, array formulas and functions, and more Excel 2007 has more than 500 built-in functions. This book looks at the top 150, so you can find out which ones will make your life easier. Want to compare a 15-year mortgage to a 30-year mortgage? Forecast expenses for your college freshman? See how your online business is doing? Here's the fun and easy way! Discover how to * Create worksheets to track costs and revenue * Tell the difference among average, median, and mode * Work with statistical functions * Develop forecasts and track trends * Manipulate strings and work with database functions 

литературоведение

Microsoft Office Excel 2007 Formulas and Functions For Dummies

Find out how to * Understand XML specification and schemas * Set up and complete InfoPath?TM forms * Design new forms from XML data files * Debug InfoPath scripts * Tackle real-world problems with the help of case studies * Work with data in each of the XML-supported Office applications You don't need to be a programmer to enhance Office with XML XML support for Microsoft?? Office 2003 has taken interoperability to a new level. Now you can share data among Office applications, across platforms, and over the Internet using built-in XML tools. In this clearly organized volume, Peter Aitken helps you define and standardize document data structure within your organization using XML. He explains XML technology, walks you through designing templates with InfoPath, and shows you how to use the XML tools built into Word, Excel, Access, and FrontPage?? to facilitate data exchange throughout your enterprise. «…the real-world case studies are practical, offering detailed solutions to the scenarios outlined. I would recommend this book to anyone who plans to leverage the features found in the Office System 2003 for their business.» –Dave Beauchemin, Microsoft MVP CD-ROM Includes * Trial versions of John Walkenbach's Power Utility Pak, HotDog Professional, WinRAR?TM, and many others * Demo versions of BBEdit??, XML Pro, and more * Exclusive Office 2003 Super Bible eBook, with more than 500 pages of information about how Microsoft Office components work together * Valuable author files and examples 

Peter G. Aitken