Excel 2010 Power Programming with VBA (Mr. Spreadsheet's Bookshelf)
All the methods and tools you need to successfully program with Excel
John Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows you how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf.
Featuring a complete introduction to Visual Basic for Applications and fully updated for the new features of Excel 2010, this essential reference includes an analysis of Excel application development and is packed with procedures, tips, and ideas for expanding Excel’s capabilities with VBA.
- Offers an analysis of Excel application development and a complete introduction to Visual Basic for Applications (VBA)
- Features invaluable advice from "Mr. Spreadsheet" himself (bestselling author John Walkenbach), who demonstrates all the techniques you need to create large and small Excel applications
- Provides tips, tricks, and techniques for expanding Excel's capabilities with VBA that you won’t find anywhere else
- Includes a CD with templates and worksheets from the book
This power-user's guide is packed with procedures, tips, and ideas for expanding Excel's capabilities with VBA.
Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
Microsoft Excel 2010 Introduction Quick Reference Guide (Cheat Sheet of Instructions, Tips & Shortcuts - Laminated Card)
Laminated quick reference card showing step-by-step instructions and shortcuts for how to use Microsoft Office Excel 2010. This guide is suitable as a training handout, or simply an easy to use reference guide, for any type of user. The following topics are covered:
Creating Workbooks, Entering and Editing Data, Undo and Redo, Resizing Column Width and Row Height, Inserting and Deleting Rows Columns and Cells, Clearing Cells, Clearing Formatting, Formatting Numbers and Cells, Aligning and Merging Cell Contents, Borders and Grids, Viewing the Worksheet as it will Print, Entering Dates, Entering Sequences.
Entering Formulas & Functions, Entering a SUM Function Quickly, Absolute vs. Relative Cell References.
Copying and Moving Data: Copying to Adjacent Cells; Cut, Copy, Paste; Drag & Drop.
Sheet Features: Renaming, Moving, Copying, Selecting, Inserting, Deleting Sheets.
Editing Multiple Worksheets Simultaneously, Copying Data and Formatting to Multiple Worksheets.
Previewing, Printing and Page Setup, Printing a Specific Area, Using Page Break Preview to Adjust Page Breaks, Repeating Rows/Columns on Every Page.
Working with Previous Versions (Compatibility Mode).
Also includes: Lists of Selection and Movement Shortcuts.
This guide is one of several titles available for Excel 2010: Excel 2010 Introduction; Excel 2010 Tables, PivotTables, Sorting & Filtering; Advanced & Macros; Charts & Sparklines; Functions & Formulas.
