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

Calculate 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.

Please share on social

I want to do more than add with formulas in Excel

Excel formule

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.

Blog Curacao entrepreneur

1st quarter 2020

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

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...
Read More
2 Replies
7 things I would like to do in Spain
Blog Hiking Life

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...
Read More
The 5 types of hikers
Blog Life Travel

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...
Read More
5 reasons to live in southern Spain in winter
Blog Hiking Travel

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...
Read More
7 reasons to walk a 4 Days hike
Blog Hiking Life Netherlands

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...
Read More
Farewell to Strijp-S in Style
Blog entrepreneur Investing Life Reading

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)....
Read More
The 5 lessons I learned from the book Blondies invest better
Blog Life

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...
Read More
1 percent gross turnover to the Food Bank
Blog entrepreneur Life

Databeet story

Databeet story The Databeet story begins on August 13, 2012, on the day of the left-handers. I myself am left-handed,...
Read More
Databeet story
Blog Hiking Life Travel

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...
Read More
Ubud, Hiking through the rice fields
Blog entrepreneur Life Reading Travel

Travel stories inspiration

Inspiration I follow a Travel Stories course on Instagram. There we were asked who inspire you with their writing about...
Read More
5 Replies
Travel stories inspiration
Blog Life Travel

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...
Read More
Nerves for my trip
Blog Curacao Life Travel

Just back

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

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...
Read More
A simple Address book template in Excel
Blog Excel

Calculate in Excel

Do you know how to calculate in Excel? In this blog I explain how to calculate in Excel using symbols...
Read More
Calculate in Excel
Blog entrepreneur Excel Life Research

Dealing better with money

Since I work for myself I earn less, but it seems like I can do more. Not only do I...
Read More
Dealing better with money
Blog entrepreneur Life

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...
Read More
Leaving 2019 behind and starting 2020
Blog WordPress

Add media to your website

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

Publish a blog in WordPress

Blog Blog, blog post, post: These are all terms we use when we talk about blogging. But what do we...
Read More
Publish a blog in WordPress
Blog WordPress

Events on your website

  For the websites I build in WordPress, I use the All-in-One Event Calendar by Time.ly plugin to put an...
Read More
Events on your website
{"slides_column":1,"slides_scroll":1,"dots":"true","arrows":"true","autoplay":"true","autoplay_interval":2000,"speed":300}

Please share on social