Book description
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.
Publisher resources
Table of contents
- Excel 2013: The Missing Manual
- The Missing Credits
- Introduction
-
1. Worksheet Basics
- 1. Creating Your First Spreadsheet
- 2. Adding Information to Worksheets
- 3. Moving Data
- 4. Managing Worksheets
- 5. Formatting Cells
- 6. Smart Formatting Tricks
- 7. Viewing and Printing Worksheets
-
2. Formulas and Functions
- 8. Building Basic Formulas
-
9. Math and Statistical Functions
- Rounding Numbers
-
Groups of Numbers
- SUM(): Summing Up Numbers
- COUNT(), COUNTA(), and COUNTBLANK(): Counting Items in a List
- MAX() and MIN(): Finding Maximum and Minimum Values
- LARGE(), SMALL(), and RANK(): Ranking Numbers
- AVERAGE() and MEDIAN(): Finding Average or Median Values
- PERCENTILE() and PERCENTRANK(): Advanced Ranking Functions
- FREQUENCY(): Putting Numbers into Grouped Ranges
- MODE(): Finding Numbers That Frequently Occur in a List
-
General Math Functions
- PRODUCT(), FACT(), POWER(), and SQRT(): Products, Factorials, Powers, and Square Roots
- QUOTIENT() and MOD(): Higher Division
- ABS() and SIGN(): Absolute Value and Determining a Numberâs Sign
- RAND() and RANDBETWEEN(): Generating Random Numbers
- GCD() and LCM(): Greatest and Least Common Denominator
- COMBIN() and PERMUT(): Figuring Combinations and Permutations
- BASE() and DECIMAL(): Converting Numbers to Different Bases
- ROMAN() and ARABIC(): Using Roman Numerals
- Trigonometry and Advanced Math
- Advanced Statistics
-
10. Financial Functions
- The World of Finance
-
Financial Functions
- FV(): Future Value
- PV(): Present Value
- PMT(), PPMT(), and IPMT(): Calculating the Number of Payments You Need to Make
- NPER(): Figuring Out How Much Time You Need to Pay Off a Loan or Meet an Investment Target
- RATE(): Calculating the Interest Rate You Need to Achieve a Target
- RRI(): Calculating the Interest Rate Your Investments Achieve
- NPV() and IRR(): Net Present Value and Internal Rate of Return
- Depreciation
- Other Financial Functions
-
11. Manipulating Dates, Times, and Text
-
Manipulating Text
- CONCATENATE(): Joining Strings of Text Together
- LEFT(), MID(), and RIGHT(): Copying Portions of a Text String
- LEN(), FIND(), and SEARCH(): Counting Characters in a String
- UPPER(), LOWER(), and PROPER(): Changing Capitalization
- TRIM() and CLEAN(): Removing Unwanted Spaces and Non-Printing Characters
- SUBSTITUTE(): Replacing One Sequence of Characters with Another
- TEXT(), VALUE(), FIXED(), and DOLLAR(): Converting Text to Numbers and Vice Versa
- Other Text Functions
-
Manipulating Dates and Times
- Math with Dates and Times
- TODAY() and NOW(): Inserting the Current Date and Time
- DATE() and TIME(): Dates and Times in Calculations
- DAY(), MONTH(), and YEAR(): More Date Calculations
- HOUR(), MINUTE(), SECOND(): More Time Calculations
- WEEKDAY(): Determining the Day of the Week
- DATEDIF(): Calculating the Difference Between Dates
- DATEVALUE() and TIMEVALUE(): Converting Dates and Times into Serial Numbers
- DAYS360(): Finding Out the Number of Days Between Two Dates
- EDATE(): Calculating Future Dates
- YEARFRAC(): Calculating the Percentage of a Year Between Two Dates
- EOMONTH(): Finding the Last Day of Any Month
- NETWORKDAYS(): Counting the Number of Business Days
- WORKDAY(): Figuring Out When Days Will Fall in the Future
- WEEKNUM(): Figuring Out in Which Week a Date Falls
-
Manipulating Text
-
12. Lookup, Reference, and Information Functions
- The Basic Lookup
-
Advanced Lookups
- MATCH(): Finding the Position of Items in a Range
- INDEX(): Retrieving the Value from a Cell
- Performing a âLeft Lookupâ
- Performing a Double Lookup
- OFFSET(): Shifting Cell References
- FORMULATEXT(): Getting the Text of a Formula
- Other Reference and Lookup Functions
- INDIRECT() and ADDRESS(): Working with Cell References Stored As Text
- TRANSPOSE(): Changing Rows to Columns and Vice Versa
- The HYPERLINK() Function: Creating a Dynamic Link
- Information Functions
- Tutorial: Generating Invoices from a Product Catalog
- 13. Advanced Formula Writing and Troubleshooting
- 3. Organizing Your Information
-
4. Charts and Graphics
- 17. Creating Basic Charts
- 18. Formatting and Perfecting Charts
- 19. Inserting Graphics
- 20. Visualizing Your Data
-
5. Sharing Data with the Rest of the World
- 21. Protecting Your Workbooks
- 22. Worksheet Collaboration
- 23. Using Excel on the Web
- 24. Exchanging Data with Other Programs
-
6. Advanced Data Analysis
- 25. Scenarios and Goal Seeking
- 26. Pivot Tables
- 27. Analyzing Databases
- 28. Analyzing XML and Web Data
- 7. Programming Excel
- 8. Appendix
- Index
- About the Author
- Copyright
Product information
- Title: Excel 2013: The Missing Manual
- Author(s):
- Release date: April 2013
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9781449359515
You might also like
book
Excel 2013 Bible
Excel at Excel with the help of this bestselling spreadsheet guide John Walkenbach's name is synonymous …
book
Essential Excel 2016: A Step-by-Step Guide
This book shows you how easy it is to create, edit, sort, analyze, summarize and format …
book
Excel Formulas & Functions For Dummies, 5th Edition
Put the power of Excel functions to work in your formulas There are more than 400 …
book
Advanced Excel Essentials
" Advanced Excel Essentials is the only book for the experienced Excel developer. This book starts …