Microsoft Office Excel 2007 is the biggest revision this industry standard software has undergone in years. It has a brand new interface, tons of new tools and even a suite of services called Excel Services to allow you to share your valuable data on the web. For the first time in years there is a lot to learn to make the most of this powerful new update. To take advantage of all of the new features in this powerful program (and to do so quickly), users need this Vi sual QuickStart Guide. In these pages, veteran author and trusted Excel teacher Maria Langer provides step-by-step instructions for the full gamut of Excel tasks: from worksheet basics like editing, using functions, formatting cells, and adding graphics objects, to more advanced topics like creating charts, working with databases, and Web publishing. As with all Visual QuickStart Gui de books, clear, concise instructions and lots of visual aids make learning easy and painless.
Provides detailed instruction in the fundamental features and functions of Access, Excel, FrontPage, Outlook, PowerPoint, Publisher, and Word, as well as InfoPath, SharePoint, LiveMeeting, and Groove--and the new integration features of the new version of the Office suite.
Brilliant guides allow you to find the info you need easily and without fuss and guide you through the task using a highly visual, step-by-step approach - providing exactly what you need to know, when you need it !! Brilliant Excel 2007 will show you how to .... · Create workbooks more efficiently using the new results-oriented interface · Use data analysis tools and techniques for better decision making · Use organizing, processing, and presenting tools to create data in Excel · Integrate data from external sources and add hyperlinks · Use conditional formatting to visualize results · Create your own macros to automate your work · Add impact to your data with PivotTable and PivotChart reports · Create organizational data reporting and publishing solutions · Organize information and impact with clip art, SmartArt diagrams, tables and charts · Use Groove and SharePoint Team Services to collaborate and share documents and information
You already know Excel 2007. Now you'd like to go beyond with shortcuts, tricks, and tips that let you work smarter and faster. And because you learn more easily when someone shows you how, this is the book for you. Inside, you'll find clear, illustrated instructions for 100 tasks that reveal cool secrets, teach timesaving tricks, and explain great tips guaranteedto make you more productive with Excel 2007. * Minimal text and maximum illustrations * Task-oriented, step-by-step approach * Navigational aids connect instructions to illustrations * Self-contained, two-page lessons * Uniform layout makes it easy to read less, learn more How easy is it? Look for these symbols marking the difficulty of each task. * Demonstrates a new spin on a common task * Introduces a new skill or a new task * Combines multiple skills requiring in-depth knowledge * Requires extensive skill and may involve other technologies
Quickly teach yourself how to automate tasks and create custom spreadsheet solutions with Excel 2007 Visual Basic for Applications (VBA). With Step By Step, you set the pace—building and practicing the skills you need, just when you need them! Create macros to automate repetitive tasks Automatically format charts, shapes, and text Manipulate tables and other objects—even build PivotTable reports Write your own functions and procedures Use loops and conditions to add decision logic to macros Build custom command buttons, dialog boxes, and user forms Your all-in-one learning experience includes: Files for building skills and practicing the book’s lessons Fully searchable eBook Windows Vista Product Guide eReference—plus other resources on CD For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.
Experience learning made easy—and quickly teach yourself how to organize, analyze, and present data with Excel 2007. With Step By Step, you set the pace—building and practicing the skills you need, just when you need them! Create formulas, calculate values, and analyze data Present information visually with graphics, charts, and diagrams Build PivotTable dynamic views—even easier with new data tables Reuse information from databases and other documents Share spreadsheets for review and manage changes Create macros to automate repetitive tasks and simplify your work Your all-in-one learning experience includes: Files for building skills and practicing the book’s lessons Fully searchable eBook Bonus quick reference to the Ribbon, the new Microsoft Office interface Windows Vista Product Guide eReference—plus other resources on CD For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.
Completely redesigned to help users finish tasks more quickly and manage information more effectively, Microsoft Office 2007 will offer users a new look and smarter ways of getting things done. From the expanded depth and power of Excel 2007 to the new graphics capabilities and formatting tools of PowerPoint, Microsoft has rethought and reworked the entire suite. And in this new edition of our Office Visual QuickStart Guide, author Steve Schwartz has rewritten from the ground up the entire book to better aid readers as they get up to speed with the new Office tools. The book is essential reference tool for the home and small business user, covering everything in the Office Basic, Home & Student, Standard, and Small Business suites. Software covered includes: Word, Excel, OneNote, Outlook, PowerPoint, and Publisher. Easy visual approach uses pictures to guide you through Microsoft Office and show you what to do. Concise steps and explanations let you get up and running in no time. Page for page, the best content and value around. Table of Contents: Part I: Introducing Microsoft Office 2007 Chapter 1: What's New in Office 2007? Chapter 2: Office Basics Part II: Microsoft Word Chapter 3: Getting Started with Word 2007 Chapter 4: Formatting Documents Chapter 5: Creating Outlines Chapter 6: Tables, Charts, and Art Chapter 7: Sharing Word Documents Part III: Microsoft Excel Chapter 8: Getting Started with Excel 2007 Chapter 9: Formatting Worksheets and Data Chapter 10: Formulas and Functions Chapter 11: Working with Tables Chapter 12: Creating Charts Part IV: Microsoft PowerPoint Chapter 13: Getting Started with PowerPoint 2007 Chapter 14: Creating a Presentation Chapter 15: Completing a Presentation Part V: Microsoft Outlook Chapter 16: Getting Started with Outlook 2007 Chapter 17: Using the Address Book Chapter 18: Composing and Sending Mail Chapter 19: Receiving Mail Chapter 20: Managing the Mail Chapter 21: Tasks and Appointments Part VI: Microsoft OneNote Chapter 22: Getting Started with OneNote 2007 Chapter 23: Creating Notes Chapter 24: Embellishing and Editing Notes Chapter 25: Managing Notes Part VII: Microsoft Publisher Chapter 26: Getting Started with Publisher 2007 Chapter 27: Distributing and Printing Index
How to use • Create workbooks more efficiently using a new results-oriented interface • Use data-analysis tools and techniques for better decision making • Use organizing, processing, and presenting tools to create data in Excel • Integrate data from external sources and add hyperlinks • Use conditional formatting to visualize results • Add impact to your data with PivotTable and PivotChart reports • Create organizational data reporting and publishing solutions • Organize information and add impact with clip art, SmartArt diagrams, tables, and charts • Use Groove and SharePoint Team Services to collaborate and share documents and information • Prepare for the Microsoft Certified Application Specialist (MCAS) exam • Practice your new skills with the useful workshops inside On the Web This book uses real-world examples to give you a context in which to use the task. This book also includes workshops to help you put together individual tasks into projects. The Excel example files that you need for project tasks are available at www.perspection.com. Includes MCAS Exam Objectives! This courseware meets the objectives for the Microsoft Certified Application Specialist (MCAS). Upon completion of this courseware, you may be prepared to take the exam for MCAS qualification. To learn more about becoming a Microsoft Certified Application Specialist, visit www.microsoft.com.
