The worldas most popular spreadsheet program is now more powerful than ever, but itas also more complex. Thatas 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. Youall 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 Excelas 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.PIVOT TABLE Fortunately, Excel makes it easy to change the type of calculation you use. And as CALCULATIONS youa#39;ll see in the following sections, you can even perform more than one calculation in the same pivot table, and throw youranbsp;...
|Title||:||Excel 2013: The Missing Manual|
|Publisher||:||"O'Reilly Media, Inc." - 2013-04-18|