|
Microsoft Office 2007 On Demand
How to Use • Office: Organize information and add impact with clip art, SmartArt diagrams, tables, and charts with a new results-oriented interface • Word: Create great-looking documents faster using themes, styles, and templates • Excel: Use organizing, processing, and presenting tools to create data in Excel • PowerPoint: Create powerful presentations faster using ready-made design templates and themes • Outlook: Use tools for creating and managing your e-mail, calendar, contacts, and tasks • Publisher: Use task panes to quickly create a brochure or a newsletter without being a designer • SharePoint: Collaborate and share documents and information • Prepare for the Microsoft Certified Application Specialist 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 a task. This book also includes workshops to help you put together individual tasks into projects. The Office example files that you need for project tasks are available at www.perspection.com Perspection has written and produced books on a variety of computer software—including Microsoft Office 2003 and XP, Microsoft Windows XP, Apple Mac OS X Panther, Adobe Photoshop CS2, Macromedia Flash 8, Macromedia Director MX, and Macromedia Fireworks—and Web publishing. In 1991, after working for Apple Computer and Microsoft, Steve Johnson founded Perspection, Inc. Perspection is committed to providing information and training to help people use software more effectively. Perspection has written more than 80 computer books, and sold more than 5 million copies. 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. Chapter 1 Getting Started with Office 1 Chapter 2 Using Shared Office Tools 33 Chapter 3 Adding Art to Office Documents 57 Chapter 4 Adding Shapes to Office Documents 93 Chapter 5 Formatting Office Documents 115 Chapter 6 Creating a Document with Word 131 Chapter 7 Formatting a Document with Word 153 Chapter 8 Enhancing a Document with Word 173 Chapter 9 Creating a Worksheet with Excel 211 Chapter 10 Building a Worksheet with Excel 239 Chapter 11 Designing a Worksheet with Excel 281 Chapter 12 Creating a Presentation with PowerPoint 305 Chapter 13 Delivering a Presentation with PowerPoint 343 Chapter 14 Creating a Database with Access 375 Chapter 15 Locating and Managing Data with Access 405 Chapter 16 Presenting Data with Access 423 Chapter 17 Communication with Outlook 447 Chapter 18 Managing Information with Outlook 489 Chapter 19 Creating a Publication with Publisher 519 Chapter 20 Designing a Publication with Publisher 537 Chapter 21 Publishing Office Documents on the Web 557 Chapter 22 Protecting and Securing Office Documents 575 Chapter 23 Reviewing and Sharing Office Documents 605 Chapter 24 Expanding Office Functionality 647 New Features 673 Microsoft Certified Applications Specialist 683
Fantastic prices with ease & comfort of Amazon.com!
|
|
VBA and Macros for Microsoft Office Excel 2007
“In this day and age of ‘too much information and not enough time,’ the ability to get to the bottom line quickly and in a concise method is what excels companies to the top of their industry. The techniques in this book will allow you to do things you only dreamt of.” —Jerry Kohl, president of Brighton Collectibles Develop your Excel macro programming skills using VBA instantly with proven techniques Automate Reports Handle Errors Master Pivot Tables Produce Charts Build User-Defined Functions Migrate to Excel 2007 Query Web Data Build Dialog Boxes Use Data Visualizations Automate Word You are an expert in Excel, but the macro recorder doesn’t work and you can’t make heads or tails out of the recorded code. If this is you, buy this book. Macros that you record today might work today but not tomorrow. Recorded macros might handle a dataset with 14 records but not one with 12 or 16 records. These are all common problems with the macro recorder that unfortunately cause too many Excel gurus to turn away from writing macros. This book shows you why the macro recorder fails and the steps needed to convert recorded code into code that will work every day with every dataset. The book assumes that you know Excel well, but there is no need for prior programming experience. This book describes everything you could conceivably need to know to automate reports and design applications in Excel VBA. Whether you want to automate reports for your office or design full-blown applications for others, this book is for you. Learn VBA syntax as easy-to-understand English Automate Excel’s power tools: Pivot Tables, Charts, Advanced Filters Save hours per week by automating redundant tasks Create applications built on top of Excel with custom dialog boxes Automatically produce hundreds of Excel reports in seconds Understand how changes in Excel 2007 impact your VBA macros Introduction 1 1 Unleash the Power of Excel with VBA 7 2 This Sounds Like BASIC, So Why Doesn’t It Look Familiar? 29 3 Referring to Ranges 61 4 User-Defined Functions 75 5 Looping and Flow Control 101 6 R1C1-Style Formulas 121 7 What’s New in Excel 2007 and What's Changed 135 8 Create and Manipulate Names in VBA 143 9 Event Programming 155 10 UserForms--An Introduction 177 11 Creating Charts 197 12 Data Mining with Advanced Filter 249 13 Using VBA to Create Pivot Tables 281 14 Excel Power 337 15 Data Visualizations and Conditional Formatting 373 16 Reading from and Writing to the Web 393 17 XML in Excel 2007 413 18 Automating Word 421 19 Arrays 441 20 Text File Processing 449 21 Using Access as a Back End to Enhance Multi-User Access to Data 461 22 Creating Classes, Records, and Collections 477 23 Advanced UserForm Techniques 493 24 Windows Application Programming Interface (API) 517 25 Handling Errors 529 26 Customizing the Ribbon to Run Macros 543 27 Creating Add-Ins 569 Index 577
Fantastic prices with ease & comfort of Amazon.com!
|
|
Office 2007 Library: Excel 2007 Bible, Access 2007 Bible, PowerPoint 2007 Bible, Word 2007 Bible
Packed with examples, techniques, and tips from Microsoft MVP John Walkenbach, this perennial bestseller has been updated for Excel 2007 and is equally valuable for beginners and power users. You’ll learn how to master Excel’s new “menuless” Ribbon interface, develop custom functions, create UserForms, analyze data with external database files and PivotTables, and much more. Here’s valuable comprehensive coverage of the fundamentals as well as advanced 2007 features like the new user interface and wider use of XML and Web services.
Fantastic prices with ease & comfort of Amazon.com!
|
|
Office 2010 Bible
The best of the best from the bestselling authors of Excel, Word, and PowerPoint Bibles!Take your pick of applications from the Office 2010 suite and your choice of leading experts to show you how to use them. This Office 2010 Bible features the best-of-the-best content from the Excel 2010 Bible, by "Mr. Spreadsheet" John Walkenbach; the Word 2010 Bible by Microsoft MVP Herb Tyson; the PowerPoint 2010 Bible, by PowerPoint expert Faithe Wempen; and coverage of Access 2010 from Microsoft MVP Michael Alexander. If you want to quickly and effectively begin using Office 2010, start in the experts' corner with this must-have book.Gives you the best-of-the-best content on Office 2010 from the leading experts, authors, and contributors to our Excel, Word, PowerPoint, and Access BiblesIncludes content from John Walkenbach, aka "Mr. Spreadsheet"; Word expert and Microsoft MVP Herb Tyson; PowerPoint expert Faithe Wempen; and Excel and Access expert and Microsoft MVP Michael AlexanderTakes you beyond creating simple text documents, spreadsheets, and presentations to help you use multiple Office applications at once to conquer critical business tasksHones in with expert coverage of the topics within each application that you need to know mostCovers even more from Outlook and other key Office topicsGet the best of four books in one with this power-packed reference!
Fantastic prices with ease & comfort of Amazon.com!
|
|
Excel 2007 Training Videos - 10 Hours of Excel 2007 training by Microsoft Office Specialist Master Instructor: 2000, XP (2002), 2003, 2007 and Microsoft Certified Trainer (MCT), Kirt Kershaw
Are you looking for Affordable, in-depth, high quality, easy to follow Microsoft Office Excel 2007 training videos? Well, look no further because our training videos are developed & trained by a Microsoft Certified Applications Specialist & Microsoft Certified Trainer, Kirt Kershaw. With 118 training videos and over 10 hrs training offered in Flash & Windows Media Video formats you will have everything you need to master, or if desired certify in, Excel 2007. Excel 2007 Training Videos will introduce you to the basics of creating a: spreadsheet, with simple formulas and calculations to more powerful ones, and how you can use Excel 2007 as a database with many sorting and filtering options. It's also important to know how to create the database by watching the top design flaws you can use helpful features! Learn how to create charts from your organized data, how to format your data range into a nice looking table, and more by our Microsoft Certified Trainer! Training Outline: Excel 2007 Level 1 ~ 4 hrs of training Excel 2007 Level 2 ~ 3.5 hrs of training Excel 2007 Level 3 ~ 2.9 hrs of training Please read some of our customers Reviews : Your videos are very professional and easy to follow. Ron - Texas The Microsoft Word 2007 and Excel 2007 training videos are great! Brad - Oregon I watched some of your videos yesterday - excellent. Bob - California I have been promoting your product as great at work all day. I am sure you will get more sells due to me but I wont ask for commission (laughing). This is going to be a big aid when I take the test next week. Jonas J. - Illinois You have a gift for making the seemingly complex easily understandable. Doing a great job. Keep up the good work. Bnewton81. - YouTube
Fantastic prices with ease & comfort of Amazon.com!
|
