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 with one click every time, matching lists of data, data consolidation, data subtotals, pivot tables, and much more.

Guerilla Data Analysis Using Microsoft Excel

Computers & Technology

Jelen, Bill

Computer Science

Holy Macro! Books

This CD-ROM contains every snippet of Excel VBA code you will ever need. Each example includes a question, answer, the VBA code and a sample Excel workbook demonstrating the code. Completely searchable, this reference is a must for anyone who needs to write Excel macros.

Holy Macro! It's 1,600 Excel VBA Examples

Herber, Hans

Software

From the archives at Ask Mr. Excel, the Excel knowledge base provides a completely searchable database of 12,000 Excel questions and answers. It covers every aspect of Microsoft Excel - from beginner to advanced and VBA macros. From 1999 to 2002, the Ask Mr. Excel Message Board grew to become one of the leading web sites for Excel Tips. Every day, MrExcel MVP's from around the globe would answer Excel questions posed by visitors to the site. This volume represents over 12,000 Q&A threads from June 1999 through Janaury 2002. Organized by topic and completely searchable, using this CD-ROM will be like having 20 Excel Experts on your desktop!

Excel Knowledge Base

Mrexcel Consulting

Explains how to use the features of the electronic spreadsheet program, discussing topics such as worksheet design, charts, formulas, and data analysis.

Mr Excel on Excel: Excel 97, Excel 2000, Excel 2002

Rubin CPA, Joseph

Written for intermediate- to expert-level Microsoft Word users, this book demonstrates frequently missed tools and the proper way to use new and existing tools. Word's settings, toolbars, and menus are reviewed, as are topics such as the importance of installing safe fonts, setting tabs correctly, and using styles for maximum effect. Also offered is advice on topics pertaining to work groups, such as sharing templates, styles, and toolbars and creating paper and paperless forms. New concepts such as using tables to set up forms, recording macros to cut down on repetition, automatically updating cross-references, and minimizing file sizes are covered. Instructions on keeping a hard drive clean, which can minimize general PC problems, are also provided.

Dreamboat on Word: Word 2000, Word 2002, Word 2003 (On Office series)

Troy, Anne

A complete Excel training course, this CD-ROM contains three complete one-day modules that teach VBA basics and show how to use the macro recorder and then edit the code in order to make a usable macro. Examples demonstrate how to control charts and pivot tables using VBA, and clear explanations reveal the difference between methods and properties. The second module covers how to calculate with VBA covering loops, functions, formulas, and arrays. The third module discusses how to build a successful application that will interact with the user. Userforms and event handlers are also discussed.

Slide Your Way Through Excel VBA: Learn to Keep Excel Under Control with VBA (Visual Training series)

Verschuuren, Dr. Gerard

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, video drivers, hardware acceleration and missing slide content.

Kathy Jacobs on PowerPoint: Unlease the Power of PowerPoint (On Office series)

Jacobs, Kathy

Programming

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 with one click every time, matching lists of data, data consolidation, data subtotals, pivot tables, and much more.

Bill Jelen

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 with various characteristics, and tips on when to use PEARSON instead of CORREL. Other science- and engineering-related Excel features such as making columns touch each other for a histogram, unlinking a chart from its data, and pivoting tables to create frequency distributions are also covered.

Excel for Scientists: A Complete Course for Scientists and Engineers (Excel for Professionals series)

Verschuuren, Gerard M.

Web Development & Design

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 appropriate Access features in the same context in which they will use them in their own work. Users are guided through the process of creating a working database from the first step (defining the business problem it is intended to solve) through the last (deploying the application into an organization and providing ongoing support to users). Also included are case studies that provide practical guidelines for situations Access users might find themselves in.

Grover Park George On Access: Unleash the Power of Access (On Office series)

Hepworth, George

Databases & Big Data

See the best price to sell, buy or rent books by the Holy Macro! Books publisher. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Books by Holy Macro! Books

See the best price to sell, buy or rent books by the Holy Macro! Books publisher. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Guerilla Data Analysis Using Microsoft Excel

Holy Macro! It's 1,600 Excel VBA Examples

Excel Knowledge Base

Mr Excel on Excel: Excel 97, Excel 2000, Excel 2002

Dreamboat on Word: Word 2000, Word 2002, Word 2003 (On Office series)

Slide Your Way Through Excel VBA: Learn to Keep Excel Under Control with VBA (Visual Training series)

Kathy Jacobs on PowerPoint: Unlease the Power of PowerPoint (On Office series)

Guerilla Data Analysis Using Microsoft Excel

Excel for Scientists: A Complete Course for Scientists and Engineers (Excel for Professionals series)

Grover Park George On Access: Unleash the Power of Access (On Office series)