Excel 2007 All-In-One Desk Reference For Dummies

Master the Ribbon, powerful graphics capabilities, and more!

Your one-stop guide to great-looking spreadsheets that actually mean something

Excel 2007 All-In-One Desk Reference For Dummies

Read more...

Writing Excel Macros with VBA, 2nd Edition

Newly updated for Excel 2002, Writing Excel Macros with VBA, 2nd Edition provides Excel power-users, as well as programmers who are unfamiliar with the Excel object model, with a solid introduction to writing Visual Basic for Applications (VBA) macros and programs for Excel. In particular, the book focuses on:
The Visual Basic Editor and the Excel VBA programming environment. Excel features a complete, state-of-the-art integrated development environment for writing, running, testing, and debugging VBA macros. The VBA programming language, the same programming language used by the other applications in Microsoft Office XP and 2000, as well as by the retail editions of Visual Basic 6.0. The Excel object model, including new objects and new members of existing objects in Excel 2002. Excel exposes nearly all of its functionality through its object model, which is the means by which Excel can be controlled programmatically using VBA. While the Excel object model, with 192 objects, is the second largest among the Office applications, you need to be familiar with only a handful of objects to write effective macros. Writing Excel Macros focuses on these essential objects, but includes a discussion of many more objects as well. Writing Excel Macros with VBA, 2nd Edition is written in a terse, no-nonsense manner that is characteristic of Steven Roman's straightforward, practical approach. Instead of a slow-paced tutorial with a lot of handholding, Roman offers the essential information about Excel VBA that you must master to write macros effectively. This tutorial is reinforced by interesting and useful examples that solve common problems you're sure to have encountered. Writing Excel Macros with VBA, 2nd Edition is the book you need to delve into the basics of Excel VBA programming, enabling you to increase your power and productivity.

Writing Excel Macros with VBA, 2nd Edition

Read more...

Excel Gurus Gone Wild

Drawn from actual excel conundrums posted on the author’s website, this high-level resource is designed for people who want to stretch Excel to its limits. Tips for solving 100 incredibly difficult problems are covered in depth and include extracting the first letter of each word in a paragraph, validating URL’s, generating random numbers without repeating, and hiding rows if cells are empty. The answers to these and other questions have produced results that have even surprised the Excel development team.

Excel Gurus Gone Wild

Read more...

How to Use Microsoft Excel 2010

This easy to follow book helps employees, students, teachers and parents wanting their children to get a head start in their use of Spreadsheet software.

- This book shows you how to use the basic tasks in Microsoft Excel 2010.

- This simple step by step tutorial introduces you to the main functions of spreadsheets using Microsoft Excel 2010.

- It is suitable for absolute beginners and those looking for a refresher guide into Excel 2010.

- The book is divided into clear sections that demonstrate the separate skills that you can follow at your own pace.

- The book offers a gradual introduction to the correct vocabulary to ease the learning of the software and improve future communication.

Overview

o An introduction to the basics of Microsoft Excel 2010.
o It can be used by professionals, teachers, parents or children.
o It shows you how spreadsheet may be used in a range of different situations.
o It is divided in a series of lessons/chapters which you can follow at your own pace.
o You will need no additional assistance.
How to Use Microsoft Excel 2010

Read more...