Excel is the most sophisticated spreadsheet program available, making it easy for you to create a variety of analyses and calculations for personal and professional use. However, this program is much more than just an electronic version of an accountant's green sheet, and mastering even the most basic functions can be a challenge.
Create killer formulas--Mr. Spreadsheet shows you how Excel master John Walkenbach has shared his expertise in two previous editions of this bestseller. Now he shows you how to create financial formulas, release the power of array formulas, develop custom worksheet functions with VBA, debug formulas, and more with Excel 2007.
Focused on report development using OLTP databases, this book offers comprehensive information on both technical and strategic aspects. It helps to examine the main features of Excel's reporting technology-PivotTable reports, Spreadsheet reports, parameter queries, and web components.
A reference useful for Excel beginners, intermediate users, power users, and would-be power users everywhere, this book provides Excel tips, tricks, and techniques. It covers the Excel interface, file formats, interactivity with other Office applications, and collaboration features. It includes a CD-ROM with templates and worksheets from the book.
Shows you how to set up your project for success as you examine an overview of the project management practices followed by Microsoft Project. This work also explores time-saving techniques such as how to share information between other applications and Project and how to share resource information between files.