Tagged: Excel Tips

HLOOKUP Function

Do you need to fetch certain values from a list searching horizontally? Than HLOOKUP function is for you.

Excel Text Functions

  There are a total of 24 functions that are categorized as excel text functions. Though we are all sure that all of them are...

Formatting your Workbook

Though it is not completely necessary, formatting your workbook is usually a good practice. Most cases you don’t need extensive formatting. Just a little formatting...

Excel Formula Errors

When dealing with formulas you will get error messages time to time. They may seem similar to you at first glance. But actually every formula...

Excel Interface

All spreadsheet softwares have somewhat similar user interfaces. You may see Excel’s user interface below (I’ve used Excel 2010 for this screenshot. Current version is...

What does Excel do ?

Being a very powerful spreadsheet software, excel can cover most of your needs in data management. In this post you will find what does Excel...