The complete change in the Excel 2007 interface has jolted many Excel users out of their comfort zone as they struggle to locate and familiarize themselves with the regular functions they have been using for many years. Most Excel users tend to stick to the regular functions that they have been using to get their job done and may not be aware of shorter and more productive methods of working with the new version of Excel. As such, more than 30 Tips and Tricks have been specially identified and compiled in this book. Each of the Tips and Tricks has the potential of saving you hours of cleaning up the data manually, drastically changing the way you use Excel. Some of the Tips and Tricks found in this book are:

• Customize The Quick Access Toolbar (QAT)
• Double Click On The Ribbon To Hide It
• Quick Access To Frequently Used Files
• Tracking Real-Time Changes With Excel Camera
• Jump Instantly To The End Of Your Database
• Searching And Entering Formula With Autocomplete
• Create Attention-Getting Comments

This book is not designed to teach you all the formulas in Excel, neither is it meant for passing any examinations. The book sets out to help those who would like to save time on their existing Excel tasks. It consists of business case studies intended to introduce key concepts for the effective management of data, analysis of information, and reporting of findings using Microsoft Excel. The case studies will walk you through the entire process of manipulating raw data to reporting and showing you how to use Excel in the various stages of data management. They also illustrate how you can harness the power of formulas beyond their basic purpose. The intention is to lay the foundation for you to explore Excel on your own after you have completed the book. At the end of the day, it would make you less reliant on your IT staff and help you achieve a much quicker turnaround on your tasks, which you previously thought was impossible.

This is a must-read for all marketers who are constantly swarmed by a tremendous amount of data in Excel and are expected to regularly analyse and present their company sales performance within a short turnaround time. This book uniquely puts Excel in a business perspective and helps marketing and sales executives, as well as managers, discover the critical techniques of using Excel functions in the real business environment. Using case studies, this book will walk you through the entire process of manipulating raw marketing/sales data and reporting, and show you how to use Excel in the different stages of data management.