Google Exceltip.com
Account Icon
Shopping Cart
CheckOut

Home
Introduction
About the Authors
Book Contents
Sample Chapters
Reader Testimonials


"This is the most unbelievable software book I've ever read!"



"I started highlighting helpful ideas, but almost immediately gave up that effort because I'd have to highlight every line!"



"There are so many tips
and tricks listed in this book that every chapter can teach even the oldest of dogs new tricks."




"This book is absolutley jam-packed with useful tips and tricks."




"What it will do is show you techniques and tricks that will speed up tasks you already think you know how to do, and introduce you to a few that will show you how to do things you thought couldn't be done."

Mr Excel on Excel

for Excel versions 97, 2000, 2002


By Joseph Rubin and Bill Jelen

Sample Chapters

Chapter 1 - Time is money, Give the Mouse a Break

Author Comments - Joseph Rubin

Instead of using mouse, icons, or choosing from the Excel menus, this chapter reviews keyboard shortcuts. It will save you time and save you money by working faster and more efficiently. Most of the common techniques we do when using this excellent Excel appplication are - copying, deleting, pasting, selecting cells, rows or columns, finding, searching, moving between cell, sheets, workbooks and more - this chapter will teach you to do these actions faster by using shortcuts to perform all the technique.   

Chapter 1


Chapter 7 - Formulas

Author Comments - Joseph Rubin

This chapter will teach you how to insert formulas, nest formulas, copy and paste without loosing relative reference, handling errors, auditing, links, break all unnessary links, protecting formulas and more. 

Chapter 7


Chapter 7 - Filtering

Author Comments - Joseph Rubin

Filtering is a very easy technique, but can be tricky. For example, do you know how to filter months and years? How to sum filtered rows? How to color filtered rows by criteria? How to save for future use filtered criteria? Find out all the answers for the questions in this chapter.

Chapter 18



Mr Excel on Excel is available at your local book seller, and online:
-------------------------
-------------------------