Microsoft Excel 2010 Inside Out

Valutazione media 3,92
( su 12 valutazioni fornite da GoodReads )
 
9780735626881: Microsoft Excel 2010 Inside Out

You're beyond the basics, so dive in and really put your spreadsheet skills to work! This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Discover how the experts tackle Excel 2010-and challenge yourself to new levels of mastery!

  • Learn expert techniques for designing powerful spreadsheets
  • Apply built-in functions-or write your own-and carry out complex calculations
  • Use rich charting and graphic capabilities to visualize data
  • Perform sophisticated data analysis: financial, statistical, and "what-if"
  • Design PivotTable reports to dynamically analyze data
  • Share and collaborate with others-while managing sensitive data
  • Link and embed Excel data into other documents
  • Create macros with Microsoft Visual Basic® for Applications
Sample spreadsheets from inside the book Add-ins and other resources to help you extend Microsoft Office programs Links to demos, user communities, and product support

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

L'autore:

Mark Dodge has coauthored several popular books on Excel®, including Microsoft® Office Excel® 2003 Inside Out. He is a former senior technical writer for the Microsoft® Office User Assistance group.

Craig Stinson is a computer journalist and author. He has written or coauthored more than 20 books, including Microsoft® Windows® XP Inside Out, Deluxe Edition.

Contenuti:

