General Books - Page 12

Microsoft Excel 2002 Visual Basic for Applications Step by Step (Step by Step (Microsoft))

Reed Jacobson

List Price: $39.99 By: Microsoft Press Amazon Marketplace: 10 new & used starting at $5.24

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Microsoft -> Applications -> Excel
Subjects -> Computers & Internet -> Microsoft -> Development -> VBA
Subjects -> Computers & Internet -> Microsoft -> Development -> Visual Basic -> General AAS

Customer Reviews:
Total reviews: 12 Average rating: 4.0 of 5

There is no better book to teach and learn VBA for Excel 5 out of 5 stars.
5 of 6 people found this review helpful.

Although this book is indeed introductory and would not qualify as a reference manual it is the best resource that I have found to teach VBA object programming to my students. The examples are great and with the exception of Chapter 6 on Pivot Tables, maybe too difficult for a beginner, I agree with the good reviews of this book.

Editorial Review:

Teach yourself just what you need to know about developing with Excel Version 2002 Visual Basic for Applications. This title, aimed at beginner developers, is a teach-yourself guide to creating custom software solutions, automating tasks, and taking creative control of Excel Version 2002 by exploiting its built-in programming language, Microsoft Visual Basic for Applications (VBA). You'll learn to automate spreadsheets, write your own functions and procedures, customize menus and toolbars, and more. The popular Step-by-Step method lets you choose your best starting point, and the easy-to-follow lessons include clear objectives and real-world business examples so you can learn exactly what you need to know, at your own speed. Prepared by an author with extensive knowledge of VBA and Excel, this book includes numerous screen shots that illustrate specific step-by-step programming procedures, plus a companion CD-ROM full of practice files that are tightly integrated with the lessons.

Excel Gurus Gone Wild: Do the IMPOSSIBLE with Microsoft Excel

Bill Jelen

Amazon Price: $16.47 List Price: $24.95 Not yet published By: Holy Macro! Books

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Microsoft -> Applications -> Excel
Subjects -> Computers & Internet -> Software -> Spreadsheets -> General
Subjects -> Computers & Internet -> Software -> Spreadsheets -> General AAS

Editorial Review:

Drawn from actual excel conundrums posted on the author's website, www.mrexcel.com, 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.

Microsoft Office Excel 2007: Top 100 Simplified Tips & Tricks (Top 100 Simplified Tips & Tricks)

Denise Etheridge

Amazon Price: $13.59 List Price: $19.99 Usually ships in 24 hours By: Visual Amazon Marketplace: 48 new & used starting at $3.62

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Microsoft -> Applications -> Excel
Subjects -> Computers & Internet -> Software -> Spreadsheets -> General
Subjects -> Computers & Internet -> Software -> Spreadsheets -> General AAS

Customer Reviews:
Total reviews: 2 Average rating: 3.0 of 5

Editorial Review:

You already know Excel 2007. Now you'd like to go beyond with shortcuts, tricks, and tips that let you work smarter and faster. And because you learn more easily when someone shows you how, this is the book for you. Inside, you'll find clear, illustrated instructions for 100 tasks that reveal cool secrets, teach timesaving tricks, and explain great tips guaranteedto make you more productive with Excel 2007.

* Minimal text and maximum illustrations
*

Task-oriented, step-by-step approach
*

Navigational aids connect instructions to illustrations
*

Self-contained, two-page lessons
*

Uniform layout makes it easy to read less, learn more

How easy is it?


Look for these symbols marking the difficulty of each task.

* Demonstrates a new spin on a common task
*

Introduces a new skill or a new task
*

Combines multiple skills requiring in-depth knowledge
*

Requires extensive skill and may involve other technologies

EXCEL 2007 MACROS MADE EASY (Made Easy Series)

Gail Perry

