Category Archives: Spreadsheets

Excel 2007 Data Analysis For Dummies

Shows ordinary users how to tap the rich data analysis functionality of Excel, make sense of their organization’s critical financial and statistical information, and put together compelling data presentations Now revised with over 30 percent new content to cover the … Continue reading

Posted in Computers & Internet, Database Storage & Design, Excel, For Dummies, Format, Introductory, Science & Research, Spreadsheets, Statistics, pdf | Leave a comment

Excel for the Math Classroom (Excel for Professionals series)

Thisguide to enabling middle-grade mathematics teachers to use Microsoft Excel in the classroom focuses primarily on concepts taught in grades 4–10, with some pre-algebralessons for higher grades. Including files available for downloading to create custom math worksheets, build self-grading interactive … Continue reading

Posted in Excel, Format, Spreadsheets, pdf | Leave a comment

Excel 2007 for Starters: The Missing Manual

Fast-paced and easy to use, this new book teaches you the basics of Excel 2007 so you can start using the program right away. This concise guide shows readers how to work with Excel’s most useful features and its completely … Continue reading

Posted in Excel, Format, Spreadsheets, Windows OS, chm | Leave a comment

From VBA to VSTO: Is Excel’s New Engine Right for You?

This Excel user’s guide to VSTO—the new Excel Macro programming language being promoted by Microsoft—shows how to perform the equivalent VBA actions with VSTO. The differences between the VSTO and VBA development environments are explained, helping Excel users decide if … Continue reading

Posted in Computers & Internet, Format, Spreadsheets, VBA, Visual Basic, chm | Leave a comment

Excel for Auditors: Audit Spreadsheets Using Excel 97 through Excel 2007 (Excel for Professionals series)

Providing the tools and techniques necessary for finding errors and fraud in audits, this guide for auditors looking to better validate their Microsoft Excel spreadsheets provides techniques for performing a risk assessment and gathering spreadsheet and other data from company … Continue reading

Posted in Format, Spreadsheets, pdf | Leave a comment

Excel 2007: The Missing Manual

Microsoft Excel continues to grow in power, sophistication, and capability, but one thing that has changed very little since the early ’90s is its user interface. The once-simple toolbar has been packed with so many features over the years that … Continue reading

Posted in Excel, Format, Spreadsheets, Windows OS, chm | Leave a comment

Programming Excel with VBA and .NET

Why program Excel? For solving complex calculations and presenting results, Excel is amazingly complete with every imaginable feature already in place. But programming Excel isn’t about adding new features as much as it’s about combining existing features to solve particular … Continue reading

Posted in .NET, Excel, Format, Spreadsheets, VBA, Visual Basic, Windows OS, chm | Leave a comment

Analyzing Business Data with Excel

As one of the most widely used desktop applications ever created, Excel is familiar to just about everyone with a computer and a keyboard. Yet most of us don’t know the full extent of what Excel can do, mostly because … Continue reading

Posted in Excel, Format, Modeling & Simulation, New Business Enterprises, PMP Exam, Spreadsheets, Windows OS, chm | Leave a comment

F1 Get the Most Out of Excel Formulas & Functions: The Ultimate Excel Formulas & Functions Help Guide

With more than 300 solutions to the time-consuming problem of combining Microsoft Excel functions into effective, problem-solving formulas, this handbook addresses questions that are regularly posted to Excel newsgroups—topics of the most interest to Excel users. Questions and answers provide … Continue reading

Posted in Excel, Format, Spreadsheets, pdf | Leave a comment

Windows XP Power Hound: Teach Yourself New Tricks

Windows XP can be a great tool, but it is all too easy to trip over Windows XP’s annoying traits more often than you leverage its productivity. Windows XP power-users troll online resources, documentation, and the expertise (or lucky finds) … Continue reading

Posted in Format, Spreadsheets, Windows OS, chm | Leave a comment