 |
| Ordering |
| Press Room |
| Articles |
| Our Authors |
| Contact |
| Home |
 |
 |
 | |
|
| |
|
"See what other Excel books have missed!"Introduction Microsoft Excel is an incredibly feature-rich product. Far too many people are introduced to Excel through a trial-by-fire basis – they discover they need Excel for their job, learn the basics and then continue to do things the hard way without learning the tips which can cut hours and hours from their routine tasks. It is very possible to use Excel for 40 hours a week and not be aware of many of the incredibly powerful techniques available to them in Excel. Both of the authors teach others these power tricks in Excel. My favorite experience is to be in front of a room full of accountants who believe they must know everything about Excel because it is their main tool at work. When I hear the first collective gasp from the room within the first two minutes of the seminar, I know that I have hit my stride and will provide an enriching class to these experienced Excel users. This book is designed for the intermediate to advanced Excel user. It is for the person who can perform the basics with their eyes closed all day but has been too busy to really delve into the menus and learn all of the “new” techniques that were introduced since we all switched over from Lotus to Excel in the 1990’s. You should be able to turn to any chapter and find that it is dripping with tips designed to make your use of Excel far more efficient. Dig in & enjoy. Bill Jelen & Joseph Rubin Click here to order the book! "Has tips and tricks even the tricksters miss!"About the Authors Bill Jelen is the principal behind the popular MrExcel.com website. With over 10 million annual pageviews, MrExcel.com is a leading Excel website. Along with a dedicated team of Excel gurus, Bill Jelen provides custom Excel and Access applications for hundreds of clients around the world. He is the author of “Guerilla Data Analysis Using Microsoft Excel” and offers an entertaining seminar on the power tips and tricks for Microsoft Excel. Joseph Rubin, CPA has over 25 years of financial experience in the accounting industry. He has served as CFO, Controller and run his CPA practice for years Joseph Rubin, CPA is an independent consultant specializing in the development of applications using Microsoft Excel for the financial industry and has instructed thousands of professionals on Microsoft Excel. Click here to order the book! "If You Think You're Good at Excel -- This Book Will Get You Better!"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 Part2 : 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 Part3: Financial & What If Chapter 24 : Loans Chapter 25 : What-If Part 5: VBA, Macros Chapter 26 : Running a Macro Chapter 27 : Write your first program Chapter 28 : More VBA Techniques Click here to order the book! "If you use Excel --- You Need This Book!"Product Details Paperback: 512 Pages ; Dimensions (in inches): 1 x 9 x 6 Publisher: Holy Macro! Books; ISBN 0972425837 (April 2003) (Advance copies shipping now) Price: $35.95 Click here to order the book! Sample Chapter Download Chapter 7 Click here to order the book! Review This book is absolutley jam-packed with useful tips and tricks. You will easily recoup your outlay on the book in the time savings that you will make in your first few Excel sessions after reading it. I've used Excel for many years and used to think that I knew pretty much all that I needed to know. I was wrong! There are so many time-saving tips in here that you will find yourself referring to it time and again - keep it near your computer. And its not just about working faster, its about working smarter too. We've all been in this situation I suspect - you reach a certain point in your spreadsheet design and sit there thinking 'There must be a way to do this!'. Well there probably is and its probably in this book. Typical examples include, adding a watermark to your spreadsheets, moving a minus sign from the right of a figure to the left, using the a Euro symbol. Bluntly, if you use Excel you NEED this book. - Richie Sills Review Given how many Excel books there are out there, it can't be easy to write a good one that fills a genuine gap in the market. Nevertheless, Jelen & Rubin have managed to do just that. Aimed primarily at the intermediate user, "MrExcel on Excel" is packed full of tips that will get you using Excel much more effectively. The book will not teach you everything there is to know about Excel; nor will it show you how, with some fancy API programming, you can make Excel do the washing-up and walk the dog. 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. If you've already used Excel and want to use it better, then buy this book - in time saved alone it should pay for itself in under a month. - Paddy Davies Review Although many other authors and publishers claim that there isn't another Excel book like their's, in this case it is true. The book reads the way a true Help manual should, quick and to the point. There are so many tips and tricks listed in this book that every chapter can teach even the oldest of dogs new tricks. There is a nice blend of tips that speed up spreadsheet navigation, auditing and use with easy to follow examples that introduce some of the most useful features of Excel. If you have ever cringed whilst watched people using Excel inefficiently, just wait until you've mastered some of the techniques explained in this book. The book has examples using VBA but the intent of the book is not to teach VBA extensively. In keeping with the theme of the book, most of the VBA examples that are included are useful and can be directly imported into you workbooks without modification. i.e. useful real-world examples. "Mr. Excel on Excel" is purely and simply a very well-written reference manual for those of us that need the answers quickly. - Mark O'Brien Order Click here to order the book! Download Sample Files Once you've bought the book, download Sample Files to complement the examples in the book.
|
|
