The world of mathematical formulas and jargon in Microsoft Excel is complex and can be intimidating for even advanced computer users. Perhaps like you, a majority of users find it difficult to get the most they can out of this very valuable program. Formulas and Functions with Microsoft Excel 2003 strives to break down the complexities by focusing on the four primary technologies to master: ranges, formulas, data analysis tools and lists. Chapters such as “Getting the Most Out of Ranges,” “Building Your Own Functions Using VBA,” and “Solving Complex Problems with Solver” will teach you practical skills and solutions that you can put to work immediately. Frustration will become a thing of the past as you begin to master the complex world of Excel!

(more…)

The Visibooks Guide to PowerPoint 2003 helps beginners learn to create presentations using Microsoft PowerPoint.

(more…)

Millions of people use Microsoft Access, but
only a small fraction of them are really comfortable with it. If you’re
ready to go �beyond the wizards��and become a confident, highly
effective Access user�Hands-On Microsoft Access was written for you.

In
plain English, Bob Schneider helps you master crucial principles for
building flexible, powerful databases. Discover how to enter data more
easily, retrieve it more freely, manipulate it more successfully,
analyze it with greater sophistication, and share it more effectively.
Schneider’s dozens of hands-on examples thoroughly demystify Access,
and his friendly, conversational style makes it more approachable than
ever before.

(more…)

Quicken is the #1 personal finance software on the market, with greater than 70 percent retail market share and 16 million active users This book features eight minibooks comprising nearly 750 pages-all the information people need to get the most out of the latest Quicken release, get their finances under control, start building a nest egg, and pay less to the IRS The only book on the market to include coverage on Quicken Premier Home and Business Minibook topics include personal finance basics, an introduction to Quicken, household finances, planning ahead and saving, tracking investments, retirement planning, taxes, and managing small business finances Quicken books are consistent top sellers, with more than 900,000 copies of Quicken For Dummies sold in all in all editions

(more…)

Get more out of Outlook! The Outlook Answer Book brings together
hundreds of bite-size tips and tricks for saving time, using Outlook more
efficiently, uncovering its hidden power, and overcoming its quirks and
pitfalls. With this book’s fast-paced Q&A format, you can find new ideas
and better solutions fast-and keep finding them for months and years
to come.

There’s no other Outlook book like it! You’ll find high-powered tips for
using every Outlook module: Mail, Tasks, Contacts, Calendar, Notes,
and more. From Favorite Folders to the Journal, you’ll learn how to take
advantage of Outlook features you’ve never used-or even noticed! You’ll
master simple techniques for automating routine tasks… customizations
that make Outlook far more powerful… easy backup and troubleshooting solutions…
even new ways to protect your privacy and security.

(more…)

Sure you want to save money. We all do. But saving money is
sometimes easier said than done. Did you know that there is a program
probably already installed on your computer that can help you manage
your money better? It’s Microsoft Excel, part of the Microsoft Office
suite. Manage Your Money and Investments with Excel can help you take control of your finances with Excel. Learn how to:

• Perform basic financial calculations.
• Track and analyze investments.
• Compare mutual fund options.
• Manage mortgages, loans, and escrow accounts.
• Balance checking accounts and manage credit card debt.
• Track your net worth.

(more…)

In a corporate setting, the Microsoft Office Suite is an invaluable
set of applications. One of Offices’ biggest advantages is that its
applications can work together to share information, produce reports,
and so on. The problem is, there isn’t much documentation on their
cross-usage. Until now.

Introducing Integrating Excel and Access,
the unique reference that shows you how to combine the strengths of
Microsoft Excel with those of Microsoft Access. In particular, the book
explains how the powerful analysis tools of Excel can work in concert
with the structured storage and more powerful querying of Access. The
results that these two applications can produce together are virtually
impossible to achieve with one program separately.

But the
book isn’t just limited to Excel and Access. There’s also a chapter on
SQL Server, as well as one dedicated to integrating with other
Microsoft Office applications. In no time, you’ll discover how to:

• Utilize the built in features of Access and Excel to access data
• Use VBA within Access or Excel to access data
• Build connection strings using ADO and DAO
• Automate Excel reports including formatting, functions, and page setup
• Write complex functions and queries with VBA
• Write simple and advanced queries with the Access GUI
• Produce pivot tables and charts with your data

With Integrating Excel and Access,
you can crunch and visualize data like never before. It’s the ideal
guide for anyone who uses Microsoft Office to handle data.

(more…)

As one of the most widely used desktop applications ever created, Excel is familiar to just about everyone with a computer and a keyboard. Yet most of us don’t know the full extent of what Excel can do, mostly because of its recent growth in power, versatility, and complexity. The truth is that there are many ways Excel can help make your job easier-beyond calculating sums and averages in a standard spreadsheet.

Analyzing Business Data with Excel shows you how to solve real-world business problems by taking Excel’s data analysis features to the max. Rather than focusing on individual Excel functions and features, the book keys directly on the needs of business users. Most of the chapters start with a business problem or question, and then show you how to create pointed spreadsheets that address common data analysis issues.

(more…)

“If you’re a SQL programmer or an experienced Excel user, here at last
is the ultimate resource on developing reporting solutions with Excel.
Focused on report development using OLTP databases, this book is packed
with comprehensive information on both technical and strategic aspects.
You’ll thoroughly examine the main features of Excel’s reporting
technology-PivotTable reports, Spreadsheet reports, parameter queries,
and web components. With notes, tips, warnings, and real-world examples
in each chapter, you’ll be able to put your knowledge to work
immediately. This book includes:

• Single-source coverage of Excel’s report development features
• Extensive and in-depth information on PivotTable and Spreadsheet report features, functions, and capabilities
• Thorough documentation of the Microsoft Query program included with Excel
• Comprehensive information on Excel’s client-based OLAP cube tools for processing very large datasets from OLTP data sources
• Detailed information on creating and working with web-enabled Excel reports

The download link was corrected already !

(more…)

This go-to-resource is a must-have for anyone using Project Server
2003!� Written by a widely recognized authority on project management, QuantumPM, this
in-depth approach to planning and implementing Microsoft Office Project
Server 2003 is derived from the team’s technical and practical client
experiences.� Microsoft Office Project Server 2003 Unleashed provides an in-depth look at Microsoft Office Project Server 2003 and the possibilities of this technology.

(more…)