There are endless tasks that can be made easier with Excel. Excel can be used to track classroom management from grade books, class rosters, attendance, testing results, assessment measurement charts, and more. Excel can be used as an aide in teaching. Use Excel to generate random fact worksheets. Use Excel to create graphs to help teach math standards. Finally, your students can use Excel to develop models and homework.

The concepts in this book apply equally well to every version of Excel from Excel 97 through Excel 2003. As this book goes to press, pre-beta copies of Excel 12 are available. I’ve reviewed these and many concepts will be different in Excel 12. While Excel 12 threatens to make every Excel book obsolete, most public school districts are in financial trouble and will not be upgrading to Excel 12 soon. If you happen to live in a district that upgrades to Excel 12, check the aforementioned web page for information about an e-book upgrade for Excel 12 users.

We will assume that you have Excel 97 or newer running on Windows or Macintosh. You should know how to start Excel and navigate from cell to cell.

Workflow is the glue that binds information worker processes, users, and artifacts. Without workflow, information workers are just islands of data and potential. Workflow in the 2007 Microsoft Office System details how to implement workflow in SharePoint 2007 and the rest of the 2007 Office System to help information workers share data, enforce processes and business rules, and work more efficiently together or solo.

This book covers anything youre likely going to need to know – from what workflow is all about, to creating new Activities; from InfoPath forms to ASP.Net forms; from the Rules Engine to the object model. Theres even a section on integrating Office 2003 clients with SharePoint 2007 workflows. Youll come away from reading this book with solid knowledge of how to implement workflow in the new world of Office and SharePoint.

VBA helps you put your computer in its place Write programs that automate tasks and make Office 2007 work better for you If your computer is becoming your boss instead of your servant, start using VBA to tell it what to do! Here's the latest on the VBA IDE and program containers, debugging and controlling your programs, working with multiple applications using a single program, and the most exciting stuff — programming for all the Office 2007 applications.

Discover how to
Customize an application's interface
Quick-launch a VBA program
Store and modify information
Use VBA with the Ribbon
Understand object-oriented programming
Avoid runtime errors

What’s the use of putting out reports that no one reads? Properly created dashboards are graphical representations that put data in a context for your audience, and they look really cool! How cool? You’ll find out when you see the dazzling examples in Excel 2007 Dashboards & Reports For Dummies. And, before long, everyone’s eyes will be riveted to your dashboards and reports too!

This revolutionary guide shows you how to turn Excel into your own personal Business Intelligence tool. You’ll learn the fundamentals of using Excel 2007 to go beyond simple tables to creating dashboard-studded reports that wow management. Get ready to catch dashboard fever as you find out how to use basic analysis techniques, build advanced dashboard components, implement advanced reporting techniques, and import external date into your Excel reports. Discover how to:

• Unleash the power of Excel as a business intelligence tool
• Create dashboards that communicate and get noticed
• Think about your data in a new way
• Present data more effectively and increase the value of your reports
• Create dynamic labels that support visualization
• Represent time and seasonal trending
• Group and bucket data
• Display and measure values versus goals
• Implement macro-charged reporting

Can Google applications really become an alternative to the venerable Microsoft Office suite? Conventional wisdom may say no, but practical wisdom says otherwise. Right now, 100,000 small businesses are currently running trials of Google office applications. So are large corporations such as General Electric and Proctor & Gamble. Google Apps Hacks gets you in on the action with several ingenious ways to push Google's web, mobile, and desktop apps to the limit.

The scores of clever hacks and workarounds in this book help you get more than the obvious out of a whole host of Google's web-based applications for word processing, spreadsheets, PowerPoint-style presentations, email, calendar, and more by giving you ways to exploit the suite's unique network functionality.