In this book, Michael Kofler provides definitive coverage of Visual Basic for Applications (VBA) for Excel by showing how it can be used to implement real-world business solutions. Designed to be useful to programmers who have never used VBA before, it also covers advanced topics needed for users already familiar with VBA.
Excel 2007: Beyond the Manual will introduce those who are already familiar with Excel basics to more advanced features, like consolidation, what-if analysis, PivotTables, sorting and filtering, and some commonly used functions.
Debra Dalgleish, Microsoft Office Excel "Most Valuable Professional" since 2001, and an expert and trainer in Excel, brings together a one-stop resource for anyone curious about representing, analyzing, and using their data with PivotTables and PivotCharts.
Over 500 screen visuals and clear-cut instructions guide you through the features of Excel 2010, from formulas and charts to navigating around a worksheet and understanding Visual Basic for Applications and macros.
Excel As Your Database is ideal if you need to manage facts and figures, yet have little need for a full-scale relational database management system. You'll learn how to use Excel to enter, store, and analyze your data. This book assumes some exposure to Excel, but no prior experience with databases.
This book covers the entire breadth of situations you might encounter when working with PivotTablesfrom planning and creating, to formatting and extracting data, to maximizing performance and troubleshooting.
High Impact Data Visualization with Power View, Power Map, and Power BI shows how to deliver state-of-the art interactive analysis to browsers and mobile devices using Microsofts innovative new, self-service business intelligence suite.
Author Rod Stephens gives you the most valuable information possible as quickly as possible without rehashing the trivial VB and VBA details you already can recite in your sleep. This comprehensive reference provides fast-paced, in-depth information on programming Office XP applications and takes you far deeper in far fewer pages than most books.
This book provides a fresh take on Microsoft's premier collaboration solution. A critical resource if you're developing on the SharePoint platform, this book features a complete focus on the features and capabilities of SharePoint 2010.
With the release of Office 2003, Microsoft enhanced your ability to build Word and Excel applications, with its Visual Studio Tools for the Microsoft Office System (VSTO). When you work with VSTO, you will enjoy the full range of Visual Studio .NET features, at your fingertips.