Series:

Visual Blueprint

4 primary works

Book 21

Cover of Microsoft Office Excel 2007 Programming
Microsoft(r) Office Excel(r) 2007 Programming Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you'll discover step-by-step screen shots that demonstrate over 140 key Excel programming techniques, including: Assigning digital signatures to macros Setting properties for a project Assigning values to a variable Changing the properties of an object Formatting a numeric expression Processing a runtime error Saving worksheets to another file Displaying a built-in dialog box Creating custom Ribbon tabs Building and debugging add-ins Extra Apply It "Apply It" and "Extra" sidebars highlight useful tips High-resolution screen shots demonstrate each task Succinct explanations walk you through step by step Two-page lessons break big topics into bite-sized modules

Book 43

Cover of Excel Data Analysis – Your visual blueprint for Creating and analyzing data, charts and PivotTables, 3rd Edition
Advanced techniques for Excel power users

Crunch and analyze Excel data the way the professionals do with this clean, uncluttered, visual guide to advanced Excel techniques. Using numerous screenshots and easy-to-follow numbered steps, this book clearly shows you how to perform professional-level modeling, charting, data access, data slicing, and other functions. You'll find super techniques for getting the most out of Excel's statistical and financial functions, Excel PivotTables and PivotCharts, Excel Solver, and more.

  • Provides a clear look at power-using Excel, the world's leading spreadsheet application from Microsoft, and part of the new Microsoft Office 2010 suite
  • Expands your Excel knowledge and helps you use Excel data more efficiently
  • Demonstrates how to retrieve data from databases;; cut, slice, and pivot data using PivotTables; model data and chart data; and use advanced formulas
  • Explores all features and functions in friendly, two-color pages packed with screenshots, numbered steps, and other visual graphics that clearly show you how to accomplish tasks
  • Includes practical examples, tips, and advice to help you get the most out of Excel's features and functions

Learn Excel at the highest levels with this practical guide.

Book 45

Cover of Excel Programming

Excel Programming

by Denise Etheridge

Published 1 January 2010
A great guide to Excel programming that is perfect for visual learners and takes you beyond Excel basics! This book is the perfect reference for Excel users who want to delve deeper into the application to create powerful and dynamic programs. From creating macros to customizing dialog boxes, this step-by-step guide helps you get more out of Excel than you knew was possible. Each step has callouts so you can see exactly where the action takes place and this Web site offers tons of usable code and sample macros that you can put to use instantly.



Explains step-by-step how to automate Excel, the world's leading spreadsheet application from Microsoft
Covers most tasks in two-page spreads -- no flipping back and forth required!
Teaches you over 130 tasks, including how to record macros, program in Visual Basic for Applications (VBA), debug code, automate charts, interface with other macros, automate functions -- all in an easy-to-follow visual format
Uses clear, step-by-step, numbered instruction and lots of graphics and screenshots -- perfect for visual learners!
Helps you maximize your productivity with practical examples, tips, and advice

Harness everything that Excel has to offer with this friendly, practical, visual guide.

Book 57

Cover of Microsoft Office Excel 2007 Data Analysis
Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you'll discover step-by-step screen shots that demonstrate over 110 Excel data analysis techniques, including: Identifying trends in your data Sorting, filtering, and identifying lists Creating, editing, and checking formulas Calculating interest rates and depreciation Performing simple sorts and filters Hiding rows or columns in a PivotTable Adding and removing chart data Querying an Access database Assigning digital signatures Solving a formula with a data table "I was stuck on an Excel problem for two days. Finally, I opened one of your books, and there was a macro to accomplish exactly what I needed! You made me look good to the boss." -Rob L. Meerscheidt(The Woodlands, TX) High-resolution screen shots demonstrate each task Succinct explanations walk you through step by step Two-page lessons break big topics into bite-sized modules "Apply It" and "Extra" sidebars highlight useful tips