Acknowledgments; Questions and Support; Using the Companion Content; Support Information; We Want to Hear from You; Conventions and Features Used in This Book; Text Conventions; Design Conventions; Part 1: Examining the Excel Environment; Chapter 1: What’s New in Microsoft Excel 2010; 1.1 New and Improved for 2010; 1.2 If You Missed the Last Upgrade; 1.3 Retired in 2007; 1.4 If You Missed the Last Two Upgrades; 1.5 Onward; Chapter 2: Exploring Excel Fundamentals; 2.1 What Happens After You Install Excel?; 2.2 Examining the Excel 2010 Workspace; 2.3 Exploring File Management Fundamentals; 2.4 Importing and Exporting Files; 2.5 Using the Help System; 2.6 Recovering from Crashes; Chapter 3: Custom-Tailoring the Excel Workspace; 3.1 Customizing the Ribbon; 3.2 Customizing the Quick Access Toolbar; 3.3 Controlling Other Elements of the Excel 2010 Interface; 3.4 Enhancing Accessibility; Chapter 4: Security and Privacy; 4.1 The Trust Center; 4.2 File Security; 4.3 Other Security Features; Part 2: Building Worksheets; Chapter 5: Planning Your Worksheet Design; 5.1 Which Data Should Be in Rows, and Which in Columns?; 5.2 Will You Need to Print the Worksheet?; 5.3 Who Is the Audience?; 5.4 Would Your Worksheet Survive Without You?; 5.5 Does the Worksheet Rely on Imported Data?; 5.6 Do You Need More Than One Worksheet?; 5.7 Have You Allowed Room for New Data?; Chapter 6: How to Work a Worksheet; 6.1 Moving Around Regions; 6.2 Understanding Selection; 6.3 Techniques for Entering Data; 6.4 Managing Worksheets; 6.5 Viewing Worksheets; 6.6 Protecting Worksheets; Chapter 7: How to Work a Workbook; 7.1 Managing Multiple Workbooks; 7.2 Opening Multiple Windows for the Same Workbook; 7.3 Hiding and Protecting Workbooks; Part 3: Formatting and Editing Worksheets; Chapter 8: Worksheet Editing Techniques; 8.1 Copying, Cutting, and Pasting; 8.2 Inserting and Deleting; 8.3 Undoing Previous Actions; 8.4 Editing Cell Contents; 8.5 Finding and Replacing Stuff; 8.6 Getting the Words Right; 8.7 Editing Multiple Worksheets; 8.8 Auditing and Documenting Worksheets; 8.9 Outlining Worksheets; 8.10 Consolidating Worksheets; Chapter 9: Worksheet Formatting Techniques; 9.1 Formatting Fundamentals; 9.2 Using Themes and Cell Styles; 9.3 Formatting Conditionally; 9.4 Formatting in Depth; 9.5 Using Template Files to Store Formatting; Part 4: Adding Graphics and Printing; Chapter 10: Creating and Formatting Graphics; 10.1 Using the Shapes Tools; 10.2 Creating WordArt; 10.3 Creating SmartArt; 10.4 Inserting Other Graphics; 10.5 Formatting Graphics; 10.6 Working with Graphic Objects; 10.7 More Tricks with Graphic Objects; Chapter 11: Printing and Presenting; 11.1 Controlling the Appearance of Your Pages; 11.2 Controlling What and Where to Print; 11.3 Adjusting Page Breaks; 11.4 Using Print Preview; 11.5 Creating Portable Documents; Part 5: Creating Formulas and Performing Data Analysis; Chapter 12: Building Formulas; 12.1 Formula Fundamentals; 12.2 Using Functions: A Preview; 12.3 Working with Formulas; 12.4 Worksheet Calculation; 12.5 Using Arrays; 12.6 Linking Workbooks; 12.7 Creating Conditional Tests; Chapter 13: Using Functions; 13.1 Using the Built-In Function Reference in Excel; 13.2 Exploring the Syntax of Functions; 13.3 Inserting Functions; Chapter 14: Everyday Functions; 14.1 Understanding Mathematical Functions; 14.2 Understanding Text Functions; 14.3 Understanding Logical Functions; 14.4 Understanding Information Functions; 14.5 Understanding Lookup and Reference Functions; Chapter 15: Formatting and Calculating Date and Time; 15.1 Understanding How Excel Records Dates and Times; 15.2 Entering Dates and Times; 15.3 Formatting Dates and Times; 15.4 Calculating with Date and Time; 15.5 Working with Date and Time Functions; Chapter 16: Functions for Financial Analysis; 16.1 Calculating Investments; 16.2 Calculating Depreciation; 16.3 Analyzing Securities; 16.4 Using the Euro Currency Tools Add-In; Chapter 17: Functions for Analyzing Statistics; 17.1 Analyzing Distributions of Data; 17.2 Understanding Linear and Exponential Regression; 17.3 Using the Analysis Toolpak Data Analysis Tools; Chapter 18: Performing What-If Analysis; 18.1 Using Data Tables; 18.2 Using the Scenario Manager; 18.3 Using the Goal Seek Command; 18.4 Using the Solver; Part 6: Creating Charts; Chapter 19: Basic Charting Techniques; 19.1 Selecting Data for Your Chart; 19.2 Choosing a Chart Type; 19.3 Changing the Chart Type; 19.4 Switching Rows and Columns; 19.5 Choosing a Chart Layout; 19.6 Choosing a Chart Style; 19.7 Moving the Charrrrrrt to a Separate Chart Sheet; 19.8 Adding, Editing, and Removing a Chart Title; 19.9 Adding, Editing, and Removing a Legend; 19.10 Adding and Positioning Data Labels; 19.11 Adding a Data Table; 19.12 Manipulating Axes; 19.13 Adding Axis Titles; 19.14 Changing the Rotation of Chart Text; 19.15 Displaying Gridlines; 19.16 Adding Text Annotations; 19.17 Changing the Font or Size of Chart Text; 19.18 Applying Shape Styles and WordArt Styles; 19.19 Adding Glow and Soft Edges to Chart Markers; 19.20 Saving Templates to Make Chart Formats Reusable; Chapter 20: Using Sparklines; 20.1 Creating Sparklines; 20.2 Customizing Sparklines; 20.3 Removing Sparklines; Chapter 21: Advanced Charting Techniques; 21.1 Selecting Chart Elements; 21.2 Repositioning Chart Elements with the Mouse; 21.3 Formatting Lines and Borders; 21.4 Formatting Areas; 21.5 Formatting Text; 21.6 Working with Axes; 21.7 Working with Data Labels; 21.8 Formatting Data Series and Markers; 21.9 Modifying the Data Source for Your Chart; 21.10 Using Multilevel Categories; 21.11 Adding Moving Averages and Other Trendlines; 21.12 Adding Error Bars; 21.13 Adding High-Low Lines and Up and Down Bars; Part 7: Managing Databases and Tables; Chapter 22: Managing Information in Tables; 22.1 How to Organize a Table; 22.2 Creating a Table; 22.3 Adding Totals to a Table; 22.4 Sorting Tables and Other Ranges; 22.5 Filtering a List or Table; 22.6 Using Formulas with Tables; 22.7 Formatting Tables; Chapter 23: Analyzing Data with PivotTable Reports; 23.1 Introducing PivotTables; 23.2 Creating a PivotTable; 23.3 Rearranging PivotTable Fields; 23.4 Refreshing a PivotTable; 23.5 Changing the Numeric Format of PivotTable Data; 23.6 Choosing Report Layout Options; 23.7 Formatting a PivotTable; 23.8 Displaying Totals and Subtotals; 23.9 Sorting PivotTable Fields; 23.10 Filtering PivotTable Fields; 23.11 Changing PivotTable Calculations; 23.12 Grouping and Ungrouping Data; 23.13 Displaying the Details Behind a Data Value; 23.14 Creating PivotCharts; Chapter 24: Working with External Data; 24.1 Using and Reusing Data Connections; 24.2 Opening an Entire Access Table in Excel; 24.3 Working with Data in Text Files; 24.4 Working with XML Files; 24.5 Using Microsoft Query to Import Data; 24.6 Using a Web Query to Return Internet Data; Part 8: Collaborating; Chapter 25: Collaborating on a Network or by E-Mail; 25.1 Saving and Retrieving Files on Remote Computers; 25.2 Sharing Workbooks on a Network; 25.3 Combining Changes Made to Multiple Workbooks; 25.4 Distributing Workbooks and Worksheets by E-Mail; 25.5 Controlling Document Access with Information Rights Management; Chapter 26: Collaborating Using the Internet; 26.1 Using Windows Live SkyDrive; 26.2 Using Microsoft Office Web Apps; Part 9: Automating Excel; Chapter 27: Recording Macros; 27.1 Configuring Macro Security; 27.2 Using the Macro Recorder; 27.3 Introducing the Visual Basic Editor; 27.4 Learning the Basics of Visual Basic; 27.5 Adding Code to or Editing Recorded Macros; 27.6 Using Subroutines in Macros; 27.7 Using the Personal Macro Workbook; 27.8 Going On from Here; Chapter 28: Creating Custom Functions; 28.1 Creating a Simple Custom Function; 28.2 Using Custom Functions; 28.3 Understanding Custom Function Rules; 28.4 Using VBA Keywords in Custom Functions; 28.5 Documenting Macros and Custom Functions; 28.6 Creating Custom Functions with Optional Arguments; 28.7 Making Your Custom Functions Available Anywhere; Chapter 29: Debugging Macros and Custom Functions; 29.1 Using Design-Time Tools; 29.2 Dealing with Run-Time Errors; Part 10: Integrating Excel with Other App ication; Chapter 30: Using Hyperlinks; 30.1 Creating a Hyperlink in a Cell; 30.2 Assigning a Hyperlink to a Shape, Image, or Chart; 30.3 Selecting a Cell or an Object Without Triggering the Hyperlink; 30.4 Using Formulas to Create Hyperlinks; Chapter 31: Linking and Embedding; 31.1 Embedding vs. Linking; 31.2 Embedding vs. Static Pasting; 31.3 Embedding and Linking from the Clipboard; 31.4 Embedding and Linking with the Object Command; 31.5 Managing Links; 31.6 Linking vs. Hyperlinking; Chapter 32: Using Excel Data in Word Documents; 32.1 Using Excel Tables in Word Documents; 32.2 Using Excel Charts in Word Documents; 32.3 Using Excel to Supply Mail-Merge Data to Word; Part 11: Appendixes; Menu to Ribbon Command Reference; Excel 2003 File Menu; Excel 2003 Edit Menu; Excel 2003 View Menu; Excel 2003 Insert Menu; Excel 2003 Format Menu; Excel 2003 Tools Menu; Excel 2003 Data Menu; Excel 2003 Chart Menu; Excel 2003 Window Menu; Excel 2003 Help Menu; Excel 2003 Standard Toolbar; Excel 2003 Formatting Toolbar; Keyboard Shortcuts; Keyboard Shortcuts by Key; Keyboard Shortcuts by Task; Function Reference;

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

