Excel 2013 On Demand

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.

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

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.

What you need, when you need it! Need answers quickly? Microsoft Excel 2010 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. Includes Workshops MCAS Exam Prep More than 500 Essential Excel Tasks Inside the Book • Create workbooks more efficiently using the improved Ribbon interface • Use data-analysis tools and techniques for better decision making • Use organizing, processing, and presenting tools to create and analyze data • Integrate data from external sources and add hyperlinks • Use conditional formatting and Sparklines to visualize results • Add impact to your data with PivotTable and PivotChart reports • Organize information and add impact with clip art, SmartArt diagrams, tables, and charts • Use SharePoint to collaborate and share documents • Use the Excel Web App to view and edit documents in a browser • Prepare for the Microsoft Certified Application Specialist (MCAS) exam Bonus Online Content Register your book at queondemand.com to gain access to: • Workshops and related files • Keyboard shortcuts

Learn the new Microsoft Office suite the easy, visualway Microsoft Office 2013 is a power-packed suite of officeproductivity tools including Word, Excel, PowerPoint, Outlook,Access, and Publisher. This easy-to-use visual guide covers thebasics of all six programs, with step-by-step instructions andfull-color screen shots showing what you should see at each step.You'll also learn about using Office Internet and graphics tools,while the additional examples and advice scattered through the bookgive you tips on maximizing the Office suite. If you learn bestwhen you can see how things are done, this book is for you. Shows you how to use Microsoft Office 2013 with easy-to-follow,step-by-step instructions illustrated with full-color screenshots Covers Word, Excel, PowerPoint, Outlook, Access, andPublisher Includes additional information on using Office Internet andgraphics tools Designed to help visual learners read less and learn more Teach Yourself VISUALLY Office 2013 shows you how to useall six tools in the Office suite, step by step.

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.

Go beyond technique to master the difficult judgement calls of forecasting A variety of software can be used effectively to achieve accurate forecasting, but no software can replace the essential human component. You may be new to forecasting, or you may have mastered the statistical theory behind the software’s predictions, and even more advanced “power user” techniques for the software itself—but your forecasts will never reach peak accuracy unless you master the complex judgement calls that the software cannot make. Profit From Your Forecasting Software addresses the issues that arise regularly, and shows you how to make the correct decisions to get the most out of your software. Taking a non-mathematical approach to the various forecasting models, the discussion covers common everyday decisions such as model choice, forecast adjustment, product hierarchies, safety stock levels, model fit, testing, and much more. Clear explanations help you better understand seasonal indices, smoothing coefficients, mean absolute percentage error, and r-squared, and an exploration of psychological biases provides insight into the decision to override the software’s forecast. With a focus on choice, interpretation, and judgement, this book goes beyond the technical manuals to help you truly grasp the more intangible skills that lead to better accuracy. Explore the advantages and disadvantages of alternative forecasting methods in different situations Master the interpretation and evaluation of your software’s output Learn the subconscious biases that could affect your judgement toward intervention Find expert guidance on testing, planning, and configuration to help you get the most out of your software Relevant to sales forecasters, demand planners, and analysts across industries, Profit From Your Forecasting Software is the much sought-after “missing piece” in forecasting reference.