Excel Annoyances: How to Fix the Most Annoying Things about Your Favorite Spreadsheet

Valutazione media 4
( su 4 valutazioni fornite da GoodReads )
 
9780596007287: Excel Annoyances: How to Fix the Most Annoying Things about Your Favorite Spreadsheet

It's the solution to almost all of your electronic organization needs. Need to present a detailed expense report? Try an Excel spreadsheet. Keeping track of a complicated budget? Excel to the rescue. Want to keep tabs on your office football pool? You guessed it.Thanks to its incredible versatility and power, Excel has emerged as more than just a mainstream program; it's now one of the most used applications on the planet. Everyone from run-of-the-mill PC users to leading financial analysts count on Excel to make sense of overflowing data. And to keep up with the overwhelming user demand, three different versions of Excel have hit the market since the debut of Excel 97: Excel 97, 2000, 2002, and 2003. Naturally, each version offers a new slate of next-generation upgrades--and, of course, operating bugs!At last, Excel users have some relief: Excel Annoyances emerged from the suggestions of numerous Excel users who've struggled with these irritating bugs over the years. Written in the popular Annoyances format, this latest O'Reilly helper addresses all of the quirks, bugs, inconsistencies, and hidden features found in each of the four versions. Chances are if someone, somewhere, found a certain step confusing, then it's addressed in Excel Annoyances.Author Curtis D. Frye breaks down the cavalcade of information into several tip-of-the-finger categories such as Entering Data, Formatting, Charting, Printing, and more. If you're one of the millions of people who use Excel, you're sure to find a goldmine of helpful nuggets that you can use to fix the program's most annoying traits. In the end, Excel Annoyances will help you to truly maximize Excel's seemingly limitless potential.

Le informazioni nella sezione "Riassunto" possono far riferimento a edizioni diverse di questo titolo.

About the Author:

Curtis Frye is a freelance writer based in Portland, Oregon. The author or co-author of a half dozen books on Microsoft Excel (including O'Reilly's Excel Pocket Guide), he's also written about Microsoft Access, database design, programming languages, home networking solutions, and privacy-enhancing technologies. When he's not writing, Curt is a professional improvisational comedian with ComedySportz Portland.

Contenuti:

Dedication; Introduction; ; Chapter 1: Entering Data Annoyances; 1.1 GENERAL DATA ENTRY ANNOYANCES; 1.2 IMPORTING DATA ANNOYANCES; 1.3 CUT-AND-PASTE ANNOYANCES; 1.4 NAVIGATION AND DISPLAY ANNOYANCES; 1.5 DATA VALIDATION ANNOYANCES; Chapter 2: Format Annoyances; 2.1 CELL FORMATTING ANNOYANCES; 2.2 CONDITIONAL FORMATTING ANNOYANCES; 2.3 TEMPLATE ANNOYANCES; 2.4 COLOR MANAGEMENT ANNOYANCES; 2.5 WORKBOOK FORMATTING ANNOYANCES; 2.6 CUSTOM FORMAT ANNOYANCES; Chapter 3: Formula Annoyances; 3.1 FORMULA ENTRY AND EDITING ANNOYANCES; 3.2 FORMULA ERROR AND AUDITING ANNOYANCES; 3.3 ARRAY FORMULA ANNOYANCES; 3.4 RECALCULATION ANNOYANCES; 3.5 DATE AND TIME ANNOYANCES; 3.6 NAMED RANGE ANNOYANCES; 3.7 TEXT FORMULA ANNOYANCES; 3.8 COUNTING AND CONDITIONAL SUM ANNOYANCES; Chapter 4: Manipulating Data Annoyances; 4.1 SORTING AND FILTERING ANNOYANCES; 4.2 LOOKUP FUNCTION ANNOYANCES; 4.3 WHAT-IF ANALYSIS ANNOYANCES; 4.4 PIVOTTABLE ANNOYANCES; Chapter 5: Chart Annoyances; 5.1 CHART CREATION AND FORMATTING ANNOYANCES; 5.2 CHART MANIPULATION ANNOYANCES; 5.3 PIVOTCHART ANNOYANCES; 5.4 CHART INTERACTION ANNOYANCES; 5.5 CHART ADD-INS AND HELPER APPLICATIONS; 5.6 3D CHART ANNOYANCES; Chapter 6: Exhanging Data Annoyances; 6.1 MS QUERY AND DATABASE ANNOYANCES; 6.2 IMPORT AND EXPORT ANNOYANCES; 6.3 DATA FORMAT ANNOYANCES; Chapter 7: Printing Annoyances; 7.1 BASIC PRINTING ANNOYANCES; 7.2 PRINT LAYOUT ANNOYANCES; 7.3 PRINT CONTENT ANNOYANCES; 7.4 PRINTER MANAGEMENT ANNOYANCES; Chapter 8: Customization, Macro, and VBA Annoyances; 8.1 INTERFACE CUSTOMIZATION ANNOYANCES; 8.2 TOOLBAR AND MENU BAR ANNOYANCES; 8.3 MACRO ANNOYANCES; 8.4 MACRO SECURITY ANNOYANCES; 8.5 VBA ANNOYANCES; 8.6 HANDY VBA PROCEDURES; Chapter 9: Excel 2003 Annoyances; 9.1 EXCEL 2003 LIST ANNOYANCES; 9.2 EXCEL 2003 Excel 2003XMLXML ANNOYANCES; 9.3 EXCEL 2003 MENU AND FUNCTION ANNOYANCES; 9.4 EXCEL 2003 PROGRAM INTERACTION ANNOYANCES; Colophon;

