Excel 2013 On Demand is built from the ground up for today's beginning-to-intermediate-level Exceluser. Like every book in the On Demand Series, it teaches visually, using an easy, friendly, full-color format designed to "show you how," instead of "telling you how." But that's not all. This book: * Combines step-by-step training with quick-reference material users can rely on long after they've mastered the core skills they need * Provides easy-to-follow task-based coverage of the techniques you'll use most often, presenting most tasks in just one or two pages * Offers in-depth coverage of all new MOS (Microsoft Office Specialist) exam objectives, so you can use it as a study guide to enhance your job prospects or current career * Provides additional end-of-chapter workshops, plus even more hands-on projects online * Includes a complete practical troubleshooting guide * Helps you upgrade by presenting New Feature icons, plus a detailed list of new features indexed to the pages where they're covered Simply put, no other book offers beginning-to-intermediate-level Excelusers this much simplicity, usable content, flexibility, and value.

Normal 0 false false false MicrosoftInternetExplorer4 Need answers quickly? Office 2013 on Demand provides those answers in a visual step-by-step format. We will show you exactly what to do through lots of full color illustrations and easy-to-follow instructions. Inside the Book • Office: Organize information and add impact with online pictures and video, SmartArt diagrams, tables, and charts • Word: Create great-looking documents using themes, templates, and video • Excel: Use organizing, processing, and presenting tools to quickly create data tables and charts • PowerPoint: Create powerful presentations faster using ready-made design templates and themes • Access: Use full-featured templates and application parts to create desktop and web app databases. • Outlook: Use tools for creating and managing your e-mail, calendar, contacts, and tasks • Publisher: Use ready-made design templates to quickly create a brochure or a newsletter • Office Web Apps: View and edit your Office documents in a browser • Online Sharing: Save, open, and share Office documents on Skydrive and Office 365 SharePoint from all your devices • Prepare for the Microsoft Office Specialist exam Bonus Online Content Register your book at queondemand.com to gain access to: • Workshops and related files • Keyboard shortcuts Visit the author site: perspection.com Includes • Online Workshops that focus on real-world techniques • MOS Exam Prep • More than 700 of the most essential Office 2013 tasks

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

Need answers quickly? PowerPoint 2013 on Demand provides those answers in a visual step-by-step format. We will show you exactly what to do through lots of full color illustrations and easy-to-follow instructions. Inside the Book • Create powerful presentations faster using ready-made templates • Use gestures to navigate your presentation and slide show on touch screens • Organize information in sections and add impact with online pictures, SmartArt diagrams, tables, and charts • Make your presentation come alive with custom animations, 3-D effects, and slide transitions • Embed, format, trim, and add text to videos in your presentation • Add comments and email or IM your presentation to others for review • Broadcast your presentation over the Internet in a browser • Use SharePoint and SkyDrive to collaborate and share documents • Prepare for the Microsoft Office Specialist (MOS) exam Illustrations with matching steps Tasks are presented on one or two pages Numbered Steps guide you through each task Did You Know? alerts you to tips and techniques See Also points you to related information in the book Bonus Online Content Register your book at queondemand.com to gain access to: • Workshops and related files • Keyboard shortcuts Visit the author site: perspection.com

Need answers quickly? Access 2013 on Demand provides those answers in a visual step-by-step format. We will show you exactly what to do through lots of full color illustrations and easy-to-follow instructions. Inside the Book * Create desktop databases or web apps for traditional and online users to gather, organize, and share data * Use professional templates to help you create desktop databases or web apps * Create web apps on SharePoint Team Services to collaborate and share information * Use tools for building a database or web app that makes information easier to find and use * Import data from other programs, HTML, XML files, and other databases * Use forms, filters, queries, and reports to capture and analyze data * Organize information and add impact with themes, pictures, tables, and charts * Add hyperlinks and web pages to forms and reports to use content on the Internet * Use macros and Visual Basic for Applications (VBA) to automate and add functionality to databases * Prepare for the Microsoft Office Specialist (MOS) exam Numbered Steps guide you through each task See Also points you to related information in the book Did You Know? alerts you to tips and techniques Illustrations with matching steps Tasks are presented on one or two pages Register your book at queondemand.com to gain access to: * Workshops and related files * Keyboard shortcuts Visit the author site: perspection.com

