மிக முக்கியமான எக்செல் ஷார்ட் கட்ஸ்

This trick is for you!
If you hate Backstage when opening or saving files.
You are welcome smile emoticon

Number of Words
This example describes how to count the number of words in a cell.

Cool or lame? smile emoticon

A check box is a field which can be checked to store information. To create a check box in Excel VBA, execute the following steps.

1. On the Developer tab, click Insert.

2. In the ActiveX Controls group, click Check Box.

3. Drag a check box on your worksheet.

4. Right click the check box (make sure Design Mode is selected).

5. Click View Code.

Note: you can change the caption and name of a control by right clicking on the control (make sure Design Mode is selected) and then clicking on Properties. Change the caption of the check box to MyCheckBox. For now, we will leave CheckBox1 as the name of the check box.

6. Add the following code lines:

If CheckBox1.Value = True Then Range("D2").Value = 1
If CheckBox1.Value = False Then Range("D2").Value = 0
7. Click the check box on the sheet (make sure Design Mode is deselected).

Although in some situations it can be useful to directly place a check box on your worksheet, a check box is particularly useful when placed on a Userform.

Who want more VBA?

Trendline
This example teaches you how to add a trendline to a chart in Excel.

Do you use Trendline?

Compare Text
This example shows two ways to compare text in Excel.
Who knows the differentce?

To hide the coulmn, right-click the column header containing Cost/lb and then select Hide.

Too easy or it's ok?

Windows vs Mac - Navigation shourtcuts in MS #Excel

What do you use? Windows or Mac? —

Great #trick to hide text in Excel

Formula: =LEFT(A1;FIND(A1;" ")+2) & "***"

LEFT - give you text from left site in A1
FIND - find place where is space " " and +2
From "Name Surname" we have -> "Name Su"
To add *** we must add: & "***"

Easy?

New in Excel or need refresh basics?

Special for you - Quick Start Guide!

Share the knowledge!

Who knows this very cool trick?

CTRL + SHIFT + ↓
If the active cell is empty, Excel will extend the selection to the first non-empty cell below the active cell. If the active cell is non-empty, Excel will extend the selection on the last non-empty cell below the active cell. On a Mac, the command key (⌘) can be used instead of the control key.

CTRL + SHIFT + →
If the active cell is empty, Excel will extend the selection to the first non-empty cell to the right. If the active cell is non-empty, Excel will extend the selection on the last non-empty cell to the right. On a Mac, the command key (⌘) can be used instead of the control key.

Super easy trick. Only 5% of Excel users know about it! 

CTRL+; - Enters the current date in the right format

How to use it? 
1. Click in any cell 
2. Press Ctrl +; 
Simple? smile emoticon

I wonder who knows the difference between Ctrl +; and =(Today) formula?

Please, share the knowledge!

ROMAN formula

This simple to use, math based Excel formula will convert a value, written in Arabic format (standard numeral system) and converts it into the Roman Numeral system as text. The syntax is as follows:
=ROMAN(number, [form])

The ROMAN formula syntax has the following arguments:
The number argument. This can be a set value, or a cell address, of the Arabic numeral that you wisg to convert.
The optional argument, form. This is a number specifying the type of roman numeral you want. The roman numeral style ranges from Classic to Simplified, becoming more concise as the value of form increases. Refer to the following list.
Form Type
0 or omitted Classic.
1,2,3 More concise
4 Simplified.
TRUE Classic.
FALSE Simplified.

REPT function

Let’s assume you needed to replicate a certain symbol over a 1000 times in a single cell. Now, you can Repeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string.
Syntax
=REPT(text, number_times) where, the ‘text’ is the text that you intend to repeat and the ‘number_of-times’ is a positive number specifying the number of times the text should be repeated.

Countdown to a Specific Date in Excel

In A1 enter =TODAY(). In B1 enter the date you want to count the years, months, and days until. 

In column C3, D3, and E3 enter =B1-A1. Right click on C3 and select custom, enter Y in the text box. Repeat for D3, but enter M instead of Y. Repeat again for E3 and enter in the custom format text box.

Freeze Panes to See Headings When Working with Multiple Columns and Rows

When working with multiple rows and columns, you may want to see your column and row headings. To freeze a single row or column, go to the View tab, select Freeze Panes. To free only the top row, select Top Row or to freeze only the first column, select First Column. In this case, I wanted to see both by first row and column, so I selected the entire first row. Holding control, select the entire first column, then go to Freeze Panes, and select Freeze Panes. Go to back to the View tab, select Freeze Panes and then Unfreeze Panes to unfreeze.

sing the IF formula

The IF formula can be used to determine whether a condition specified by you turns out to be true of false. This can be useful if you need to evaluate a decision based on supplied data.
The syntax for the IF formula is as follows: IF(logical_test, [value_if_true], [value_if_false])

- The logical_test is the condition that you would be checking against. In this case, we are checking to see if the product does not have a tax attached to it.

- The value_if_true is the value displayed if the test turns out to be true. In our case, we calculate the final sales of the item. (Multiply the unit price by the amount of units sold.)

- The value_if_false is the value displayed if the test turns out to be false. In our case, we calculate the total sales, then add the tax to determine the final sales.

Learn to use appropriate "Cell Reference" in Excel Formulas