## Calculate in Excel

Do you know how to calculate in Excel? In this blog I explain how to calculate in Excel using symbols and formula.

## The calculating tools

When calculating in Excel we use:

• = When we start in een cel in Excel with this symbol, Excel knows we are going to calculate.
• + When we use this symbol in Excel, Excel knows we are going to add up.
• – When we use this symbol in Excel, Excel knows we are going to deduct.
• * When we use this symbol in Excel, Excel knows we are going to multiply.
• / When we use this symbol in Excel, Excel knows we are going to divide.

Thes symbols are used in combination with numbers and the = sign in Excel.

## Examples of calculating in Excel To calculate 101+102, You go stand in cel A3. And put in =101+102 and then you use Enter. After enter the result will be given in cel A3 and in the formula bar the calculation.

Try this know for the other examples. Shouldn’t be so difficult if you follow the instructions I gave. If you have trouble with it don’t hesitate to contact me.

This is one of the thing you learn in the basic beginners course. It is a one on one course let me know if you are interested in the course.

## I want to do more than add with formulas in Excel Excel has lots of possibilities to make complicated calculations with formulas, but the formulas can also be used to manage data better or to look for things. Excel divides the formulas into the following 7 categories:

• Financial: Calculates financial calculations such as interest, return, revenue, etc.
• Logical: Logical functions allow you to check whether things are correct or whether something is excluded or included. Examples: If (if a condition is met then the formula is executed or give value), where (You enter a value and if it satisfies you will get a true), etc.
• Text: Allows you to adjust texts. For example, Delete spaces (all spaces are erased), Length (indicates how long a text is in a cell), merge text (can merge texts from different cells into a cell), etc.
• Date / time: Date (convert the day you enter into Microsoft codes), minute (calculates day, year, month to minutes), days360 (calculates the number of days between 2 dates assuming 360 days in a year), etc .
• Search and reference: Horizontal search (looks for a specified value in the first row of table and returns the answer from the corresponding column), Transpose (changed vertically to horizontal), Vertical search (looks for a specified value in the leftmost column, and then outputs that row returns the corresponding answer), etc.
• Mathematics and trigonometry: Rounding off (around numbers), sum. (Counts on everything that meets criteria), root (calculates the root of a number), etc.
• Other functions: Below are more functions grouped to:
• Statistical: Below you will find useful formulas such as Number (counts number of cells with a value), but also more complicated static calculations as standard deviation.
• Technique: Below are formulas to calculate technical things.
• Cube: Does all kinds of cube calculations
• Information: Checks information for example: Is.even (or number is even), ISText (checks whether value is in cell text).

But how do you use the formula in Excel? Stand in the cell. Click on insert function in formulas tab. In the screen that opens you choose the formula you want to use. With each formula, Excel also indicates which condition it expects from you.

## 1st quarter 2020

1st quarter 2020 The first quarter of 2020 started with me as a digital nomad working on Curaçao. That means...

## 7 things I would like to do in Spain

I have been to Spain before and every time I discover new things that I would like to do. That's...

## The 5 types of hikers

In my opinion there are 5 types of hikers among the hikers. I would like to share with you those...

## 5 reasons to live in southern Spain in winter

My dream is to escape the winter. I did that all winter in 2013/2014 by going to Australia and New...

## 7 reasons to walk a 4 Days hike

While walking my 2nd Four Days Marche I have thought of 7 reasons why you should walk a 4...

## Farewell to Strijp-S in Style

How do you say goodbye to Strijp-S in style? I lived in Strijp-s, Eindhoven for 2.5 years and saw the...

## The 5 lessons I learned from the book Blondies invest better

I share 5 lessons with you that I learned from the book Blondies Invest Better (Dutch book Blondjes beleggen beter)....

## 1 percent gross turnover to the Food Bank

1 percent turnover to the Food Bank This year I want to donate 1 percent of my turnover to charities...

## Databeet story

Databeet story The Databeet story begins on August 13, 2012, on the day of the left-handers. I myself am left-handed,...

## Ubud, Hiking through the rice fields

Ubud, hike through the rice fields Back in 2014 I was fierless and went on a Hike through the rice...

## Travel stories inspiration

Inspiration I follow a Travel Stories course on Instagram. There we were asked who inspire you with their writing about...

## Nerves for my trip

Nerves for my trip In February 2013, I board the plane for a three-week solo tour of Cuba. I am...

## Just back

Just back It is the end of 2017 after almost 7 years I set foot on my birth island Curaçao,...

## A simple Address book template in Excel

Address book template With this template you can save all your adresses and phonenumbers of the people you know. There...

## Calculate in Excel

Do you know how to calculate in Excel? In this blog I explain how to calculate in Excel using symbols...

## Dealing better with money

Since I work for myself I earn less, but it seems like I can do more. Not only do I...

## Leaving 2019 behind and starting 2020

2019 was over before I could blink. I hope 2020 last longer. WHat happend in 2019? And what am I...

Add media to your website By media we mean image, photo, video and pdf in this case. These things can...