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: excel, solved, mysteries, learn
Number of Pages: 926
Published: 2007-10-27
List price: $39.95
ISBN-10: 1932802274
ISBN-13: 9781932802276
Updating the previous edition’s tips to make them compatible with Excel 2007, and featuring new tips that are only available in Excel 2007, 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, followed by a broad strategy for solving the problem. Mr. Excel then walks readers through through the specific steps to solve the issue. Alternate strategies are also provided, along with common "gotchas" that trip users up, leaving readers with not only answers to thei
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: Bernd Held
Publisher: Wordware Publishing, Inc.
Keywords: excel, applications, library, wordware, formulas, functions, microsoft
Number of Pages: 397
Published: 2006-09-05
List price: $29.95
ISBN-10: 159822011X
ISBN-13: 9781598220117
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. But most users only scratch the surface of the program’s functionality, especially the built-in formulas designed to make everyday operations and real-world tasks more efficient. Microsoft Excel Functions & Formulas demonstrates the secrets of Excel functions through the use of practical and useful examples in a quick reference format. Topics include logical, text, date and time, basic statistical, mathematical, financial,
Author: Mike Girvin
Publisher: Holy Macro! Books
Keywords: excel, frustrations, making, fun, conquering, guide, dragons, beginners, slaying
Number of Pages: 532
Published: 2011-02-21
List price: $29.95
ISBN-10: 161547000X
ISBN-13: 9781615470006
This enthusiastic introduction provides support for Excel beginners and focuses on using the program immediately for maximum efficiency. With 1,104 screenshots and explicit information on everything from rows, columns, and cells to subtotaling, sorting, and pivot tables, this guide aims to alleviate the frustrations that come with using the program for the first time. This manual offers strategies for avoiding problems and streamlining efficiency and assists readers from start to finish, turning Excel 2010 novices into experts.
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: 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.
