Author: Bill Jelen
Publisher: Que
Keywords: business, solutions, excel, office, graphs, microsoft, charts
Number of Pages: 480
Published: 2007-05-04
List price: $39.99
ISBN-10: 0789736101
ISBN-13: 9780789736109

It is easy to create a bad looking chart in Excel. This book teaches you how to unlock the beautiful formatting options available to make incredible looking charts. The first section will talk about how to decide which chart type to use. Subsequent chapters will walk through each chart type, how to create them, how to utilize them, and special options available for each chart. The book discusses themes, colors, creating metallic charts, shadows, transparency, etc. The book also handles anything graphical in Excel. It will show the new In-Cell Data Bar charts available in Excel 2007. A

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: 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 Jelen
Publisher: Holy Macro! Books
Keywords: invention, changed, world, evolved, examples, amazing, excel, spreadsheet
Number of Pages: 128
Published: 2005-04-01
List price: $19.95
ISBN-10: 1932802045
ISBN-13: 9781932802047

From the 1979 invention by two MIT students of the visible calculator to the war between Lotus and Microsoft for dominance in the spreadsheet market, this book is a fascinating look at the software application that helped spur the entire computer industry. This loving look back at the early computer and technology evolution will teach anyone interested in computer history about the MIT students, Bricklin and Frankston, and their unique vision; how Mitch Kapor and Lotus 1-2-3 trumped VisiCalc; how the spreadsheet gave businesses a reason to buy PCs; and how Microsoft came to dominate the market

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: Que
Keywords: mrexcel, library, excel, microsoft, graphs, charts
Number of Pages: 496
Published: 2010-10-09
List price: $39.99
ISBN-10: 0789743124
ISBN-13: 9780789743121

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 unprecedented visual features. Bill Jelen ("MrExcel") explains exactly when and how to use each type of Excel chart, then walks through creating superb visuals and customizing them with themes, colors, and effects. Jelen shows how to craft charts that illuminate trends, differences, and