Microsoft Excel 2013 Inside Out

Microsoft Excel 2013 Inside Out
ISBN-10
0735674299
ISBN-13
9780735674295
Category
Computers
Pages
1168
Language
English
Published
2013-04-15
Publisher
Pearson Education
Authors
Craig Stinson, Mark Dodge

Description

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. Topics include: Customizing the Excel workspace Best practices for designing and managing worksheets Creating formulas and functions Performing statistical, what-if, and other data analysis Core to advanced charting techniques Using graphics and sparklines Managing databases and tables Automating Excel with macros and custom functions Collaborating in Excel online, in the cloud, and more Extending Excel

Similar books

  • Microsoft Excel 2010 Inside Out
    By Craig Stinson, Mark Dodge

    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: ...

  • Microsoft Office Inside Out
    By Ed Bott, Carl Siechert

    Provides timesaving tips, tricks, shortcuts, solutions, and troubleshooting guidelines for Microsoft Excel, Outlook, Word, PowerPoint, and other applications, and explores new features and capabilities of Office 2013.

  • Microsoft SharePoint 2013 Inside Out
    By Christina Wheeler, Penelope Coventry, Darvish Shadravan

    Micro Share 2013 Ins O_p1 Darvish Shadravan, Penelope Coventry, Thomas Resing, Christina Wheeler ... Penny has authored and coauthored more than 10 SharePoint-related books, including Exploring Microsoft SharePoint 2013: New Features ...

  • Microsoft Access 2013 Inside Out
    By Jeff Conrad

    Conquer Microsoft Access 2013—from the inside out!

  • Microsoft Excel 2010 Formulas and Functions Inside Out
    By Egbert Jeschke, Helmut Reinke, Sara Unverhau

    Customize Excel formulas using 350+ built-in functions Create reusable formulas for common calculations Learn smarter ways to calculate date and time values Systematically search worksheets with lookup and reference functions Perform ...

  • Excel 2013 In Depth: Excel 2013 In Depth _p1
    By Bill Jelen

    Excel 2013 In Depth _p1 Bill Jelen. III To use Advanced Filter on a data set, follow these steps: 1. ... Excel in Practice: Using Formulas for Advanced Filter Criteria Sometimes you might need to filter based on criteria that are too ...

  • MOS 2013 Study Guide for Microsoft Excel Expert: MOS 2013 Stud Gui Mic Exc _p1
    By Mark Dodge

    Demonstrate your expertise with Microsoft Office!

  • Microsoft Excel 2013: Building Data Models with PowerPivot
    By Marco Russo, Alberto Ferrari

    Shows readers how to perform complex data analysis, create reports with the data analysis expressions language, and add hierarchies to data models to enable faster browsing.

  • Excel 2013 Charts and Graphs
    By Bill Jelen

    Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will: • Dramatically increase your productivity–saving you 50 hours a year or more • Present proven, ...

  • Microsoft Office Excel 2003
    By Craig Stinson, Mark Dodge

    Hey, you know your way around a spreadsheet—so now dig into Excel 2003 and really put your data to work! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting...