Excel Books

Excel 2007 Tips and Tricks

Excel 2007 Tips and Tricks 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.

Our Tips and Tricks include:

  • 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

Buy Now from Amazon 
from Amazon 

OR 

 
from everydayExcel and enjoy free delivery within Asia

Hidden Secrets of Data Analysis with Excel 2007 / 2010

How to Use Microsoft® Excel Differently for Breakthrough Performance

Hidden Secrets of Data Analysis with Excel 2007 / 2010This is a must-read for all Excel users who are constantly swarmed by a tremendous amount of data in Excel and are expected to regularly analyse, update and prepare reports with a short turnaround time. This book uniquely puts Excel in a business perspective and helps 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 data and reporting, and show you how to use Excel in the different stages of data management.

The case studies are used in everydayExcel's Excel training courses and have been tried and tested by more than 700 people so far. A survey conducted with these participants showed that by going through just this book, it can help you save about two days per week from your Excel tasks if you have five to eight years of experience working with Excel.

We will share, step-by-step, how you can achieve the following:

  • Prepare that report in minutes instead of days
  • Spend your time analysing your report instead of performing data crunching, copying and pasting
  • How to remove duplicates in seconds
  • How to merge data from multiple sources
  • Make Excel pull out the text intelligently for you in seconds
  • Find out your monthly, quarterly, and yearly sales trends in a few simple steps

This book's intended readers are managers and executives using Excel 2007 and 2010 in their work.

Buy Now from Amazon 
from Amazon 

OR 

 
from everydayExcel and enjoy free delivery within Asia.

Excel Secrets for Highly Effective Marketers

How to Use Microsoft® Excel Differently from Most Marketers to Gain a Productive Edge

Excel Secrets for Highly Effective MarketersThis book is a compilation of a total of 18 practical business case studies used in EverydayExcel Business Lab's Microsoft® Excel course, "Sales Performance Analytics with Excel".

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.

The case studies are used in EverydayExcel’s Excel training courses and have been tried and tested by more than 300 people so far. A survey conducted with these participants showed that by going through just the first five case studies, it can help you save about two days per week from your Excel tasks if you have five to eight years of experience working with Excel.

We will share, step-by-step, how you can achieve the following:

  • Prepare that marketing report in minutes instead of days
  • Spend your time analysing your report instead of performing data crunching, copying and pasting
  • How to remove duplicates in seconds
  • How to merge data from multiple sources
  • Make Excel pull out the text intelligently for you in seconds
  • Find out your monthly, quarterly, and yearly sales trends in a few simple steps

The techniques in this book can be applied to Excel 2000-2003.

ISBN 978-981-08-0914-0 | 2008 |

You can purchase this book from all Major Bookstores in Singapore and Malaysia. Alternatively, you could drop us an email to order the book directly from us.
If you are in other countries, you can order this book through Amazon.

Price: US$39.95 or US$29.90