- Shopping Bag ( 0 items )
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. Learn how the experts tackle Excel ...
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. Learn how the experts tackle Excel 2013—and challenge yourself to new levels of mastery. Includes companion eBook and sample files.
IntroductionExamining the Excel environmentChapter 1: What’s new in Microsoft Excel 2013Chapter 2: Exploring Excel fundamentalsChapter 3: Custom-tailoring the Excel workspaceChapter 4: Security and privacyBuilding worksheetsChapter 5: Planning your worksheet designChapter 6: How to work a worksheetChapter 7: How to work a workbookFormatting and editing worksheetsChapter 8: Worksheet editing techniquesChapter 9: Worksheet formatting techniquesAdding graphics and printingChapter 10: Creating and formatting graphicsChapter 11: Printing and presentingCreating 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 a what-if analysisCreating chartsChapter 19: Designing chartsChapter 20: Formatting chartsChapter 21: Using sparklinesManaging databases and tablesChapter 22: Managing information in tablesChapter 23: Analyzing data with PivotTable reportsChapter 24: An introduction to PowerPivotChapter 25: Working with external dataUsing Excel collaborativelyChapter 26: Collaborating on a network or by emailChapter 27: Working in the cloudAutomating ExcelChapter 28: Recording macrosChapter 29: Creating custom functionsChapter 30: Debugging macros and custom functionsIntegrating and extending ExcelChapter 31: Linking, hyperlinking, and embeddingChapter 32: Using Excel data in Word documentsAppendixesMenu-to-ribbon command referenceKeyboard shortcutsFunction referenceIndex to troubleshooting topicsAbout the authors