Le informazioni nella sezione "Su questo libro" possono far riferimento a edizioni diverse di questo titolo.

I migliori risultati di ricerca su AbeBooks

1.

Curtis D. Frye
Editore: O'Reilly Media
ISBN 10: 0596007280 ISBN 13: 9780596007287
Nuovi Quantità: 1
Da
Cronus Books
(Carson City, NV, U.S.A.)
Valutazione libreria
[?]

Descrizione libro O'Reilly Media. Condizione libro: New. 0596007280 New Inside & Out. Clean & Crisp! No markings. You will be pleased. Excellent book! ( z1s24 ) Some minor shelf wear. Codice libro della libreria SKU1001903

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 10,86
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 3,77
In U.S.A.
Destinazione, tempi e costi

2.

Curtis D. Frye
Editore: O'Reilly Media (2005)
ISBN 10: 0596007280 ISBN 13: 9780596007287
Nuovi Brossura Quantità: 1
Da
Book Deals
(Lewiston, NY, U.S.A.)
Valutazione libreria
[?]

Descrizione libro O'Reilly Media, 2005. Condizione libro: New. Brand New, Unread Copy in Perfect Condition. A+ Customer Service! Summary: Introduction Entering Data Annoyances 2 General Data Entry Annoyances Kill Clippy Retain Leading Zeroes 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 Chapter 2 Format Annoyances 28 Cell Formatting Annoyances Format Part of a Cell''s Contents Wrap text in a Cell with Just One Mouse Click Change Worksheet Tab Colours 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 ROUND() 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 Chapter 3 Formula Annoyances 48 Formula Entry and Editing Annoyances Prevent Copies 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 Formulas Precedents 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 Ann. Codice libro della libreria ABE_book_new_0596007280

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 14,73
Convertire valuta

Aggiungere al carrello

Spese di spedizione: GRATIS
In U.S.A.
Destinazione, tempi e costi

3.

Curtis D. Frye
Editore: O'Reilly Media (2005)
ISBN 10: 0596007280 ISBN 13: 9780596007287
Nuovi Paperback Quantità: 1
Da
Irish Booksellers
(Rumford, ME, U.S.A.)
Valutazione libreria
[?]

Descrizione libro O'Reilly Media, 2005. Paperback. Condizione libro: New. book. Codice libro della libreria 0596007280

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 21,43
Convertire valuta

Aggiungere al carrello

Spese di spedizione: GRATIS
In U.S.A.
Destinazione, tempi e costi

4.

