Excel Formulas and Functions Module 1
This course is currently not scheduled on the open calendar, but can be organized on request.
Request CourseDuration
1 day(s)
MS Excel: Formulas and Functions
Duration
1day
Audience
This course is intended for people who already have a basic knowledge of MS Excel and who want to work more productively by making better use of the possibilities of formulas and functions.
Prerequisites
A good knowledge of the basics of MS Excel is required.
Objectives
Gain insight into working with formulas and functions.
Methods
Classroom training with attention to individual guidance and the possibility to ask questions. Because of exercises, the student can immediately put the possibilities of the program into practice.
Description
MS Excel offers many possibilities in the field of calculation and number analysis.
We start with the distinction between a formula and a function.
Next, we see the different ways to copy formulas. The use of relative and absolute cell references is also explained.
Tools that can be useful when creating and managing formulas are also covered.
In this module, a few functions of several important function categories are explained.
Contents
- Introduction
- Distinction between formulas and functions
- Entering, changing, and deleting formulas and functions (general)
- Formulas
- Parts of formulas
- Arguments (cell addresses, constants, ...)
- Operators and calculation priority
- Calculations with percentages
- Calculate with dates
- Calculate with times
- Parts of formulas
- Functions
- Types of functions
- Function categories
- Classification according to number of arguments
- The different methods for entering functions
- Nested functions
- Types of functions
- Copy formulas and functions
- The possible paste methods
- Relative, absolute and mixed cell references
- Useful tools
- Defined names
- Evaluate formulas
- Goal Seek
- The logical function IF
- The lookup function VLOOKUP
- The date and time functions TODAY, NOW, DATE and TIME
- Some useful mathematical functions
- Some useful information functions