Computations in Excel

Overview
A formula is an executable that acts on a value (s) and returns a new value. The value(s) may be a constant or the result of another computations. Function is a second type of formula that enables you to do analysis and much more complicated computations. In this course, you’ll learn how to use formula and function to do computations in Excel.
- how to create formulas
- how to create functions
- how to use formulas and functions to compute results from constant values
Course Features
- Lectures 0
- Quizzes 0
- Students 1
- Certificate No
- Assessments Yes
-
Overview of Data
Formula A formula is an executable that acts on a value (s) and returns a new value. The value(s) may be a constant or the result of another computations. Function is a second type of formula that enables you to do analysis and much more complicated computations. In this course, you'll learn how to use formula and function to do computations in Excel.
-
Syntax of a Formula
-
Syntax of a Function