Category: Basics

On this page you can find basic Excel Tips and Tutorials.

Writing Your First Formula

Aside from organising and formatting your data, excel has very powerful calculation capabilities. In order to get benefit from these capacities, you need to be...

Using Excel Functions

Excel has a very wide array of functions for your use in various calculations. These functions are grouped into several titles. You may find a...

Select Special

  Select Special tool lets you select multiple cells with certain contents with just one click.

Joining Text in Excel

Have you ever needed to join two or more text values into one? Yes, excel has a built-in function for that too. But it is...

Conditional Formatting

Conditional Formatting

Have you ever tried to change formatting of a cell or a range of cells based on a condition? If so, conditional formatting is the...

Quick Excel Tip: Transpose

Did you know that you can easily switch rows and columns of a list of values in an instant by copy-paste using transpose option ?