Master VISUALLY Excel 2007

Master VISUALLY Excel 2007
Author: Elaine Marmel
Publisher: John Wiley & Sons
Total Pages: 802
Release: 2008-03-10
Genre: Computers
ISBN: 0470181702

Presents step-by-step screen shots and instructions on the features and functions of Excel 2007, covering such topics as formatting cells, designing worksheets, calculating data, creating charts, analyzing data, and working with macros.

Teach Yourself VISUALLY Microsoft Office Access 2007

Teach Yourself VISUALLY Microsoft Office Access 2007
Author: Faithe Wempen
Publisher: John Wiley & Sons
Total Pages: 321
Release: 2008-03-11
Genre: Computers
ISBN: 0470377720

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 will find clear, step-by-step screen shots that show you how to tackle more than 170 Access 2007 tasks. Each task-based spread includes easy, visual directions for performing necessary operations, including * Navigating the new interface * Using templates to create databases * Entering and editing data * Working with tables and fields * Creating simple or summary queries * Linking to Excel(r) worksheets * 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

Master VISUALLY Microsoft Office 2007

Master VISUALLY Microsoft Office 2007
Author: Tom Bunzel
Publisher: John Wiley & Sons
Total Pages: 722
Release: 2008-03-11
Genre: Computers
ISBN: 0470377429

Within this comprehensive, visual reference, succinctly captioned, step-by-step screen shots show you how to accomplish more than 300 Office tasks. You’ll learn how to format text and apply styles in Word, work with Excel formulas and functions, add animation to PowerPoint slides, create an Access database, manage contacts with Outlook, collaborate with OneNote and Live Meeting, and create publications with Publisher. A bonus CD-ROM includes demo software, add-ins, sample files, and additional chapters.

Pivot Table Data Crunching

Pivot Table Data Crunching
Author: Bill Jelen
Publisher: Pearson Education
Total Pages: 581
Release: 2010-10-20
Genre: Computers
ISBN: 0789746689

PivotTables may be Excel's most powerful feature, but Microsoft has estimated that only 15% of Excel users take advantage of them. That's because PivotTables (and their companion feature, PivotCharts) have a reputation for being difficult to learn. Not any more! In this book, Excel legends Bill Jelen ("MrExcel") and Michael Alexander teach PivotTables and PivotCharts step-by-step, using realistic business scenarios that any Excel user can intuitively understand. Jelen and Alexander go far beyond merely explaining PivotTables and PivotCharts: they present practical "recipes" for solving a wide range of business problems. Drawing on more than 30 combined years of Excel experience, they provide tips and tricks you won't find anywhere else, and show exactly how to sidestep common mistakes. Coverage includes: " Creating PivotTables, customizing them, and changing the way you view them " Performing calculations within PivotTables " Using PivotCharts and other visualizations " Analyzing multiple data sources with PivotTables " Sharing PivotTables with others " Working with and analyzing OLAP data " Making the most of Excel 2010's powerful new PowerPivot feature " Using Excel 2010's Slicer to dynamically filter PivotTables " Enhancing PivotTables with macros and VBA code This book is part of the new MrExcel Library series, edited by Bill Jelen, world-renowned Excel expert and host of the enormously popular Excel help site, MrExcel.com. Teaches PivotTables, PivotCharts, and Excel 2010's new PowerPivot feature through real-world scenarios that make intuitive sense to users at all levels Includes proven PivotTable recipes for instant on-the-job results Helps Excel users avoid common pitfalls and mistakes Part of the brand-new MrExcel Library series, edited by Excel legend Bill Jelen

Master VISUALLY Excel 2010

Master VISUALLY Excel 2010
Author: Elaine Marmel
Publisher: John Wiley and Sons
Total Pages: 1595
Release: 2011-03-03
Genre: Computers
ISBN: 1118036255

