This detailed second edition is Scot Hillier’s follow-up to his market-leading SharePoint book. The new version includes extensive updates to the previous edition, with emphasis on Visual Studio Tools for Office 2005 and new approaches for using SharePoint to improve business efficiency. Also featured are new workflow solutions for SharePoint and BizTalk, and a new chapter on building a SharePoint solution from start to finish.

In this second edition, Hillier’s goal remains to provide intermediate-level guidance for those who want to design and deploy business solutions based on Microsoft SharePoint technologies. Hillier defines the business cases and scenarios for these technologies. He reviews the installation, configuration, and administration of business solutions based on Microsoft SharePoint technologies, and provides programming instruction, guidance, and examples for custom web parts and solutions.

(more…)

Home Office Computing Made Easy!

Today’s busy families depend on their home PCs now more than ever. From managing the family budget to digitizing memories or composing the term paper from Hades, home computers are being pressed into service by family members of all ages as never before.

As the number of homes that are equipped with multiple PCs continues to expand, so does the need for trusted resources that can help your family gain maximum benefit from its computer investments. TechRepublic’s Home Office Computing Survival Guide, Second Edition is just such a resource.

With its strong emphasis on the features that make Windows 2000 and Windows XP the home and small office network operating systems of choice, this essential guide will help you do all this and more:

• Determine what kind of computer network is right for your family.
• Select the most appropriate Internet connection for your home network.
• Understand the basics of TCP/IP and file sharing.
• Configure your network to use a DSL or cable modem.
• Secure your Windows XP network with Internet Connection Firewall.
• Set access levels and file-sharing permissions.
• Protect data using proper backup and recovery methods.

(more…)

Paul McFedries
Publisher: Que
Publication date: 2005
ISBN 0789733692

We all have those “go-to” people in our lives. The one you go-to for advice, the one you go-to for comfort, the one you go-to with technical questions…now you can be the one that others go-to for help with Microsoft Office 2003. Tricks of the Microsoft Office Gurus is full of exclusive tricks from Paul McFedries, an Office “insider,” that will help you learn the Office applications inside and out. Designed to bridge the gap between your expectation and reality, you will go beyond the basics and learn newly discovered techniques, shortcuts and best practices, including:

- Using Excel’s “Camera Tool” for what-if analysis
- Embedding fonts in shared documents
- Adding a live stock price quote to a worksheet
- Using dummy text to layout and format a document
- Publishing Outlook Calendar to the web
- Using Word to customize Power Point handouts

Through real-world examples that showcase how the tips and tricks can be used in everyday business tasks, Tricks of the Microsoft Office Gurus will help you get the most out of Office 2003.

(more…)

OpenOffice.org 2.0 is all the office productivity software you’ll ever need for your Windows or Linux computer: word processing, spreadsheets, presentations, drawing, even databases… and it’s free! Not sure it’s up to the job? It is. Not sure you can switch from Microsoft Office? You can. Just let OpenOffice.org expert and Open Source Technology Group (OSTG) editor-in-chief Robin ‘Roblimo’ Miller teach you OpenOffice.org the easy way—using the skills you already have!

Robin will help you become productive in minutes—and you don’t need to be a computer expert! His easy, visual instructions walk you through every step of every task you need to know… plus, you’ll find twenty how-to videos on CD! You’ll master everything from formatting text documents to creating presentation slide shows and building “what-if” projections to designing flowcharts. There’s even bonus coverage of Firefox and Thunderbird, the fast, safe, free software for Web browsing and e-mail!

• Master OpenOffice.org Writer, Calc, Impress, Draw, and Base.

• Create Microsoft Office-compatible documents anyone can read and use.

• Analyze, manage, and manipulate business information with Calc.

• Design attractive charts and other visuals.

• Use mail merge to create great form letters or e-mails.

• Create and manipulate sophisticated databases—even if you have no previous database experience.

• Start using Firefox—the safest, most secure Web browser available for Windows!

• Filter out junk mail with Thunderbird and say goodbye to Outlook Express.

• Do things you can’t do with Microsoft Office—such as creating Flash slide shows for the Web!
(more…)

Special Edition Using WordPerfect Office X3 is crammed full of tips, tricks, and practical examples that you won’t find anywhere else! Covering all of the applications within WordPerfect Office Standard including WordPerfect, Quattro Pro, and Presentations, this is an all-inclusive reference for every user. Whether you are just looking to learn the new features of the latest version or need to know how to use the entire feature set more effectively, this book will answer all the questions you have along the way.
(more…)

