Formulas and Functions with Microsoft Office Excel 2007 (Business Solutions)

出版者:Que

作者:Paul McFedries

页数:552

出版时间:2007-03-14

价格:USD 39.99

装帧:Paperback

isbn号码:9780789736680

图书标签:Excel

<P style="MARGIN: 0px">“If you&rsquo;ve never quite grasped formulas and functions, Paul McFedries will radically expand your understanding and use of Excel. And if you&rsquo;re already an expert and you&rsquo;re moving up to Excel 2007, this book will quickly show you features you&rsquo;ve only dreamed of until now...”</P> <P style="MARGIN: 0px">&ndash;Thomas ‘Duffbert&rsquo; Duff, Duffbert&rsquo;s Random Musings, http://www.twduff.com</P> <P style="MARGIN: 0px"> </P> <P style="MARGIN: 0px">Develop your Microsoft Excel expertise instantly with proven techniques</P> <UL> <LI> <DIV style="MARGIN: 0px">Master Excel Ranges</DIV></LI> <LI> <DIV style="MARGIN: 0px">Create Powerful Arrays</DIV></LI> <LI> <DIV style="MARGIN: 0px">Troubleshoot Formula Problems</DIV></LI> <LI> <DIV style="MARGIN: 0px">Validate Worksheet Data</DIV></LI> <LI> <DIV style="MARGIN: 0px">Perform What-If Analysis</DIV></LI> <LI> <DIV style="MARGIN: 0px">Model Your Business</DIV></LI> <LI> <DIV style="MARGIN: 0px">Track Trends and Make </DIV></LI> <LI> <DIV style="MARGIN: 0px">Forecasts</DIV></LI> <LI> <DIV style="MARGIN: 0px">Analyze Data</DIV></LI> <LI> <DIV style="MARGIN: 0px">Find Optimal Solutions</DIV></LI> <LI> <DIV style="MARGIN: 0px">Build Dynamic Loan </DIV></LI> <LI> <DIV style="MARGIN: 0px">Schedules </DIV></LI></UL> <P style="MARGIN: 0px">Most Microsoft® Excel users learn only a small percentage of the program&rsquo;s features. They know they could get more out of Excel if they could just get a leg up on building formulas and using functions. Unfortunately, this side of Excel appears complex and intimidating to the uninitiated&ndash;shrouded in the mysteries of mathematics, finance, and impenetrable spreadsheet jargon.</P> <P style="MARGIN: 0px">Sound familiar? If you&rsquo;re a businessperson who needs to use Excel as an everyday part of your job, then you&rsquo;ve come to the right book. Formulas and Functions with Microsoft® Office Excel 2007 demystifies worksheet formulas and presents the most useful Excel functions in an accessible, jargon-free way. This book not only takes you through Excel&rsquo;s intermediate and advanced formula-building features, it also tells you why these features are useful to you and shows you how to use them in everyday situations. Throughout the book you&rsquo;ll find no-nonsense, step-by-step tutorials and lots of practical examples aimed directly at business users.</P> <P style="MARGIN: 0px"> </P> <P style="MARGIN: 0px"> &bull; Focuses like a laser on the four technologies that you must master to get the most out of Excel: ranges, formulas, functions, and data analysis tools.</P> <P style="MARGIN: 0px"> &bull; Shuns spreadsheet theory in favor of practical know-how that you can put to use right away.</P> <P style="MARGIN: 0px"> &bull; Provides numerous real-world examples and techniques to help you learn and understand the importance of each section.</P> <P style="MARGIN: 0px"> </P> <P style="MARGIN: 0px">Paul McFedries is well-known as a teacher of Windows and Office, particularly Excel, and is the president of Logophilia Limited, a technical writing company. Paul has been working with spreadsheets for more than 20 years and has been developing Excel solutions since the late 1980s. Now primarily a writer, Paul has written more than 50 books that have sold more than three million copies worldwide. These books include Microsoft Office Access 2007 Forms, Reports, and Queries; Tricks of the Microsoft Office 2007 Gurus (all from Que); and Microsoft Windows Vista Unleashed (Sams).</P> <P style="MARGIN: 0px"> </P> <P style="MARGIN: 0px">Category Office Productivity Suite</P> <P style="MARGIN: 0px">Covers Microsoft Office Excel 2007</P> <P style="MARGIN: 0px">User Level Intermediate - Advanced</P> <P style="MARGIN: 0px"> </P>