Holy Macro Books: 57 books

Cover of MrExcel LX The Holy Grail of Excel Tips

MrExcel LX The Holy Grail of Excel Tips

Covers Excel Backwards and Forwards

by Bill Jelen
Language: English
Release Date: September 1, 2019

These are the 125 essential tips that all Excel users need to know. MrExcel LX provides users with a concise book that can be absorbed in under two hours. 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.
Cover of Don't Fear the Spreadsheet

Don't Fear the Spreadsheet

A Beginner's Guide to Overcoming Excel's Frustrations

by Tyler Nash, Bill Jelen, Kevin Jones
Language: English
Release Date: July 1, 2012

Written in a question-and-answer format, this lowest-level beginner book covers the extreme basics of using spreadsheets in Excel. Instead of delving into advanced topics that scare most Excel novices away, the guide starts at a much more basic level, quickly providing a passable knowledge of the...
Cover of More Excel Outside the Box

More Excel Outside the Box

Unbelievable Excel Techniques from Excel MVP Bob Umlas

by Bob Umlas
Language: English
Release Date: May 1, 2015

A follow-up to Excel Outside the Box, More Excel Outside the Box is designed with the Excel guru in mind, introducing advanced, creative solutions and hacks for the software's most challenging problems. Through a series of more than 30 techniques, tables, formulas, and charts, this guide details processes...
Cover of Excel Outside the Box

Excel Outside the Box

Unbelieveable Excel Techniques from Excel MVP Bob Umlas

by Bob Umlas
Language: English
Release Date: April 1, 2012

Designed with the Excel guru in mind, this handbook introduces advanced and creative solutions, and hacks to the software's most challenging problems. Through a series of more than 50 techniques, tables, formulas, and charts, this guide details processes that may be used in any Excel application,...
Cover of From VBA to VSTO

From VBA to VSTO

Is Excel's New Engine Right for You?

by Dr. Gerard M. Verschuuren
Language: English
Release Date: April 12, 2006

This Excel user's guide to VSTO—the new Excel Macro programming language being promoted by Microsoft—shows how to perform the equivalent VBA actions with VSTO. The differences between the VSTO and VBA development environments are explained, helping Excel users decide if they should embrace VSTO or seek out other technologies.
Cover of PowerPivot Alchemy

PowerPivot Alchemy

Patterns and Techniques for Excel

by Bill Jelen, Rob Collie
Language: English
Release Date: July 1, 2014

Rob Collie (PowerPivotPro) and Bill Jelen (MrExcel) join forces in this combined sequel to their best-selling Power Pivot books. Alchemy sets aside the fundamentals of past books and provides a series of practical, easy-to-follow "patterns" for dozens of common analysis, reporting, and dashboarding...
Cover of Confessions of a Girl

Confessions of a Girl

Truth to Be Told

by Tessa Sean Hershberger
Language: English
Release Date: April 1, 2005

The Fresh Voices series was inspired by a writing contest of by the same name that identified high school writers interested in composing book-length works for young adults. Working with a professional editor, the young authors spent the summer learning about the book industry and meeting journalists...
Cover of Super Charge Power BI

Super Charge Power BI

Power BI Is Better When You Learn to Write DAX

by Matt Allington
Language: English
Release Date: June 1, 2018

Power BI is a powerful self-service (and enterprise) business intelligence (BI) tool that was first made generally available by Microsoft in July 2015. Power BI is a complete BI package that covers the end to end BI process including data acquisition (get data), data modelling (prepare/model the data)...
Cover of Baker's Dozen

Baker's Dozen

In 13 Days, Justin Baker and the World Will Change

by Joshua Matthew Moorhead
Language: English
Release Date: April 1, 2005

The Fresh Voices series was inspired by a writing contest of the same name that identified high school writers interested in composing book-length works for young adults. Working with a professional editor, the young authors spent the summer learning about the book industry and meeting journalists...
Cover of Celtic Night

Celtic Night

A Fifteen-Year-Old Girl's Modern Retelling of Shakespeare's A Midsummer Night's Dream

by Bridget O'Dwyer
Language: English
Release Date: March 28, 2006

A modern retelling of A Midsummer Night's Dream, this story of a 15-year-old American girl's experience studying abroad in the Irish countryside borrows elements from Irish folklore and escapist-fantasy fiction. Adjustment to life with an Irish family is hard at first, but she forges a bond with her...
Cover of Fórmulas DAX para PowerPivot

Fórmulas DAX para PowerPivot

Una guía simple hacia la revolución de Excel

by Rob Collie
Language: Spanish
Release Date: September 1, 2013

Microsoft PowerPivot es un complemento gratuito para Excel de Microsoft que permite a los usuarios producir nuevos tipos de informes y análisis que simplemente eran imposibles antes, y este libro es el primero en abordar fórmulas DAX, la capacidad central de PowerPivot, desde la perspectiva de la...
Cover of Power Pivot and Power BI

Power Pivot and Power BI

The Excel User's Guide to DAX, Power Query, Power BI & Power Pivot in Excel 2010-2016

by Rob Collie, Avichal Singh
Language: English
Release Date: December 1, 2015

Microsoft PowerPivot is a free add-on to Excel from Microsoft that allows users to produce new kinds of reports and analyses that were simply impossible before, and this book is the first to tackle DAX formulas, the core capability of PowerPivot, from the perspective of the Excel audience. Written...
Cover of Ctrl+Shift+Enter Mastering Excel Array Formulas

Ctrl+Shift+Enter Mastering Excel Array Formulas

Do the Impossible with Excel Formulas Thanks to Array Formula Magic

by Mike Girvin
Language: English
Release Date: August 1, 2013

Designed with Excel gurus in mind, this handbook outlines how to create formulas that can be used to solve everyday problems with a series of data values that standard Excel formulas cannot or would be too arduous to attempt. Beginning with an introduction to array formulas, this manual examines topics...
Cover of Red Headed Geek

Red Headed Geek

My Short and Painful Career as a Rasslin' Manager

by Billy C. Wirtz
Language: English
Release Date: December 1, 2012

Neither an exposé of the dark underbelly of wrestling nor a justification of its existence, Red Headed Geek is a loving, firsthand look inside the regional wrestling circuits of yesteryear by a former manager who's been tossed from the ring, bashed with a folding chair, and had painfully honest conversations...
12 3 4 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