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

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

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? 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

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

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.