At first, new Excel users only do basic data entry. Let’s explore Excel’s core Formulas and Functions. These are the basic tools that allow you to perform calculations that can turn basic data entry into useful information and valuable insights. This post breaks down the ultimate formulas and functions you should know. Don’t worry we’ll keep it simple with practical easy to learn examples with clear explanation.
Basic Formulas
Formulas are a fundamental component of Excel, Basic calculations can be performed using arithmetic operators such as Addition (+), Subtraction (-), Multiplication (*), Division (/) and Percentage (%). Let’s learn how to use these operators to perform basic calculations.
- Addition (+): =A1+B1
- Subtraction (-): =A1-B1
- Multiplication (*): =A1*B1
- Division (/): =A1/B1
- Percentage (%): =A1*10% or =A1/100
