Holy Macro Books: 57 books

Covering a variety of Excel simulations, from gambling to genetics, this introduction is for people interested in modeling future events, without the cost of an expensive textbook. The simulations covered offer a fun alternative to the usual Excel topics and include situations such as roulette, password cracking, sex determination, population growth, and traffic patterns, among many others.

With examples from the world of science, this reference teaches scientists how to create graphs, analyze statistics and regressions, and plot and organize scientific data. Scientists can learn the tips and techniques of Excel—and tailor them specifically to their experiments, designs, and research....

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...

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,...

The 54 essential tips that all Excel users need to know. MrExcel LIVe provides users with a concise book that can be absorbed in under an hour. Includes a section with keyboard shortcuts. Anyone who uses Excel will be able to turn to any page and pick up tips that will save them hours of work.

This book completely and thoroughly covers every trick known about Subtotals in Excel. You will learn: How to get your data ready for subtotals, Adding Subtotals, Showing only the Subtotals, Sorting Subtotals, Formatting Subtotals, Subtotal Tricks, Subtotal Troubleshooting, Using the SUBTOTAL function...

Microsoft's revolutionary Power BI is a tool that allows users to create and transform data into reports and dashboards in new and much more powerful ways.This book, written by a member of Microsoft's Power BI team, provides a practical step by step guide on creating a financial dashboard. The book...

A textbook and study guide for new and intermediate Microsoft Access users, this book takes Access developers through the development process step by step. Terms and concepts are explained as they arise and relevant examples are provided to keep users on track and to teach them how to the use the...

This guide assists all levels of Microsoft Outlook users in furthering their understanding of the program's features, from communicating with an ever-growing list of contacts to upgrading installations. A full range of functions are discussed, such as adding an appointment to a calendar, sending a...

Author Oz Du Soleil's area of frustration with Excel is cleaning data. From his earliest days with Excel, he has found himself constantly needing to fix names that are ALLCAPS, peel addresses away from phone numbers, and fixing all the many other things that prevent data from being useful. In this...

After being kidnapped, Sara has undergone torture and sadistic abuse for almost a year and is now a terror-filled shell. Will her courage be sufficient to see her through? Once Sara re-emerges, several mysteries remain. Who kidnapped her? Why are strange things happening at the hospital? Where is...

College teaching assistant Ruth Tyack is excitedly planning for a new job in Rome when she falls in love with Tom, a poet and guest-lecturer at the college. Despite their intense feelings for each other, Ruth and Tom must part after a single romantic together. Tom is married and has too much respect...

A recognized expert in teaching Microsoft PowerPoint skills demonstrates how to design presentations to meet the needs of every audience. The peskiest PowerPoint problems are investigated—saving to removable media, how to back save, fast saves and other presentation corruptors, the AutoFormat feature,...

This Straight to the Point guide provides an introduction to data cleansing, which also goes by names such as data munging and data wrangling. Whatever the name, it basically means doing what needs to be done to make data useful and trustworthy. Data cleansing can include the following tasks:Deleting...