Excel Hacks:Tips & Tools for Streamlining Your Spreadsheet

 

Published in: 2007
ISBN: 0596528345   

Millions of users create and share Excel spreadsheets every day, but few go deeply enough to learn the techniques that will make their work much easier. There are many ways to take advantage of Excel’s advanced capabilities without spending hours on advanced study. Excel Hacks provides more than 130 hacks – clever tools, tips and techniques – that will leapfrog your work beyond the ordinary. Now expanded to include Excel 2007, this resourceful, roll-up-your-sleeves guide gives you little known “backdoor” tricks for several Excel versions using different platforms and external applications. Think of this book as a toolbox. When a need arises or a problem occurs, you can simply use the right tool for the job. Hacks are grouped into chapters so you can find what you need quickly, including ways to:

• Reduce workbook and worksheet frustration – manage how users interact with worksheets, find and highlight information, and deal with debris and corruption.
• Analyze and manage data – extend and automate these features, moving beyond the limited tasks they were designed to perform.
• Hack names – learn not only how to name cells and ranges, but also how to create names that adapt to the data in your spreadsheet.
• Get the most out of PivotTables – avoid the problems that make them frustrating and learn how to extend them.
• Create customized charts – tweak and combine Excel’s built-in charting capabilities.
• Hack formulas and functions – subjects range from moving formulas around to dealing with datatype issues to improving recalculation time.
• Make the most of macros – including ways to manage them and use them to extend other features.
• Use the enhanced capabilities of Microsoft Office 2007 to combine Excel with Word, Access, and Outlook. You can either browse through the book or read it from cover to cover, studying the procedures and scripts to learn more about Excel. However you use it, Excel Hacks will help you increase productivity and give you hours of “hacking” enjoyment along the way.

Links: rapidshare.com

Microsoft Office Excel 2007 Inside Out

 

Published in: 2007
Published by: Microsoft Press
Author: Mark Dodge
ISBN: 073562321X 

This book packs hundreds of time-saving solutions, troubleshooting tips, and workarounds for using Office Excel 2007. Whether you are upgrading from Office 97 or Office 2003, youll be able to dig in to the work-ready resources that help you take your Office Excel 2007 experience to the next level. This information-packed complete reference shows you how to get the most out of Office Excel 2007. You will learn how to navigate the products new features and capabilities, including the new formatting and editing advances such as Live Preview. Youll explore new graphics capabilities, master the charting interface, and learn how to create dynamic lists with PivotTable reports. Youll even learn how to automate Office Excel with macros, custom functions, and more.

Links: eazyupload.net, rapidshare.com

Core PHP Programming, 3rd Edition

 

Published in: 2003
Published by: Prentice Hall
Author: Atkinson, Suraski
ISBN: 0130463469
Size: 1.59MB

Core PHP Programming, Third Edition is the authoritative guide to the new PHP 5 for experienced developers. Top PHP developer Leon Atkinson and PHP 5 contributor/Zend Engine 2 co-creator Zeev Suraski cover every facet of real-world PHP 5 development, from basic syntax to advanced object-oriented development — even design patterns! It’s all here: networking, data structures, regular expressions, math, configuration, graphics, MySQL/PostgreSQL support, XML, algorithms, debugging, optimization…and 650 downloadable code examples, with a Foreword by PHP 5 contributor and Zend Engine 2 co-creator Andi Gutmans! Forward When I wrote the Foreword for Leon’s second edition, PHP 4 had just started making it big, taking over the market share from PHP 3. The new version made great promises, and looking back it met all of its promises and more. We can see that at present PHP 4 has no doubt not only replaced almost all PHP 3 installations, but has conquered the Web application development market with its millions of installations and use in enterprise companies. Today, we are again facing exciting times. PHP 5 is about to be released, promising major improvements to the growing PHP community. As with previous versions, the major improvements are at the language level. Zeev and I redesigned the object model–at last dumping the problematic model, which originated from our work in PHP 3. Some of the other changes we made include: Treating objects as handles and not native types, allowing for other new features and fixing some odd behavior. Allowing for private, public, and protected access restrictions on members and methods. Introducing exception handling a la C++’s try/catch. Providing interfaces similar to the ones found in Java giving. And lots more… PHP 5 is also expected to feature improvements and additions in other areas, including better all-around XML support, improved streams support, and more. In the 3rd edition of Core PHP Programming, Leon has invited my partner Zeev Suraski to cover the PHP 5 language changes. No doubt that Leon’s experience in writing PHP books and Zeev’s superior knowledge of PHP 5 and its internals have led to a must-buy book for PHP developers.

Links: rapidshare.com, hot.ee, rapidsafe.net

Advanced PHP for Web Professionals

Published in: 2002
Published by: Prentice Hall
Author: Chris Cosentino
ISBN: 0130085391

Size: 1.32MB

In this concise, hands-on tutorial, PHP expert Christopher Cosentino delivers dozens of powerful new techniques for building serious Web applications. Through professional-quality examples drawn from his six years as a PHP developer, Cosentino walks you through building friendlier, more usable sites; improving user authentication; generating dynamic graphics; parsing XML documents; building database-independent Web applications; and much more!