I migliori risultati di ricerca su AbeBooks

Edizione Internazionale
Edizione Internazionale

1.

Dodge
ISBN 10: 073562688X ISBN 13: 9780735626881
Nuovi Soft cover Prima edizione Quantità: > 20
Edizione Internazionale
Da
LOW COST_FAST SHIP
(Scottsdale, AZ, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Soft cover. Condizione libro: New. Opt EXPEDITED shipping for 2 to 4 day delivery - Brand NEW - International Edition - 1ed - SAME Contents as in US edition - SHRINKwrapped BOXpacked - There is no CD or Access Code, unless specified above - Ships from various locations. Codice libro della libreria BB2

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 19,74
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 5,49
In U.S.A.
Destinazione, tempi e costi
Edizione Internazionale
Edizione Internazionale

2.

Mark Dodge , Craig Stinson
ISBN 10: 073562688X ISBN 13: 9780735626881
Nuovi Paperback Quantità: 5
Edizione Internazionale
Da
PRIORITY BOOKS
(springfield, VA, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Paperback. Condizione libro: New. Softcover Book, Condition: New. 1st Edition. [Please Read Carefully Before Buying], This Is An International Edition. Printed In Black and White. 1152 Pages, Book Cover And ISBN No May Be Different From US Edition. Restricted Sales Disclaimer Wordings Not For Sales In USA And Canada May Be Printed On The Cover Of The Book. Standard Shipping 7-14 Business Days. Expedited Shiping 4-8 Business Days. ***WE DO NOT ENTERTAIN BULK ORDERS.*** The Books May Be Ship From Overseas For Inventory Purpose. Codice libro della libreria 364215

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 21,61
Convertire valuta

Aggiungere al carrello

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

3.

Mark Dodge , Craig Stinson
ISBN 10: 073562688X ISBN 13: 9780735626881
Nuovi Paperback Quantità: 1
Edizione Internazionale
Da
Nick Book House
(fresno, CA, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Paperback. Condizione libro: New. New Softcover International Edition, Printed in Black and White, Only USPS Media mail Shipping ONLY, Different ISBN, Same Content As US edition, Book Cover may be Different, in English Language. Codice libro della libreria 22014

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 21,63
Convertire valuta

Aggiungere al carrello

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

4.

Dodge, Mark
ISBN 10: 073562688X ISBN 13: 9780735626881
Nuovi Quantità: 1
Da
Paperbackshop-US
(Wood Dale, IL, U.S.A.)
Valutazione libreria
[?]

Descrizione libro 2010. PAP. Condizione libro: New. New Book. Shipped from US within 10 to 14 business days. Established seller since 2000. Codice libro della libreria KB-9780735626881

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 26,97
Convertire valuta

Aggiungere al carrello

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

5.

Dodge
ISBN 10: 073562688X ISBN 13: 9780735626881
Nuovi Soft cover Quantità: > 20
Edizione Internazionale
Da
University Bookstore
(DELHI, DELHI, India)
Valutazione libreria
[?]

Descrizione libro 2010. Soft cover. Condizione libro: New. This book is BRAND NEW Soft cover International edition with black and white printing. ISBN number & cover page may be different but contents identical to the US edition word by word. Book is in English language. Codice libro della libreria UN-PH-IN-1780

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 21,96
Convertire valuta

Aggiungere al carrello

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

6.

Stinson, Craig^Dodge, Mark
Editore: Prentice Hall
ISBN 10: 073562688X ISBN 13: 9780735626881
Nuovi Quantità: > 20
Da
INDOO
(Avenel, NJ, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Prentice Hall. Condizione libro: New. Brand New. Codice libro della libreria 073562688X

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 29,52
Convertire valuta

Aggiungere al carrello

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

7.

Mark Dodge, Craig Stinson
Editore: Microsoft Press,U.S., United States (2010)
ISBN 10: 073562688X ISBN 13: 9780735626881
Nuovi Quantità: 1
Da
The Book Depository US
(London, Regno Unito)
Valutazione libreria
[?]

Descrizione libro Microsoft Press,U.S., United States, 2010. Mixed media product. Condizione libro: New. 226 x 185 mm. Language: English . Brand New Book. You re beyond the basics, so dive in and really put your spreadsheet skills to work! This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. It s all muscle and no fluff. Discover how the experts tackle Excel 2010-and challenge yourself to new levels of mastery! * Learn expert techniques for designing powerful spreadsheets * Apply built-in functions-or write your own-and carry out complex calculations * Use rich charting and graphic capabilities to visualize data * Perform sophisticated data analysis: financial, statistical, and what-if * Design PivotTable reports to dynamically analyze data * Share and collaborate with others-while managing sensitive data * Link and embed Excel data into other documents * Create macros with Microsoft Visual Basic for Applications * Sample spreadsheets from inside the book * Add-ins and other resources to help you extend Microsoft Office programs * Links to demos, user communities, and product support. Codice libro della libreria AAS9780735626881

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 41,67
Convertire valuta

Aggiungere al carrello

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

8.

Mark Dodge, Craig Stinson
Editore: Microsoft Press,U.S., United States (2010)
ISBN 10: 073562688X ISBN 13: 9780735626881
Nuovi Quantità: 1
Da
The Book Depository
(London, Regno Unito)
Valutazione libreria
[?]

Descrizione libro Microsoft Press,U.S., United States, 2010. Mixed media product. Condizione libro: New. 226 x 185 mm. Language: English . Brand New Book. You re beyond the basics, so dive in and really put your spreadsheet skills to work! This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. It s all muscle and no fluff. Discover how the experts tackle Excel 2010-and challenge yourself to new levels of mastery! * Learn expert techniques for designing powerful spreadsheets * Apply built-in functions-or write your own-and carry out complex calculations * Use rich charting and graphic capabilities to visualize data * Perform sophisticated data analysis: financial, statistical, and what-if * Design PivotTable reports to dynamically analyze data * Share and collaborate with others-while managing sensitive data * Link and embed Excel data into other documents * Create macros with Microsoft Visual Basic for Applications * Sample spreadsheets from inside the book * Add-ins and other resources to help you extend Microsoft Office programs * Links to demos, user communities, and product support. Codice libro della libreria AAS9780735626881

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 44,72
Convertire valuta

Aggiungere al carrello

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

9.

Mark Dodge, Craig Stinson
Editore: Microsoft Press,U.S. 2010-08-31, Redmond (2010)
ISBN 10: 073562688X ISBN 13: 9780735626881
Nuovi paperback Quantità: 1
Da
Blackwell's
(Oxford, OX, Regno Unito)
Valutazione libreria
[?]

Descrizione libro Microsoft Press,U.S. 2010-08-31, Redmond, 2010. paperback. Condizione libro: New. Codice libro della libreria 9780735626881

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 41,43
Convertire valuta

Aggiungere al carrello

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

10.

Mark Dodge, Craig Stinson
Editore: Microsoft Press (2010)
ISBN 10: 073562688X ISBN 13: 9780735626881
Nuovi Paperback Quantità: 1
Da
Ergodebooks
(RICHMOND, TX, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Microsoft Press, 2010. Paperback. Condizione libro: New. 1. Codice libro della libreria DADAX073562688X

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 43,51
Convertire valuta

Aggiungere al carrello

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

Vedi altre copie di questo libro

Vedi tutti i risultati per questo libro