|
|
Learn Excel 97 through Excel 2007 From MrExcel - 377 Excel Mysteries Solved
|
|
"I have never read anything about the computer or computer programs so well written and easily followed, with clear diagrams and explanations. I am one of those people that cannot read directiions, but these Excel lessons changed all that."
-Loron Winn
|
|
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 64 new topics that apply only to Excel 2007:
Find Icons on the Ribbon - page 3
Go Wide - page 4
Minimize the Ribbon to Make Excel Feel a Bit more Like Excel 2003 - page 6
Someone on the Office Development Teams Likes the Artist Formerly Known as Prince - page 7
The Paste Icon is Really Two Icons - page 8
Use Dialog Launchers to Access the Excel 2003 Dialogs - page 11
Make Your Most-Used Icons Always Visible - page 13
Your old Alt Keystrokes Still Work (If you type them slowly enough) - page 16
Use new Keybboard shortcuts to Access the Ribbon - page 18
The Blue Question Mark is Help - page 21
All Commands Start at the Top, (Except for 2 controls at the bottom) - page 23
What happened to Tools - Customize? - page 25
What happened to Tools - Options? - page 26
Where are my Macros? - page 28
Why do I only have 65,536 rows? - page 31
Which File Format Should I use? - page 32
Share Files With People Who Are Still Using Excel 97 Through Excel 2003 - page 34
Use Live Preview - page 36
Get Quick Access to Formatting Options Using the Mini Toolbar - page 38
I am a Lobbyist Writing Policy Papers for the White House - page 42
Keep Favorites in the Recent Documents List - page 46
I've Searched Everywhere. Where is the Save Workspace command on the ribbon? - page 47
Return to the First Column After Typing the Last Column - page 53
Enter Data in a Circle (or any other pattern) - page 55
Yes, AutoComplete is Cool, if You can Stop Entering the Opening Parentheses - page 234
Use Table Functionality to Simplify Copying of Formulas - page 256
Rename your tables - page 258
Use Simple References in a Table - page 259
Handle Long Formulas in the new Excel 2007 Formula Bar - page 292
Sort All Red Cells to the Top of a Report - page 426
Why Does This Look So Different than Excel 2003? - page 543
Explore the new filters available in Excel 2007 Pivot Tables - page 565
Why Aren't the Cool New Filters Available in My Pivot Table? - page 567
Why Can't my coworkers with Excel 2003 Open My Pivot Table? - page 568
Quickly Create Reports for Every Customer - page 571
Format Pivot Tables Using the Gallery - page 596
None of the 23,233 Built-In Styles Do What My Manager Asks For - page 599
Apply Conditional Formatting to a Pivot Table - page 604
Why Does the PivotTable Field List Keep Disappearing? - page 634
Remove Duplicates - page 674
"Change The Look Of Your Workbook with Document Themes - page 681"
Add Formatting to Pictures in Excel - page 684
Excel Creates Charts at the Bottom of My Data Set. How can I move to the top? - page 689
How can I move a chart within the window? - page 690
Why do none of the built-in chart layouts look good? - page 693
The Chart Styles are Cool, but Why So Few Colors? - page 696
Display Axis in Millions Using the Layout Built-In Menus - page 698
The Format Dialog Box Offers a New Trick - page 704
Charts acting flakey? It's not just you. - page 706
Choose the Right Type of SmartArt - page 791
Use the Text Pane to Build Your SmartArt - page 794
Change a SmartArt Layout - page 796
Finalize SmartArt Layout Before Adding Pictures - page 799
Format SmartArt - page 800
Switch to the Format Tab to Format Individual Shapes - page 803
How do the Labeled Hierarchy Charts Work? - page 808
Change the Aspect Ratio of Your SmartArt to Control Layout - page 809
You Can Add New SmartArt Layouts - page 811
Convert SmartArt to Shapes to Use cells as the Content - page 812
Convert a table of numbers to a visualization - page 857
Prevent one outlier from ruining the visualization - page 862
Add Icons To Only The Bad Cells - page 864
Select Every Kid in Lake Wobegon - page 868
Chart or SmartArt Text Can Be WordArt - page 884
For the list of 65 new topics that that apply to all versions of Excel 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!
Product Details
Paperback: 926 Pages ; Dimensions (in inches): 9.2 x 7.5 x 2
Publisher: Holy Macro! Books; Second edition (November 2007)
ISBN: 978-1-932802-27-6
Price: $39.95
|
|
