Big Data eCourse
Together with Laudius and another teacher I made a Big Data eCourse in Dutch about what Big Data is, how to analyze Big Data and Privacy & Ethics in Big Data research. With the code: GUISELAINE 10 percent discount (Affiliate).
Index
More With Formulas In Excel
I want to do more with formulas than add in Excel. That is a frequently heard 'complaint' about Excel. In this blog I explain which formula types there are in Excel.
Kind Of Formulas In Excel
Excel has many possibilities to make complex calculations with formulas, but the formulas can also be used to manage my data better or to search for things. Excel divides the formulas into the following 7 categories:
Financial: Calculates financial calculations such as interest, return, turnover, etc.
Logical: With logical functions I can check if things are correct or if something is excluded or included. Examples: if (if a condition is met, the formula is executed or returns a value), where (I enter a value and if it matches, I get a true), etc.
Text: Allows me to customize texts. For example: Remove spaces (all spaces will be erased), Length (indicates how long a text is in a cell), Merge text (can merge texts from different cells in a cell), etc.
Date / Time: Date (convert the day I enter into Microsoft codes), minute (calculates day, year, month to minutes), days 360 (calculates the number of days between 2 dates, assuming 360 days in a year) , etc.
Search & Reference: Horizontal Search (searches for a specified value in the first row of the table and returns the answer from the corresponding column), Transpose (changes vertically to horizontal), Vertical Search (searches for a specified value in the most left column and then output in that row returns the corresponding answer), etc.
Mathematics and trigonometry: Rounding (round numbers), sum. (Calculates on anything that meets the criteria), root (calculates the root of a number), etc.
Other Features: Below are more features grouped by:
Statistics: Below I will find useful formulas such as Number (counts number of cells with a value), but also more complicated static calculations such as standard deviation.
Technique: Below are formulas to calculate technical matters.
Cube: Performs all kinds of cube calculations
Information: Checks information for example: Is.even (or number is even), ISText (checks if value is in cell text).
Use Formula In Excel
But how do I use the formula in Excel? Stand in the cell. Click the Insert function in the Formulas tab. In the opened screen, choose the formula to use. For each formula, Excel also indicates which condition it expects from me as an input.
Related blogs on my website
Related guest publications
Esser, Y (2020) Zo maak je die online cursus wel af en meer tips om bij te leren via internet
Hidajattoellah, D. & Capella, G. (2018) Pre-testing Rapport Reality Keeper
Rotterdam Festivals (2015) Wat wil het publiek? Rotterdam, cultuur en publiek in kaart gebracht
Capella, G. & Stijnenbosch (2009) Actualisatie ruimtebehoefte (wierden.nl), Stogo Onderzoek + Advies
Related external links
Related affiliate links
I earn a bit on the sale through the links in this category like writers earn on their books with publishers, more information on the Disclaimer page.