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.
Chapter 1 Creating Your First Spreadsheet
Starting a Workbook
Adding Information to a Worksheet
Using the Ribbon
Using the Status Bar
Chapter 2 Adding Information to Worksheets
Adding Different Types of Data
Dealing with Change: Undo, Redo, and AutoRecover
Chapter 3 Moving Data
Moving Cells Around
Adding and Moving Columns or Rows
Chapter 4 Managing Worksheets
Worksheets and Workbooks
Find and Replace
Chapter 5 Formatting Cells
Formatting Cell Values
Formatting Cell Appearance
Chapter 6 Smart Formatting Tricks
The Format Painter
Styles and Themes
Chapter 7 Viewing and Printing Worksheets
Controlling Your View
Formulas and Functions
Chapter 8 Building Basic Formulas
Creating a Basic Formula
Chapter 9 Math and Statistical Functions
Groups of Numbers
General Math Functions
Trigonometry and Advanced Math
Chapter 10 Financial Functions
The World of Finance
Other Financial Functions
Chapter 11 Manipulating Dates, Times, and Text
Manipulating Dates and Times
Chapter 12 Lookup, Reference, and Information Functions
The Basic Lookup
Tutorial: Generating Invoices from a Product Catalog
Chapter 13 Advanced Formula Writing and Troubleshooting
Matthew MacDonald is a science and technology writer with well over a dozen books to his name. Web novices can tiptoe out onto the Internet with him in Creating a Website: The Missing Manual. HTML fans can learn about the cutting edge of web design in HTML5: The Missing Manual. And human beings of all description can discover just how strange they really are in the quirky handbooks Your Brain: The Missing Manual and Your Body: The Missing Manual.