Sep 03, 2011 |
5,931 views |
Book Description
Demonstrate your expertise with Microsoft Office! Designed to help you practice and prepare for four Microsoft Office Specialist (MOS) exams, this all-in-one study guide features:
- Full, objective-by-objective exam coverage
- Easy-to-follow procedures and illustrations to review essential skills
- Hands-on practice tasks to apply what you’ve learned; files included
- Online pre-test to assess your readiness
Use the in-depth exam prep, practice, and review to help advance your proficiency with Microsoft Office—and earn the credential that proves it!
Exams covered:
Companion Content includes:
- Practice files for each exam
- Fully searchable eBook
- Sample chapters from five STEP BY STEP books from Microsoft Press (TBD) Download Now »
Apr 21, 2011 |
9,677 views |
Book Description
Master Microsoft’s Business Intelligence Tools
Building Integrated Business Intelligence Solutions with SQL Server 2008 R2 & Office 2010 explains how to take full advantage of Microsoft’s collaborative business intelligence (BI) tools. A variety of powerful, flexible technologies are covered, including SQL Server Analysis Services (SSAS), Excel, Excel Services, PowerPivot, SQL Server Integration Services (SSIS), Server Reporting Services (SSRS), SharePoint Server 2010, PerformancePoint Services, and Master Data Services. This practical guide focuses on deveoloping end-to-end BI solutions that foster informed decision making.
- Create a multidimensional store for aggregating business data with SSAS
- Maximize the analysis capabilities of Excel and Excel Services
- Combine data from different sources and connect data for analysis with PowerPivot
- Move data into the system using SSIS, InfoPath, Streamsight, and SharePoint 2010 External Lists
- Build and publish reports with SSRS
- Integrate data from disparate applications, using SharePoint 2010 BI features
- Create scorecards and dashboards with PerformancePoint Services
- Summarize large volumes of data in charts and graphs Download Now »
Apr 13, 2011 |
8,277 views |
Book Description
Trade More Profitably by Exploiting Excel’s Powerful New Statistical and Data Mining Tools!
- Uncover subtle anomalies and distortions that signal profit opportunities
- Create powerful new custom indicators, alerts, and trading models
- Visualize and analyze huge amounts of trading data with just a few clicks
- Powerful techniques for every active investor who can use Excel
Now that high-speed traders dominate the market, yesterday’s slower-paced analysis strategies are virtually worthless. To outperform, individual traders must discover fleeting market trends and inefficiencies and act on them before they disappear.
Five years ago, this required multimillion-dollar data mining and analytical infrastructures. Today, you can do it with Microsoft Excel, a powerful PC, and this book.
Step by step, world-class trader Jeff Augen shows how to use Excel 2007 or 2010 to uncover hidden correlations and reliable trade triggers based on subtle anomalies and price distortions…create and test new hypotheses others haven’t considered…visualize data to reveal insights others can’t see!
Download Now »
Apr 06, 2011 |
9,198 views |
Book Description
Get up to speed on the revolutionary changes in Office for the Mac
The 2011 version of the Microsoft Office productivity suite for the Mac sports major changes from what Mac users are accustomed to. This soup-to-nuts guide gets the Mac crowd up to date quickly and easily. Individual minibooks thoroughly cover the Project Gallery, Word, Excel, PowerPoint, Outlook (new for Mac), and the Project Center. You’ll learn how the new Office integrates with the Windows version, how to use and customize the new Ribbon interface, and much more.
- Office for Mac is the most popular office productivity suite for the Mac, used by 1.5 to 2 million people
- The new version includes new features such as the Ribbon interface, Outlook (which replaces Entourage), and greater integration with the Windows version
- Covers everything you’ll want to know about the Project Gallery, Word, Excel, PowerPoint, Outlook, and the Project Center
With Office 2011 for Mac All-in-One For Dummies, you’ll be ready to use the newest version of Office like a pro.
From the Back Cover
Whether you’re a Mac newbie or just eager to get going with Office 2011, start here! Download Now »
Apr 02, 2011 |
10,199 views |
Book Description
Demonstrate your expertise with Microsoft Office 2010! This all-in-one guide is designed to help you practice and prepare for the four core Microsoft Office Specialist (MOS) exams.
With the MOS 2010 Study Guide, you get full, objective-by-objective coverage for:
- Exam 77-881: Microsoft Word 2010
- Exam 77-882: Microsoft Excel 2010
- Exam 77-883: Microsoft PowerPoint 2010
- Exam 77-884: Microsoft Outlook 2010
Use the book’s easy-to-follow procedures and illustrations to review the essential skills measured by the MOS exams. And you can apply what you’ve learned hands-on—using the downloadable files for all the book’s practice tasks.
About the Author
Joan Lambert is the author of more than a dozen books on Windows® and Office, including several popular STEP BY STEP titles from Microsoft Press®.
Joyce Cox has 20+ years of experience developing training materials on technical subjects for non-technical audiences, specializing in Office and Windows® technologies.
Download Now »
Mar 31, 2011 |
3,482 views |
Book Description
Microsoft Excel 2011 for the Mac OS X is a powerful application, but many of its most impressive features can be difficult to find. Guy Hart-Davis’ Learn Excel 2011 for Mac is a practical, hands-on approach to learning all of the details of Excel 2011 to get work done efficiently on Mac OS X. From using formulas and functions to creating databases, from analyzing data to automating tasks, you’ll learn everything you need to know to put this powerful application to use in a variety of tasks.
What you’ll learn
- The secrets of the Excel:Mac interface!
- How to create effective workbooks and templates
- How to quickly format worksheets
- How to perform custom calculations and formulas
- What kind of creative and persuasive charts
- How to illustrate your worksheets with SmartArt, pictures, and more
- What business problem solving can be done with Excel
- How to analyze data with pivot tables
- How to automate tasks with VBA Download Now »
