Digital Purview

  • Home
  • About
  • Archive
  • Subscribe
  • Contact

Pivot table Tutorial in Excel 2007

Sep 212009
 

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

 September 21, 2009  Posted by Gatt Software Tagged with: Excel, Excel 2007, Microsoft, Pivot Table No Responses »

Data Validation in Excel

Aug 212009
 

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

 August 21, 2009  Posted by Gatt Software Tagged with: Data Validation, Excel, Excel 2007, Microsoft No Responses »

Conditional Formatting in Excel 2007

Aug 142009
 

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. Continue reading »

 August 14, 2009  Posted by Gatt Software Tagged with: Conditional Formatting, Excel, Excel 2007, Microsoft No Responses »

Extracting Data from Internet in Excel 2007

Jun 212009
 

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. Continue reading »

 June 21, 2009  Posted by Gatt Software Tagged with: data, Excel, Excel 2007, Internet, Microsoft No Responses »

Using What If Analysis Function Data Table in Excel

Mar 082009
 

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

 March 8, 2009  Posted by Gatt Software Tagged with: Data Table, Excel 2007, Microsoft, Whatif No Responses »

Using Name Range in Excel

Feb 282009
 

Name range in Excel is a way to define a range to be used in Formula. Continue reading »

 February 28, 2009  Posted by Gatt Software Tagged with: Excel, Excel 2007, Microsoft, Name Range No Responses »

Relative, Absolute and Mixed References in Excel

Feb 112009
 

There are different ways a cell can be referenced or called in Excel. Continue reading »

 February 11, 2009  Posted by Gatt Software Tagged with: Excel, Excel 2007, Microsoft 1 Response »

Using What If Analysis Function Scenarios in Excel

Jan 082009
 

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

 January 8, 2009  Posted by Gatt Software Tagged with: Excel, Excel 2007, Microsoft, Scenario, Whatif No Responses »

Using What If Analysis function Goal Seek in Excel

Dec 062008
 

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. Continue reading »

 December 6, 2008  Posted by Gatt Software Tagged with: Excel, Excel 2007, Goal Seek, Microsoft, Whatif No Responses »

Product Cloud

Recent Jobs

Popular Posts

  • Free Scan to PDF Solution
  • PMP ITTO Chart
  • Project Stakeholders - Roles and Responsibilities
  • Norton Toolbar for Firefox 3 fix released
  • Firefox 3 Support for UPEK Fingerprint reader - Password Bank

Recent Posts

  • Convert djvu files to pdf
  • Alternative to Phone in/ Phone out by Yahoo/Jajah Voice
  • Implement GPS not Analytics in your organization
  • How to call USA or international phone numbers using internet for cheap?
  • 5 Things I wish Google Analytics improve

Tag cloud

Blogging content Search Software PMP business Windows Excel web service firefox GMAT SEO error plugin Excel 2007 Google Analytics Microsoft Asset web publishing service yahoo PDF Tutorial web Video project management open source firefox 3 CRM SAP norton blog Google squidoo web publishing web tools Wordpress web apps social web VBA wikipedia security finance Add-on Website Widget
© 2012 Digital Purview Suffusion theme by Sayontan Sinha