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
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 Joe Habraken, an Office expert and best selling author
Covers the hottest new features in Word, Excel, PowerPoint, Outlook, Access, and Publisher
For everyone who wants to get the most out of Office 2010, from hobbyists to power users to corporate developers
Office 2010 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone who wants to streamline their work with Office 2010, and get more done in less time. Best selling technology expert Joe Habraken provides specific, tested, proven solutions to the problems Office users run into every day: challenges other books ignore or oversimplify. Habraken thoroughly covers all facets of working with Office 2010′s core features and techniques, and powerful new enhancements such as: ” The updated customizable Ribbon and new Backstage full-screen options menu ” Vastly improved image and illustration tools ” Live Preview for tasks like Paste, Insert, or Theme change ” Improved integration with SharePoint services, Windows Live, and Office Web Apps ” And much more Simply put, no other book offers Office 2010 users this much simplicity, usable content, flexibility, and value. As with all In Depth books, Office 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. This book is both a reference and a desk-side resource, providing in depth coverage of important Office 2010 applications features and tools.
Real solutions, new techniques, innovative shortcuts!
Get started fast with Microsoft Project 2010 and its new Ribbon interface
Plan and initiate your project to maximize the likelihood of success
Create an effective preliminary project schedule
Accurately define task logic and project resources
Prepare work formulas and schedule resource assignments
Refine and review your schedules, and perform an effective “Reality Check”
Use Project 2010 to collaborate more efficiently with colleagues and partners
Track progress and costs, and analyze project performance
Customize Project 2010’s reports, views, tables, filters, groups, fields, toolbars, menus, and forms
Work with multiple projects at once, and resolve complex resource allocation problems
Analyze and present Project data in other applications, including Excel and Visio
Identify and solve problems with your project and with Project 2010 itself
Microsoft Project 2010 In Depth
This is the world’s most expert, complete, and practical guide to succeeding with Microsoft Project 2010! World-renowned project management consultants QuantumPM help you improve Project 2010 planning, scheduling, resource assignments, budgeting, collaboration, workload analysis, progress reporting, completion, closure, and more. Get comfortable with Project 2010, leverage its immense power, and tailor it to your unique needs-no matter how large or complex your project may be!
Access 2010 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone who wants to streamline their work with Access 2010, and get more done in less time. Legendary Access expert Roger Jennings provides specific, tested, proven solutions to the problems Access database users and developers run into every day: challenges other books ignore or oversimplify. Jennings thoroughly covers all facets of working with Access 2010, and adds new chapters on integration and collaboration with Microsoft SharePoint and emulating Table Triggers with Access Data Macros. New coverage also includes: customizable Ribbon and Themes; the revamped Macro Designer; Quick Start Fields; IntelliSense support in Expression Builder; Application Parts and Navigation Forms; conditional formatting and data bars in reports; and new web database publishing techniques. As with all In Depth books, Access 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.
Advice and techniques that you need to get the job done. Looking for ways to streamline your work so you can focus on maximizing your time? Microsoft Word 2010 In Depth provides specific, tested, and proven solutions to the problems you run into every day things other books ignore or oversimplify. This is the one book you can rely on to answer the questions you have now and will have in the future.
Microsoft Word 2010 In Depth offers:
Comprehensive coverage with detailed solutions
Breakthrough techniques and shortcuts that are unavailable elsewhere
Practical, real-world examples with nothing glossed over or left out
Troubleshooting help for tough problems you can’t fix on your own
Outstanding authors recognized worldwide for their expertise and teaching style
Quick information via sidebars, tips, reminders, notes, and warnings
In Depth is the only tool you need to get more done in less time!
Advice and techniques that you need to get the job done. Looking for ways to streamline your work so you can focus on maximizing your time? Microsoft Word 2010 In Depth provides specific, tested, and proven solutions to the problems you run into every day things other books ignore or oversimplify. This is the one book you can rely on to answer the questions you have now and will have in the future.
Use Excel 2010’s powerful statistical tools to gain a deeper understanding of your data, make more accurate and reliable inferences, and solve problems in fields ranging from business to health sciences.
Top Excel guru Conrad Carlberg shows how to use Excel 2010 to perform the core statistical tasks every business professional, student, and researcher should master. Using real-world examples, Carlberg helps you choose the right technique for each problem and get the most out of Excel’s statistical features, including its new consistency functions. Along the way, you discover the most effective ways to use correlation and regression and analysis of variance and covariance. You see how to use Excel to test statistical hypotheses using the normal, binomial, t and F distributions.
Use Excel 2010’s powerful statistical tools to gain a deeper understanding of your data, make more accurate and reliable inferences, and solve problems in fields ranging from business to health sciences.
Becoming an expert with Excel statistics has never been easier! You’ll find crystal-clear instructions, insider insights, and complete step-by-step projects all complemented by an extensive set of web-based resources.
Entries
