Excel Tips

Excel Macros Using VBA

We earlier covered an an article on creating an Excel Macro using the macro recorder.This article is on creating an Excel Macro using VBA …

Excel Macro: How To Create An Excel Macro?

This is an article on creating Excel Macro using the macro recorder.We earlier covered a tutorial on creating Word Macros using Macro Recorder. It …

Conditional Formatting In Excel 2007

In Microsoft Excel, Conditional Formatting is a technique to format cells based on one or more rules.Conditional Formatting helps you visually explore and analyze data …

How to encrypt, password protect and lock files in Excel 2007?

Excel 2007 offers better file protection options. You can easily encrypt and password protect files created using Microsoft office Excel 2007.
Earlier we covered a …

Excel 2007 – Merge or join column contents using ampersand

In Microsoft Excel 2007, you can concatenate or merge the contents (text or number values) of two cells (or columns of cells), by creating a …

Excell 2007: Split contents in cells of excel worksheets

In Excel (including Excel 2007), contents of cells can be split and displayed across other cells, based on a delimiter.The following is a tutorial on …

Change text alignment or orientation in excel 2007

You would have seen text in excel 2007, that is aligned or tilted vertically or diagonally or on its side! This excel trick of changing …

Excel workbooks – shared or collaboration mode to add or modify data simultaneously

Microsoft Excel workbooks can be setup as “shared” and placed on a network server for multiple users to add or modify data simultaneously.

Microsoft Excel …