Amazon Price: $14.95 List Price: $21.99 Usually ships in 24 hours By: McGraw-Hill Osborne Media Amazon Marketplace: 26 new & used starting at $13.15

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Computer Science -> Software Engineering -> General AAS
Subjects -> Computers & Internet -> Programming -> Software Design, Testing & Engineering -> Software Development
Subjects -> Computers & Internet -> Software -> Spreadsheets -> General

Editorial Review:

Get beyond the basics with Excel 2007 macros

Now you can take your Excel skills to the next level with help from this hands-on guide. Excel 2007 Macros Made Easy shows you how to create, run, and revise macros to simplify repetitive tasks and store the instructions for complicated ones. YouAnd#39;ll learn to use Visual Basic for Applications (VBA), add macros to the Excel toolbar, and share your macros with other users. Discover how easy it is to develop custom macros, save time, and boost productivity.

• Record and edit macros
• Create and debug macros in VBA
• Save macros to the Personal Macro Workbook or other workbooks
• Create VBA subroutines and functions
• Develop interactive macros
• Format cells using macros
• Create variables and arrays
• Apply logic to macros with If/Then/Else routines
• Use loops to process data
• Add controls to your worksheets

Andnbsp;

Microsoft Office Excel 2007 QuickSteps (Quicksteps)

John Cronan

Amazon Price: $14.99 List Price: $19.99 Usually ships in 24 hours By: McGraw-Hill Osborne Media Amazon Marketplace: 51 new & used starting at $5.85

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Microsoft -> Applications -> Excel
Subjects -> Computers & Internet -> Software -> Spreadsheets -> General
Subjects -> Computers & Internet -> Software -> Spreadsheets -> General AAS

Customer Reviews:
Total reviews: 1 Average rating: 4.0 of 5

Editorial Review:

Step-by-Step, Full-Color Graphics!

Get started using Microsoft Office Excel 2007 right away--the QuickSteps way. Color screenshots and clear instructions show you how to use all the new and improved features available in this premier spreadsheet program. Follow along and learn to work with the new Office interface and ribbon, create workbooks, use Excel's XML file formats, enter and edit data, use formulas and functions, create charts and tables, analyze data, and more. Plus, it's easy to flip straight to the information you need using the color-coded tabs. Get the book that gets you started using Excel 2007 in no time.

In each chapter:

• Shortcuts for accomplishing common tasks
• Need-to-know facts in concise narrative
• Helpful reminders or alternate ways of doing things
• Bonus information related to the topic being covered
• Errors and pitfalls to avoid

Microsoft Office Excel 2007: Introductory Concepts and Techniques (Shelly Cashman Series)

Gary B. Shelly, Thomas J. Cashman, Jeffrey J. Quasney

Amazon Price: $40.45 List Price: $44.95 Usually ships in 24 hours By: Course Technology Amazon Marketplace: 33 new & used starting at $19.43

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Microsoft -> Applications -> Excel
Subjects -> Computers & Internet -> Software -> Spreadsheets -> General
Subjects -> Computers & Internet -> Software -> Spreadsheets -> General AAS

Customer Reviews:
Total reviews: 1 Average rating: 5.0 of 5

Great Purchase 5 out of 5 stars.
0 of 1 people found this review helpful.

This book was delivered promptly and in very good condition, exactly as listed under the book condition on the web site!

Editorial Review:

In Microsoft Excel 2007: Introductory Concepts and Techniques you’ll find features that are specifically designed to improve retention, and prepare readers for future success. Our trademark step-by-step, screen-by-screen approach now encourages readers to expand their understanding of the Excel 2007 software through experimentation, exploration, and planning ahead.

Sequential Monte Carlo Methods in Practice (Statistics for Engineering and Information Science)

Amazon Price: $71.96 List Price: $99.00 Usually ships in 24 hours By: Springer Amazon Marketplace: 30 new & used starting at $63.00

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Software -> Spreadsheets -> General
Subjects -> Computers & Internet -> Software -> Spreadsheets -> General AAS
Subjects -> Professional & Technical -> Professional Science -> Mathematics -> Applied -> Statistics

