Holy Macro Books imprint: 57 books

by Dr. Gerard Verschuuren
Language: English
Release Date: August 1, 2005

For scientists and engineers tired of trying to learn Excel with examples from accounting, this self-paced tutorial is loaded with informative samples from the world of science and engineering. Techniques covered include creating a multifactorial or polynomial trendline, generating random samples...

Office VBA Macros You Can Use Today

Over 100 Amazing Ways to Automate Word, Excel, PowerPoint, Outlook, and Access

by Juan Pablo González, Cindy Meister, Suat Ozgur
Language: English
Release Date: January 1, 2006

For any Microsoft Office user familiar with Word, Excel, PowerPoint, Access, or Outlook, this book provides tutorials on the tools and tricks that automate these programs for increased productivity. Each lesson includes instructions and a downloadable file on which to test the VBA macros and procedures...
by Dr. Gerard Verschuuren
Language: English
Release Date: May 1, 2008

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

Excel Tables

A Complete Guide for Creating, Using and Automating Lists and Tables

by Zack Barresse, Kevin Jones
Language: English
Release Date: August 1, 2014

Creating tables in Excel allows for easier formatting and reporting, but the new syntax that it implies can be intimidating to the uninitiated. In this guide, one of the developers of the official Microsoft Excel 2013 templates—all of which employ tables—helps introduce readers to the multiple...

Learn to Write DAX

A practical guide to learning Power Pivot for Excel and Power BI

by Matt Allington
Language: English
Release Date: December 1, 2015

Active learning lessons for mastering DAX Data analysis expressions (DAX) is the formula language of PowerPivot and this book is written to give hands-on practice to anyone who wants to become competent at writing such formulas. Sample exercises that explain each concept are provided and followed by practice questions and answers to maximize learning and experience with DAX.
by Oz du Soleil, Bill Jelen
Language: English
Release Date: April 1, 2015

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,” and Oz do Soleil during their careers run as a financial analyst charged with taking mainframe data and turning it into useful...

MrExcel XL

The 40 Greatest Excel Tips of All Time

by Bill Jelen, Szilvia Juhasz
Language: English
Release Date: September 1, 2015

The 40 essential tips that all Excel users need to know. Crowdsourced by more than 300 contributors who collaborated on choosing the 40 best Excel tips, MrExcel XL provides users with a concise book that can be absorbed in under an hour. Includes a bonus 30 tips, keyboard shortcuts, Excel jokes, Excel...

Power Excel 2016 with MrExcel

Master Pivot Tables, Subtotals, Charts, VLOOKUP, IF, Data Analysis in Excel 2010–2013

by Bill Jelen
Language: English
Release Date: October 1, 2016

Updating the previous edition's tips to include features in Excel 2016, this new edition of MrExcel'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. MrExcel...
by Chris Smitty Smith
Language: English
Release Date: December 1, 2012

Microsoft Excel is one of the most powerful tools a business owner, manager, or new employee has at their disposal, and this guide teaches how to harness business data and put it to use. Using real-world examples of a small business in operation, the book covers topics such as preparing financial...

VLOOKUP Awesome Quick

From Your First VLOOKUP to Becoming a VLOOKUP Guru

by Bill Jelen
Language: English
Release Date: February 1, 2012

VLOOKUP is a function in Excel that enables people to use Excel like a database, joining data on different worksheets. VLOOKUP Awesome Quick is an ehnanced eBook designed to get the reader up to speed with the VLOOKUP function in Excel. The book starts with the basics of "Explain a VLOOKUP in...
by Kathy Jacobs, Bill Jelen
Language: English
Release Date: May 1, 2008

Covering the use of Microsoft OneNote in a wide variety of situations, this handbook provides tips for anyone who takes notes, organizes materials, or keeps a to-do list. In addition to providing the basic information on using the product's interface, this guide teaches how to use OneNote to do specific...

Your Excel Survival Kit

Your Guide to Surviving and Thriving in an Excel world

by Anne Walsh
Language: English
Release Date: June 1, 2016

You have just been promoted into a job that requires more Excel skills than ever. You are floundering, drowning in a sea of spreadsheets. This book walks you through in an easy accessible way—vlookups, pivot tables, Power Query, and Power Pivot. The Excel Survival Kit is small enough to slip into your purse.

The Many Faces of Anxiety

Does Anxiety Have a Grip on Your Life?

by Susan Rau Stocker
Language: English
Release Date: August 1, 2012

Real-world examples abound in this resource that provides a basic context for understanding how anxiety affects people and those around them. The author shares 12 cases of various clients with whom she has worked and paints detailed, clear pictures of the many reasons people become anxious and the...

The Spreadsheet at 25

25 Amazing Excel Examples that Evolved from the Invention that Changed the World

by
Language: English
Release Date: July 1, 2008

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...
1 2 34 5
We use our own "cookies" and third party cookies to improve services and to see statistical information. By using this website, you agree to our Privacy Policy