There are an estimated 400 million Excel users, very few of whom know how to use Excel VBA effectively. This book is designed to get Excel users up and running with Excel VBA. Users will quickly learn how to automate reports and design applications.[...]

Furnishing a variety of practical, real-world scenarios to demonstrate the applications of Pivot Tables, a comprehensive review of their function in Excel 2007 offers a series of proven, innovative Pivot Table recipes that can be applied to a variety of business situations and includes helpful tips [...]

Provides information on ways to automate reports and design applications in Excel VBA.

Get comfortable with the latest versions of Microsoft Excel, Microsoft Excel Starter, and the Excel Web App. Don't just read about it: see it, hear it, with step-by-step video tutorials and valuable audio sidebars delivered through the Free Web Edition that comes with every USING book. For the pric[...]

Using Excel 2010, it's possible to create breathtaking charts, graphs, and other data visualizations - and communicate even the most complex data more effectively than ever before. In Charts and Graphs, one of the world's leading Excel experts show exactly how to make the most of Excel 2010's unprec[...]

AUTOMATE REPORTS BUILD FUNCTIONS VISUALIZE DATA WRITE FAST, RELIABLE SCRIPTS Microsoft Excel 2010 VBA AND MACROS: SAVE TIME AND SUPERCHARGE EXCEL 2010 WITH VBA AND MACROS! Use Excel 2010 VBA and macros to automate virtually any routine task, and save yourself hours, days, maybe even weeks. Then lear[...]

PivotTables may be Excels most powerful feature, but Microsoft has estimated that only 15% of Excel users take advantage of them. Thats 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 [...]

Use Excel 2013's radically revamped charting and graphing tools to communicate more clearly, powerfully, and quickly...so you drive your message home, and get the decisions and actions you're looking for! This book reveals data visualization techniques you won't find anywhere else and shows you how [...]

Designed with Excel gurus in mind, this handbook outlines how to create formulas that can be used to solve everyday problems with a series of data values that standard Excel formulas cannot or would be too arduous to attempt. Beginning with an introduction to array formulas, this manual examines top[...]

The most powerful Microsoft Excel features that can be used to sort through data to produce meaningful marketing analyses are outlined in this manual. Marketing managers will learn the math functions to produce budgets and forecasts, and how to use survey analysis to quickly spot trends using pivot [...]

Updating the previous edition's tips to make them compatible with Excel 2010, and featuring tips that are only available in Excel 2010, this new edition of Mr Excel's popular software guide even incorporates suggestions sent in by readers. Each featured topic has a problem statement and description,[...]