Brilliant Microsoft Excel 2007


Book Description

Pivot tables are the most powerful feature in Excel. A basic pivot table will allow you to summarize 500,000 rows of transactional data in 30 seconds with just a few mouse clicks. Business productivity would skyrocket if everyone knew how to use pivot tables. However, only 12% of people using Excel can create a basic pivot table. Of this group only a small percentage actually harness all the power that pivot tables afford them. By the end of the book, users will be pivot table gurus automating pivot tables using VBA, creating pivot tables with external data in OLAP cubes, and even creating dynamic reporting systems so that managers can answer their own queries with a few mouse clicks. Throughout the book there are no-nonsense, step-by-step tutorials and lots of practical examples aimed directly at business users.




Teach Yourself VISUALLY Microsoft Office 2007


Book Description

Are you a visual learner? Do you prefer instructions that show youhow to do something - and skip the long-winded explanations? If so,then this book is for you. Open it up and you'll find clear,step-by-step screen shots that show you how to tackle more than 220Office 2007 tasks. Each task-based spread includes easy, visualdirections for performing necessary operations, including: * Using Galleries and Live Preview * Finding hidden files * Creating a blog post * Assembling and presenting slideshows * Developing a publication * Building a spreadsheet * Helpful sidebars offer practical tips and tricks * Full-color screen shots demonstrate each task * Succinct explanations walk you through step by step * Two-page lessons break big topics into bite-sized modules




The Unofficial Guide to Outlook 2007


Book Description

Microsoft Outlook 2007 is a major update and to use it with confidence you need to know its quirks and shortcuts. Readers will find unbiased information on everything from simple tasks like working with schedules and the calendar to expertly managing contacts and expediting repetitive or common tasks.







Professional Outlook 2007 Programming


Book Description

Written by one of the most popular and knowledgeable Microsoft Outlook MVPs, this book fills a void in the market for a professional-level Outlook programming book Explains how to use the many new features of Outlook 2007's object model and offers honest advice from the author on how to deal with common shortcomings and pitfalls of Outlook Addresses common workarounds for Outlook programming bugs and how to interface with Word, Excel, SharePoint, and Access Discusses the new Object Model, Outlook forms, COM add-ins, security, and more




Microsoft Office Word 2007 Plain & Simple


Book Description

Presents step-by-step instructions on the essentials of the word processing program, covering such topics as creating different types of documents, formatting, editing, reviewing, publishing documents on the Web, and integrating with other Office products.




Teach Yourself VISUALLY Excel 2007


Book Description

Are you a visual learner? Do you prefer instructions that show you how to do something - and skip the long-winded explanations? If so, then this book is for you. Open it up and you'll find clear, step-by-step screen shots that show you how to tackle more than 150 Excel 2007 tasks. Each task-based spread includes easy, visual directions for performing necessary operations, including: * Using the Ribbon and galleries * Entering data and resizing columns * Applying formulas and functions * Formatting worksheets * Adding clip art and 3D effects * Interpreting data with charts * Helpful sidebars offer practical tips and tricks * Succinct explanations walk you through step by step * Full-color screen shots demonstrate each task * Two-page lessons break big topics into bite-sized modules




VBA and Macros


Book Description

Provides a step-by-step guide to using Visual Basic for Applications (VBA) and macros to import data and produce reports in Microsoft Excel 2010.




Word 2007 For Dummies


Book Description

Dan Gookin's For Dummies guides to Word have consistently led the pack, selling more than 1.7 million copies in previous editions The author's irreverent sense of humor and crystal-clear prose make getting up to speed on Word a snap Thoroughly updated to cover Word's new interface, new file format options, and new collaboration and connectivity features An essential resource for everyone who wants to hit the ground running with Word 2007 and make the most of all the new features




Word 2013 Bible


Book Description

Top-to-bottom coverage of the top-selling Microsoft Office application If you want to use Microsoft Word to create more than just simple documents, start with this ultimate Word guide. Packed with the in-depth content that is the hallmark of all Wiley Bibles, this book covers it all. You'll first find out what's new in Word 2013 on the features level - formatting, styles, tables, and more - before you dive into the big stuff that can help you become more efficient. From document design to creating master documents to applying security to collaborating in the Cloud, you'll learn not just how to do tasks, but the best ways to do them, and why. Details everything you need to know to get the most out of Word 2013 Walks you through new or refreshed basics, such as formatting, styles, charts, and tables Shows you how to use data sources, create envelopes and labels, and make forms Takes your Word skills up a notch with coverage of keyboard customization, security, collaborating on the Cloud, comparing documents, and much more Start creating documents at a new level and wow your colleagues, with Word 2013 Bible.