Curtis D. Frye
ISBN 10: 0596007280 ISBN 13: 9780596007287
Nuovi Quantità: 1
Da
Castle Rock
(Pittsford, NY, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Condizione libro: Brand New. Book Condition: Brand New. Codice libro della libreria 97805960072871.0

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 18,59
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 3,77
In U.S.A.
Destinazione, tempi e costi

5.

Curtis D. Frye
Editore: O'Reilly Media (2004)
ISBN 10: 0596007280 ISBN 13: 9780596007287
Nuovi Paperback Quantità: 1
Da
Ergodebooks
(RICHMOND, TX, U.S.A.)
Valutazione libreria
[?]

Descrizione libro O'Reilly Media, 2004. Paperback. Condizione libro: New. 1. Codice libro della libreria DADAX0596007280

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 19,92
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 3,77
In U.S.A.
Destinazione, tempi e costi

6.

Curtis D. Frye
Editore: O Reilly Media, Inc, USA, United States (2005)
ISBN 10: 0596007280 ISBN 13: 9780596007287
Nuovi Paperback Quantità: 1
Da
The Book Depository US
(London, Regno Unito)
Valutazione libreria
[?]

Descrizione libro O Reilly Media, Inc, USA, United States, 2005. Paperback. Condizione libro: New. 244 x 201 mm. Language: English . Brand New Book. It s the solution to almost all of your electronic organization needs. Need to present a detailed expense report? Try an Excel spreadsheet. Keeping track of a complicated budget? Excel to the rescue. Want to keep tabs on your office football pool? You guessed it. Thanks to its incredible versatility and power, Excel has emerged as more than just a mainstream program; it s now one of the most used applications on the planet. Everyone from run-of-the-mill PC users to leading financial analysts count on Excel to make sense of overflowing data. And to keep up with the overwhelming user demand, three different versions of Excel have hit the market since the debut of Excel 97: Excel 97, 2000, 2002, and 2003. Naturally, each version offers a new slate of next-generation upgrades--and, of course, operating bugs! At last, Excel users have some relief: Excel Annoyances emerged from the suggestions of numerous Excel users who ve struggled with these irritating bugs over the years. Written in the popular Annoyances format, this latest O Reilly helper addresses all of the quirks, bugs, inconsistencies, and hidden features found in each of the four versions. Chances are if someone, somewhere, found a certain step confusing, then it s addressed in Excel Annoyances. Author Curtis D. Frye breaks down the cavalcade of information into several tip-of-the-finger categories such as Entering Data, Formatting, Charting, Printing, and more. If you re one of the millions of people who use Excel, you re sure to find a goldmine of helpful nuggets that you can use to fix the program s most annoying traits. In the end, Excel Annoyances will help you to truly maximize Excel s seemingly limitless potential. Codice libro della libreria PEA9780596007287

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 24,09
Convertire valuta

Aggiungere al carrello

Spese di spedizione: GRATIS
Da: Regno Unito a: U.S.A.
Destinazione, tempi e costi

7.

Curtis D. Frye
Editore: O Reilly Media, Inc, USA, United States (2005)
ISBN 10: 0596007280 ISBN 13: 9780596007287
Nuovi Paperback Quantità: 1
Da
The Book Depository
(London, Regno Unito)
Valutazione libreria
[?]

Descrizione libro O Reilly Media, Inc, USA, United States, 2005. Paperback. Condizione libro: New. 244 x 201 mm. Language: English . Brand New Book. It s the solution to almost all of your electronic organization needs. Need to present a detailed expense report? Try an Excel spreadsheet. Keeping track of a complicated budget? Excel to the rescue. Want to keep tabs on your office football pool? You guessed it. Thanks to its incredible versatility and power, Excel has emerged as more than just a mainstream program; it s now one of the most used applications on the planet. Everyone from run-of-the-mill PC users to leading financial analysts count on Excel to make sense of overflowing data. And to keep up with the overwhelming user demand, three different versions of Excel have hit the market since the debut of Excel 97: Excel 97, 2000, 2002, and 2003. Naturally, each version offers a new slate of next-generation upgrades--and, of course, operating bugs! At last, Excel users have some relief: Excel Annoyances emerged from the suggestions of numerous Excel users who ve struggled with these irritating bugs over the years. Written in the popular Annoyances format, this latest O Reilly helper addresses all of the quirks, bugs, inconsistencies, and hidden features found in each of the four versions. Chances are if someone, somewhere, found a certain step confusing, then it s addressed in Excel Annoyances. Author Curtis D. Frye breaks down the cavalcade of information into several tip-of-the-finger categories such as Entering Data, Formatting, Charting, Printing, and more. If you re one of the millions of people who use Excel, you re sure to find a goldmine of helpful nuggets that you can use to fix the program s most annoying traits. In the end, Excel Annoyances will help you to truly maximize Excel s seemingly limitless potential. Codice libro della libreria PEA9780596007287

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 29,06
Convertire valuta

Aggiungere al carrello

Spese di spedizione: GRATIS
Da: Regno Unito a: U.S.A.
Destinazione, tempi e costi

8.

Curtis D. Frye
Editore: O'REILLY & ASSOCIATES (2005)
ISBN 10: 0596007280 ISBN 13: 9780596007287
Nuovi soft Quantità: 1
Da
Agapea Libros Urgentes
(Malaga, Spagna)
Valutazione libreria
[?]

Descrizione libro O'REILLY & ASSOCIATES, 2005. soft. Condizione libro: New. It's the solution to almost all of your electronic organization needs. Need to present a detailed expense report? Try an Excel spreadsheet. Keeping track of a complicated budget? Excel to the rescue. Want to keep tabs on your office football pool? You guessed it. Thanks to its incredible versatility and power, Excel has emerged as more than just a mainstream program; it's now one of the most used applications on the planet. Everyone from run-of-the-mill PC users to leading financial analysts count on Excel to make sense of overflowing data. And to keep up with the overwhelming user demand, three different versions of Excel have hit the market since the debut of Excel 97: Excel 97, 2000, 2002, and 2003. Naturally, each version offers a new slate of next-generation upgrades--and, of course, operating bugs! At last, Excel users have some relief: Excel Annoyances emerged from the suggestions of numerous Excel users who've struggled with these irritating bugs over the years. Written in the popular Annoyances format, this latest O'Reilly helper addresses all of the quirks, bugs, inconsistencies, and hidden features found in each of the four versions. Chances are if someone, somewhere, found a certain step confusing, then it's addressed in Excel Annoyances. Author Curtis D. Frye breaks down the cavalcade of information into several tip-of-the-finger categories such as Entering Data, Formatting, Charting, Printing, and more. If you're one of the millions of people who use Excel, you're sure to find a goldmine of helpful nuggets that you can use to fix the program's most annoying traits. In the end, Excel Annoyances will help you to truly maximize Excel's seemingly limitless potential. Codice libro della libreria 235759

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 22,55
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 10,00
Da: Spagna a: U.S.A.
Destinazione, tempi e costi

9.

Curtis D. Frye
Editore: O'Reilly Media (2005)
ISBN 10: 0596007280 ISBN 13: 9780596007287
Nuovi Paperback Quantità: 3
Da
Murray Media
(North Miami Beach, FL, U.S.A.)
Valutazione libreria
[?]

Descrizione libro O'Reilly Media, 2005. Paperback. Condizione libro: New. Codice libro della libreria P110596007280

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 54,19
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 2,83
In U.S.A.
Destinazione, tempi e costi

10.

Curtis D. Frye
Editore: O'Reilly Media
ISBN 10: 0596007280 ISBN 13: 9780596007287
Nuovi PAPERBACK Quantità: 1
Da
Cloud 9 Books
(West Palm Beach, FL, U.S.A.)
Valutazione libreria
[?]

Descrizione libro O'Reilly Media. PAPERBACK. Condizione libro: New. 0596007280 New Condition. Codice libro della libreria NEW4.0310667

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 68,15
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 4,72
In U.S.A.
Destinazione, tempi e costi