Editorial Review:

Monte Carlo methods are revolutionizing the on-line analysis of data in fields as diverse as financial modeling, target tracking and computer vision. These methods, appearing under the names of bootstrap filters, condensation, optimal Monte Carlo filters, particle filters and survival of the fittest, have made it possible to solve numerically many complex, non-standard problems that were previously intractable.

This book presents the first comprehensive treatment of these techniques, including convergence results and applications to tracking, guidance, automated target recognition, aircraft navigation, robot navigation, econometrics, financial modeling, neural networks, optimal control, optimal filtering, communications, reinforcement learning, signal enhancement, model averaging and selection, computer vision, semiconductor design, population biology, dynamic Bayesian networks, and time series analysis. This will be of great value to students, researchers and practitioners, who have some basic knowledge of probability.

Arnaud Doucet received the Ph. D. degree from the University of Paris-XI Orsay in 1997. From 1998 to 2000, he conducted research at the Signal Processing Group of Cambridge University, UK. He is currently an assistant professor at the Department of Electrical Engineering of Melbourne University, Australia. His research interests include Bayesian statistics, dynamic models and Monte Carlo methods.

Nando de Freitas obtained a Ph.D. degree in information engineering from Cambridge University in 1999. He is presently a research associate with the artificial intelligence group of the University of California at Berkeley. His main research interests are in Bayesian statistics and the application of on-line and batch Monte Carlo methods to machine learning.

Neil Gordon obtained a Ph.D. in Statistics from Imperial College, University of London in 1993. He is with the Pattern and Information Processing group at the Defence Evaluation and Research Agency in the United Kingdom. His research interests are in time series, statistical data analysis, and pattern recognition with a particular emphasis on target tracking and missile guidance.

Power Excel 2007 with MrExcel (Video Training) (LiveLessons)

Bill Jelen

Amazon Price: $26.39 List Price: $39.99 Usually ships in 24 hours By: Que Amazon Marketplace: 44 new & used starting at $22.74

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Microsoft -> Applications -> Excel
Subjects -> Computers & Internet -> Software -> Spreadsheets -> General
Subjects -> Computers & Internet -> Software -> Spreadsheets -> General AAS

Editorial Review:

Power Excel 2007 with MrExcel

Mastering the Smartest, Fastest Ways to Use Excel 2007

Bill Jelen

For anyone who wants to get more done in less time with Excel 2007—from entrepreneurs to financial analysts, marketers to office managers!

Bill Jelen (“MrExcel”) presents focused, practical videos that teach you Excel 2007’s best new techniques: supercharged solutions for charting, calculating, formatting, data analysis, automation, and a whole lot more! Click play to follow along as Jelen walks you through using Excel 2007’s most sophisticated features… all you need to do is watch!

You’ve got Microsoft Excel…now get the most out of it, faster and more easily than ever before! In more than 90 quick video lessons, Bill Jelen (“MrExcel”) shows you all you need to maximize your productivity with Excel 2007.

Building on the live course he’s taught to thousands of financial professionals, Jelen walks you through Excel’s most powerful features and techniques. Just watch: You’ll master Excel 2007’s new Ribbon interface and most powerful techniques at your own pace—and get specific answers and solutions immediately, whenever you need them!

These practical, easy-to-use videos cover Excel 2007’s hottest new features: everything from charting improvements to conditional formatting, filtering to SmartArt. You’ll find up-to-the-minute tips and tricks for using PivotTables, managing and automating worksheets, and a whole lot more—great new solutions that could save you hours every single week!

Looking for a better way to master today’s rapidly changing technologies? Want expert help but don’t have the time or energy to read a book? Can’t find classroom training worth the money? Discover LiveLessons: self-paced, personal video instruction from the world’s leading experts.

