Overview

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

Full Product Details

9781484008607

Table of Contents

Reviews

Author Information

About The Author Jason Khoo is the author of the Excel books, Excel Secrets for Highly Effective Marketers and Hidden Secrets of Data Analysis with Excel . When working in Tibs, M1, 3M and Virgin Mobile, he used Excel as his primary work tool to support the sales and marketing, operations, finance and strategic planning departments in data cleaning, analysis, budgeting, forecasting and business modeling. In 2001, Jason founded Synergyworks which has helped companies like Discovery Asia, NATAS, The Nelson Company, Timberland, etc develop Excel solutions to simplify their work in data management, operations, analysis and reporting. Subsequently, everydayExcel Business Lab Pte Ltd was founded in 2007 to primarily provide tailor-made applied Excel courses for managers, executives and frequent Excel users. Focusing on problem solving and the dynamic use of Excel formulas and functions, some of these courses include: - Hidden Secrets in Data Analysis with Excel 2007/2010 - Interactive Dashboard Reporting with Excel 2007/2010 - Learning the Magic of Macros 2007/2010

Tab Content 6

Customer Reviews

Recent Reviews

Countries Available