2013-0225

Causes and solutions of #REF! errors in Excel

5 Comments[Author: Category: Other ]

This is one of the most problematic errors in Excel. There is no direct way how to fix it. I show you some of the frequent examples with #REF errors. The worst case is if you open the file and you see the # REF error in it. At first you may try to contact the file creator and ask him about the original formula. If you are the creator of the file, you have to decipher the composition of the original formula. I hope these examples will help you. Continue reading “Causes and solutions of #REF! errors in Excel” »

2013-0223

Free planning calendar 2013

2 Comments[Author: Category: Templates ]

I have created the very simple planning calendar for 2013. Its advantage is that it can adapt to all language versions of Excel. So you will see descriptions written in your own language. Continue reading “Free planning calendar 2013” »

2013-0218

Missing date in the chart

4 Comments[Author: Category: Charts ]

The table in this example shows dates and values. There is a missing dates. It causes a big blank space in the chart. Continue reading “Missing date in the chart” »

2012-1229

Free sport training calendar

19 Comments[Author: Category: Templates ]

This training diary is designed for all kinds of sports. You can write the plan to the table and control its implementation and monitor your progress. The template is especially suitable for recording numbers of pushups, chin-ups, running, cycling miles (kilometers), pools, every fitness performances and many others sports activities. This Excel file offers weeks and months statistics of your training.

Continue reading “Free sport training calendar” »

Tags: , ,
2012-0930

Custom format of date and time in MS Excel

7 Comments[Author: Category: Other ]

MS Excel offers many possibilities how display date and time. The custom format can be set in the Format Cells… menu. Do the right-click and select Format Cells… .

Continue reading “Custom format of date and time in MS Excel” »

2012-0927

How to insert the current date or time

Add a Comment[Author: Category: Quick Tips ]

Example 1

The first way is to write date right into the cell or to use the shortcuts:

Ctrl+; enters the current date.

Ctrl+: enters the current time.

This method ensures that the cell will always has the date which you have written into it. Continue reading “How to insert the current date or time” »

Tags: ,
2012-0921

How to split the value

Add a Comment[Author: Category: Other ]

In this article I want to show the possibilities of splitting values to the multiple parts. There are several ways how to do it. It depends on the value you want to split. I will show you how to use Text to Columns and text functions LEFT, RIGHT, FIND, LEN. Continue reading “How to split the value” »

Tags: , , ,
2012-0911

Formula for the cells on the same address, but on the different sheets

1 Comment[Author: Category: Quick Tips ]

Let us have several identical tables that are on different Excel worksheets, but always on the same address. How to make SUM or AVERAGE of these tables? Continue reading “Formula for the cells on the same address, but on the different sheets” »

2012-0905

Data Validation in Excel

3 Comments[Author: Category: Other ]

Data validation is used when it is necessary to keep an eye on what values are entered into the cell. This tool allows you to specify the values that may be written into the cell. This helps for example to avoid entering wrong date or entering text, where is supposed to be a number, etc.

Example

There is a list of employees. Each column in the following Excel table have some rule for writing values. We have to modify Data Validation to be able to enter only correct values into the cells.

List of employees

Rules:

Employee number is exactly 5 characters long.

Salary can be set in the range 600-2000.

Bonus cannot be greater than 10 % of the salary.

Date of entry can be set only as today.

Department must be one of the values from the list of Departments.

Continue reading “Data Validation in Excel” »

Tags: ,
2012-0830

How many times are the values in the table?

1 Comment[Author: Category: Duplicates ]

There is an easy way to find number of occurrences of items in the table. For example, the following table contains repeated Products. We want to know, how many times was each product ordered.

Table with duplicates

Continue reading “How many times are the values in the table?” »

Tags:
« Previous Entries
Next Entries »

Copyright © All Rights Reserved · Green Hope Theme by Sivan & schiy · Proudly powered by WordPress