How to Use Microsoft Excel 2013

How to Use Microsoft Excel 2013

Step by Step Guide to Operating and Understanding Excel Better

Table of Contents

1. How to enter basic formulas and calculations in Excel
2. Creating formulas that refer to other cells in the same worksheet
3. Creating formulas that link to other workbooks
4. Add up a column or row of cells in Excel
5. Option One – simple addition
6. Option Two – use the SUM() function
7. Option 3 – Autosum – a shortcut
8. Absolute and relative references in Excel
9. Relative references
10. Copying and pasting a formula containing relative references
11. Absolute References
12. More on absolute references
13. Cutting and pasting formulas
14. Rounding numbers in Excel
15. Rounding versus Formatting in Excel
16. The ROUND function
17. Scale your spreadsheet to fit on one page when printing from Excel
18. Freeze or lock rows and columns in an Excel worksheet
19. Why you might need to freeze rows or columns in your spreadsheet
20. How to freeze rows and columns
21. How to use the IF function in Excel
22. Logical Tests in Excel
23. How to create a Pivot Table in Excel