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.

If you have any questions contact me. Read more about Excel in my other Excel blogs. Improve your Excel skilss with my Excel lessons.

Blog entrepreneur

Yet, again business cards

At the beginning of July, I launched my website Niksmetcijfers.nl. All the research, Excel and data visualization offerings and blogs...
Read More
Yet, again business cards
Blog Life

Varied vegetarian food

I have been eating less meat for a long time, but didn't no how to vary with vegetarian food.  I've...
Read More
Varied vegetarian food
Blog entrepreneur Hiking Investing Life

2nd quarter and charity 3rd quarter turnover

Business is starting to pick up again in terms of work. The second quarter turnover was better than the first,...
Read More
2nd quarter and charity 3rd quarter turnover
Blog

hip, Instagram cooking class

I had the taste of taking Instagram courses after the travel writing course and finance course. So when the opportunity...
Read More
hip, Instagram cooking class
Blog Curacao Reading

5 Less known slavery stories

There are a lot of books and movies out there about slavery and even some blockbusters, but today I want...
Read More
5 Less known slavery stories
Blog Investing Life

7 lessons I learned from the finance course on Instagram

Because I would like to reach FIRE (Financial independent and Retire early) in a few years and want to get...
Read More
7 lessons I learned from the finance course on Instagram
Blog Investing Life

7 Tips to save on groceries

Groceries always come out more expensive than you had in mind and then you also forget some ingredients and you...
Read More
7 Tips to save on groceries
Blog entrepreneur Hiking Life Travel

My after Corona Bucket List

I would like to share with you my bucket list for after Corona era. Actually, it is more of a...
Read More
My after Corona Bucket List
Blog Investing Life

I don’t want to know about my student debt

Last week I took part in the student debt challenge of Maaike van fuck that student debt (fuck die studieschuld)....
Read More
3 Replies
I don’t want to know about my student debt
Blog Life

Chocolate fair

For the second time I couldn't stop myself from going to the Chocolate fair in Amsterdam in February. It is...
Read More
Chocolate fair
Blog Hiking

Not one but two walking related conferences just before spring starts

This year I went to the Mountain climbing conference in Nieuwegein as well as the Walking & Cycling Fair in...
Read More
Not one but two walking related conferences just before spring starts
Blog Hiking Travel

Hiking between Cascais and Sintra

Cascais is the escape city for Lisbon, Portugal if you want to be by the sea. I traveled twice to...
Read More
Hiking between Cascais and Sintra
Blog Life

No I am not ….

No, I am not eating more Unfortunately, was it that easy. That I started eating more and by eating less...
Read More
No I am not ….
Blog Life

No reason Retroprints

Would you like to try out our retroprints in exchange for a blog on your website? Actually yes, I wanted...
Read More
No reason Retroprints
Blog Curacao Hiking

Caracasbaai peninsula

I would like to take a long walk on Curaçao. In the meantime, there are about three organizations that offer...
Read More
Caracasbaai peninsula
Blog Life

1 percent turnover to Wegloophuis Utrecht

1 percent turnover to charity This year 1 percent of my turnover goes to charity. A different charity each quarter....
Read More
1 percent turnover to Wegloophuis Utrecht
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
{"slides_column":1,"slides_scroll":1,"dots":"true","arrows":"true","autoplay":"true","autoplay_interval":2000,"speed":300,"lazyload":""}

Sharing is appreciated

Shortcuts, I don’t think so

Keyboard shortcuts are key combinations that you can run on your computer without having to use the mouse to perform a function. The addition short is because it takes less time to use the shortcut keys then using the mouse to do the same function in any program. Each program has its own combination of  keys that are often used as shortcuts. This makes it less easy for the user, and often even discourage people in using them. In addition, Windows and Apple use different key combinations, which makes that users of both system have to remember a lot more short keys. Despite this, it is worthwhile to delve into all the several keyboard shortcuts combination.

