Tag Archives: Excel 2007

Pivot table Tutorial in Excel 2007

September 21, 2009 – 12:08 pm | By Gatt | Posted in Software | Also tagged , , | Comments (0)

Pivot table is great tool in Excel to create reports and analyze data. Go thru the simple exercise below to understand the concept Read More »

Data Validation in Excel

August 21, 2009 – 11:52 am | By Gatt | Posted in Software | Also tagged , , | Comments (0)

When you need to verify data that can go in a cell, Data validation is the function in Excel to use. Read More »

Conditional Formatting in Excel 2007

August 14, 2009 – 11:38 am | By Gatt | Posted in Software | Also tagged , , | Comments (0)

Conditional Formatting allows changing appearance (different color, font, format etc) of cell based on certain condition. For example you can show employees with Salary Higher than 100000 USD in Red. This makes easy and visually appealing to read and interpret data. Read More »

Extracting Data from Internet in Excel 2007

June 21, 2009 – 11:53 am | By Gatt | Posted in Software | Also tagged , , , | Comments (0)

Excel 2007 comes with the option of querying web to export table data from internet. This is a very good option if you rely on constantly updated data such as exchange rates etc. Read More »

Using What If Analysis Function Data Table in Excel

March 8, 2009 – 12:15 pm | By Gatt | Posted in Software | Also tagged , , | Comments (0)

Data Table is a What If Analysis Function to find out result by altering an input cell in Excel. Read More »

Using Name Range in Excel

February 28, 2009 – 12:10 pm | By Gatt | Posted in Software | Also tagged , , | Comments (0)

Name range in Excel is a way to define a range to be used in Formula. Read More »

Relative, Absolute and Mixed References in Excel

February 11, 2009 – 11:19 am | By Gatt | Posted in Software | Also tagged , | Comments (0)

There are different ways a cell can be referenced or called in Excel. Read More »

Using What If Analysis Function Scenarios in Excel

January 8, 2009 – 12:14 pm | By Gatt | Posted in Software | Also tagged , , , | Comments (0)

You can use Scenarios to see what would happen to your bottom line figure if you change certain values. Read More »

Using What If Analysis function Goal Seek in Excel

December 6, 2008 – 12:12 pm | By Gatt | Posted in Software | Also tagged , , , | Comments (0)

When you know the result but are not sure of the input that would bring the desired result, Goal Seek function can help. Goal Seek is one of the” What If” analysis functions in Excel. Read More »