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

Contents at a Glance

Part 1 : Excel Fundamentals

  •  Chapter 1 : Time is Money,give your mouse a break
  •  Chapter 2 : Text
  •  Chapter 3 : Formatting Numbers
  •  Chapter 4 : Date & Time
  •  Chapter 5 : Styles
  •  Chapter 6 : Name
  •  Chapter 7 : Formulas
  •  Chapter 8 : Summing and Counting
  •  Chapter 9 : Security and Protection
  •  Chapter 10 : Information
  •  Chapter 11 : Printing
  •  Chapter 12 : Charts
  •  Chapter 13 : Customizing Excel
  •  Chapter 14 : Opening, Closing and Savings Workbooks

Part 2 : Data Organize & Analysys

  •  Chapter 15 : Data
  •  Chapter 16 : Importing Text Files
  •  Chapter 17 : Sorting
  •  Chapter 18 : Filtering
  •  Chapter 19 : Subtotals
  •  Chapter 20 : Grouping and Outlining
  •  Chapter 21 : Consolidating Data
  •  Chapter 22 : PivotTable
  •  Chapter 23 : Using Functios and Objects to extract Data

Part 3: Financial & What If

  •  Chapter 24 : Loans
  •  Chapter 25 : What-If

Part 4: VBA, Macros

  •  Chapter 26 : Running a Macro
  •  Chapter 27 : Write your first program
  •  Chapter 28 : More VBA Techniques



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