Advantage shortcuts

  • It works faster than using your mouse (time saving)
  • Fewer steps needed so it’s efficient
  • There is less concentration (effort) required (With a mouse you need to ‘search’ and ‘point’ exactly in the menu)
  • Ergonomically it is better because you use your mouse arm less in repetitive way on the same mouse motion
  • Shortcut keys are preventive against RSI and can help prevent RSI from becoming worse
  • By using shortcuts you train your memory in remembering (this can be useful in remembering PINnumber) :-).

How do you discover shortcuts

Often they are indicated by the functions in the menu when using the menu as an alternative. Another option is to use the Help section of the program. Look for ‘Keyboard shortcuts’ and then you get a list of keyboard shortcuts for the corresponding program. Now you know why some people use keyboard shortcuts:

  • To save time
  • To have a healthier sit behind their computer
  • And to train there memory in remembering them.

So if you think those three things are handy, maybe you should start learning some keyboard shortkeys. 

Blog entrepreneur

Yet, again business cards

At the beginning of July, I launched my website Niksmetcijfers.nl. All the research, Excel and data visualization offerings and blogs...
Read More
Yet, again business cards
Blog Life

Varied vegetarian food

I have been eating less meat for a long time, but didn't no how to vary with vegetarian food.  I've...
Read More
Varied vegetarian food
Blog entrepreneur Hiking Investing Life

2nd quarter and charity 3rd quarter turnover

Business is starting to pick up again in terms of work. The second quarter turnover was better than the first,...
Read More
2nd quarter and charity 3rd quarter turnover
Blog

hip, Instagram cooking class

I had the taste of taking Instagram courses after the travel writing course and finance course. So when the opportunity...
Read More
hip, Instagram cooking class
Blog Curacao Reading

5 Less known slavery stories

There are a lot of books and movies out there about slavery and even some blockbusters, but today I want...
Read More
5 Less known slavery stories
Blog Investing Life

7 lessons I learned from the finance course on Instagram

Because I would like to reach FIRE (Financial independent and Retire early) in a few years and want to get...
Read More
7 lessons I learned from the finance course on Instagram
Blog Investing Life

7 Tips to save on groceries

Groceries always come out more expensive than you had in mind and then you also forget some ingredients and you...
Read More
7 Tips to save on groceries
Blog entrepreneur Hiking Life Travel

My after Corona Bucket List

I would like to share with you my bucket list for after Corona era. Actually, it is more of a...
Read More
My after Corona Bucket List
Blog Investing Life

I don’t want to know about my student debt

Last week I took part in the student debt challenge of Maaike van fuck that student debt (fuck die studieschuld)....
Read More
3 Replies
I don’t want to know about my student debt
Blog Life

Chocolate fair

For the second time I couldn't stop myself from going to the Chocolate fair in Amsterdam in February. It is...
Read More
Chocolate fair
Blog Hiking

Not one but two walking related conferences just before spring starts

This year I went to the Mountain climbing conference in Nieuwegein as well as the Walking & Cycling Fair in...
Read More
Not one but two walking related conferences just before spring starts
Blog Hiking Travel

Hiking between Cascais and Sintra

Cascais is the escape city for Lisbon, Portugal if you want to be by the sea. I traveled twice to...
Read More
Hiking between Cascais and Sintra
Blog Life

No I am not ….

No, I am not eating more Unfortunately, was it that easy. That I started eating more and by eating less...
Read More
No I am not ….
Blog Life

No reason Retroprints

Would you like to try out our retroprints in exchange for a blog on your website? Actually yes, I wanted...
Read More
No reason Retroprints
Blog Curacao Hiking

Caracasbaai peninsula

I would like to take a long walk on Curaçao. In the meantime, there are about three organizations that offer...
Read More
Caracasbaai peninsula
Blog Life

1 percent turnover to Wegloophuis Utrecht

1 percent turnover to charity This year 1 percent of my turnover goes to charity. A different charity each quarter....
Read More
1 percent turnover to Wegloophuis Utrecht
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
{"slides_column":1,"slides_scroll":1,"dots":"true","arrows":"true","autoplay":"true","autoplay_interval":2000,"speed":300,"lazyload":""}

Sharing is appreciated