Links: megaupload.com (Password = www.phuquoconline.net), rapidshare.com (Password = ebookspyder.net), mihd.net

Teach Yourself PHP in 24 Hours

Published in: 2003
Published by: Sams
Author: Matt Zandstra
ISBN: 0672326191
Size: 2.36MB

Consisting of 24 one-hour lessons, Sams Teach Yourself PHP in 24 Hours, is divided into five sections that guide the reader through the language from the basics to advanced functions. The first section of the book teaches the fundamentals of PHP. And then, sections two through four shows the reader how to apply that knowledge in order to interact with the user by creating and managing forms, cookies and authentication. It also teaches how to access databases and how to integrate system components, e-mail, LDAP, network sockets and much more…

Links: rapidshare.de, eazyupload.net

The PHP Anthology: 101 Essential Tips, Tricks & Hacks 2nd ed.

 

Published in: 2007
Author: Ben Balbo
ISBN: 0975841998
Size: 2.86MB

The PHP Anthology: 101 Essential Tips, Tricks & Hacks, 2nd Edition is a collection of powerful PHP 5 solutions to the most common programming problems. Featuring best-practice code and a commonsense approach to development, this book includes coverage of:

Manage errors gracefully

Build functional forms, tables, and SEO-friendly URLs

Reduce load time with client- and server-side caching

Produce and utilize web services with XML

Secure your site using access control systems

Easily work with files, emails, and images

And much more

The question and answer format will allow you to to quickly find and reference any of the 101 solutions, saving you hours of Internet research or painful trial & error. All solutions are fully explained and the ready-to-use code is available for download.

Links: rapidshare.com, megaupload.com, megaupload.com

PHP 5 Power Programming

 

Published in: 2004
Published by: Prentice Hall PTR
ISBN: 013147149X
Size: 8.10MB

- Expert PHP 5 programming techniques, direct from PHP 5 co-creator and key developers

- Definitive coverage of the PHP object model, design patterns, XML/SOAP integration, and more

- Solid introduction and expert insights into performance tuning, PEAR, extensions, and database access

- The definitive introduction to PHP 5′s advanced features!

- The definitive introduction for today’s most powerful PHP 5 techniques

Links: rapidshare.com

Microsoft Excel Functions and Formulas: Excel 97 – Excel 2003

 

Published in: 2006
Published by: Wordware
Author: Bernd Held
ISBN: 159822011X

Size: 3.45MB 

Equipped with a variety of functions and easy to use, Microsoft Excel is the tool of choice when it comes to crunching numbers, building charts, and analyzing tables. But most users only scratch the surface of the program’s functionality, especially the built-in formulas designed to make everyday operations and real-world tasks more efficient. Microsoft Excel Functions & Formulas demonstrates the secrets of Excel functions through the use of practical and useful examples in a quick reference format. Topics include logical, text, date and time, basic statistical, mathematical, financial, database, and reference functions as well as conditional formatting with formulas, array formulas, and user-defined functions. Easy to use and equipped with a variety of functions, Microsoft Excel is the tool of choice when it comes to crunching numbers, building charts, and analyzing tables. But most users only scratch the surface of the program’s functionality, especially the built-in formulas designed to make everyday operations and real-world tasks more efficient. Microsoft Excel Functions & Formulas demonstrates the secrets of Excel functions through the use of practical and useful examples in a quick reference format. Topics include logical, text, date and time, basic statistical, mathematical, financial, database, and lookup and reference functions as well as conditional formatting with formulas, array formulas, and user-defined functions. This book’s extensive examples make it an excellent tutorial for all Excel users who want to understand, create, and apply formulas. Intermediate and advanced users will find Microsoft Excel Functions & Formulas an excellent reference to many of the program’s advanced formulas and functions. Bernd Held is one of the leading authorities on Microsoft Office software in Germany, especially Microsoft Excel. The author of more than 40 books and 800 articles and reviews for various publications, he is also a professional consultant specializing in training and customized solutions for a variety of businesses. For the past eight years, Microsoft has recognized him as an MVP (Most Valuable Professional). He lives in Germany with his wife, son, and daughter.

Links: rapidshare.com

Excel 2007 VBA Programming For Dummies

 

Author: John Walkenbach
Published in: 2007
ISBN: 0470046740

Size: 4.42MB

Step-by-step instructions for creating VBA macros Harness the power of VBA and create custom Excel applications Make Excel 2007 work for you! This clear, nonintimidating guide shows you how to use VBA to create Excel apps that look and work the way you want. Packed with plenty of sample programs, it explains how to work with range objects, control program flow, develop custom dialog boxes, create custom toolbars and menus, and much more. Discover how to:

- Grasp essential programming concepts

- Use the Visual Basic® Editor

- Navigate the new Excel user interface

- Communicate with your users

- Deal with errors and bugs

Links: rapidshare.com, mihd.net