eBook By Category (Microsoft Excel)

Pivot Tables are powerful data analysis tools, yet most Excel users don't use them to their fullest potential...

Microsoft Excel 2003 is an incredibly versatile and easy-to-use spreadsheet program that helps users calculate and analyze numerical data...

As one of the most widely used desktop applications ever created, Excel is familiar to just about everyone with a computer and a keyboard...

Because the analysis of copious amounts of data and the preparation of custom reports often take away time from true research, the automation of these processes is paramount to ensure productivity...

Excel Services is a new technology being delivered as part of Microsoft Office SharePoint Server 2007...

Beginning Excel What-If Data Analysis Tools explores the use of Goal Seek, Data Tables, Scenarios, and Solver to help you get insight on your data...

Beginning PivotTables in Excel 2007 explains what Pivot Tables are, how you can benefit from using them, how to create them and modify them, and how to use their enhanced features...

It is easy to create a bad looking chart in Excel...

Microsoft Excel is the world's most-popular spreadsheet program--used by schools, offices, and home users...

In today's increasingly competitive financial world, successful risk management, portfolio management, and financial structuring demand more than up-to-date financial know-how...

Crystal Xcelsius For Dummies...

• Covers Excel 2000 to 2003
• Explains how to access Web Services from Excel programs
• Shows you how to process lists and XML data with Excel 2003

Escape from Excel Hell...

A handy listing of entries that define important Excel 2002 terms and describe key functions, this book organizes its data alphabetically by task...

Whether you’re just discovering Excel or are already a power user, there’s no better instructor than "Mr...

Everything you need to know about

• Mastering operators, error values, naming techniques, and absolute versus relative references
• Debugging formulas and using the auditing tools
• Importing and exporting XML files and mapping the data to specific cells
• Using Excel 2003’s rights management feature
• Working magic with array formulas Developing custom formulas to produce the results you need

On the surface, it doesn't appear as if much in Excel 2003 has changed...

Excel 2003 VBA Programmer's Reference is an updated and expanded version of the two previous editions now with a reference section downloadable from the Web for easy perusal...

• Filling the void in the market for comprehensive coverage on all things Microsoft Excel 2007 report development-related, this book addresses the technical and strategic angles of developing reporting solutions using Microsoft Excel 2007
• Each chapter includes real-world examples of effective reports and demonstrates how this technology is used in various organizations
• Offers readers useful information on PivotTable and spreadsheet report features and capabilities, parameter queries, Web components, report automation, and data source access methods

Master the Ribbon, powerful graphics capabilities, and more!

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

Create colorful spreadsheets and charts, use Live Preview, and maximize everything Excel 2007 has to offer! Find just what you need to know about using the new Ribbon, designing spreadsheets that communicate, editing and printing them, working with formulas, protecting your data when you collaborate, turning out cool charts, and much more...

• This book is a single reference that’s indispensable for Excel beginners, intermediate users, power users, and would-be power users everywhere
• Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques readers won’t find anywhere else
• John Walkenbach, aka "Mr...

Excel 2007 Dashboards & Reports For Dummies fills the gap between handling data and synthesizing data into meaningful reports...

• Shows ordinary users how to tap the rich data analysis functionality of Excel, make sense of their organization's critical financial and statistical information, and put together compelling data presentations
• Now revised with over 30 percent new content to cover the enhancements in Excel 2007, including the completely redesigned user interface, augmented charting and PivotTable capabilities, improved security, and better data exchange through XML
• Provides thorough coverage of Excel features that are critical to data analysis-working with external databases, creating PivotTables and PivotCharts, using Excel statistical and financial functions, sharing data, harnessing the Solver, taking advantage of the Small Business Finance Manager, and more

• With more than 2...

Fast answers to frequently asked questions

Excel 2007 essentials at your fingertips!

If you like your answers quick and your information up-to-date, look no further...

Fast-paced and easy to use, this new book teaches you the basics of Excel 2007 so you can start using the program right away...

• Completely updated to reflect the many changes in the latest release of Excel, this helpful book presents readers with concise instructions for carrying out common Excel 2007 tasks
• An easy-to-navigate design features a two-column layout and is packed with step-by-step directions and illustrations that incorporate the notable changes to Excel 2007
• Readers can pick the task, find it fast, and get it done quickly, all while gaining a clear understanding of Excel 2007 enhancements, such as a new user interface, improved charting and PivotTable capabilities, and better data exchange with XML

Devoted entirely to PivotTables and PivotCharts, this book shows you how to take full advantage of these powerful tools, which enable you to pull meaningful information from masses of seemingly meaningless data...

Debra Dalgleish, Microsoft Office Excel MVP since 2001, and an expert and trainer in Excel, brings together a one-stop resource for anyone curious about representing, analyzing, and using their data with PivotTables and PivotCharts...

