|
|
Build robust Excel 2010 apps quickly and efficiently Known as "Mr. Spreadsheet," John Walkenbach's name is synonymous with excellence in computer books that explain the complexities of various topics. With this collection of favorite Excel tips and tricks, you get a unique look at ways to make Excel 2010 more efficient than you ever imagined. Packed with easy-to-understand advice regarding all aspects of Excel, this book shares improved ways of speeding up application development with Excel and maximizing the power of Excel to create robust applications.* Addresses the extensive changes to the 2010 version of Excel and shares tricks and shortcuts for making your Excel experience as successful and efficient as possible* Reveals ways to deal with function arguments, create "impossible" charts, and tame the Ribbon bar* Discusses absolute vs. relative references, change data entry orientation, and sort more than three columns* Demonstrates ways to enter fake data for testing purposes With John Walkenbach's Favorite Excel 2010 Tips and Tricks, you'll get a jump start on mastering the extensive changes to the 2010 version of Excel.
| ISBN | 0470475374 | | Pages | 504 | | ISBN13 | 9780470475379
(What's this?) | | Weight (grammes) | 738 | | Publisher | John Wiley and Sons Ltd | | Published in | Chichester | | Imprint | John Wiley & Sons Ltd | | Series title | Mr. Spreadsheet's Bookshelf | | Format | Paperback | | Height (mm) | 233 | | Publication date | 09 Jul 2010 | | Width (mm) | 187 | | DEWEY | 005.54 | | Spine width (mm) | 27 | | DEWEY edition | DC22 | | Academic level | General |
|
| |
| Part I | | Basic Excel Usage | | | | Tip 1 | | Understanding Excel Versions | | 9 | | Tip 2 | | Maximizing Ribbon Efficiency | | 12 | | Tip 3 | | Understanding Protected View | | 15 | | Tip 4 | | Selecting Cells Efficiently | | 17 | | | | Selecting a range by using the shift and arrow keys | | 17 | | | | Selecting the current region | | 17 | | | | Selecting a range by Shift+clicking | | 17 | | | | Selecting noncontiguous ranges | | 17 | | | | Selecting entire rows | | 18 | | | | Selecting entire columns | | 18 | | | | Selecting multisheet ranges | | 19 | | Tip 5 | | Making "Special" Range Selections | | 20 | | Tip 6 | | Undoing, Redoing, and Repeating | | 22 | | | | Undoing | | 22 | | | | Redoing | | 23 | | | | Repeating | | 23 | | Tip 7 | | Discovering Some Useful Shortcut Keys | | 25 | | Tip 8 | | Navigating Sheets in a Workbook | | 26 | | Tip 9 | | Resetting the Used Area of a Worksheet | | 27 | | Tip 10 | | Understanding Workbooks versus Windows | | 28 | | Tip 11 | | Customizing the Quick Access Toolbar | | 30 | | | | About the Quick Access toolbar | | 30 | | | | Adding new commands to the Quick Access toolbar | | 30 | | | | Performing other Quick Access toolbar actions | | 33 | | Tip 12 | | Customizing the Ribbon | | 34 | | Tip 13 | | Accessing the Ribbon with Your Keyboard | | 37 | | Tip 14 | | Recovering Your Work | | 38 | | | More... | | |
|
|
|
|
|
Enlarge
