Formulas and Functions
Formulas and Functions in Excel
Categories:
less than a minute
This Document is actively being developed as a part of ongoing Excel learning efforts. Chapters will be added periodically.
Excel: Formulas and Functions
This guide will help you with the formulas and functions for Microsoft Excel, including creating spreadsheets, entering data, and using basic formulas.
Topics Covered
- How to Create Your First Formula in Excel
- How to Use the SUM Function in Excel
- How to Use the AVERAGE Function in Excel
- How to Use the COUNT Function in Excel
- How to Use the COUNTA Function in Excel
- How to Use COUNTBLANK in Excel
- How to Use the IF Function in Excel
- How to Use Nested IF Statements in Excel
- How to Use the IFS Function in Excel
- How to Use the AND Function in Excel
- How to Use the OR Function in Excel
- How to Use the NOT Function in Excel
- How to Use VLOOKUP in Excel
- How to Use HLOOKUP in Excel
- How to Use XLOOKUP in Excel
- How to Replace VLOOKUP with XLOOKUP in Excel
- How to Use INDEX and MATCH in Excel
- How to Use SUMIF in Excel
- How to Use SUMIFS in Excel
- How to Use COUNTIF in Excel
- How to Use COUNTIFS in Excel
- How to Use AVERAGEIF in Excel
- How to Use AVERAGEIFS in Excel
- How to Use the TEXT Function in Excel
- How to Use LEFT, RIGHT, and MID Functions in Excel
- How to Use the TRIM Function in Excel
- How to Use CONCAT and TEXTJOIN in Excel
- How to Use FIND and SEARCH in Excel
- How to Use the SUBSTITUTE Function in Excel
- How to Use UPPER, LOWER, and PROPER Functions in Excel
- How to Use the TODAY Function in Excel
- How to Use the NOW Function in Excel
- How to Calculate Age in Excel
- How to Calculate Date Differences in Excel
- How to Use the DATEDIF Function in Excel
- How to Extract Year from Date
- How to Use the EOMONTH Function in Excel
- How to Calculate Working Days in Excel
- How to Use the NETWORKDAYS Function in Excel and Google Sheets
Feedback
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.