Excel Gurus Gone Wild

Name: Excel Gurus Gone Wild | Do the IMPOSSIBLE with Microsoft Excel
Brand: Holy Macro! Books
Price: 19.49 EUR
Availability: OnlineOnly

Do the IMPOSSIBLE with Microsoft Excel

Bill Jelen(Autor*in)

Holy Macro! Books (Verlag)

Erschienen am 1. April 2009

250 Seiten

E-Book

PDF mit Adobe-DRM

Systemvoraussetzungen

978-1-932802-50-4 (ISBN)

19,49 €inkl. 7% MwSt.

Systemvoraussetzungen

für PDF mit Adobe-DRM

E-Book Einzellizenz

Als Download verfügbar

Beschreibung

Weitere Details

Weitere Ausgaben

Inhalt

FRONT COVER
TABLE OF CONTENTS
ABOUT THE AUTHOR ACKNOWLEDGEMENTS
FOREWORD
DEDICATION
PART 1
FIND THE FIRST NON-BLANK VALUE IN A ROW
CALCULATE WORKDAYS FOR 5, 6, 7 DAY WORKWEEKS
STORE HOLIDAYS IN A NAMED RANGE
SUM EVERY OTHER ROW OR EVERY THIRD ROW
WHY THE MINUS MINUS? COERCE NUMBERS FROM TRUE/ FALSE
INTRODUCING THE BORING USE OF SUMPRODUCT
UNDERSTAND BOOLEAN LOGIC: FALSE IS ZERO
AND IS *,OR IS + AND EVERYTHING ELSE IS TRUE
USE GET.CELL TO HIGHLIGHT NON-FORMULA CELLS
REFER TO A CELL WHOSE ADDRESS VARIES, BASED ON A CALCULATION
POINT TO ANOTHER WORKSHEET WITH INDIRECT
GET DATA FROM ANOTHER WORKSHEET BY USING INDIRECT
USE INDIRECT TO GET A DATA FROM A MULTI-CELL RANGE
ALWAYS POINT TO CELL B10
USE NATURAL LANGUAGE FORMULAS WITHOUT USING NATURAL LANGUAGE FORMULAS
SUM A CELL THROUGH SEVERAL WORKSHEETS
SUM VISIBLE ROWS
LEARN R1C1 REFERENCES
RANDOM NUMBERS WITHOUT DUPLICATES
SORT WITH A FORMULA
DEAL WITH DATES BEFORE 1900
USE VLOOKUP TO GET THE NTH MATCH
USE A SELF-REFERENCING FORMULA
USE TWO-WAY INTERPOLATION WITH A SINGLE FORMULA
FIND THE SUM OF ALL DIGITS OCCURING IN A STRING
GET AN ARRAY OF UNIQUE VALUES FROM A LIST
AUTO-NUMBER RECORDS AND COLUMNS IN AN EXCEL DATABASE
PART 2
USE AUTOFILTER WITH A PIVOT TABLE
SORT SUBTOTALS
COPY AN EXACT FORMULA BY USING DITTO MARKS
RIGHT-DRAG BORDER TO ACCESS MORE COPYING OPTIONS
QUICKLY CREATE A HYPERLINK MENU
QUICKLY CREATE MANY RANGE NAMES
ADD FORMULAS TO SMARTART
CREATE A PIVOT TABLE FROM DATA IN MULTIPLE WORKSHEETS
DETERMINE THE HEIGHT AND WIDTH OF THE DATALABEL OBJECT
ADJUST XY CHART SCALING FOR CORRECT ASPECT RATIO
PART 3
MAKE A PERSONAL MACRO WORKBOOK
RUN A MACRO FROM A SHORTCUT KEY
RUN A MACRO FROM A BUTTON
RUN A MACRO FROM AN ICON
CREATE A REGULAR MACRO
CREATE AN EVENT HANDLER MACRO
EXTRACT AN E-MAIL ADDRESS FROM A CELL CONTAINING OTHER TEXT
FIND THE CLOSEST MATCH
USE TIMER TO MICRO-TIME EVENTS
DISCOVER THE TEMP FOLDER PATH
USE EVALUATE IN VBA INSTEAD OF LOOPING THROUGH CELLS
RENAME EACH WORKSHEET BASED ON ITS A1 VALUE
USE A CUSTOM PULL FUNCTION INSTEAD OF INDIRECT WITH A CLOSED WORKBOOK
IN VBA, DETERMINE THE NUMBER OF THE ACTIVE WORK-SHEET
CREATE WORKSHEET NAMES BY USING THE FILL HANDLE
COPY THE PERSONAL MACRO WORKBOOK TO ANOTHER COMPUTER
ADD FILTER TO SELECTION FUNCTIONALITY
USE A MACRO TO HIGHLIGHT THE ACTIVE CELL
REMOVE THE CAPTION BAR FROM A USER FORM
KEEP A BUTTON IN VIEW
ADD A RIGHT-CLICK MENU TO A USER FORM
FORMAT A USER FORM TEXT BOX AS CURRENCY OR A PERCENTAGE
DELETE RECORDS IN VBA
SELF-SIGN YOUR MACROS FOR CO-WORKERS
MAGNIFY A SECTION OF YOUR SCREEN
LIST COMBINATIONS OF N ITEMS TAKEN M AT A TIME
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE
INDEX

Systemvoraussetzungen

Als PDF speichern Als Link merken