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
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: ...
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.
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 ...
Conquer Microsoft Access 2013—from the inside out!
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 _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 ...
Demonstrate your expertise with Microsoft Office!
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.
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, ...
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...