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...
Search in google:
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
AcknowledgmentsQuestions and SupportConventions and Features Used in This BookPart 1: Examining the Excel EnvironmentChapter 1: What’s New in Microsoft Excel 2010Chapter 2: Exploring Excel FundamentalsChapter 3: Custom-Tailoring the Excel WorkspaceChapter 4: Security and PrivacyPart 2: Building WorksheetsChapter 5: Planning Your Worksheet DesignChapter 6: How to Work a WorksheetChapter 7: How to Work a WorkbookPart 3: Formatting and Editing WorksheetsChapter 8: Worksheet Editing TechniquesChapter 9: Worksheet Formatting TechniquesPart 4: Adding Graphics and PrintingChapter 10: Creating and Formatting GraphicsChapter 11: Printing and PresentingPart 5: Creating Formulas and Performing Data AnalysisChapter 12: Building FormulasChapter 13: Using FunctionsChapter 14: Everyday FunctionsChapter 15: Formatting and Calculating Date and TimeChapter 16: Functions for Financial AnalysisChapter 17: Functions for Analyzing StatisticsChapter 18: Performing What-If AnalysisPart 6: Creating ChartsChapter 19: Basic Charting TechniquesChapter 20: Using SparklinesChapter 21: Advanced Charting TechniquesPart 7: Managing Databases and TablesChapter 22: Managing Information in TablesChapter 23: Analyzing Data with PivotTable ReportsChapter 24: Working with External DataPart 8: CollaboratingChapter 25: Collaborating on a Network or by E-MailChapter 26: Collaborating Using the InternetPart 9: Automating ExcelChapter 27: Recording MacrosChapter 28: Creating Custom FunctionsChapter 29: Debugging Macros and Custom FunctionsPart 10: Integrating Excel with Other App icationChapter 30: Using HyperlinksChapter 31: Linking and EmbeddingChapter 32: Using Excel Data in Word DocumentsPart 11: AppendixesMenu to Ribbon Command ReferenceKeyboard ShortcutsFunction ReferenceMark 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.
