Here is expert advice on high-level Excel for Windows 95 topics and programming. Written for programmers and consultants who need an advanced guide to the new features and to programming the product, this guide covers high-level spreadsheet activities such as data manipulation, creating custom functions and formulas, automating complex spreadsheet operations, and more.

Excel Expert Solutions

Computers & Technology

Carlberg, Conrad

Person, Ron

Payne, Donna

Devenshire, Shane

Umlas, Bob

Underdahl, Brian

Hager, David

Maguiness, David

Sullivan-Liscomb, Heidi

Lacher, John

Howard, Willis E., III

Green,John

BELLAMY, David

Software

Que Pub

Become an Excel Wizard! This isn't Excel, it's Magic! 2nd edition will save you time and effort. This expanded and enlarged guide is written in a friendly, easy-to-understand style, and is full of screen shots and visuals to help you on your way.

This Isn't Excel, It's Magic!

Programming

Iil Pub New York

Designed with the Excel guru in mind, this handbook introduces advanced and creative solutions and hacks for 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 and across all disciplines. Creative approaches for building formulas within formulas, pivot tables, conditional formatting, and mastering array formulas are just some of the numerous challenges explained. Other higher-level solutions discussed include using VBA macro code to override cell calculations, solve for sums from a text string, and trimming and cleaning all cells on a worksheet. This is the all-encompassing resource for advanced users of Excel wanting to learn more techniques to broaden and empower their use of Excel.

Excel Outside the Box: Unbelieveable Excel Techniques from Excel MVP Bob Umlas

Holy Macro! Books

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 that may be used in any Excel application and across all disciplines. Creative approaches for building formulas within formulas, pivot tables, conditional formatting, and mastering array formulas are just some of the numerous challenges explained. Other higher-level solutions discussed include using VBA macro code to override cell calculations, solve for sums from a text string, and trimming and cleaning all cells on a worksheet. This is the all-encompassing resource for advanced users of Excel wanting to learn more techniques to broaden and empower their knowledge of the program.

More Excel Outside the Box: Unbelievable Excel Techniques from Excel MVP Bob Umlas

Fifty Excel tricks that no one has ever seen before.\nCool Excel Sh*t 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 50 techniques, formulas, dynamic arrays, and VBA macros, this guide details processes that may be used in any application and across all disciplines. Includes a section on techniques using Dynamic Arrays in Excel.

Cool Excel Sh*t

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

Books by Umlas, Bob