Excel 2003 Advanced

This A4 spiral bound manual has been specifically designed to provide the necessary knowledge and techniques for the successful creation and manipulation of a complex Excel spreadsheet. The accompanying data files on disk are designed to help demonstrate the features you are learning as you work through the manual step by step approach.

This guide to Excel focuses on three areas--least squares, Fourier transformation, and digital simulation. It illustrates the techniques with detailed examples, many drawn from the scientific literature. It also includes and describes a number of sample macros and functions to facilitate common data analysis tasks. De Levie is affiliated with Bowdoin College. Annotation : 2004 Book News, Inc., Portland, OR (booknews.com).

This book shows beginning users how to manage their data using one of the world’s most popular programs - Excel — without investing time and money in complex databases such as Access. We’ve written and organized the book for readers who know something about Excel but nothing about databases. We provide quick start solutions, step-by-step exercises, try-it-out sections, troubleshooting, and best practices solutions.

This ILT Series course, rated 4.9/5.0 in overall quality by ProCert Labs, covers advanced-level features and functions of Excel 2003. Students will learn how to create nested functions, export/import data, perform what-if analyses, use the Goal Seek and Solver utilities, record and run macros, and use SharePoint services. This course is approved courseware for Microsoft Office Specialist certification. Comes with CertBlaster exam prep software (download). Also available with a companion CBT program and student data files on CD-ROM.

A guide to the integrated software package for experienced users delves into hundreds of undocumented secrets, hidden tools, and little-known field codes.

Get Down to Business—Maximize Your Efficiency with Office 2003 Written for business-minded and experienced Office users, this task-oriented guide goes directly to the bottom line, revealing optimal ways to perform critical, challenging tasks. After fifteen years of teaching people how to be more productive with Office, Courter and Marquis know users' FAQs and understand the way you use Office—as an integrated suite rather than as a collection of separate applications. In Mastering Microsoft Office 2003 for Business Professionals they skip the basics and focus instead on precious time-saving techniques that help you streamline your day-to-day activities. Inside, you'll learn how to: Manage schedules, tasks, contacts (Outlook) Build and deliver convincing, animated presentations (PowerPoint) Create documents collaboratively (Word, Excel, PowerPoint) Streamline mailings and messaging (Word, Outlook, Access, Excel) Produce complex publications such as manuals, proposals, and contracts (Word, Binder, FrontPage) Publish documents on the Web (FrontPage, Excel) Organize and secure documents (Word, Excel, PowerPoint, Outlook) Build robust, foolproof workbooks (Excel) Design and develop data sources (Word, Excel, Access, Outlook) Create templates for repetitive tasks (Word, Excel, PowerPoint, FrontPage) Construct user input forms (Outlook, FrontPage, Word) Dissect data, and then present it in compelling ways (Excel, Access) Tweak Office to fit the way you work (Word, Excel, Outlook, PowerPoint) Use macros to do more with Office (Word, Excel)