The Absolute Basics hub is where every Excel user should begin. These foundational functions form the backbone of nearly every spreadsheet, from simple totals to conditional calculations. Whether you’re brand new to Excel or strengthening your core skills, the tutorials in this hub will help you build confidence using the most essential formulas step by step.
In this hub, you’ll learn how to calculate totals, averages, counts, minimum and maximum values, perform rounding operations, and use conditional calculations to enable Excel to analyze data automatically.
What You’ll Learn in This Hub
- How to calculate totals using SUM
- How to calculate averages using AVERAGE
- How to count values using COUNT and COUNTA
- How to round numbers using ROUND, ROUNDUP, and ROUNDDOWN
- How to find smallest and largest values using MIN and MAX
- How to use conditional formulas like SUMIF, COUNTIF, and AVERAGEIF
- How to summarize filtered data using SUBTOTAL
Absolute Basics Function Tutorials
Below is the complete list of tutorials included in the Absolute Basics hub. Start with SUM and work through the list to build a strong Excel foundation.
Core Calculation Functions
- 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 the COUNTBLANK Function in Excel
- How to Use the MIN Function in Excel
- How to Use the MAX Function in Excel
Rounding and Number Formatting Functions
- How to Use the ROUND Function in Excel
- How to Use the ROUNDUP Function in Excel
- How to Use the ROUNDDOWN Function in Excel
- How to Use the INT Function in Excel
- How to Use the MOD Function in Excel
- How to Use the ABS Function in Excel
Conditional Calculation Functions
- How to Use the SUMIF Function in Excel
- How to Use the COUNTIF Function in Excel
- How to Use the AVERAGEIF Function in Excel
- How to Use the SUMIFS Function in Excel
- How to Use the COUNTIFS Function in Excel
- How to Use the AVERAGEIFS Function in Excel
