Extent: | Online-Ressource (xx, 853 p) ill |
---|---|
Type of publication: | Book / Working Paper |
Language: | English |
Notes: | Includes index BOOK COVER; HALF TITLE; FULL TITLE; COPYRIGHT PAGE; TABLE OF CONTENTS; ABOUT THE AUTHOR; ACKNOWLEDGMENTS; DEDICATION; FOREWORD; PART-I: THE EXCEL ENVIRONMENT; SHOW FULL MENUS ALL THE TIME; SHOW FULL TOOLBARS ALL THE TIME; ADD A CLOSE BUTTON TO THE STANDARD TOOLBAR; CLOSE ALL OPEN WORKBOOKS; DOUBLE THE VALUE OF THE RECENTLY USED FILE LIST; REMEMBER WORKBOOKS TO OPEN USING A WORKSPACE; AUTOMATICALLY MOVE THE CELL POINTER IN A DIRECTION AFTER ENTERING A NUMBER; HOW TO SEE HEADINGS AS YOU SCROLL AROUND A REPORT; HOW TO SEE HEADINGS AND ROW LABELS AS YOU SCROLL AROUND A REPORT HOW TO PRINT TITLES AT THE TOP OF EACH PAGEPRINT A LETTER AT THE TOP OF PAGE 1 AND REPEAT HEADINGS AT THE TOP OF EACH SUBSEQUENT PAGE; HOW TO PRINT PAGE NUMBERS AT THE BOTTOM OF EACH PAGE; HOW TO MAKE A WIDE REPORT FIT TO ONE PAGE WIDE BY MANY PAGES TALL; ARRANGE WINDOWS TO SEE TWO OR MORE OPEN WORKBOOKS; WHY IS THERE A ":2" AFTER MY WORKBOOK NAME IN THE TITLE BAR?; HAVE EXCEL ALWAYS OPEN CERTAIN WORKBOOK(S); SET UP EXCEL ICONS TO OPEN A SPECIFIC FILE ON STARTUP; USE A MACRO TO FURTHER CUSTOMIZE STARTUP; CONTROL SETTINGS FOR EVERY NEW WORKBOOK AND WORKSHEET; OPEN A COPY OF A WORKBOOK OPEN A SAVED FILE WHOSE NAME YOU CANNOT RECALLSUPPRESS THE UPDATE LINKS MESSAGE; SEND EXCEL FILE AS AN ATTACHMENT; SAVE EXCEL DATA AS A TEXT FILE; USE A LASER PRINTER TO HAVE EXCEL CALCULATE FASTER; USE EXCEL AS A WORD PROCESSOR; SPELLCHECK A REGION; USE HYPERLINKS TO CREATE AN OPENING MENU FOR YOUR WORKBOOK; GET QUICK ACCESS TO PASTE SPECIAL; USE SHIFT KEY TO REVERSE POPULAR TOOLBAR ICONS; CREATE A MENU OR A TOOLBAR OF YOUR FAVORITE ICONS; RESTORE YOUR MENUS AFTER CUSTOMIZING; QUICKLY COPY A FORMULA TO ALL ROWS OF DATA; QUICKLY TURN A RANGE ON ITS SIDE STOP EXCEL FROM AUTOCORRECTING CERTAIN WORDSUSE AUTOCORRECT TO ENABLE A SHORTCUT; WHY WON'T THE TRACK CHAGES FEATURE WORK IN EXCEL?; COPY CELLS FROM ONE WORKSHEET TO MANY WORKSHEETS; HAVE EXCEL TALK TO YOU; ENTER SPECIAL SYMBOLS; FIND TEXT ENTRIES; COPY A FORMULA THAT CONTAINS RELATIVE REFERENCES; COPY A FORMULA WHILE KEEPING ONE REFERENCE FIXED; CREATE A MULTIPLICATION TABLE; CALCULATE A SALES COMMISSION; SIMPLIFY ENTRY OF DOLLAR SIGNS IN FORMULAS; LEARN R1C1 REFERENCING TO UNDERSTAND FORMULA COPYING; CREATE EASIER-TO-UNDERSTAND FORMULAS WITH NAMED RANGE; USE NAMED CONSTANTS TO STORE NUMBERS BUILD A FORMULA USING LABELS INSTEAD OF CELL ADDRESSESUSE NATURAL LANGUAGE FORMULAS TO REFER TO THE CURRENT ROW; ASSIGN A FORMULA TO A NAME; TOTAL WITHOUT USING A FORMULA; COUNT, AVERAGE, ETC. WITHOUT USING A FORMULA; ADD TWO COLUMNS WITHOUT USING FORMULAS; HOW TO CALCULATE SALES OVER QUOTA; HOW TO JOIN TWO TEXT COLUMNS; HOW TO SORT ON ONE SEGMENT OF AN ACCOUNT ID; HOW TO ISOLATE THE CENTER PORTION OF AN ACCOUNT ID; HOW TO ISOLATE EVERYTHING BEFORE A DASH IN A COLUMN BY USING FUNCTIONS; HOW TO USE FUNCTIONS TO ISOLATE EVERYTHING AFTER A DASH IN A COLUMN HOW TO USE FUNCTIONS TO ISOLATE EVERYTHING AFTER THE SECOND DASH IN A COLUMN Electronic reproduction; Available via World Wide Web |
ISBN: | 1-932802-12-6 ; 1-932802-19-3 ; 978-1-932802-12-2 |
Source: | ECONIS - Online Catalogue of the ZBW |
Persistent link: https://www.econbiz.de/10012673415