Category: Basics

Excel Autocomplete and Autofill

  Do you know that you don’t need to input every value into your cells one by one. Excel will help you input values into...

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