Need answers quickly? SharePoint 2013 on Demand provides those answers in a visual step-by-step format. We will show you exactly what to do through lots of full color illustrations and easy-to-follow instructions. Inside the Book • Take a tour of SharePoint to see what you do • Create a SharePoint site from built-in templates • Use Newsfeed and My Site to stay connected with social networking • Create a blog and community site to collaborate and share ideas • Create lists and libraries to store data and documents on a site • Add built-in apps, or ones from the SharePoint Store, to a site for extended functionality • Synchronize documents to a SkyDrive on SharePoint • Work with Office programs and documents on SharePoint • Upload and use documents and media files on pages • Customize pages with web and app parts • Change site permissions for enhanced security Illustrations with matching steps Tasks are presented on one or two pages Numbered Steps guide you through each task Did You Know? alerts you to tips and techniques See Also points you to related information in the book Bonus Online Content Register your book at queondemand.com to gain access to: • Example files • Keyboard shortcuts Visit the author site: perspection.com

A basic introduction to learn Office 2013 quickly, easily, and in full color Office 2013 has new features and tools to master, and whether you're upgrading from an earlier version or using the Office applications for the first time, you'll appreciate this simplified approach. Offering a clear, visual style of learning, this book provides you with concise, step-by-step instructions and full-color screen shots that walk you through the applications in the Microsoft Office 2013 suite: Word, Excel, PowerPoint, Outlook, and Publisher. Shows you how to tackle dozens of Office 2013 tasks Shares practical examples and beneficial advice to guide you through each application Focuses on visual learners, with step-by-step instructions illustrated with full-color screen shots throughout Office 2013 Simplified makes the new Office suite easy to understand, even if you are new to the software.

Provides timesaving tips, tricks, shortcuts, solutions, and troubleshooting guidelines for Microsoft Excel, Outlook, Word, PowerPoint, and other applications, and explores new features and capabilities of Office 2013.

An indispensible collection of Office 2013 Bibles Eager to delve into the new suite of Office 2013 applications? Look no further than this spectacular collection of four invaluable resources that boast nearly 5,000 pages and cover the core Office programs: Excel, Access, PowerPoint, and Word. The world's leading experts of these applications provide you with an arsenal of information on the latest version of each program. Features four essential books on the most popular applications included in the Office 2013 suite: Excel, Access, PowerPoint, and Word Excel 2013 Bible - serves as an essential reference for Excel users, no matter your level of expertise, and updates you on the latest Excel tips, tricks, and techniques Access 2013 Bible - offers a detailed introduction to database fundamentals and terminology PowerPoint 2013 Bible - shows you how to use the newest features and make successful presentations Word 2013 Bible - begins with a detailed look at all the latest features and then cover more advanced, intricate topics Look no further than Office 2013 Library for the most thorough coverage on every aspect of the Office 2013 suite!

Exceptional managers know that they can create competitive advantages by basing decisions on performance response under alternative scenarios. To create these advantages, managers need to understand how to use statistics to provide information on performance response under alternative scenarios. This updated edition of the popular text helps business students develop competitive advantages for use in their future careers as decision makers. Students learn to build models using logic and experience, produce statistics using Excel 2013 with shortcuts, and translate results into implications for decision makers. The author emphasizes communicating results effectively in plain English and with compelling graphics in the form of memos and PowerPoints. Statistics, from basics to sophisticated models, are illustrated with examples using real data such as students will encounter in their roles as managers. A number of examples focus on business in emerging global markets with particular emphasis on emerging markets in Latin America, China and India. Results are linked to implications for decision making with sensitivity analyses to illustrate how alternate scenarios can be compared. Chapters include screenshots to make it easy to conduct analyses in Excel 2013 with time-saving shortcuts expected in the business world. PivotTables and PivotCharts, used frequently in businesses, are introduced from the start. The Third Edition features Monte Carlo simulation in three chapters, as a tool to illustrate the range of possible outcomes from decision makers’ assumptions and underlying uncertainties. Model building with regression is presented as a process, adding levels of sophistication, with chapters on multicollinearity and remedies, forecasting and model validation, autocorrelation and remedies, indicator variables to represent segment differences, and seasonality, structural shifts or shocks in time series models. Special applications in market segmentation and portfolio analysis are offered, and an introduction to conjoint analysis is included. Nonlinear models are motivated with arguments of diminishing or increasing marginal response.