Why program Excel? For solving complex calculations and presenting results, Excel is amazingly complete with every imaginable feature already in place. But programming Excel isn’t about adding new features as much as it’s about combining existing features to solve particular problems. With a few modifications, you can transform Excel into a task-specific piece of software that will quickly and precisely serve your needs. In other words, Excel is an ideal platform for probably millions of small spreadsheet-based software solutions.

The best part is, you can program Excel with no additional tools. A variant of the Visual Basic programming language, VB for Applications (VBA) is built into Excel to facilitate its use as a platform. With VBA, you can create macros and templates, manipulate user interface features such as menus and toolbars, and work with custom user forms or dialog boxes. VBA is relatively easy to use, but if you’ve never programmed before, Programming Excel with VBA and .NET is a great way to learn a lot very quickly. If you’re an experienced Excel user or a Visual Basic programmer, you’ll pick up a lot of valuable new tricks. Developers looking forward to .NET development will also find discussion of how the Excel object model works with .NET tools, including Visual Studio Tools for Office (VSTO).

This book teaches you how to use Excel VBA by explaining concepts clearly and concisely in plain English, and provides plenty of downloadable samples so you can learn by doing. You’ll be exposed to a wide range of tasks most commonly performed with Excel, arranged into chapters according to subject, with those subjects corresponding to one or more Excel objects. With both the samples and important reference information for each object included right in the chapters, instead of tucked away in separate sections, Programming Excel with VBA and .NET covers the entire Excel object library. For those just starting out, it also lays down the basic rules common to all programming languages.

(more…)

• Offers an easy-to-navigate design featuring a two-column landscape layout loaded with step-by-step instructions and illustrations to help readers get up to speed fast on key PowerPoint tasks-and create effective and striking presentations
• Covers creating a new presentation, resizing or moving an object, duplicating a slide, using the outlining toolbar, and adding notes to a slide
• Shows how to print a presentation, set up a slide show, work with pictures and clip art, color text and objects, modify the slide master, create a template, insert a diagram or chart, add sound and video, and much more

(more…)

* Delivers more than fifty real solutions that will help people speed up numerous Office 2003 tasks
* Provides timesaving techniques for each of the most frequently used Office modules-Word, Excel, Access, Outlook, and PowerPoint
* Leonhard shows readers how to cut time-consuming tasks down to size with his easy-to-use, easy-to-understand techniques and tricks
* While the tips are designed for Office 2003, the author indicates when the advice may also be applied to Office XP or Office 2000
* Leonhard is well known for his skill in cutting through the hype and getting to the essential information-he wastes no time in helping readers save time (more…)

Written for intermediate- to expert-level Microsoft Word users, this book demonstrates frequently missed tools and the proper way to use new and existing tools. Word’s settings, toolbars, and menus are reviewed, as are topics such as the importance of installing safe fonts, setting tabs correctly, and using styles for maximum effect. Also offered is advice on topics pertaining to work groups, such as sharing templates, styles, and toolbars and creating paper and paperless forms. New concepts such as using tables to set up forms, recording macros to cut down on repetition, automatically updating cross-references, and minimizing file sizes are covered. Instructions on keeping a hard drive clean, which can minimize general PC problems, are also provided.

(more…)

Now included with Microsoft Office, Project 2003 is the world’s leading project management tool. With extensive help resources and printing assistance, Project 2003 enables users to organize and track tasks and resources efficiently to keep projects on time and within budget. If you want to realize the immense potential of Microsoft Project 2003 and harness the many features and functionality of this powerful tool, you need Project 2003 Personal Trainer. It includes everything you want to know about Project 2003–and then plenty more. It’s the most complete and engaging tutorial available for Microsoft Project. As part of O’Reilly’s new Personal Trainer Series, this book is based on content from CustomGuide (www.customguide.com), a leading provider of computer training materials that fly in the face of traditional, dry course materials that bore users to tears. CustomGuide is dedicated to delivering courseware, quick references, software bulletins, and e-learning courses that are fun, flexible, and easy to use. And this book is no exception to their rule. Project 2003 Personal Trainer lets you, whatever your technical expertise (or lack thereof), learn exactly what you need to know–at your own pace. Unlike many consumer software tutorials that dumb down (and dull up) the material or make it exceptionally technical and confusing, this book is written in a style that you’ll find entertaining, easy to follow, and most of all, clear and informative. Beginning with the fundamentals of planning and managing a project with Microsoft Project 2003, the book then includes sections on:
working with the task list
managing costs, timelines, and available resources
using the project database
viewing and updating a project
tracking progress
creating reports
handling multiple projects
The fully illustrated Project 2003 Personal Trainer features dozens of time-saving, task-oriented lessons, includes detailed diagrams, and comes with a fully interactive CD tutorial to guide your learning–everything you need to become a Project pro.

(more…)