Formulas and Functions

What are formulas?

Formulas form the basis for arithmetic operations. Operators are used in formulas. The following operators are often used: plus (with keyboard symbol, +), minus (-), times (*), section, (/), exponent (^, Example 3 ^ 2 = 9).
Comparison operators such as, equals (=), is greater than (>), is less than (<), is not equal to (<>).
A formula in a spreadsheet always begins with an equals sign, = followed for instance by; 2 * 5. If you type this in a spreadsheet cell you will see 10 appear.

Sequence of operators is also important. Here we have an extra set of operators namely brackets ( ). Brackets are used 1st, exponents, roots and logarithms are used in the 2nd place, divide and multiply follow and add and subtract are used last laatset the place.
To remember this the word BODMAS is used or if in doubt you can use brackets.
Example; 5 +3 * 2 = which answer is correct? 16 or 11? Multiply is 1st so the correct answer is 11! Do you want 16 to be the answer then you modify the formula as follows (5 + 3) * 2! By using the brackets () the addition is done 1st.

What are functions?

A function is always used to replace a long or complicated formula.
The function = sum (arguments) in the Excel spreadsheet represents a formula: the addition of different cell contents.
Is there 3 in cell B2 and 3 in cell B3 and 5 in cell B4 then this can be added by B2, B3 and B4 in the following formula : = B2 + B3 + B4 the answer would be 11. The use of the function = sum (B2: B4) (read; cell B2 to cell B4) also adds the contents of the same cells with the same result;11. If you want to add a long list of numbers it is easier and faster tu use the sum function because you need to type a lot less.

Examples of some functions; Sum, Average, Maximum and Minimum If, Lookup, What If, Date and Time functions
Financial: Depreciative, Annuities, Interest (Ask us for complete list)
Algebraic: Logarithmical, Arrays (Ask us for complete list)
Examples of how a function in a spreadsheet looks like, = Min (), = Max (), = If () Arguments could be: (B2: B4) (read; cell B2 to cell B4). An argument is what the function needs to operate. The sum function can have one argument such as a list of numbers but it can also take more arguments several lists of numbers. Example Sum( B2:B4, C5:C9, E11:E24)

Methodiek

Learning Methods

There are a substantial amount of learning styles based on a variety of human modes. Energetic or reluctant, feeling or evidence oriented, investigating or resolving, pursuing the big picture or follow the rules oriented, impulsive or reflective.

We are using learning styles that can aid memorization and understanding (learning).

In the design of our training and our course material, we considered the fact that people often essentially use one of these learning styles. They use mainly visual, or auditory (hearing), kinaesthetic or inner dialogue. Of course people use a mix of all systems including those based on taste and smell. There are also people that use all the four main systems evenly.

To address these main learning styles, we offer our courses with a visual component (the keystroke and video examples) an auditory component (the voice of the trainer) and the keystrokes examples, to be followed. It is intended that this keystroke examples are imitated (especially important for the kinaesthetic learner). Additionally you get the written text which is meant specifically for those we call internal dialogue users or thinkers. These type of learners often need to read something and consider it, so they can better understand and remember it. We also offer exercises to help you test your knowledge.

The following information is to help you determine what type you are or someone else is!

For visual people
Visual words; Seeing, I see, I see, I imagine, lets take a look, that completes the picture.
Visual people use visual words a lot, they like looking good and usually make an effort to look good and to make their environment look good.
Visual people see pictures in their heads and are good at remembering how things look. Visual people like receiving a visual tokens of appreciation like tiny presents.
You can make yourself feel better or reward yourself if you;
Buy yourself a present.
Look in the mirror and Complement your self.


For auditory people.
Auditory words are listening hearing, beats, rhythm, I hear you, I can tell, I can hear the beat, that sounds like a good thing.
An auditory person uses auditory words a lot and likes doing things with sound, hearing 'good' sounds and they're good at remembering words, phrases and rhythms.

You can make yourself feel better or reward yourself if you;
Sing yourself a happy song or if you feel you need to cry sing yourself and sad song.
Tell yourself nice words, complemented yourself, tell yourself; well done .