Excel 2010 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone who wants to streamline their work with Excel 2010, and get more done in less time. Legendary Excel expert Bill Jelen provides specific, tested, proven solutions to the problems Excel users run into every day: challenges other books ignore or oversimplify. Jelen thoroughly covers all facets of working with Excel 2010, and adds new chapters on Excel Web App which allows multiple users to edit a spreadsheet simultaneously. New coverage also includes: Slicer, which offers dynamic filtering of PivotTables; Sparklines, which add data visualization to any cell; Calculation engine which improves the speed and accuracy of math, financial, and statistical functions; and the new version of Solver. As with all In Depth books, Excel 2010 In Depth presents comprehensive coverage, breakthrough techniques, exclusive shortcuts, quick access to information, troubleshooting help for tough problems, and real-world examples with nothing glossed over or left out. Step-by-step instructions with icons guide readers through essential tasks such as designing tables, entering data, importing external data, designing and executing queries, and designing data entry forms and printed reports. Additional chapters on advanced form and report design emphasize data entry efficiency and presentation clarity. By Bill Jelen, aka MrExcel, an Excel MVP and the principal behind the leading Excel website, MrExcel.com Covers all aspects of working with Excel 2010, from its updated Ribbon interface to its breakthrough collaboration and improved business intelligence For everyone who wants to get the most out of Excel 2010, from casual users to corporate professionals
Find the answers to your most important Excel questions with this reference John Walkenbach’s name is synonymous with excellence in computer books that decipher complex technical topics. Known as "Mr. Spreadsheet," Walkenbach—along with Excel expert Colin Banfield—answers your most common and important Excel questions in this easy-to-understand reference. You'll learn how to open, save, protect, and recover workbook files; add, copy, and delete worksheets; enter and edit data and text; create formulas and functions; audit, format, and print; and more. Highly organized and free of unnecessary jargon, this essential reference allows you to find the answers you’re looking for quickly and easily. Excel gurus Walkenbach and Banfield offer quick and easy answers to common Excel questions Offers information in a highly organized, easy-to-understand format so you can find exactly what you need Includes information on opening, saving, protecting and recovering workbook files; adding, copying, and deleting worksheets; entering and editing data and text; creating formulas and functions; auditing; formatting; printing; and more Covers navigating the user interface; using the Ribbon and Quick Access toolbar; saving, protecting, and recovering workbook files; entering and editing data; creating formulas and functions, and much more Excel 2010 For Dummies Quick Reference enables you to spend more time working on your projects rather than trying to figure how to make Excel work for you!
Master the leading spreadsheet and data analysis tool with this book-and-CD package! Learn step by step to create worksheets, work with formulas and functions, format data, use financial functions, and more.
This is the first book to show the capabilities of Microsoft Excel to teach physical sciences statistics effectively. It is a step-by-step exercise-driven guide for students and practitioners who need to master Excel to solve practical science problems. If understanding statistics isn’t your strongest suit, you are not especially mathematically-inclined, or if you are wary of computers, this is the right book for you. Excel, a widely available computer program for students and managers, is also an effective teaching and learning tool for quantitative analyses in science courses. Its powerful computational ability and graphical functions make learning statistics much easier than in years past. However, Excel 2010 for Physical Sciences Statistics: A Guide to Solving Practical Problems is the first book to capitalize on these improvements by teaching students and managers how to apply Excel to statistical techniques necessary in their courses and work. Each chapter explains statistical formulas and directs the reader to use Excel commands to solve specific, easy-to-understand science problems. Practice problems are provided at the end of each chapter with their solutions in an appendix. Separately, there is a full Practice Test (with answers in an Appendix) that allows readers to test what they have learned. Includes 159 illustrations in color Suitable for undergraduates or graduate students
Simplify SharePoint with this comprehensive, understandable guide SharePoint is a Microsoft technology that enables project collaboration through a single portal. It can be complex, but not when approached the Dummies way! This guide offers eight self-contained minibooks that examine each aspect of SharePoint 2010. Whether you're an experienced administrator or developer or you're just getting your feet wet, you'll find it's easy to locate what you need and learn to install, configure, and manage a SharePoint portal. You can dig as deeply into SharePoint as you want or need to. SharePoint 2010 is the newest version of collaboration technology that allows you to aggregate SharePoint sites, information, and applications into a single portal Administrators, page producers, and developers will be able to get SharePoint installed, configured, and running with the advice in this guide Eight minibooks address the Microsoft Office SharePoint system, SharePoint services, collaboration, SharePoint Server, enterprise content management, managing users, architecting SharePoint, and SharePoint deployment Covers planning, installation, configuration, performance, troubleshooting, data structure, and more If you work with SharePoint, you'll find Microsoft SharePoint 2010 All-in-One For Dummies provides what you need to get starting and keep going with SharePoint 2010.
The complete book-and-video training package for Office 2010! This Microsoft Office 2010 book-and-video training package-from the same professional training experts who also create many training materials for Microsoft-is like having your own personal instructor guiding you through each lesson, but you work at your own pace! The full-color book includes 27 lessons that teach you the new features and quirks of Microsoft Office 2010. Each lesson includes step-by-step instructions and lesson files, and provides valuable video tutorials that complement what you're learning and clearly demonstrate how to do tasks. This jam-packed training package takes you well beyond the basics in a series of easy-to-absorb, five-minute lessons. Shows you how to use Microsoft Office 2010, the new version of the Microsoft Office suite that is available in standard 32-bit and now also a 64-bit version Walks you through 27 lessons, each consisting of easy-to-follow, step-by-step instructions and lesson files in full color that make each task less intimidating Includes all the lesson files from the book and video tutorials that clearly show you how to do tasks and reinforces what you're learning in the book Covers exciting new Office 2010 features such as Office Web apps that can be accessed from anywhere and a streamlined new Ribbon Provides the perfect, one-stop, robust learning package-with book and supplementary video training on all the applications in Office 2010 Additional resources available on companion Web site: www.digitalclassroombooks.com Learn the ins-and-outs of Office 2010 with this all-in-one, value-packed combo!
A comprehensive guide to programming for Access 2010 and 2007 Millions of people use the Access database applications, and hundreds of thousands of developers work with Access daily. Access 2010 brings better integration with SQL Server and enhanced XML support; this Wrox guide shows developers how to take advantage of these and other improvements. With in-depth coverage of VBA, macros, and other programming methods for building Access applications, this book also provides real-world code examples to demonstrate each topic. Access 2010 Programmer's Referenceis a comprehensive guide to the best-of-breed techniques for programming Access applications. Coverage Includes: Introduction to Microsoft Access 2010 New Features Upgrading and Converting to Access 2010 Macros in Access 2010 Using the VBA Editor VBA Basics Using VBA in Access Creating Classes in VBA Extending VBA with APIs Working with the Windows Registry Using DAO to Access Data Using ADO to Access Data Using SQL with VBA Using VBA to Enhance Forms Enhancing Reports with VBA Customizing the Ribbon Customizing the Office Backstage Working with Office 2010 Working with SharePoint Working with .NET Building Client-Server Applications with Access The Access 2010 Templates Access Runtime Deployment Database Security Access 2010 Security Features
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 Bibles Includes 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 Alexander Takes you beyond creating simple text documents, spreadsheets, and presentations to help you use multiple Office applications at once to conquer critical business tasks Hones in with expert coverage of the topics within each application that you need to know most Covers even more from Outlook and other key Office topics Get the best of four books in one with this power-packed reference!
Microsoft Office is the most widely used productivity software in the world, but most people just know the basics. This helpful guide gets you started with the programs in Office 2013, and provides lots of power-user tips and tricks when you’re ready for more. You’ll learn about Office’s new templates and themes, touchscreen features, and other advances, including Excel’s Quick Analysis tool. The important stuff you need to know: Create professional-looking documents. Use Word to craft reports, newsletters, and brochures for the Web and desktop. Stay organized. Set up Outlook to track your email, contacts, appointments, and tasks. Work faster with Excel. Determine the best way to present your data with the new Quick Analysis tool. Make inspiring presentations. Build PowerPoint slideshows with video and audio clips, charts and graphs, and animations. Share your Access database. Design a custom database and let other people view it in their web browsers. Get to know the whole suite. Use other handy Office tools: Publisher, OneNote, and a full range of Office Web Apps. Create and share documents in the cloud. Upload and work with your Office files in Microsoft’s SkyDrive.