• LiveLessons is an eight-hour video course organized into bite-sized, self-contained sessions—you’ll learn key skills in as little as five minutes!
• Each session begins with well-defined learning objectives and ends with comprehensive summaries, which help you track your progress.
• Follow along as your instructor shows exactly how to get great results in your real-world environment.

Bill Jelen is known worldwide as MrExcel. He presents live Excel seminars to accountants throughout the U.S. and has logged more than 60 appearances on

The Lab with Leo Laporte. Honored as a Microsoft MVP for Excel, he has produced 500 episodes of his “Learn Excel from MrExcel” video podcast. He writes the monthly Excel column for Strategic Finance magazine.

Microsoft Office Spreadsheets/Desktop Applications

Contents:

Part 1 Excel 2007 Interface

Lesson 1 Introducing the Ribbon

Lesson 2 Quick Access Toolbar

Lesson 3 Finding Icons

Lesson 4 Keyboard Shortcuts

Lesson 5 Mini Toolbar and Live Preview

Lesson 6 Zoom Slider and Page Layout

Lesson 7 Recent Documents

Lesson 8 Save as PDF

Lesson 9 Excel Options

Lesson 10 Opening Templates, Closing Excel

Part 2 Excel 2007 New Features

Lesson 11 Unlocking the Big Grid, File Formats

Lesson 12 Cell Styles and Themes

Lesson 13 Data Visualizations

Lesson 14 Tables and Table Formulas

Lesson 15 Sort and Filter by Color

Lesson 16 Duplicates

Lesson 17 Picture Tools and WordArt

Lesson 18 New Features

Part 3 Text

Lesson 19 Drag the Fill Handle to Extend a Series

Lesson 20 Create Your Own Series

Lesson 21 Joining Text

Lesson 22 Rapid Formula Copy

Lesson 23 Convert to Proper Case

Lesson 24 Joining Dates

Lesson 25 Converting Formulas to Values

Lesson 26 Breaking Apart Text

Lesson 27 Parsing Fixed Width

Part 4 Excel Customizations

Lesson 28 Data Entry Tricks

Lesson 29 Customize All Future Workbooks

Lesson 30 Copy Worksheets

Lesson 31 Change All Worksheets

Lesson 32 Arranging Windows

Part 5 Sorting and Subtotals

Lesson 33 Data Preparation

Lesson 34 Sorting Basics

Lesson 35 Random Sort

Lesson 36 Sorting by Weekday

Lesson 37 Rearranging Columns

Lesson 38 Subtotals

Lesson 39 Collapsing Subtotals

Lesson 40 Copy Subtotals

Lesson 41 Formatting Subtotals

Lesson 42 Multiple Subtotals

Lesson 43 Filling In Data on Subtotal Rows

Lesson 44 Subtotal Tricks

Part 6 Pivot Tables

Lesson 45 Creating a Pivot Table

Lesson 46 Changing a Pivot Table

Lesson 47 Pivot Gotchas

Lesson 48 Pivot Sorting

Lesson 49 Drill Down

Lesson 50 Summarizing Dates

Lesson 51 Top 10 Report

Lesson 52 Pivot Calculations

Lesson 53 Pivot Formatting

Lesson 54 Unique List

Lesson 55 Ad-Hoc Queries

Lesson 56 New Filtering Options

Lesson 57 50 Reports in 5 Seconds

Lesson 58 Pivot Compatibility

Lesson 59 Making Reports Pivotable

Part 7 Charting and SmartArt

Lesson 60 Creating and Formatting a Chart

Lesson 61 Adding or Removing Chart Data

Lesson 62 Interactive Chart

Lesson 63 Charting Differing Orders of Magnitude

Lesson 64 Pie Chart Tricks, Histograms

Lesson 65 XY and Bubble Charts

Lesson 66 Saving Favorite Chart Settings

Lesson 67 Creating Smart Art

Lesson 68 Formulas in Smart Art

Part 8 Formulas

Lesson 69 AutoSum Tricks

Lesson 70 Formula Auditing

Lesson 71 Three Ways of Entering Formulas