• This book is a single reference that’s indispensable for Excel beginners, intermediate users, power users, and would-be power users everywhere
• Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques readers won’t find anywhere else
• John Walkenbach, aka "Mr...

• Fully updated and expanded to cover Microsoft Office Excel 2007, this book is aimed at Excel users who want to gain more control over their spreadsheets using VBA or who want to develop Excel applications...

Step-by-step instructions for creating VBA macros

Harness the power of VBA and create custom Excel applications

Make Excel 2007 work for you! This clear, nonintimidating guide shows you how to use VBA to create Excel apps that look and work the way you want...

From formulas to functions to the latest features - practice and plan Excel tasks with ease

Confused by Excel? Want to make the most of its capabilities? No worries - this hands-on workbook gets you up to speed in a step-by-step manner...

Many experienced users may initially find Excel 2007 rather disorientating...

Microsoft Excel continues to grow in power, sophistication, and capability, but one thing that has changed very little since the early '90s is its user interface...

Whether you are an Excel neophyte, a sophisticate who knows the program inside out, or an intermediate-level plodder eager to hone your skills, Excel: The Missing Manual is sure to become your go-to resource for all things Excel...

Excel is the industry standard for financial modelling, providing a number of ways for users to extend the functionality of their own add-ins, including VB...

If you're a SQL programmer or an experienced Excel user, here at last is the ultimate resource on developing reporting solutions with Excel...

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...

* One of the world's best-known Excel experts shows how to master the charting features in Excel 2000 and 2002 to create compelling graphic representations of data
* Covers basic and advanced features, focusing on the new charting featuresprovided in version 2002
* Explains how to select charts for different categories of data, modify data in a chart, deal with missing data, format charts, customize shapes, and give charts a professional look

Learn to fully harness the power of Microsoft Excel® to perform scientific and engineering calculations

With this text as your guide, you can significantly enhance Microsoft Excel's® capabilities to execute the calculations needed to solve a variety of chemical, biochemical, physical, engineering, biological, and medicinal problems...

The dominant spreadsheet program and one of the most widely used software applications in the world, Microsoft Excel is unbelievably powerful--and can be downright intimidating...

Addressing a classroom teacher's need to simultaneous manage a classroom full of students, meet state mandated assessment standards for students, and track students' performance against a rubric, this overview of Excel shows how to put its features to use immediately in a classroom...

If you think that getting creative with Excel means the underhanded tweaking of numbers, think again...

Millions of users create and share Excel spreadsheets every day, but few go deeply enough to learn the techniques that will make their work much easier...

Excel Pivot Tables and Charts...

Excel Pivot Tables Recipe Book: A Problem-Solution Approach is for anyone who uses Excel frequently...

* Thirty clearly defined lessons take the reader from understanding the parts of an Excel application into building applications to work with data, formulas, charts, and the enhanced XML capabilities of the new Excel "X" * Book is designed to teach the core concepts of Excel over a weekend or in just fifteen hours, with each session being thirty minutes * Applicable to Excel 2000, Excel 2002, and the latest release, Excel "X" * Helps Excel power users in fields such as accounting, finance, operations management, and market research to begin automating data manipulation in Excel quickly, so they can handle real-world projects * A how-to guide to using Excel's programmability to create custom data-processing and analysis solutions * Covers security, debugging, and error handling * Companion Web site includes sample files, projects, and test enginewith self-assessment exam

Given the improved analytical capabilities of Excel, scientists and engineers everywhere are using it--instead of FORTRAN--to solve problems...

Covering formulas, charts, data lists, macros, and versions 2000, 2002, and 2003, this book offers more than seventy easy-to-follow techniques that show both new and experienced Excel users how to save time and avoid tedious or redundant tasks...

Make Excel work harder and faster for you...

Start using Excel spreadsheets, formulas, and charts - practice exercises make it easy See how to Set up, format, and edit basic spreadsheets Create a variety of formulas for finance, date and time, math, and more Calculate return on investments or loan amortization Master data analysis with pivot tables Turn spreadsheets into Web pages and master hyperlinks

Providing Excel users with a tutorial and help tool, this book offers simple answers and solutions for any problem or question...

FAME explores the use of Excel as THE calculating tool for finance professionals...

Financial Applications using Excel Add-in Development in C/C++ is a must-buy book for any serious Excel developer...

“If you’ve never quite grasped formulas and functions, Paul McFedries will radically expand your understanding and use of Excel...

This Excel user's guide to VSTO—the new Excel Macro programming language being promoted by Microsoft—shows how to perform the equivalent VBA actions with VSTO...

Here is the ideal resource for anyone who wants to get the most out of all the new and enhanced features Excel has to offer...

In a corporate setting, the Microsoft Office Suite is an invaluable set of applications...

