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.
more…

Microsoft Office 2007 Blue Edition SP2 Integrated

Microsoft Office 2007 Blue Edition SP2 Integrated | 952 MB

more…

Lynda.com Excel 2007 Macros in Depth
HF | 180 MB | Exercice files incl.
www.lynda.com/home/DisplayCourse.aspx?lpk2=62643

In Excel 2007: Macros in Depth, author Dennis Taylor demonstrates common tasks for which macros are used, and walks through the process of creating and running simple macros. This course also covers more advanced topics, including making macros widely available through the Personal Macro Workbook, recording a macro in stages, absolute and relative recording, and using Visual Basic for Applications (VBA) for actions that can’t be recorded. The course wraps up with a macro project that brings together each of the elements in a real-world scenario. Exercise files accompany the course
more…

Business Analysis: Microsoft Excel 2010
Que | 4th Edition [ June 2010 | 0789743176 | pdf | 21.7mb
www.amazon.com/Business-Analysis-Microsoft-MrExcel-Library/dp/0789743175/

USE EXCEL 2010 TO GAIN DEEPER INSIGHTS, MAKE SMARTER DECISIONS, AND EARN MORE PROFITS

Using real-world examples, Carlberg helps you put Excel’s features and functions to work and get the power of quantitative analysis behind your management decisions.

Excel expert Conrad Carlberg shows how to use Excel 2010 to perform the core financial tasks every manager and entrepreneur must master: analyzing statements, planning and controlling company finances, making investment decisions, and managing sales and marketing. Using real-world examples, Carlberg helps you get the absolute most out of Excel 2010’s newest features and functions. Along the way, you’ll discover the fastest, best ways to handle essential tasks ranging from importing business data to analyzing profitability ratios.
more…

VBA and Macros: Microsoft Excel 2010
Que | July 2010 | 0789743145 | pdf | 656p | 21.1mb
www.amazon.com/VBA-Macros-Microsoft-MrExcel-Library/dp/0789743140/

Use Excel 2010 VBA and macros to automate virtually any routine task, and save yourself hours, days, maybe even weeks. Then learn how to make Excel do things you thought were simply impossible! This book reveals scripting techniques you won’t find anywhere else and shows you how to create automated reports that are amazingly powerful and useful. It helps you instantly visualize information so you can understand and act on it. It also shows you how to capture data from anywhere and use it anywhere, and helps you automate Excel 2010’s most powerful new features. Learning advanced Excel scripting has never been easier. You’ll find simple, step-by-step instructions, real-world examples and case studies, and 50 workbooks packed with bonus examples, macros, and solutions, straight from MrExcel.
more…

Microsoft Project is brimming with features to help you manage any project, large or small. But learning the software is only half the battle. What you really need is real-world guidance: how to prep your project before touching your PC, which Project tools work best, and which ones to use with care. This book explains it all, helping you go from project manager to project master.
more…

Office 2010 Workflow
Apress | July 2010 | Pdf | 1430229049 | 7 mb
www.amazon.com/Office-2010-Workflow-Mark-Collins/dp/1430229047

Workflow is the glue that binds information worker processes, users, and artifacts. Without workflow, information workers are just islands of data and potential. Office 2010 Workflow details how to implement workflow in SharePoint 2010 and the client Microsoft Office 2010 suite to help information workers share data, enforce processes and business rules, and work more efficiently together or solo. more…