Excel is the world's most popular spreadsheet program and the de facto standard for numerical analysis. But this complex program can take a lifetime to learn without the right guide. That's where Excel 2013: The Missing Manual comes in. With crystal-clear explanations, hands-on examples, and lots of undocumented tips, tricks, and workarounds, this jargon-free book helps you master Excel's raft of impressive features. The important stuff you need to know: Go from novice to ace. Learn everything from writing your first formula to analyzing data. Perform a variety of calculations. Enter raw data and have Excel perform financial analyses, math operations, and statistical analyses Illustrate trends. Bring your data to life using charting, summarizing, and data visualization options in the Quick Analysis feature Examine your data. Summarize information and find hidden patterns with pivot tables and slicers Pinpoint the data you need. Use the handy timeline filter to browse specific date ranges in a mass of pivot table data Share your spreadsheets. Store Excel files on SkyDrive and collaborate with colleagues on Facebook, Twitter, and LinkedIn