Containing 277 business case studies that illustrate nearly every aspect of Excel, this book presents real-life business problems and works them through to their solutions...

Create Powerful Business Applications with Excel 2003 Excel 2003 is an ideal application development platform for all levels of business needs...

Teach yourself just what you need to know about developing with Excel Version 2002 Visual Basic for Applications...

MICROSOFT EXCEL Version 2002 INSIDE OUT is the foremost reference to Excel version 2002 for PC "super users"...

This book packs hundreds of time-saving solutions, troubleshooting tips, and workarounds for using Office Excel 2007...

Excel provides an easy-to-use, powerful spreadsheet environment that helps you handle calculations and data more effectively...

Experience learning made easy, and quickly teach yourself Microsoft Office Excel 2007 Visual Basic for Applications (VBA)--one step at a time! Work at your own pace through the easy numbered steps and practice files on CD, and master the fundamentals for using VBA to create custom software solutions and automating tasks in Excel 2007--no developer experience required! You'll learn how to automate spreadsheets, write your own functions and procedures, and customize menus and toolbars...

Master the techniques that business analysts at leading companies use to transform data into bottom-line results...

Excel 2002 Formulas covers every aspect of formulas, including some unusual uses -- such as chart series and conditional formatting specifications...

Ace the essentials for programming with Microsoft Visual Basic for Applications; working with the new XML capabilities in Excel 2003; getting the most out of new programmable smart tags; manipulating and customizing Excel objects; and integrating Excel capabilities with other Office programs...

• Offering step-by-step instruction, this invaluable book shows readers how to save time and enhance data analysis and reporting capabilities by combining the abilities of Excel and Access
• While both Excel and Access are powerful tools on their own, combining the functionality of these two applications opens up a whole new world of possibilities
• In addition to demonstrating a wide range of integration techniques, the book also provides practical, real-world scenarios that illustrate ways to avoid common pitfalls when moving and analyzing data across applications
• Shows readers how integration allows Access to get the benefit of Excel's flexible presentation layer and versatile analysis capabilities, while Excel gets the benefit of Access's relational database structure and robust querying tools

Equipped with a variety of functions and easy to use, Microsoft Excel is the tool of choice when it comes to crunching numbers, building charts, and analyzing tables...

VBA Programming for the Absolute Beginner is designed to help readers with no programming experience learn not only the basics of VBA, but also the fundamental programming concepts they need to grasp in order to learn their next programming language...

Written specifically with the beginner in mind, ?Microsoft Excel VBA for the Absolute Beginner, Second Edition? is the follow up to the most successful and best selling title in the Absolute Beginner series...

This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and handy workarounds for Excel 2003 in concise, fast-answer format...

This practical, hands-on tutorial expertly builds your skills with Microsoft Office Excel 2003 one step at a time! With STEP BY STEP, you work at your own pace through easy-to-follow lessons and practice exercises to learn exactly the tools and techniques you need...

Maximize Your Productivity with these Project Management Tools and Skills

Combine the power of Excel 2007, Microsoft Office SharePoint Server, and sound project management tools to bring added value to your skill set...

Get on the fast track to mastering Excel

Want to find success in your profession or business? Master the timesaving tools you'll need in the real world, like Excel 2007...

A practical guide to building fully operational financial cash flow models for structured finance transactions

Structured finance and securitization deals are becoming more commonplace on Wall Street...

A valuable reference for understanding operational risk

Operational Risk with Excel and VBA is a practical guide that only discusses statistical methods that have been shown to work in an operational risk management context...

Praise for Option Pricing Models & Volatility Using Excel-VBA

"Excel is already a great pedagogical tool for teaching option valuation and risk management...

-

This book consolidates all the best functionality of pivot tables into one guide that provides you with a meaningful tutorial, offering practical solutions to day-to-day problems...

Pro Excel 2007 VBA is the complete guide to creating Excel VBA applications, including covering all the new features in Excel 2007...

Finally, there's a book that treats Excel as the powerful development platform it really is, and covers every facet of developing commercial-quality Excel applications...

Professional Excel Services

With this unique resource, you'll discover how to unlock the power behind Excel Services in order to effectively utilize server-side spreadsheet calculation and rendering...

Why program Excel? For solving complex calculations and presenting results, Excel is amazingly complete with every imaginable feature already in place...

Microsoft Office Excel 2003 provides powerful new tools with which to create, analyze, and share spreadsheet information...

If data rules your life, odds are you're using (or you soon will be) Excel 2000, Microsoft's revised version of its premier spreadsheet application...

Does your life play out in a spreadsheet? Are numbers in columns and rows what make or break you in the work world?If you answered yes to either of these questions, then Special Edition Using Microsoft Office Excel 2003 is the book that will make it all better...

In just 24 lessons of one hour or less, you will be able to churn out worksheets, charts, drawings, and databases,with all the help you need...

# 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...