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

Reisverhalen inspiratie

Inspiratie Ik volg een Reisverhalencursus op Instagram. Daar werd gevraagd wie inspireren jou met hun schrijven over reizen. Ik moest...
Read More
5 Replies
Reisverhalen inspiratie
Blog Life Travel

Zenuwen voor mijn reis

Zenuwen voor mijn reis In februari 2013 stap ik in de vliegtuig voor een soloreis door Cuba van drie weken....
Read More
Zenuwen voor mijn reis
Blog Curacao Life Travel

Even terug

Even terug Het is eind 2017 ik zet na bijna 7 jaar weer voet aan de grond op mijn geboorte-eiland...
Read More
Even terug
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
Blog WordPress

The best plugins for 2020

If you build a website in WordPress you need plugins to support that website. Plugins are small parts of a...
Read More
The best plugins for 2020
Blog

Create a page in WordPress

Create a page One of the first things you do in WordPress is creating pages to be able to display...
Read More
Create a page in WordPress
Blog WordPress

Update your plugins

To keep your WordPress site safe, it is essential that you update the plugins used in your website. Updating will...
Read More
Update your plugins
Blog WordPress

Choose a theme

The design in WordPress is determined by the theme you choose. In this blog I discuss how you can choose...
Read More
Choose a theme
Blog WordPress

Create menu with items in WordPress

WordPress automatically creates a menu with your website. Usually in this menu the items are not arranged as you want...
Read More
Create menu with items in WordPress
Blog WordPress

The world wide web is too crowded

Like in the real world the worldwide web is lacking space. The population growth has taken its biggest growth. The...
Read More
The world wide web is too crowded
Blog WordPress

Draw your own IP address out of the statistics of Google Analytics

With Google Analytics you can see how many visitors have been to your website and how they have walked through...
Read More
Draw your own IP address out of the statistics of Google Analytics
Blog WordPress

What is WordPress

WordPress is a system to manage your website, blog or even webshop without having to know HTML or PHP Originally,...
Read More
What is WordPress
Blog WordPress

WordPress terms with which we sprinkle

Sometimes you think you are the only one who does not know the WordPress terms that are used. There are...
Read More
WordPress terms with which we sprinkle
{"slides_column":1,"slides_scroll":1,"dots":"true","arrows":"true","autoplay":"true","autoplay_interval":2000,"speed":300}

Please share on social