Get the guide that makes learning Microsoft Excel plain and simple! This full color, no-nonsense book shows you the quickest ways to solve a problem or learn a skill, using easy-to-follow steps and concise, straightforward language. You'll analyze, manage, and share information in more ways than ever before. Here’s WHAT You’ll Learn Manage your data quickly and efficiently Filter, sort, summarize, and crunch your numbers Use formulas and functions to do the heavy lifting Bring data to life with charts and graphics Share data between Microsoft Office documents Work as a team, online and in the cloud Here’s HOW You’ll Learn It Jump in wherever you need answers Follow easy STEPS and SCREENSHOTS to see exactly what to do Get handy TIPS for new techniques and shortcuts Use TRY THIS! exercises to apply what you learn right away

Learn the simplest ways to get things done with Microsoft Office 2013 Get the full-color, visual guide that makes learning Microsoft Office 2013 plain and simple! Follow the book’s easy steps and screenshots and clear, concise language to learn the simplest ways to get things done with Microsoft Word, Excel, Outlook, PowerPoint, Access, Publisher, and OneNote. Here’s WHAT you’ll learn: Navigate with mouse, keyboard, or touch Create documents, reports, databases, and presentations Share your desktop, worksheets, and files Manage your email and organize your calendar Stay connected with online meetings and instant messaging Access your programs and your documents via the cloud Here’s HOW you’ll learn it: Jump in wherever you need answers Follow easy STEPS and SCREENSHOTS to see exactly what to do Get handy TIPS for new techniques and shortcuts Use TRY THIS! Exercises to apply what you learn right away

Transform your skills, data, and business and create your own BI solutions using software you already know and love: Microsoft Excel. Two business intelligence (BI) experts take you inside PowerPivot functionality for Excel® 2013, with a focus on real world scenarios, problem-solving, and data modeling. You'll learn how to quickly turn mass quantities of data into meaningful information and on-the-job results?no programming required!

Master business modeling and analysis techniques with Microsoft Excel 2013, and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables—and how to effectively build a relational data source inside an Excel workbook. Solve real business problems with Excel—and sharpen your edge Summarize data with PivotTables and Descriptive Statistics Explore new trends in predictive and prescriptive analytics Use Excel Trend Curves, multiple regression, and exponential smoothing Master advanced Excel functions such as OFFSET and INDIRECT Delve into key financial, statistical, and time functions Make your charts more effective with the Power View tool Tame complex optimization problems with Excel Solver Run Monte Carlo simulations on stock prices and bidding models Apply important modeling tools such as the Inquire add-in

The world’s most popular spreadsheet program is now more powerful than ever, but it’s also more complex. That’s where this Missing Manual comes in. With crystal-clear explanations and hands-on examples, Excel 2013: The Missing Manual shows you how to master Excel so you can easily track, analyze, and chart your data. You’ll be using new features like PowerPivot and Flash Fill in no time. The important stuff you need to know: Go from novice to ace. Learn how to analyze your data, from writing your first formula to charting your results. Illustrate trends. Discover the clearest way to present your data using Excel’s new Quick Analysis feature. Broaden your analysis. Use pivot tables, slicers, and timelines to examine your data from different perspectives. Import data. Pull data from a variety of sources, including website data feeds and corporate databases. Work from the Web. Launch and manage your workbooks on the road, using the new Excel Web App. Share your worksheets. Store Excel files on SkyDrive and collaborate with colleagues on Facebook, Twitter, and LinkedIn. Master the new data model. Use PowerPivot to work with millions of rows of data. Make calculations. Review financial data, use math and scientific formulas, and perform statistical analyses.

Learn the simplest ways to get things done with Microsoft Office 2013 for Tablets Get the full-color, visual guide that makes learning Microsoft Office 2013 on your touch-enabled devices plain and simple! Follow the book’s easy steps and screenshots and clear, concise language to learn the simplest ways to get things done with Microsoft Word, Excel, Outlook, PowerPoint, Access, Publisher, and OneNote—all in touch mode. Here’s WHAT you’ll learn: Tap the power of Office on your touch device Stay in the loop with Ims, social media, and email Create, share, and collaborate on documents Put together professional-looking publications Analyze your worksheet data on the fly Set up an online meeting with your team Here’s HOW you’ll learn it: Jump in wherever you need answers Follow easy STEPS and SCREENSHOTS to see exactly what to do Get handy TIPS for new techniques and shortcuts Use TRY THIS! Exercises to apply what you learn right away

Get the full-color, visual guide that makes learning Microsoft Word 2013 plain and simple! Follow the book’s easy steps and screenshots and clear, concise language to learn the simplest ways to create and share documents. Here’s WHAT you’ll learn: Create, edit, format, and share text Add graphics, data, table, and charts Improve page layout to best present your ideas Use and make templates for increased productivity Collaborate and present documents online Access your documents from almost any browser Here’s HOW you’ll learn it: Jump in wherever you need answers Follow easy STEPS and SCREENSHOTS to see exactly what to do Get handy TIPS for new techniques and shortcuts Use TRY THIS! Exercises to apply what you learn right away

Get the full-color, visual guide that makes learning Microsoft Project 2013 plain and simple! Follow the book’s easy steps and screenshots and clear, concise language to learn the simplest ways to effectively manage all your projects. Here’s WHAT you’ll learn: Develop a project plan and schedule resources Pull together your team and plan their assignments Understand dependencies and mitigate risks Stay on top of progress, delays, and costs Make adjustments and updates quickly Communicate with clear, customized reports Here’s HOW you’ll learn it: Jump in wherever you need answers Follow easy STEPS and SCREENSHOTS to see exactly what to do Get handy TIPS for new techniques and shortcuts Use TRY THIS! exercises to apply what you learn right away

Presents a guide to Office Professional 2013, describing such tasks as creating documents, spreadsheets, and slide presentations; managing email; and organizing notes, covering the Microsoft programs Word, Excel, Access, OneNote, Publisher, Outlook, and PowerPoint.

Get the full-color, visual guide that makes learning Microsoft OneNote 2013 plain and simple! Follow the book’s easy steps and screenshots and clear, concise language to learn the simplest ways to organize information and manage your work and personal lives. Here’s WHAT you’ll learn: Take notes, organize, and share them Bookmark and tag notes for easier searching Add pictures, drawings, and spreadsheets Handwrite notes and convert them to text Record audio and video notes Access notes from the web or mobile device Here’s HOW you’ll learn it: Jump in wherever you need answers Follow easy STEPS and SCREENSHOTS to see exactly what to do Get handy TIPS for new techniques and shortcuts Use TRY THIS! Exercises to apply what you learn right away