PowerPivot comprises a set of technologies for easy access to data mining and business intelligence analysis from Microsoft Excel and SharePoint. Power users and developers alike can create sophisticated, online analytic processing (OLAP) solutions using PowerPivot for Excel, and then share those solutions with other users via PowerPivot for...

...

Known as "Mr. Spreadsheet," John Walkenbach's name is synonymous with excellence in computer books that explain the complexities of various topics. With this collection of favorite Excel tips and tricks, you get a unique look at ways to make Excel 2010 more...

Get the most out of Excel 2010 with Excel 2010 Made Simple—learn the key features, understand what’s new, and utilize dozens of time-saving tips and tricks to get your job done. Over 500 screen visuals and clear-cut instructions guide you through the features of Excel 2010, from formulas and charts to navigating around a...

If you’ve ever spent hours renaming files or updating hundreds of spreadsheet cells, you know how tedious tasks like these can be. But what if you could have your computer do them for you?

In Automate the Boring Stuff with Python, you’ll learn how to use Python to write programs that do in minutes what...

Excel Data Analysis For Dummies, 2^nd Edition is the ultimate guide to getting the most out of your data. Veteran Dummies author Stephen L. Nelson guides you through the basic and not-so-basic features of Excel to help you discover...

Packed with straightforward, friendly instruction, this updateto one of the bestselling Office books of all time gets youthoroughly up to speed and helps you learn how to take fulladvantage of the new features in Office 2013. After coverage of...

Ready to leave your other Office? Open this friendly guide and find out how OpenOffice.org opens up your options! You can collect your thoughts in Writer documents, crunch numbers with...

• Implementing the new XML features in Spreadsheet Portals and Web Services
• Auditing spreadsheets provided by third parties
• Making spreadsheets accessible to individuals with disabilities
• Performing spreadsheet makeovers
• Constructing...

This is a book for business analysts about modeling. A model is a simplified representation of a situation or problem, and modeling is the process of building, refining, and analyzing that representation for greater insight and improved decision making. Some models are so common that they are thought of as routine instruments rather...