Brilliant Microsoft Excel 2007 Charts and Graphs (Brilliant Excel Solutions)

Computers & Technology

MICHAEL, ALEXANDER

Bill Jelen

Software

PRENTICE/HALL

Brilliant Microsoft Excel 2007 VBA and Macros (Brilliant Excel Solutions)

Brilliant Microsoft Excel 2007 Pivot Tables (Brilliant Excel Solutions)

VBA and Macros for Microsoft Excel

Tracy Syrstad

Pearson Technology Group

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.

Guerilla Data Analysis Using Microsoft Excel

Holy Macro! Books

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 section will  talk about creating business flowcharts with IGX Graphics and how to  display product pictures in Excel, and a section on VBA will cover  creating 100's of charts using the macro language.     “More  than a how-to and reference, this book also provides the why-tos and  when-tos, with serious consideration given to layout best practices and  design possibilities–a very well-rounded resource.”  –Kathy Villella, CEO, PowerFrameworks.com    Implementing 1-Click Charting    Incorporating Drag & Drop and Dynamic Charts    Creating Amazing Effects    Using Charting Templates and Macros    Mastering Glow, Shadow, Sparklines, Dashboards, and More   Eliminating Chart Junk    Structuring Spreadsheets with Business Diagrams, SmartArt Graphics, and Pivot Charts    Develop your Charting expertise instantly with proven techniques    After  15 years with no updates to the Excel charting engine, Microsoft has  provided a complete rewrite of the chart rendering engine in Excel  2007. However, no amount of soft glow or glass bevel effects will help  you communicate your point if you use the wrong chart type. This book  helps you choose the right charting type and shows you how to make it  look great.   This  book shows you how to coax Excel to create many charts you might not  have believed were possible. You’ll learn techniques that allow you to  ditch the Microsoft defaults and actually create charts that  communicate your point. You’ll learn why the Excel stock charts are so  restrictive and how you can easily turn any line chart into a stock  chart–without any limitations. You’ll also learn how to add invisible  series to make columns float in midair. Learn how to create charts  right in Excel cells using the new Excel 2007 data bars–or even the  decades-old REPT function!   In no time, this book will have you creating charts that wow your audience and effectively communicate your message.   Master effective visual display of data   Choose the right chart type to convey your message   Learn time-saving workarounds   Create charts that most people think you can’t create with Excel   Understand what a Radar chart is and when you might use it   Summarize a million rows of data in a single pivot table chart   Present data graphically without charts   Employ SmartArt graphics to show process or relationship charts   Utilize VBA to create charts   Put your data on a map   Export your charts to the web or PowerPoint   Detect chart lies    ABOUT THE AUTHOR   Bill Jelen is  MrExcel! He is principal behind the leading Excel website, MrExcel.com.  He honed his Excel wizardry during his 12-year tenure as a financial  analyst for a fastgrowing public computer firm. Armed with only a  spreadsheet, he learned how to turn thousands of rows of transactional  data into meaningful summaries in record time. He is an accomplished  author of books on Excel and is a regular guest on The Lab on  TechTV Canada. You can find Bill at your local accounting group chapter  meeting entertaining audiences with his humorous and informative Power  Excel seminar. His website hosts more than 12 million page views  annually.          Introduction   1 Introducing Charts in Excel 2007   2 Customizing Charts   3 Creating Charts That Show Trends   4 Creating Charts That Show Differences   5 Creating Charts That Show Relationships   6 Creating Stock Analysis Charts   7 Advanced Chart Techniques   8 Creating and Using Pivot Charts   9 Presenting Data Visually Without Charts   10 Presenting Your Excel Data on a Map Using Microsoft MapPoint   11 Using SmartArt Graphics and Shapes   12 Exporting Your Charts for Use Outside of Excel   13 Using Excel VBA to Create Charts 14 Knowing When Someone Is Lying to You with a Chart   Appendix A: Charting References   Index

Charts and Graphs for Microsoft Office Excel 2007

Guerrilla Data Analysis Using Microsoft Excel: Overcoming Crap Data and Excel Skirmishes

Oz du Soleil

Mrexcel XL: The 40 Greatest Excel Tips of All Time

Szilvia Juhasz

MrExcel LX The Holy Grail of Excel Tips: Covers Excel Backwards and Forwards

Mrexcel 2024

MrExcel's Holy Macro! Books

Packt Publishing Ltd.

See the best price to sell, buy, or rent books by Bill Jelen. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Books by Bill Jelen