The complete visual reference on Excel basics Aimed at visual learners who are seeking an all-in-one reference that provides in-depth coveage of Excel from a visual viewpoint, this resource delves into all the newest features of Excel 2010. You'll explore Excel with helpful step-by-step instructions that show you, rather than tell you, how to navigate Excel, work with PivotTables and PivotCharts, use macros to streamline work, and collaborate with other users in one document. This two-color guide features screen shots with specific, numbered instructions so you can learn the actions you need to perform in order to execute a wide range of Excel 2010 tasks. Features beginning, intermediate andadvanced visual coverage of Excel 2010 Shows you how to enter information into a worksheet, use formulas and functions, find and control formulaic errors, and much more Presents more than 1,000 screen shots that demonstrate step-by-step instructions of numerous Excel 2010 tasks You're encouraged to move at your own pace as you acquire confidence and proficiency with the newest version of Excel.

Microsoft Office 2007 Simplified

Microsoft Office 2007 Simplified
Author: Sherry Willard Kinkoph
Publisher: John Wiley & Sons
Total Pages: 419
Release: 2008-03-11
Genre: Computers
ISBN: 0470377569

Are you new to computers? Does new technology make you nervous? Relax! You're holding in your hands the easiest guide ever to Office 2007 -- a book that skips the long-winded explanations and shows you how things work. All you have to do is open the book, follow Chip, your friendly guide -- and discover just how easy it is to get up to speed. "The Simplified series is very accessible to beginners and provides useful information for more experienced users. For visual learners (like myself), the illustrations are a great help. It's challenging to take a complex subject and express it simply, clearly, concisely, and comprehensively. This book meets the challenge." --John Kelly (Anchorage, AK) "Simplify It" sidebars offer real-world advice A friendly character called Chip introduces each task Full-color screen shots walk you through step by step Self-contained, two-page lessons make learning a snap

Teach Yourself VISUALLY Microsoft Office PowerPoint 2007

Teach Yourself VISUALLY Microsoft Office PowerPoint 2007
Author: Lisa A. Bucki
Publisher: John Wiley & Sons
Total Pages: 322
Release: 2008-03-11
Genre: Computers
ISBN: 0470377410

Covers new PowerPoint features including how to create presentation slides, dress them up using templates and graphics, add sound and animation, and present in a business or Internet setting Equips users to present visually charged, captivating slideshows Sophisticated, revised full-color design provides readers with easier navigation Shows users how to make real-world use of PowerPoint 2007 with highly visual two-page tutorials and numbered, step-by-step screen shots in full color on high-quality paper

Microsoft Office Excel 2007 Data Analysis

Microsoft Office Excel 2007 Data Analysis
Author: Denise Etheridge
Publisher: John Wiley & Sons
Total Pages: 308
Release: 2007-07-23
Genre: Computers
ISBN: 0470132299

Provides instructions on using Excel to analyze data, covering such topics as creating formulas, using financial functions, organizing worksheet data, working with PivotTables, and automating with macros.

Teach Yourself VISUALLY Office 2010

Teach Yourself VISUALLY Office 2010
Author: Kate Shoup
Publisher: John Wiley & Sons
Total Pages: 435
Release: 2010-03-09
Genre: Computers
ISBN: 0470641126

Master the new version of Microsoft Office with this easy, visual guide The popular Microsoft Office suite has been revamped to provide new features, including Web applications that can be accessed from anywhere and a new, streamlined Ribbon. If you learn better with visual instructions, this full-color guide is just what you need. Covering Word, Excel, PowerPoint, Outlook, Access, and Publisher, this book is filled with step-by-step instructions and full-color screen shots that show you exactly what you'll see at each step. You'll also get instruction on the new Office Internet and graphics tools, as well as how to tackle dozens of common tasks in each application. Ideal for visual learners, this guide covers the entire Office suite: Word, Excel, PowerPoint, Outlook, Access, and Publisher Introduces the new Microsoft Office features, including Office Internet and graphics tools Provides step-by-step instructions for common tasks in each application Full-color screen shots illustrate what you see on the screen every step of the way Teach Yourself VISUALLY Office 2010 gets you up and running with Office 2010 quickly and easily, so you can take advantage of all the enhanced features.