Learn IT - Holy Macro! Books

Office VBA Macros You Can Use Today: Over 100 Amazing Ways to Automate Word, Excel, PowerPoint, Outlook, and Access

Holy Macro! Books, 2006

A simple macro language appeared in version 3 of VisiCalc. When Lotus 1-2-3 introduced the keystroke macro recorder, accountants everywhere began developing arcane little macros to automate the daily task of importing and formatting sales data in their spreadsheets. When Excel 5 shipped with a new macro language called VBA in 1993, the world...

M Is for (Data) Monkey: A Guide to the M Language in Excel Power Query

Holy Macro! Books, 2015

Power Query is one component of the Power BI (Business Intelligence) product from Microsoft, and “M” is the name of the programming language created by it. As more business intelligence pros begin using Power Pivot, they find that they do not have the Excel skills to clean the data in Excel; Power Query solves this problem. This book...

Rev Up to Excel 2010: Upgraders Guide to Excel 2010

Holy Macro! Books, 2010

This updated edition of Excel 2007 Miracles Made Easy features the amazing new upgrades offered in Excel 2010 and prepares users to transition to it. Covering only the revised components in Excel 2010, this manual shows how to navigate the ribbon interface and leverage the new business-intelligence...

Excel Gurus Gone Wild: Do the IMPOSSIBLE with Microsoft Excel

Holy Macro! Books, 2009

Drawn from actual excel conundrums posted on the author's website, www.mrexcel.com, this high-level resource is designed for people who want to stretch Excel to its limits. Tips for solving 100 incredibly difficult problems are covered in depth and include extracting the first letter of each word in a paragraph, validating...

The Spreadsheet at 25: 25 Amazing Excel Examples that Evolved from the Invention that Changed the World

Holy Macro! Books, 2005

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

$Excel for the Math Classroom (Excel for Professionals series)$

Excel for the Math Classroom (Excel for Professionals series)

Holy Macro! Books, 2007

This book was born out of a desire to help teachers teach their students math by being engaged in its study, and by showing teachers how they can custombuild visual examples of some of the concepts they are trying to get across to their students. Microsoft Excel is an extremely powerful spreadsheet with literally hundreds of built-in mathematical,...

Power One Note: Unleash the Power of One Note

Holy Macro! Books, 2004

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 tasks such as brainstorming, mind mapping,...

Excel 2007 Miracles Made Easy: Mr. Excel Reveals 25 Amazing Things You Can Do with the New Excel

Holy Macro! Books, 2007

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

Guerilla Data Analysis Using Microsoft Excel

Holy Macro! Books, 2002

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

Kathy Jacobs on Powerpoint: PPT 2000, PPT 2002, PPT 2003 (On Office series)

Holy Macro! Books, 2004

Learn to design presentations to fit any audience, create reports and graphical essays, use PowerPoint with other Microsoft Office products, and more with this timesaving guide.

A recognized expert in teaching Microsoft PowerPoint skills demonstrates how to design presentations to meet the needs of every audience. The peskiest PowerPoint...

From VBA to VSTO: Is Excel's New Engine Right for You?

Holy Macro! Books, 2006

This book is for those who wonder whether they should transit from Excel/VBA to Excel/VSTO. It was not written for people who want to learn programming in Excel, nor was it written for those (professional) developers who want to know all the ins and outs of VSTO programming.

My only intention is to help...

Learn Excel 97 Through Excel 2007 from Mr. Excel: 377 Excel Mysteries Solved!

Holy Macro! Books, 2007

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

Result Page: 2 1