Author: P. K. Hari
Publisher: Holy Macro! Books
Keywords: excel, series, ceo, professionals
Number of Pages: 349
Published: 2006-10-01
List price: $24.95
ISBN-10: 1932802177
ISBN-13: 9781932802177

Presenting innovative Microsoft Excel techniques for top management professionals, this reference for company leaders who do not have the time to attend courses or read bulky books on the program provides basics, special shortcuts, and tips that cover the special features of Excel. Useful facts, trivia, and insider secrets about Excel are interspersed throughout the text, and readers have the choice of jumping directly to the section of real-life case studies to learn by the innovative Do & Learn (D&L) approach. This reference is fully updated to reflect Excel 12.

Authors:Bill Jelen, Dwayne K. Dowell,
Publisher: Holy Macro! Books
Keywords: excel, professionals, series, using, spreadsheets, auditors, audit
Number of Pages: 212
Published: 2006-10-01
List price: $24.95
ISBN-10: 1932802169
ISBN-13: 9781932802160

Providing the tools and techniques necessary for finding errors and fraud in audits, this guide for auditors looking to better validate their Microsoft Excel spreadsheets provides techniques for performing a risk assessment and gathering spreadsheet and other data from company systems. Performing audit data analysis using data and analytical management functions and pinpointing the common errors in spreadsheets with focused Excel tests is discussed, as are the best practices for error and fraud prevention when developing spreadsheets. This reference is fully updated to reflect Excel 12.

Author: Bill Jelen
Publisher: Holy Macro! Books
Keywords: microsoft, excel, using, analysis, data, guerilla
Number of Pages: 108
Published: 2002-09-30
List price: $19.95
ISBN-10: 0972425802
ISBN-13: 9780972425803

This book includes step-by-step examples and case studies that teach users the many power tricks for analyzing data in Excel. These are tips honed by Bill Jelen, “MrExcel,” during his 10-year run as a financial analyst charged with taking mainframe data and turning it into useful information quickly. Topics include perfectly sorting with one click every time, matching lists of data, data consolidation, data subtotals, pivot tables, and much more.

Author: Bill Jelen
Publisher: Holy Macro! Books
Keywords: excel, solved, mysteries, learn
Number of Pages: 836
Published: 2005-09-28
List price: $39.95
ISBN-10: 1932802126
ISBN-13: 9781932802122

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. In addition to exemplary solutions, each case analysis considers alternate approaches and gotchas, and includes a summary of the necessary commands and functions. Excel files that can be downloaded and worked through step-by-step are included for each case.

Author: Dr. Gerard Verschuuren
Publisher: Holy Macro! Books
Keywords: excel, series, professionals, engineers, scientists
Number of Pages: 258
Published: 2008-04-01
List price: $29.95
ISBN-10: 1932802355
ISBN-13: 9781932802351

With examples from the world of science and engineering, this reference teaches scientists how to create graphs, analyze statistics and regressions, and plot and organize scientific data. Physicists and engineers can learn the tips and techniques of Excel—and tailor them specifically to their experiments, designs, and research. They will learn when to use NORMDIST vs NORMSDist and CONFIDENCE vs Z, how to keep data-validation lists on a hidden worksheet, use pivot tables to chart frequency distribution, generate random samples with various characteristics, and much more. Ideal for student

Author: Bill Jelen
Publisher: Holy Macro! Books
Keywords: excel, things, new, amazing, easy, miracles, made, reveals
Number of Pages: 167
Published: 2007-02-21
List price: $24.95
ISBN-10: 1932802258
ISBN-13: 9781932802252

In this addendum to Learn Excel from Mr. Excel, the amazing new features offered in Excel 2007 are introduced. Revealing the features that make this new version the best new release of Excel since 1997, this guide provides the necessary information to teach users to quickly unleash the powerful new features in Excel 2007, create incredible-looking charts, customize color themes to match their corporate logo, utilize data-visualization tools, and learn Pivot Table improvements.

Author: Bill Hazlett
Publisher: Holy Macro! Books
Keywords: excel, series, professionals, classroom, math
Number of Pages: 234
Published: 2007-01-02
List price: $24.95
ISBN-10: 1932802150
ISBN-13: 9781932802153

This guide to enabling middle-grade mathematics teachers to use Microsoft Excel in the classroom focuses primarily on concepts taught in grades 4–10, with some pre-algebra lessons for higher grades. Including files available for downloading to create custom math worksheets, build self-grading interactive spreadsheets, and use Excel to demonstrate charts and Cartesian math, this handbook provides fun examples of probability, solving equations, magic squares, and compound interest.