Learn Excel 97 through Excel 2007 From MrExcel - 377 Excel Mysteries Solved
"MrExcel's ttips will take you from Excel Zero to Hero in no time flat! This book is sure to make you the "M. Excel" at your office!"
Learn Excel 97 through Excel 2007 From MrExcel by Bill Jelen
The original edition of Learn Excel from MrExcel offered 277 tips that applied to Excel 97 through Excel 2003.
The second edition offers 377 tips. Throughout the book, I've updated the screen shots to use Excel 2007. I still include the command sequences to solve the problems in both Excel 97-2003 and Excel 2007. You will find that 28 topics were removed from the original book (or consolidated with other topics.) That means there are 127 new topics in the book. Of the 127 new topics, you will find that 64 of them are applicable to Excel 2007 only. Particularly at the front of the book, I have 17 topics in a sequence to help the person who was just upgraded to Excel 2007. However, throughout the rest of the book, you will find 63 brand new tips that will apply equally well to Excel 97 through Excel 2007. Even in many of the tips that have been in both books, I've added new text to the topic to make the tip better. Even if you own the first edition of the book and still use Excel 2003, you will find many new techniques in the book.
List of the 65 new topics that apply to all versions:
Mix Formatting In a Single Cell - page 39
Copy Characters from a Cell, instead of Copying the Entire Cell - page 40
My Manager Wants Me to Create a New Expense Report From Scratch - page 43
I navigate by sliding the scrollbar and now the slider has become tiny - page 88
Add Word to Excel - page 99
Translate with Excel - page 103
Enter a series of months, days, or more with the fill handle - page 112
Allow the fill handle to work with your list of products - page 115
What Do All The Triangles Mean? - page 133
Why Can't Excel Find a Number? - page 135
Get Free Excel Help - page 140
Join Text with a Date or Currency - page 187
Combine intermediate calculations to create a mega formula - page 204
Change Smith, Jane to Jane Smith - page 208
Add the Worksheet Name as a Title - page 210
Create an Amortization Table - page 228
Start a formula with a plus sign - page 242
Use AutoSum After Filtering a Dataset - page 254
Why won't my dates show as dates? - page 289
Round to the nearest nickel with MROUND - page 315
Can Excel Track Negative Time? - page 359
What is the difference between now and today? - page 361
Calculate Workdays - page 363
Convert Units - page 364
Remove leading and trailing spaces - page 374
I don't Want to use a lookup table to choose one of five choices - page 376
Fill a Cell with Repeating Characters - page 378
Match Web Colors with Hex2Dec - page 378
Switching Columns Into Rows Using a Formula - page 380
Count Records Based on multiple conditions - page 388
Sort Days of the Week - page 421
Replace Multiple Filter Criteria with a Formula Criteria - page 438
Help Make Excel 2009 Better - page 485
Add blank rows between each row - page 495
Excel is Randomly Parsing Pasted Data - page 497
Hide Zeroes and Other Custom Number Formatting Tricks - page 508
Expand and Collapse Fields - page 554
Report Revenue Many Ways in a Pivot Table - page 592
Select Parts of a Pivot Table - page 602
Instead of Calculated Items, Group Text Fields - page 623
Build a Better Top 10 Using Group Selection - page 626
Group Ages into Age Ranges - page 630
Use a Pivot Table When there is no Numeric Data - page 632
Control Shape of Report Filter Fields - page 637
Create a Pivot Table from Access Data - page 639
Whatever Happened to Multiple Consolidation Ranges in Pivot Tables? - page 641
Use a Trusted Location to Prevent Excel's Constant Warnings - page 654
How do I clean up this data? - page 668
Protect Cells That Contain Formulas - page 675
Why Does Excel Add A Legend to a One-Series Chart? - page 692
Display Axis in Trillions Using the More Options choice - page 700
Chart data of different orders of magnitude - page 714
Use Meaningful Chart Titles - page 718
Legend on the Left or Top - page 720
Avoid 3D Charts - page 722
Save your favorite chart settings as a template - page 724
Other Charting Notes - page 726
Group Columns Instead of Hiding Them - page 735
Move columns by sorting left to right - page 736
Move columns using Insert Cut Cells - page 739
Move columns with Shift+Drag - page 740
Change All Cells with Red Font to Blue Font - page 742
Create Dozens of Lightning Bolts - page 773
Allow Validation Lists to Automatically Redefine as they Grow - page 895
For the list of 64 new topics that that apply to Excel 2007 see this page.
Bonus! - Get an E-Book Copy for FREE!!
There are three ways to get this book:
My goal with Learn Excel 97 through Excel 2007 from MrExcel is to get this version in the hands of 5 million people. You can help by downloading the book and passing it on to your co-workers, etc. Some percentage of people who get the book will buy a print copy or will buy a printable e-book, so I believe that the counter-intuitive strategy of giving the whole book in one download will work fine. Personally - I think many people enjoy the physical feel of a book and will be willing to invest in a real copy of the book for yourself or even everyone on the accounting staff. Plus - if you don't agree it is a 5-star book, you don't have to buy it. This is the ultimate try-it-before-you-buy-it plan.
This free offer was originally aired on the daily, two-minute Learn Excel from MrExcel Video Podcast. Find the download to an e-book on this page celebrating the 500th episode!
Paperback: 926 Pages ; Dimensions (in inches): 9.2 x 7.5 x 2
Publisher: Holy Macro! Books; Second edition (November 2007)
Excel is a registered trademark
of the Microsoft® Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.
All contents Copyright
1998-2008 by MrExcel Consulting.