Lesson 72 Relative Versus Absolute Formulas

Lesson 73 Discovering Functions

Lesson 74 Goal Seek

Lesson 75 Unusual Functions

Lesson 76 IF Formulas

Lesson 77 VLOOKUP

Lesson 78 IFERROR

Lesson 79 SUMIFS

Lesson 80 Super Formulas

Lesson 81 Date and Time

Part 9 Macros

Lesson 82 Recording a Macro

Lesson 83 Recording Navigation

Lesson 84 How Many Rows?

Lesson 85 Event Macros

Part 10 Tips and Tricks

Lesson 86 Finding Records

Lesson 87 Web Queries

Lesson 88 Copying Column Widths

Lesson 89 Page Numbering

Lesson 90 Turn Data

Lesson 91 & in Header

Lesson 92 Choose from a List

Lesson 93 Tool Tips for a Cell

Lesson 94 Word Processing in Excel

Lesson 95 Have a Talk with Excel

Excel as Your Database

Paul Cornell

Amazon Price: $28.62 List Price: $34.99 Usually ships in 24 hours By: Apress Amazon Marketplace: 63 new & used starting at $0.10

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Microsoft -> Applications -> Excel
Subjects -> Computers & Internet -> Programming -> Software Design, Testing & Engineering -> Software Development
Subjects -> Computers & Internet -> Software -> Spreadsheets -> General

Editorial Review:

Excel As Your Database guides those of you who need to manage facts and figuresyet have little experience, budget, or need for a full-scale relational database management system. Youll learn how to use Excel to enter, store, and analyze your data.

This book is written and organized in a way that assumes you have some familiarity with Excel, but not with databases. The book features quick-start solutions, practice exercises, troubleshooting tips, and best practices.

• This book covers Excel 2007 and 2003.
• The author clarifies not just how to use a technique, but under what realistic scenarios.
• The text features step-by-step, how-to procedures.
• Try-it-out exercises are based on realistic sample data.

Pro Excel 2007 VBA (Expert's Voice in Excel VBA)

Jim DeMarco

Amazon Price: $31.38 List Price: $42.99 Usually ships in 24 hours By: Apress Amazon Marketplace: 46 new & used starting at $21.37

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Microsoft -> Applications -> Excel
Subjects -> Computers & Internet -> Microsoft -> Development -> VBA
Subjects -> Computers & Internet -> Microsoft -> Development -> Visual Basic -> General AAS

Customer Reviews:
Total reviews: 1 Average rating: 5.0 of 5

Editorial Review:

Pro Excel 2007 VBA is the complete guide to creating Excel VBA applications, including covering all the new features in Excel 2007. Covering object–oriented programming techniques, debugging, and error handling methodologies, this book quickly turns novice into expert as it explores COM and .NET components and the advantages of compiled code. The book also covers XML for Excel web development.

This book is unique insomuch that author Jim DeMarco is a true expert in the field of Excel programming, and he conveys the VBA story in the context of the real world. Not just another dry programming guide, Pro Excel 2007 VBA is a journey from novice to expert where the author is your traveling companion. Bon voyage.

What you’ll learn

• Create automated forms for data collection.
• Mmanipulate lists and create data views.
• Manipulate web–based data.
• Integrate with other Office applications.
• Master Excel’s XML tools.
• Understand and build security into your applications.

Who is this book for?

This book targets anyone interested in VBA development, .NET developers, and Excel power users who need to make best use of the new features contained within Excel 2007.

About the Apress Pro Series

The Apress Pro series books are practical, professional tutorials to keep you on and moving up the professional ladder.

You have gotten the job, now you need to hone your skills in these tough competitive times. The Apress Pro series expands your skills and expertise in exactly the areas you need. Master the content of a Pro book, and you will always be able to get the job done in a professional development project. Written by experts in their field, Pro series books from Apress give you the hard–won solutions to problems you will face in your professional programming career.