Excel Tips

Gantt Chart Template for Excel 2007 and 2010

Get a free Gantt chart template for excel 2007 or excel 2010. If you are a project manager or project leader managing a software project …

Excel data analysis with pivot tables, charts and slicers

Many of you may already know that Microsoft Excel is a brilliant data analysis tool. Microsoft Excel has several functions and add-ins which you can …

Excel Viewer – Free online xls and xlsx file viewer

We had earlier told you about the free Excel viewer 2007. It can be used to open, view and print Excel files, even if you …

Download Excel Viewer, a free spreadsheet software to open and view xls and xlsx files without having Microsoft Excel installed on your computer. Download, install …

Just like the free pps viewer, Microsoft has also a free excel viewer for Ms office excel application.This free Microsoft Excel Viewer is useful to …

PowerPivot for Excel 2010 – The ultimate data analysis add-in

Free download PowerPivot for Excel 2010, an ultimate data analysis add-in for the world’s most widely used spreadsheet software.It can be used to process and …

How to make a graph in Excel 2007 and 2003

This is a tutorial on how to make a graph on excel 2007 and excel 2003. Excel charts or excel graphs are good ways to …

Convert Excel to PDF in Excel 2010 and 2007 using the built-in Excel to PDF Converter plugin. We earlier covered how to convert Word to …

Pie Chart: How to make pie charts in Excel 2007?

Pie Chart is a graphical representation of the relative sizes of the shares of a whole. It is a good method of representation, if you …

Earlier we saw how to create a Word Table in Microsoft word 2007. This article describes the steps to copy a Word table to an …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

Go to Top