Excel, No Tears

Contents:

• 1. Shortcuts
  • 1.1. File
  • 1.2. Ribbon
  • 1.3. Drag and Drop
  • 1.4. Active Cell
  • 1.5. General
  • 1.6. Selection
  • 1.7. Navigation
  • 1.8. Extend Selection
  • 1.9. Select Special
  • 1.10. Cell edit
  • 1.11. Data entry
  • 1.12. Cell format
  • 1.13. Number format
  • 1.14. Border format
  • 1.15. Formulas
  • 1.16. Grid operations
  • 1.17. Pivot tables
  • 1.18. Workbook
  • 1.19. Other
• 2. Formulas and Functions Overview
  • 2.1. Formulas
  • 2.2. Functions
• 3. Functions
  • 3.1. Basic functions
    • 3.1.1. Sum
    • 3.1.2. Average
    • 3.1.3. Count
    • 3.1.4. Max
    • 3.1.5. Min
  • 3.2. Concatenate
  • 3.3. Left, Mid, Right
  • 3.4. Hlookup
  • 3.5. Vlookup
• 4. Nested Formulas
  • 4.1. Index and Match
  • 4.2. Len, And, Or
• 5. Pivot Tables
• 6. Conditional Formatting
• 7. Downloads

About

One-Off Coder is an educational, service and product company. Please visit us online to discover how we may help you achieve life-long success in your personal coding career or with your company’s business goals and objectives.

• Website

• Facebook

• Twitter

• Instagram

• YouTube

• LinkedIn

Copyright

This work is licensed under a Creative Commons Attribution 4.0 International License by One-Off Coder.



The full source code is available on GitHub.

Cite this book as follows.:

@misc{oneoffcoder_excel_notears_2019,
title={Excel, No Tears},
url={https://excel.oneoffcoder.com},
author={One-Off Coder},
year={2019},
month={Nov}}

Author

Tor Vang Jee Vang, Ph.D.

• Patreon