Wiley eBooks Page 201

Microsoft Office Excel 2007 ProgrammingWelcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you'll discover step-by-step screen shots that demonstrate over 140 key Excel programming techniques, including:Assigning digital signatures to macrosSetting properties for a projectAssigning values to a variableChanging the properties of an objectFormatting a numeric expressionProcessing a runtime errorSaving worksheets to another fileDisplaying a built-in dialog boxCreating custom Ribbon tabsBuilding and debugging add-insExtra Apply It"Apply It" and "Extra" sidebars highlight useful tipsHigh-resolution screen shots demonstrate each taskSuccinct explanations walk you thr...

Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you'll discover step-by-step screen shots that demonstrate over 110 Excel data analysis techniques, including:* Identifying trends in your data*Sorting, filtering, and identifying lists*Creating, editing, and checking formulas*Calculating interest rates and depreciation*Performing simple sorts and filters*Hiding rows or columns in a PivotTable*Adding and removing chart data*Querying an Access database*Assigning digital signatures*Solving a formula with a data table"I was stuck on an Excel problem for two days. Finally, I opened one of your books, and there was a macro to accomplish exactly what I needed! You made me look goo...

This book is a single reference that's indispensable for Excel beginners, intermediate users, power users, and would-be power users everywhereFully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques readers won't find anywhere elseJohn Walkenbach, aka "Mr. Spreadsheet," is one of the liworld's leading authorities on ExcelThoroughly updated to cover the revamped Excel interface, new file formats, enhanced interactivity with other Office applications, and upgraded collaboration featuresIncludes a valuable CD-ROM with templates and worksheets from the bookNote: CD-ROM/DVD and other supplementary materials are not included as part of eBo...

Master the Ribbon, powerful graphics capabilities, and more!Your one-stop guide to great-looking spreadsheets that actually mean somethingCreate colorful spreadsheets and charts, use Live Preview, and maximize everything Excel 2007 has to offer! Find just what you need to know about using the new Ribbon, designing spreadsheets that communicate, editing and printing them, working with formulas, protecting your data when you collaborate, turning out cool charts, and much more. The included four-color insert highlights the Ribbon, new graphics features, and more!Discover how toCreate dynamic spreadsheets with style galleriesWork with more than 40 new cell stylesAutomate formatting with Live PreviewShare Excel data with other programsUse VBA to write cus...

If you've been using Access for a while, you're probably aware of its power and potential and itching to take advantage of both. Access2007 VBA Programming For Dummies takes you beyond forms and reports and shows you how to use VBA to create killer Access databases and applications. This gentle introduction to VBA programming covers everything you need to get started, including:Basic programming skills and conceptsExplanations of modules, procedures, objects, and argumentsAccess-unique programming activities, including SQL and recordsetsHow to use the Visual Basic editorCreating dialog boxes, lists, drop-down menus, and functionsIntegrating with other Office applicationsReady-to-use VBA code examples to type in or copy and paste from the WebCompletel...