Holy Macro Books: 57 books
by Dr. Gerard Verschuuren
Language: English
Release Date: August 1, 2005
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
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
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
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
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
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
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
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
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
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
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
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?
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
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...