Excel annoyances: how to fix the most annoying things ; about your favorite spreadsheet
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Buch |
| Sprache: | English |
| Veröffentlicht: |
Beijing ; Cambridge ; Farnham ; Köln ; Paris ; Sebastopol ; Taipei ; Tokyo
O'Reilly
2005
|
| Ausgabe: | 1. ed., [Nachdr.] |
| Schlagworte: | |
| Online-Zugang: | Inhaltsverzeichnis |
| Beschreibung: | 235 S. 25 cm |
| ISBN: | 0596007280 9780596007287 |
Internformat
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV035797527 | ||
| 003 | DE-604 | ||
| 007 | t| | ||
| 008 | 091029s2005 gw |||| 00||| eng d | ||
| 015 | |a 05,A10,0024 |2 dnb | ||
| 016 | 7 | |a 973613319 |2 DE-101 | |
| 020 | |a 0596007280 |c kart. : EUR 24.00, 24.95 |9 0-596-00728-0 | ||
| 020 | |a 9780596007287 |9 978-0-596-00728-7 | ||
| 035 | |a (OCoLC)254186191 | ||
| 035 | |a (DE-599)BVBBV035797527 | ||
| 040 | |a DE-604 |b ger |e rakddb | ||
| 041 | 0 | |a eng | |
| 044 | |a gw |c XA-DE | ||
| 049 | |a DE-M347 | ||
| 050 | 0 | |a HF5548.4.M523 | |
| 082 | 0 | |a 005.54 | |
| 084 | |a ST 371 |0 (DE-625)143672: |2 rvk | ||
| 084 | |a 004 |2 sdnb | ||
| 100 | 1 | |a Frye, Curtis |d 1968- |e Verfasser |0 (DE-588)129545651 |4 aut | |
| 245 | 1 | 0 | |a Excel annoyances |b how to fix the most annoying things ; about your favorite spreadsheet |c Curtis Frye |
| 250 | |a 1. ed., [Nachdr.] | ||
| 264 | 1 | |a Beijing ; Cambridge ; Farnham ; Köln ; Paris ; Sebastopol ; Taipei ; Tokyo |b O'Reilly |c 2005 | |
| 300 | |a 235 S. |c 25 cm | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 630 | 0 | 4 | |a Microsoft Excel (Computer file) |
| 650 | 4 | |a Electronic spreadsheets | |
| 650 | 0 | 7 | |a EXCEL |0 (DE-588)4138932-3 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a EXCEL |0 (DE-588)4138932-3 |D s |
| 689 | 0 | |5 DE-604 | |
| 856 | 4 | 2 | |m DNB Datenaustausch |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=018656726&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 943 | 1 | |a oai:aleph.bib-bvb.de:BVB01-018656726 | |
Datensatz im Suchindex
| _version_ | 1816445535193661440 |
|---|---|
| adam_text |
QOBNT^MS|
INTRODUCTION
XIII
0
ENTERING
DATA
ANNOYANCES
CH
-
1
2
GENERAL
DATA
ENTRY
ANNOYANCES
KILL
CLIPPY
RETAIN
LEADING
ZEROS
WHEN
YOU
ENTER
DATA
EXTEND
A
NUMERIC
SERIES
AUTOMATICALLY
USE
THE
SERIES
DIALOG
BOX
TO
DEFINE
A
SERIES
OF
VALUES
CREATE
DATA
SERIES
MINUS
THE
MOUSE
CREATE
A
CUSTOM
FILL
SERIES
ENTER
DATA
INTO
MULTIPLE
WORKSHEETS
AT
ONCE
ALLOW
MORE
THAN
ONE
PERSON
TO
EDIT
A
FILE
AT
THE
SAME
TIME
ADD
A
CARRIAGE
RETURN
TO
A
CELL'S
CONTENTS
ADD
SYMBOLS
TO
YOUR
EXCEL
WORKSHEET
RESTRICT
AUTOCORRECT
INTERFERENCE
KEEP
WEB
AND
FILE
ADDRESSES
AS
PLAIN
TEXT
9
IMPORTING
DATA
ANNOYANCES
COPYING
A
WORD
TABLE
INTO
EXCEL
97
INTRODUCES
BLANK
ROWS
DATA
IN
WORD
FILES
ISN'T
AVAILABLE
FOR
IMPORT
11
CUT-AND-PASTE
ANNOYANCES
PUT
MORE
THAN
ONE
ITEM
ON
THE
CLIPBOARD
PREVENT
THE
OFFICE
CLIPBOARD
FROM
APPEARING
CONTROL
PASTED
CELL
FORMATS
INSERT
OR
DELETE
SINGLE
CELLS
TRANSPOSE
ROWS
AND
COLUMNS
CHANGE
THE
DEFAULT
SAVE
LOCATION
15
NAVIGATION
AND
DISPLAY
ANNOYANCES
KEEP
THE
SAME
ACTIVE
CELL
WHEN
YOU
MOVE
TO
A
NEW
WORKSHEET
SHRINK
THE
EXCEL
WINDOW
MAGNIFY
A
SELECTION
MOVE
TO
THE
LAST
ROW
IN
A
LIST
KEEP
HEADERS
CONSTANT
AS
YOU
SCROLL
SEARCH
A
PORTION
OF
A
WORKSHEET
DIVIDE
A
WORKSHEET
INTO
MULTIPLE
SCROLLABLE
AREAS
18
DATA
VALIDATION
ANNOYANCES
RESTRICT
DATA
ENTRY
WITH
VALIDATION
RULES
CREATE
A
FORM
TO
EASE
DATA
ENTRY
BASE
VALIDATION
RULES
ON
FORMULA
RESULTS
USE
DATA
IN
ANOTHER
WORKSHEET
AS
VALIDATION
CRITERIA
AVOID
DUPLICATE
ENTRIES
IN
A
COLUMN
EXPLAIN
DATA
VALIDATION
RULES
HIGHLIGHT
INVALID
WORKSHEET
DATA
COPY
A
VALIDATION
RULE
TO
ANOTHER
CELL
PREVENT
EXCEL
FROM
SCROLLING
TOO
QUICKLY
(§)
FORMAT
ANNOYANCES'"
2
28
CELL
FORMATTING
ANNOYANCES
FORMAT
PART
OF
A
CELL'S
CONTENTS
WRAP
TEXT
IN
A
CELL
WITH
JUST
ONE
MOUSE
CLICK
CHANGE
WORKSHEET
TAB
COLORS
29
CONDITIONAL
FORMATTING
ANNOYANCES
CHANGE
CELL
FORMATTING
BASED
ON
THE
CELL'S
VALUE
EXCEL
APPLIES
THE
WRONG
CONDITIONAL
FORMAT
LOCATE
CELLS
WITH
CONDITIONAL
FORMATS
30
TEMPLATE
ANNOYANCES
CREATE
A
WORKBOOK
TEMPLATE
CREATE
A
WORKSHEET
TEMPLATE
32
COLOR
MANAGEMENT
ANNOYANCES
REPLACE
REPEATED
COLORS
IN
THE
EXCEL
COLOR
PALETTE
TRANSLATE
BETWEEN
COLOR
PALETTE
POSITION,
COLOR
NAME,
AND
COLORINDEX
VALUE
COPY
ANOTHER
WORKBOOK'S
COLOR
PALETTE
DISPLAY
THE
RGB
VALUES
OF
COLORS
IN
A
WORKBOOK
'
S
COLOR
PALETTE
MANAGE
COLORS
AND
FORMATS
WITH
A
CUSTOM
ADD-IN
36
WORKBOOK
FORMATTING
ANNOYANCES
CHANGE
EXCEL'S
DEFAULT
FONT
HOW
TO
TELL
A
STYLE
FROM
A
FORMAT
SIMPLIFY
EXCEL
FORMATTING
WITH
STYLES
SEARCH
FOR
CELLS
WITH
SPECIFIC
FORMATTING
THE
CASE
OF
THE
VANISHING
GRIDLINES
HIDE
AND
UNHIDE
ROWS
AND
COLUMNS
HIDE
AND
UNHIDE
SHEETS
40
CUSTOM
FORMAT
ANNOYANCES
CREATE
CUSTOM
NUMBER
DISPLAY
FORMATS
ADD
TEXT
TO
A
DISPLAYED
NUMERICAL
VALUE
ROUND
VALUES
WITHOUT
USING
THE
R0UND()
FUNCTION
ROUND
VALUES
TO
THE
MILLIONS
AND
DISPLAY
"MILLIONS"
AFTER
THE
VALUE
ALIGN
NUMBERS
IN
A
COLUMN
BY
DECIMAL
POINT
CREATE
A
CUSTOM
DATE
FORMAT
CREATE
CUSTOM
TIME
FORMATS
SETTING
DATE
AND
TIME
USING
OTHER
LOCAL
RULES
APPLY
SPECIAL
FORMATS
FOR
ZIP
CODES
ADDING
CUSTOM
FOREIGN
CURRENCY
SYMBOLS
@
FORMULAANNOYANCES
"
3
48
FORMULA
ENTRY
AND
EDITING
ANNOYANCES
PREVENT
COPIED
FORMULAS
FROM
CHANGING
CELL
REFERENCES
TOGGLE
BETWEEN
RELATIVE
AND
ABSOLUTE
REFERENCES
REFER
TO
CELLS
ON
ANOTHER
WORKSHEET
LEARN
R1C1
NOTATION
CREATE
A
REFERENCE
TO
A
PIVOTTABLE
CELL
DEFINE
THE
INTERSECTION
OF
TWO
RANGES
IN
A
FORMULA
NEST
FUNCTIONS
WITHIN
FUNCTIONS
DELETE
A
FORMULA
AND
KEEP
THE
RESULT
MARK
CELLS
THAT
CONTAIN
A
FORMULA
DISPLAY
FORMULAS
IN
CELLS
DROP
YOUR
OWN
PROCEDURE
INTO
A
FORMULA
PERFORM
THE
SAME
OPERATION
ON
A
GROUP
OF
CELLS
MONITOR
WATCH
VALUES
ADD
COMMENTS
TO
A
FORMULA
IMPROVE
EXCEL'S
STATISTICAL
ACCURACY
56
FORMULA
ERROR
AND
AUDITING
ANNOYANCES
TELL
EXCEL
WHAT
IS
AN
ERROR
AND
WHAT
ISN'T
FIND
FORMULA
PRECEDENTS
VI
CONTENTS
DISPLAY
ALL
DEPENDENT
CELLS
MASK
ERROR
MESSAGES
IN
A
WORKSHEET
58
ARRAY
FORMULA
ANNOYANCES
DEPLOY
ARRAY
FORMULAS
60
RECALCULATION
ANNOYANCES
RECALCULATE
NOW!
SPEED
UP
RECALCULATIONS
61
DATE
AND
TIME
ANNOYANCES
DISPLAY
PARTIAL
HOURS
AS
DECIMAL
NUMBERS
ROUND
HOURS
TO
THE
NEXT
TENTH
OF
AN
HOUR
ROUND
HOURS
TO
THE
NEXT
QUARTER
OF
AN
HOUR
SAVE
A
DATE
OR
TIME
AS
TEXT
FIND
THE
NUMBER
OF
WORKDAYS
BETWEEN
TWO
DATES
ADD
HOURS,
MINUTES,
OR
SECONDS
TO
A
TIME
IMPRESS
HISTORIANS
WITH
ROMAN
NUMERALS
FIND
THE
NUMBER
OF
A
WEEK
65
NAMED
RANGE
ANNOYANCES
CREATE
NAMED
RANGES
UPDATE
EXISTING
FORMULAS
TO
USE
NEWLY
DEFINED
NAMED
RANGES
CREATE
NAMED
CONSTANTS
CREATE
A
SELF-EXTENDING
NAMED
RANGE
CREATE
A
NAMED
RANGE
FROM
MULTIPLE
SHEETS
PASTE
A
LIST
OF
NAMES
SELECT
AN
ENTIRE
NAMED
RANGE
AVOID
RENAMING
CELLS
IN
A
NAMED
RANGE
69
TEXT
FORMULA
ANNOYANCES
PARSE
FIXED-LENGTH
SUBSTRINGS
PARSE
DATA
OF
INCONSISTENT
LENGTHS
DIVIDE
TEXT
INTO
MULTIPLE
COLUMNS
GET
RID
OF
SPACES
AND
INVISIBLE
CHARACTERS
71
COUNTING
AND
CONDITIONAL
SUM
ANNOYANCES
SUM
VALUES
THAT
MEET
A
CRITERION
COUNT
VALUES
THAT
MEET
A
CRITERION
COUNT
NONBLANK
CELLS
IN
A
RANGE
COUNT
BLANK
CELLS
IN
A
RANGE
COUNT
THE
NUMBER
OF
UNIQUE
VALUES
IN
A
RANGE
@
MANIPULATING
DATA
ANNOYANCES"
4
76
SORTING
AND
FILTERING
ANNOYANCES
SORT
BY
VALUES
IN
MULTIPLE
COLUMNS
SORT
DATA
BY
A
CUSTOM
SORT
ORDER
SORT
DATA
LEFT
TO
RIGHT
FILTER
WORKSHEET
DATA
DISPLAY
TOP
OR
BOTTOM
VALUES
CREATE
A
MULTILEVEL
FILTER
FIND
DUPLICATE
ENTRIES
IN
A
DATA
LIST
COPY
ONLY
VISIBLE
CELLS
FROM
A
FILTERED
LIST
SUMMARIZE
VISIBLE
CELLS
ONLY
81
LOOKUP
FUNCTION
ANNOYANCES
LOOK
UP
VALUES
IN
DATA
LISTS
LOOK
UP
A
VALUE
IN
ANY
COLUMN
CORRECT
AN
INCORRECT
VL00KUPO
RESULT
IN
EXCEL
97
TEXT-NUMBER
MIX
OVERWHELMS
LOOKUP
PERFORM
A
CASE-SENSITIVE
LOOKUP
WORK
WITH
INCORRECT
TIMES
SERIES
SPEED
UP
MULTIPLE
LOOKUPS
FIND
THE
FIRST
OR
LAST
MATCH
IN
AN
ARRAY
88
WHAT-IF
ANALYSIS
ANNOYANCES
CREATE
A
SCENARIO
FIND
A
VALUE
THAT
GENERATES
A
SPECIFIC
RESULT
USE
SOLVER
TO
SOLVE
MULTIVARIATE
PROBLEMS
PLACE
DATA
ANALYSIS
ON
A
MENU
CONTENTS
VII
92
PIVOTTABLE
ANNOYANCES
LEARN
TO
USE
PIVOTTABLES
CREATE
A
PIVOTTABLE
PIVOT
A
PIVOTTABLE
FILTER
PIVOTTABLE
DATA
CREATE
ADVANCED
PIVOTTABLE
FILTERS
FILTER
A
PIVOTTABLE
BY
ANY
FIELD
FIND
PIVOTTABLE
ADD-INS
APPLY
AUTOFORMAT
TO
A
PIVOTTABLE
STOP
PIVOTTABLES
FROM
PIVOTING!
PIVOTTABLE
DATA
DISPLAYS
AS
NUMBER
SIGNS
"PIVOTTABLE
IS
NOT
VALID"
ERROR
PIVOTTABLE
LOSES
FORMATTING
USE
CALCULATED
FIELDS
IN
A
PIVOTTABLE
CHANGE
SUMMARY
CALCULATIONS
IN
A
PIVOTTABLE
HIDDEN
DATA
DOESN'T
APPEAR
IN
THE
SUMMARY
"REFERENCE
NOT
VALID"
ERROR
DISPLAY
PIVOTTABLE
DATA
AS
A
PERCENTAGE
OF
A
TOTAL
@
CHART
ANNOYANCES
M
S
108
CHART
CREATION
AND
FORMATTING
ANNOYANCES
INSTANT
CHARTS
SPIFF
UP
A
CHART
QUICKLY
UPDATE
A
CHART
TO
INCLUDE
NEW
EXCEL
DATA
CREATE
AND
UPDATE
CHARTS
FROM
QUERY
DATA
EXPLODE
YOUR
PIE
CHART
TWO
CHARTS
FOR
THE
PRICE
OF
ONE
CHART
DATA
SERIES
PROPERLY
FORMAT
CHART
ELEMENTS
ADD
TEXT
TO
A
CHART
AXIS
GLITZ
UP
YOUR
COLUMNS
ADD
ERROR
BARS
TO
A
GRAPH
118
CHART
MANIPULATION
ANNOYANCES
COPY
CHARTS
AS
PICTURES
MOVE
A
CHART
TO
A
SEPARATE
SHEET
PRINT
A
CHART
WITHOUT
SURROUNDING
DATA
CHOOSE
YOUR
AXIS
SEEKING
YOUR
GOAL
WITH
A
CHART
120
PIVOTCHART
ANNOYANCES
PIVOTCHARTS
AND
PIVOTTABLES
GO
TOGETHER
LIKE
FIRST
A
PIVOTCHART,
THEN
A
PIVOTTABLE
MAKE
NORMAL
CHARTS
FROM
PIVOTTABLES
121
CHART
INTERACTION
ANNOYANCES
PRINT
AN
EXCEL
97
CHART
FROM
POWERPOINT
CHART
MACRO
CRASHES
EXCEL
CHART
GROWS
WHEN
MOVED
TO
TEXT
BOX
DISAPPEARING
SCATTER
PLOT
POINTS
ON
THE
WEB
PASTED
CHART
TURNS
INTO
GRAY
RECTANGLE
CAN'T
PUBLISH
A
CHART
FROM
MULTIPLE
SHEETS
DRAGGING
EXCEL
CHART
CRASHES
WORD
CHART
TITLES
SHOW
ONLY
ONE
LINE
PREVIEW
A
CHART,
CRASH
EXCEL
97
FALSE
PERCENTAGES
IN
PIE
CHART
THE
CASE
OF
THE
DISAPPEARING
AXIS
LABELS
CHART
IMAGE
CHOPPED
127
CHART
ADD-INS
AND
HELPER
APPLICATIONS
MAGIC
ADD-INS
FOR
CHARTS
AND
GRAPHS
BETTER
2D
AND
3D
CHARTS
129
3D
CHART
ANNOYANCES
CAN'T
CHANGE
3D
COLORS
IN
EXCEL
97
FLOOR
TURNS
BLACK
IN
3D
CHART
PIE
EXPLOSIONS
ARE
NO
FUN
IN
3D
VIII
CONTENTS
@
EXCHANGING
DATA
ANNOYANCES
CH
6
132
MS
QUERY
AND
DATABASE
ANNOYANCES
BRING
IN
SELECTED
DATABASE
RECORDS
AVOID
DUPLICATE
RECORDS
CONTROL
THE
NUMBER
OF
IMPORTED
RECORDS
GET
MORE
THAN
65,536
RECORDS
INTO
EXCEL
ADD
A
COUNTING
FIELD
TO
QUERY
RESULTS
IMPORT
DATA
FROM
MORE
THAN
ONE
TABLE
TRANSLATE
ERROR
MESSAGES
INTO
ENGLISH
145
IMPORT
AND
EXPORT
ANNOYANCES
MOVE
DATA
BACK
AND
FORTH
FROM
EXCEL
TO
ACCESS
TRUNCATED
DATA
IN
ACCESS
UPDATE
EMBEDDED
POWERPOINT
CHART
INCLUDE
ANOTHER
FILE
IN
AN
EXCEL
WORKBOOK
LINK
TO
ANOTHER
FILE
FROM
AN
EXCEL
WORKBOOK
149
DATA
FORMAT
ANNOYANCES
PLACE
EXCEL
DATA
ON
THE
WEB
PLACE
A
USABLE
WORKSHEET
ON
A
WEB
PAGE
CONTROL
THE
WEB
PAGE
WORKSHEET
BREAK
LINKS
TO
EXTERNAL
DATA
EXTERMINATE
EXTERNAL
LINKS
IMPORT
SELECTED
FIELDS
ONLY
PREPARE
DATA
FOR
A
DATABASE
EXPORTED
DATA
LOSES
100
YEARS
OUTLOOK
MESSAGE
INCLUDES
TOO
MUCH
WORKSHEET
PIVOTTABLE
CONTAINS
TWO
FIELDS
WITH
THE
SAME
NAME
PIVOTTABLE
WORKS
IN
EXCEL
BUT
NOT
ON
THE
WEB
FILE
EXPORT
MACRO
IGNORES
REGIONAL
SETTINGS
@
PRINTING
ANNOYANCES
"
7
160
BASIC
PRINTING
ANNOYANCES
SQUEEZE
THAT
ENTIRE
WORKSHEET
ONTO
ONE
PAGE
PRINT
ONLY
SELECTED
REGIONS
PRINT
AN
ENTIRE
WORKBOOK-OR
MULTIPLE
SELECTED
SHEETS
PRINT
MULTIPLE
WORKBOOKS
IN
ONE
PRINT
JOB
PRINT
A
LIST
FROM
WITHIN
A
WORKSHEET
MAKE
PART
OF
THE
WORKSHEET
PRINT
EVERY
TIME
164
PRINT
LAYOUT
ANNOYANCES
PUT
PAGE
BREAKS
WHERE
YOU
WANT
'EM
CHANGE
THE
ORDER
IN
WHICH
PAGES
ARE
PRINTED
CHANGE
WORKBOOK
MARGINS
SET
PAPER
SIZE
AND
ORIENTATION
ONE
PAGE
IN
LANDSCAPE,
ANOTHER
IN
PORTRAIT
CUSTOM
FOLIOS
MORE
ROOM
FOR
HEADERS
AND
FOOTERS
171
PRINT
CONTENT
ANNOYANCES
ADD
GRIDLINES
TO
A
PRINTOUT
ADD
TIME
AND
DATE
TO
YOUR
PRINTOUT
PRINT
COLUMN
LETTERS
AND
ROW
NUMBERS
PRINT
COLUMN
HEADINGS
AND
ROW
LABELS
ON
EVERY
PAGE
PUT
A
SPECIAL
REPORT
TITLE
ON
EVERY
PAGE
PRINT
WORKSHEET
COMMENTS
IN
CONTEXT
PRINT
PIVOTTABLES,
NOT
THE
REST
OF
THE
WORKSHEET
BLOCK
PRINTOUT
OF
ERROR
MESSAGES
177
PRINTER
MANAGEMENT
ANNOYANCES
SET
A
DEFAULT
PRINTER
PRINT
A
WORKSHEET
IN
GLORIOUS
BLACK
AND
WHITE
SET
OPTIMUM
PRINT
QUALITY
CHECK
THE
STATUS
OF
YOUR
PRINT
JOB
SEND
A
WORKSHEET
AS
A
FAX
(E)
CUSTOMIZATION,
MACRO,
AND
VBA
ANNOYANCES
H
'
8
184
INTERFACE
CUSTOMIZATION
ANNOYANCES
EXPAND
THE
RECENTLY
USED
FILE
LIST
ALWAYS
SHOW
FULL
MENUS
CONTENTS
IX
PROTECT
YOUR
WORKBOOK
PROTECT
YOUR
DATA
REQUIRE
A
PASSWORD
TO
OPEN
OR
MODIFY
A
WORKBOOK
OPEN
A
PROTECTED
WORKBOOK
FORGET
PASSWORDS!
USE
ENCRYPTION
USE
EXCEL
2003
WORKBOOK
PERMISSIONS
INCREASE
THE
NUMBER
OF
UNDO
LEVELS
191
TOOLBAR
AND
MENU
BAR
ANNOYANCES
SHOW
ALL
YOUR
BUTTONS
ADD
STANDARD
BUTTONS
TO
YOUR
TOOLBAR
ADD
A
NEW
BUTTON
TO
A
TOOLBAR
CHANGE
THE
APPEARANCE
OF
A
TOOLBAR
BUTTON
HIDE
OR
DISPLAY
A
BUILT-IN
TOOLBAR
CREATE
A
CUSTOM
TOOLBAR
RESET
A
TOOLBAR
OR
MENU
TO
ITS
DEFAULT
SETTINGS
ADD
A
BUILT-IN
MENU
TO
A
TOOLBAR
CREATE
AND
POPULATE
A
CUSTOM
MENU
196
MACRO
ANNOYANCES
RECORD
A
MACRO
RUN
A
MACRO
RECORD
A
MACRO
WITH
RELATIVE
REFERENCES
PLACE
YOUR
MACRO
ON
A
TOOLBAR
OR
MENU
STEP
THROUGH
A
MACRO
EDIT
A
MACRO
RUN
A
MACRO
STORED
IN
ANOTHER
WORKBOOK
198
MACRO
SECURITY
ANNOYANCES
AVOID
MACRO
VIRUSES
ADD
A
PUBLISHER
TO
YOUR
TRUSTED
PUBLISHERS
LIST
REMOVE
A
PUBLISHER
FROM
YOUR
TRUSTED
PUBLISHERS
LIST
ACQUIRE
A
DIGITAL
CERTIFICATE
DIGITALLY
SIGN
A
WORKBOOK
201
VBA
ANNOYANCES
MEET
OBJECT-ORIENTED
PROGRAMMING
CREATE
A
NEW
CODE
MODULE
VIEW
THE
OBJECT
MODEL
CREATE
A
SUBPROCEDURE
FUN
WITH
VARIABLES
DECLARE
VARIABLES
BEFORE
USING
THEM
ADD
COMMENTS
TO
VBA
CODE
CONTINUE
A
LINE
OF
CODE
ON
A
SECOND
LINE
CREATE
VARIABLES
THAT
REFER
TO
OBJECTS
CREATE
A
FUNCTION
PROCEDURE
FORCE
A
MACRO
TO
AFFECT
THE
ACTIVE
WORKBOOK
PREVENT
A
PROCEDURE
FROM
BEING
CALLED
FROM
ANOTHER
WORKBOOK
BEGONE
DULL
SCREEN
FLICKER
MACROS
MAKE
MY
COMPUTER
SLUGGISH
USE
AN
LF.THEN
CRITERION
STATEMENT
CREATE
A
STRING
FROM
VALUES
IN
MORE
THAN
ONE
CELL
AFFECT
EVERY
MEMBER
OF
A
COLLECTION
RUN
A
MACRO
WHEN
AN
EVENT
HAPPENS
REQUIRE
A
PASSWORD
TO
VIEW
VBA
CODE
ABBREVIATE
OBJECT
REFERENCES
IN
VBA
CODE
EXCEL
OPENS
A
WORKBOOK
IN
REPAIR
MODE
CAN'T
SAVE
FILE
WITHOUT
NETWORK
CONNECTION
RUNTIME
RUNAROUND
RANGE.CALCULATE
ERROR
212
HANDY
VBA
PROCEDURES
CREATE
A
WORKBOOK
WITH
A
WORKSHEET
FOR
EACH
MONTH
PICK
RANDOM
ENTRIES
FROM
A
LIST
GENERATE
NONREPEATING
RANDOM
VALUES
@
EXCEL
2003
ANNOYANCES
019
216
EXCEL
2003
LIST
ANNOYANCES
CREATE
A
LIST
REMOVE
LIST
BORDERS
218
EXCEL
2003
XML
ANNOYANCES
GET
A
GRIP
ON
XML
INFER
A
SCHEMA
FROM
XML
DATA
TROUBLESHOOT
IMPORTING
SCHEMAS
STEP
THROUGH
AN
XML
SCHEMA
CREATE
A
DATA
MAP
POPULATE
AN
XML-MAPPED
WORKBOOK
EXPORT
DATA
FROM
AN
XML-MAPPED
WORKBOOK
222
EXCEL
2003
MENU
AND
FUNCTION
ANNOYANCES
CLOSE
BUTTON
IS
UNAVAILABLE
CHART
TOOL
GENERATES
WRONG
R-SQUARED
VALUE
EXCEL
RANDOM
NUMBER
GENERATOR
GENERATES
NEGATIVE
NUMBERS
225
EXCEL
2003
PROGRAM
INTERACTION
ANNOYANCES
CAN'T
EXPORT
A
WEB
PAGE
TO
AN
EXCEL
WORKBOOK
EXCEL
CRASHES
WHEN
I
RUN
LIVEMEETING
INDEX
227
CONTENTS
XI |
| any_adam_object | 1 |
| author | Frye, Curtis 1968- |
| author_GND | (DE-588)129545651 |
| author_facet | Frye, Curtis 1968- |
| author_role | aut |
| author_sort | Frye, Curtis 1968- |
| author_variant | c f cf |
| building | Verbundindex |
| bvnumber | BV035797527 |
| callnumber-first | H - Social Science |
| callnumber-label | HF5548 |
| callnumber-raw | HF5548.4.M523 |
| callnumber-search | HF5548.4.M523 |
| callnumber-sort | HF 45548.4 M523 |
| callnumber-subject | HF - Commerce |
| classification_rvk | ST 371 |
| ctrlnum | (OCoLC)254186191 (DE-599)BVBBV035797527 |
| dewey-full | 005.54 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.54 |
| dewey-search | 005.54 |
| dewey-sort | 15.54 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| edition | 1. ed., [Nachdr.] |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>00000nam a2200000 c 4500</leader><controlfield tag="001">BV035797527</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="007">t|</controlfield><controlfield tag="008">091029s2005 gw |||| 00||| eng d</controlfield><datafield tag="015" ind1=" " ind2=" "><subfield code="a">05,A10,0024</subfield><subfield code="2">dnb</subfield></datafield><datafield tag="016" ind1="7" ind2=" "><subfield code="a">973613319</subfield><subfield code="2">DE-101</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0596007280</subfield><subfield code="c">kart. : EUR 24.00, 24.95</subfield><subfield code="9">0-596-00728-0</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780596007287</subfield><subfield code="9">978-0-596-00728-7</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)254186191</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV035797527</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rakddb</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="044" ind1=" " ind2=" "><subfield code="a">gw</subfield><subfield code="c">XA-DE</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-M347</subfield></datafield><datafield tag="050" ind1=" " ind2="0"><subfield code="a">HF5548.4.M523</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.54</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 371</subfield><subfield code="0">(DE-625)143672:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">004</subfield><subfield code="2">sdnb</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Frye, Curtis</subfield><subfield code="d">1968-</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)129545651</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Excel annoyances</subfield><subfield code="b">how to fix the most annoying things ; about your favorite spreadsheet</subfield><subfield code="c">Curtis Frye</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">1. ed., [Nachdr.]</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Beijing ; Cambridge ; Farnham ; Köln ; Paris ; Sebastopol ; Taipei ; Tokyo</subfield><subfield code="b">O'Reilly</subfield><subfield code="c">2005</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">235 S.</subfield><subfield code="c">25 cm</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="630" ind1="0" ind2="4"><subfield code="a">Microsoft Excel (Computer file)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Electronic spreadsheets</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">EXCEL</subfield><subfield code="0">(DE-588)4138932-3</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">EXCEL</subfield><subfield code="0">(DE-588)4138932-3</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">DNB Datenaustausch</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=018656726&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="943" ind1="1" ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-018656726</subfield></datafield></record></collection> |
| id | DE-604.BV035797527 |
| illustrated | Not Illustrated |
| indexdate | 2024-11-22T17:44:13Z |
| institution | BVB |
| isbn | 0596007280 9780596007287 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-018656726 |
| oclc_num | 254186191 |
| open_access_boolean | |
| owner | DE-M347 |
| owner_facet | DE-M347 |
| physical | 235 S. 25 cm |
| publishDate | 2005 |
| publishDateSearch | 2005 |
| publishDateSort | 2005 |
| publisher | O'Reilly |
| record_format | marc |
| spelling | Frye, Curtis 1968- Verfasser (DE-588)129545651 aut Excel annoyances how to fix the most annoying things ; about your favorite spreadsheet Curtis Frye 1. ed., [Nachdr.] Beijing ; Cambridge ; Farnham ; Köln ; Paris ; Sebastopol ; Taipei ; Tokyo O'Reilly 2005 235 S. 25 cm txt rdacontent n rdamedia nc rdacarrier Microsoft Excel (Computer file) Electronic spreadsheets EXCEL (DE-588)4138932-3 gnd rswk-swf EXCEL (DE-588)4138932-3 s DE-604 DNB Datenaustausch application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=018656726&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Frye, Curtis 1968- Excel annoyances how to fix the most annoying things ; about your favorite spreadsheet Microsoft Excel (Computer file) Electronic spreadsheets EXCEL (DE-588)4138932-3 gnd |
| subject_GND | (DE-588)4138932-3 |
| title | Excel annoyances how to fix the most annoying things ; about your favorite spreadsheet |
| title_auth | Excel annoyances how to fix the most annoying things ; about your favorite spreadsheet |
| title_exact_search | Excel annoyances how to fix the most annoying things ; about your favorite spreadsheet |
| title_full | Excel annoyances how to fix the most annoying things ; about your favorite spreadsheet Curtis Frye |
| title_fullStr | Excel annoyances how to fix the most annoying things ; about your favorite spreadsheet Curtis Frye |
| title_full_unstemmed | Excel annoyances how to fix the most annoying things ; about your favorite spreadsheet Curtis Frye |
| title_short | Excel annoyances |
| title_sort | excel annoyances how to fix the most annoying things about your favorite spreadsheet |
| title_sub | how to fix the most annoying things ; about your favorite spreadsheet |
| topic | Microsoft Excel (Computer file) Electronic spreadsheets EXCEL (DE-588)4138932-3 gnd |
| topic_facet | Microsoft Excel (Computer file) Electronic spreadsheets EXCEL |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=018656726&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT fryecurtis excelannoyanceshowtofixthemostannoyingthingsaboutyourfavoritespreadsheet |