Russell's ebook Library

Russell's ebook Library

Access 2007 VBA Programming for Dummies
Joseph C. Stockman and Alan Simpson
Customize combo and list boxesGo beyond forms and reports and build custom database solutionsNeed to know how VBA works in Access 2007? This plain-English guide introduces you to the fundamentals of VBA programming, helping you get the most out of your Access apps and giving you practical code examples for immediate use in your databases. You'll see how to control Access through VBA and apply powerful real-world VBA solutions.Discover how toCreate simple VBA programsProgram Access formsManage Access tables with SQL and recordsetsTest and debug your codeUse VBA with multiple databasesIntegrate with other Office apps
Cutting Edge PowerPoint 2007 for Dummies
Geetesh Bajaj
Get ready to add punch and pizzazz to your presentations and wow your audience using the latest PowerPoint techniques. This friendly book/CD-ROM combo covers all of the new features of Microsoft PowerPoint 2007, including interface changes, presentation themes, multimedia, the Slide Library, and more. The guide introduces you to the elements of PowerPoint: text; background, images, and info-graphics; shapes; fills, lines, and effects; sound and video; animations and transitions; and interactivity, flow, and navigation. Packed with numerous tips, shortcuts, workarounds, and timesaving techniques, it shows you step-by-step how to: Dress up your text by using fonts creatively and using WordArt to create artistic effects Work with masters and layouts, templates and themes, and fills, lines, and effects Maximize visual appeal by combining Photoshop with PowerPoint Add transitions, photos, motion, sound (narration and music), video, and animation Use SmartArt to create diagrams Create dynamic charts, equations, maps, and more Use PowerPoint's extensive clip art collection Test and set up your presentation Link to Flash, Acrobat, Word, and Excel Print presentation materials and create helpful handouts The CD includes templates, textures, backgrounds, background music scores, images, alpha channel equipped graphics, maps, illustrations, and more, so this combo gives you the know-how and the tools. An 8-page color insert shows you how to use color effectively. With this friendly guide, you're ready to bring your presentation to life with PowerPoint 2007. Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
Excel 2007 Dashboards & Reports for Dummies
Michael Alexander
What’s the use of putting out reports that no one reads? Properly created dashboards are graphical representations that put data in a context for your audience, and they look really cool! How cool? You’ll find out when you see the dazzling examples in Excel 2007 Dashboards & Reports For Dummies. And, before long, everyone’s eyes will be riveted to your dashboards and reports too!This revolutionary guide shows you how to turn Excel into your own personal Business Intelligence tool. You’ll learn the fundamentals of using Excel 2007 to go beyond simple tables to creating dashboard-studded reports that wow management. Get ready to catch dashboard fever as you find out how to use basic analysis techniques, build advanced dashboard components, implement advanced reporting techniques, and import external data into your Excel reports.Discover how to:Unleash the power of Excel as a business intelligence toolCreate dashboards that communicate and get noticedThink about your data in a new wayPresent data more effectively and increase the value of your reportsCreate dynamic labels that support visualizationRepresent time and seasonal trendingGroup and bucket dataDisplay and measure values versus goalsImplement macro-charged reportingUsing Excel 2007 as a BI tool is the most cost-efficient way for organizations of any size create powerful and insightful reports and distribute throughout the enterprise. And Excel 2007 Dashboards and Reports for Dummies is the fastest you for you to catch dashboard fever!
Excel 2007 Just the Steps for Dummies
Diane Koers
Just the steps you need to create spreadsheets, charts, and moreSimple steps......for great resultsCreate a Basic Chart1.Select the data (sequential or nonsequential) you want to plot in the chart. See Figure 11-1 for an example of sequential data selected for a chart.2.Press the F11 key. Excel immediately adds a new sheet called Chart 1 to your workbook with the data plotted into a column chart. Figure 11-2 shows you the various elements that can make up a chartSome newer keyboards use a different function for the F11 key. If your F11 key does not produce a chart, use the Insert tab as explained in the next section.Title: A descriptive name for the overall chart. By default, titles are not added in a basic chart.X or Category axis: Column or row headings from your selected data, which Excel uses for Category axis names.X Axis Title: A descriptive name for the Category axis. By default, a category label is not added in a basic chart.Get ready toEnter data into a spreadsheetBuild formulas and functionsFormat cells and add graphicsSort and analyzedataCreate charts andPivotTablesBlend Excel intoPowerPoint
Excel 2007 VBA Programmer's Reference
John Herbert Green and Stephen Bullen and Rob Bovey and Michael Alexander
Get ready to take your Excel applications to the next level by harnessing the power of the VBA language. This comprehensive resource will help you gain more control over your spreadsheets by using VBA while also showing you how to develop more dynamic Excel applications for other users. From introductory concepts to advanced developer topics, it guides you through every aspect of Excel 2007, including the Ribbon and the XML file formats.In order to master all of the new features of this program, you'll find an introduction to VBA and details on how to use it to enhance Excel. You'll then learn how to work with the key objects and uncover the best ways to gain access to workbooks, worksheets, charts, and more. And you'll find out how to write code for international compatibility, program the Visual Basic Editor, and use the functions in the Win32 API, which will expand your Excel VBA programming skills.What you will learn from this bookHow to write code that is readable, easy to maintain, and runs at maximum speedTips for utilizing the Visual Basic(R) Editor and its multitude of toolsTechniques for accessing data in a range of formatsWays to set up your applications and convert them to add-insHow to manipulate the Office XML file formatsA thorough explanation of RibbonXBest practices for managing external data and using OLAP data sourcesMethods for effectively debugging your applicationTips for packaging and distributing customized applications to other usersWho is this book for?This book is for Excel users and programmers from beginning to advanced. You should have a reasonable working knowledge of Excel and a full installation of the software.Wrox Programmer's References are designed to give the experienced developer straight facts on a new technology, without hype or unnecessary explanations. They deliver hard information with plenty of practical examples to help you apply new tools to your development projects today.
Excel 2007 VBA Programming for Dummies
John Walkenbach and Jan Karel Pieterse
From the Back CoverStep-by-step instructions for creating VBA macrosHarness the power of VBA and create custom Excel applicationsMake Excel 2007 work for you! This clear, nonintimidating guide shows you how to use VBA to create Excel apps that look and work the way you want. Packed with plenty of sample programs, it explains how to work with range objects, control program flow, develop custom dialog boxes, create custom toolbars and menus, and much more.Discover how toGrasp essential programming conceptsUse the Visual Basic® EditorNavigate the new Excel user interfaceCommunicate with your usersDeal with errors and bugs
Microsoft Office Excel 2007 Bible
John Walkenbach
This book is a single reference that’s indispensable for Excel beginners, intermediate users, power users, and would-be power users everywhere Fully 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 else John Walkenbach, aka "Mr. Spreadsheet," is one of the liworld’s leading authorities on Excel Thoroughly updated to cover the revamped Excel interface, new file formats, enhanced interactivity with other Office applications, and upgraded collaboration features Includes a valuable CD-ROM with templates and worksheets from the book Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
Microsoft Office Excel 2007 Data Analysis for Dummies
Stephen L. Nelson
Shows ordinary users how to tap the rich data analysis functionality of Excel, make sense of their organization’s critical financial and statistical information, and put together compelling data presentations Now revised with over 30 percent new content to cover the enhancements in Excel 2007, including the completely redesigned user interface, augmented charting and PivotTable capabilities, improved security, and better data exchange through XML Provides thorough coverage of Excel features that are critical to data analysis–working with external databases, creating PivotTables and PivotCharts, using Excel statistical and financial functions, sharing data, harnessing the Solver, taking advantage of the Small Business Finance Manager, and more
Microsoft Office Excel 2007 for Dummies
Greg Harvey
One look at Excel 2007, with its new Office Button, Quick Access toolbar, and Ribbon, and you realize you’re not in Kansas anymore. Well, have no fear— Excel 2007 for Dummies is here! If you’ve never worked with a computer spreadsheet, or if you’ve had some experience with earlier versions of Excel but need help transitioning, here you’ll find everything you need to create, edit, format, and print your own worksheets (without sacrificing your sanity!). Excel 2007 for Dummies covers all the fundamental techniques, concentrating on only the easiest, most user-friendly ways to get things done. You’ll discover how to: Rearrange, delete and insert new information Keep track of and organize data in a single worksheet Transfer data between the sheets of different workbooks Create a chart using the data in a worksheet Add hyperlinks and graphics to worksheets And more! Plus, in keeping with Excel 2007’s more graphical and colorful look, Excel 2007 for Dummies has taken on some color of its own, with full-color plates in the mid-section of the book illustrating exactly what you’ll see on your screen. Whether you read it from cover to cover or skip to the sections that answer your specific questions, the simple guidance in this book will have you excelling at home or in the office no time.
Microsoft Office Excel 2007 for Project Managers
Kim Heldman and William Heldman
Combine the power of Excel 2007, Microsoft Office SharePoint Server, and sound project management tools to boost your skill set and maximize your productivity. You’ll walk through a project and learn how to use these powerful tools to schedule jobs, create budgets, manage processes, and share project information. Whether new to project management or a veteran, you’ll discover techniques, hints, and examples you can use immediately.Maximize Your Productivity with these Project Management Tools and SkillsCombine the power of Excel 2007, Microsoft Office SharePoint Server, and sound project management tools to bring added value to your skill set. You'll walk through a project and learn step by step how to use these powerful tools to schedule jobs, create budgets, manage processes, and share project information. Whether new to project management or a veteran, you'll discover techniques, hints, and examples you can use immediately. As a bonus, Excel templates and checklists are available online that you can apply to your next project.Master the fundamentals of Microsoft Excel 2007 and SharePoint ServerReview key management skills such as communication and negotiationDefine project goals and create a Project CharterLearn the five steps of the project management processSet up schedules, estimates, and budgets using Excel 2007Create Gantt charts, network diagrams, and scatter chartsAssign teams, handle changes, and take corrective actionPublish and archive project information using SharePointValuable extras online!Visit for bonus Excel templates and checklists you can use immediately.
Microsoft Office Project 2007 for Dummies
Nancy C. Muir
Create project plans that make the most of your money and timeGet your projects on track, manage resources, and share information onlineProject 2007 helps you keep your projects on track by providing sophisticated tools for building task outlines and important timing relationships; efficiently assigning people, cost, and material resources; and keeping everyone and everything on schedule. Get an overview of the benefits of Project Server and Project Web Access for communicating with your team and managing your project online.Discover how toEmploy the powerful new features of Project 2007Track down problems with Task DriversExplore Project's new Visual ReportsGet tips for saving time and money on your projects
Microsoft Office Visio 2007 for Dummies
John Paul Mueller and Debbie Walkowski
Reveal your inner business artist with Visio Turn your ideas into diagrams and drawings with Visio's stencils and templates If you have an idea you want to get down on electronic paper, Visio 2007 is for you, and so is this book! They're both flexible and user-friendly. Here's how to use Visio to capture ideas from simple to intricate, update data in a drawing with a single click, add and manipulate text, work with connectors, and more. Discover how to Create business, engineering, software, or network diagrams Format an entire drawing using themes Analyze "what-if" scenarios with PivotDiagrams Produce layered multipage drawings Save drawings to publish on the Web
Outlook 2007 for Dummies
Bill Dyszel
Make scheduling and e-mail more efficient with OutlookControl your contacts, connect to podcasts and blogs, and team up with othersOutlook is a powerhouse for managing that mountain of e-mail, but do you know all the other things it can do? This book walks you through the cool new interface and every feature — sorting and answering your e-mail, activating security safeguards, handling your appointments and to-do list, collaborating with others, and more.Discover how toOrganize information for easier understandingSet up appointments and manage your calendarSort incoming and outgoing e-mailUse notes to write handy remindersSynchronize your schedule and share tasks
Word 2007 for Dummies
Dan Gookin
The word is "easy" with this friendly guide!Take advantage of cool new file formats and cruise around Word's new interfaceFrom bestselling author Dan Gookin, here are words to live by about the world's most popular word processing program — Word 2007. From starting things up (there's a good, better, and best way) to formatting your documents, dressing them up, and giving them style, here's everything you need to know to make sure your words get noticed!Discover how toUse keyboard shortcutsNavigate with scrollbar buttonsUndo and redo editsFormat text, paragraphs, and pagesSplit windows on a single documentCollaborate and review documents