| Description |
1 online resource (194 pages) |
|
text file |
| Contents |
Front Cover; Copyright; Table of Contents; About the Author; Comments from readers; Acknowledgments; Dedication; Introduction; Chapter 1 -- Techniques; 1-A Dilemma with Relative References; 2-Build a Formula with a Formula; 3-Combining a List of Values into One; 4-Comparing Worksheets; 5-Creating a Series of the 15th of the Month and the Last Day of the Month; 6-Match Colors; 7-Reorganization of Data; 8-Scrolling Text; 9-Sequences; 10-Variable Linked Cell; Chapter 2 -- Pivot Tables; 11-Pivot Table Anomaly and Workaround; 12-Reverse Pivot Table; Chapter 3 -- Features; 13-Conditional Formatting. |
|
14-Data Validation on Steroids15-The "Justify" Command; 16-Unusual Text to Columns; Chapter 4 -- Formulas; 17-Interesting Formula using MATCH and OFFSET; 18-Using LARGE (or SMALL, etc) on Non-contiguous Ranges; 19-Using SUMPRODUCT for Filtered or Hidden rows; 20-VLOOKUP with Multiple Answers; 21-Reversing a list; Chapter 5 -- Array Formulas; 22-Alphabetizing without Sorting (an Array-Formula); 23-An Odd Combination; 24-Another Array-Formula Application -- Finding the Latest Date from a String with Embedded Dates; 25-Calendar with One Formula (Array Entered, of Course!); 26-Comparing Lists. |
|
27-Finding the Last Cell Using a Formula28-Getting Sums from a Text String; 29-Parsing Information Without Breaking in the Middle of a Word (an Array Formula); 30-Using an Array Formula to Extract a Part Number; 31-VLOOKUP with Multiple Answers -- Another Look; Chapter 6 -- Charts; 32-Dynamic Range Names and Charts; 33-More Dynamic Charting; 34-Show a Chart Only When the Data is Complete; Chapter 7 -- VBA; 35-Ensure a Cell Contains a Value Before Saving File; 36-A VBA User-Defined Function for Getting Sums from a Text String; 37-Delete Defined Names in One VBA Statement. |
|
38-Ensuring Macros are Enabled39-Getting a List of Sheet Tabs in a "Table of Contents"; 40-Inserting Totals with VBA; 41-Limiting Cells a Person Can Select Without Protecting the Worksheet; 42-Many Buttons, One VBA Procedure; 43-Multiple Matches; 44-Overriding Cell Calculations; 45-Quick Way to Put Sequential Numbers into a Range Using VBA; 46-Trimming and Cleaning all Cells on a Worksheet; 47-Using a Demo of a File -- Not Allowing it to be Used More than X Times; 48-Using Excel Ranges With the VBA Join Method; Chapter 8 -- Miscellaneous; 49-What Really is the Issue with Dates? |
|
50-Getting Sums From a Text String, Revisited51-Useful Filtering Technique; 52-Referencing in Long Worksheets; 53-Interesting Conditional Formatting; 54-Highlighting Cells Which are Values Which Should Be Formulas, Without Using VBA; 55-A Piece of Silliness; Index; Back Cover. |
| Summary |
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, 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, s. |
| Local Note |
eBooks on EBSCOhost EBSCO eBook Subscription Academic Collection - North America |
| Subject |
Microsoft Excel (Computer file)
|
|
Microsoft Excel (Computer file) |
|
Microsoft Excel (Computer file) |
| Genre/Form |
Electronic books.
|
|
Electronic books.
|
| Other Form: |
Print version: Umlas, Bob. Excel Outside the Box : Unbelieveable Excel Techniques from Excel MVP Bob Umlas. Chicago : Holy Macro! Books, ©2012 9781615470105 |
| ISBN |
9781615472031 electronic book |
|
1615472037 electronic book |
|
1306057434 electronic book |
|
9781306057431 electronic book |
|
