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.
HTML5 is more than a markup language - it´s a collection of several independent web standards. Fortunately, this expanded guide covers everything you need in one convenient place. With step-by-step tutorials and real-world examples, HTML5: The Missing Manual shows you how to build web apps that include video tools, dynamic graphics, geolocation, offline features, and responsive layouts for mobile devices. The important stuff you need to know: Structure web pages more effectively. Learn how HTML5 helps web design tools and search engines work smarter. Add audio and video without plugins. Build playback pages that work in every browser. Create stunning visuals with Canvas. Draw shapes, pictures, and text; play animations; and run interactive games. Jazz up your pages with CSS3. Add fancy fonts and eye-catching effects with transitions and animation. Design better web forms. Collect information from visitors more efficiently with HTML5 form elements. Build it once, run it everywhere. Use responsive design to make your site look good on desktops, tablets, and smartphones. Include rich desktop features. Build self-sufficient web apps that work offline and store the data users need.