Advertisment

Access SOAP Web Services from Excel

If your spreadsheet needs to access constantly updated data, or if you need to access services hosted on another computer, Excel's Web...

Views: 1153 | | by Sean
MS Excel - Functions

Create Excel Spreadsheets Using Other Environments

Although Excel and other spreadsheet programs are the traditional interfaces for creating and reading spreadsheets, sometimes you might need to...

Views: 1136 | | by Sarah
MS Excel - Functions

Save To SpreadsheetML And Extracting Data

Since Excel XP, Excel has included an XML export option. SpreadsheetML provides an XML representation of your spreadsheets, complete with...

Views: 1115 | | by Brad
MS Excel - Functions

Import Data Directly into Excel

This tutorial relies on Excel's ability to perform web queries, so you'll need Excel 97 or higher. Excel's Web Queries tool...

Views: 1153 | | by Slicer
MS Excel - Functions

Create Spreadsheets using SpreadsheetML

While exporting spreadsheets as XML is useful, Excel also lets you import information this way, letting you create spreadsheets using...

Views: 874 | | by Mathew
MS Excel - Functions

Add character in each cell

You have MSExcel sheet with 100 cells filled with 001-100. And you need to add 'A' in front all of them. You don't need to work...

Views: 951 | | by Daniel
MS Excel - Macros

VLOOKUP

Learn how to use the VLOOKUP function in Excel

Views: 895 | | by Jason
MS Excel - Functions

How to Create Simple Pie Charts Using Excel

Create two different type of financial pie charts using microsoft excel.

Views: 954 | | by Amy
MS Excel - Charts and Graphs

Create Pivot Tables and Reports in Excel

How to create simple pivot tables and reports using excel.

Views: 991 | | by Troy
MS Excel - Charts and Graphs

A basic Excel 2003 tutorial

Excel is Microsoft's spreadsheet program. This basic Excel 2003 tutorial will show you how to create a simple cost administration, how to...

Views: 1007 | | by Jason
MS Excel - Basics

What's New in Excel 2007

This tutorial is for you if you've used a previous version of Excel. Here you'll find an overview of what's new and what's...

Views: 0 | | by Daniel
MS Excel - Basics

How to use Filter and Advanced Autofilter in Excel

How to Easily use the Autofilter and Advanced Filter Functions in Excel in order to automate repetitive tasks.

Views: 833 | | by Amy
MS Excel - Functions

Charts and Graphics in Excel 2007

This tutorial takes the first approach and explains how to generate straightforward charts. You'll also learn which chart types are out there,...

Views: 1004 | | by John
MS Excel - Charts and Graphs

Good Spreadsheet Design Principals

The are some basic aspects of spreadsheets which should be considered. When developing your spreadsheets some upfront thought can be vital. This...

Views: 925 | | by Nick
MS Excel - Basics

Function Wizard

The function wizard allows you to use any of Excels functions in a very user friendly way. You therefore do not need to remember the complex syntax...

Views: 853 | | by Mathew
MS Excel - Functions

Auditing Toolbar

The Auditing Toolbar is one if Excel's best kept secrets. It allows you to visualize the cells used in any formula. In particular is allows...

Views: 892 | | by Mark
MS Excel - Basics

Loading Excel's free add ins

With a standard installation of Excel, you are provided with a number of add ins that you can activate. These add significant functionality to...

Views: 0 | | by David
MS Excel - Basics

VLOOKUP with large tables of information

Once you have mastered VLOOKUP you may find that you use it for large datasets. The problem is that when you make changes to your spreadsheet you...

Views: 788 | | by Tutorial
MS Excel - Functions

VLOOKUP Errors

As useful as the VLOOKUP function is, there is a significant risk of errors. Learn what you must watch for.

Views: 813 | | by Sarah
MS Excel - Functions

Automatic sorting of lists in Excel

By combining the VLOOKUP and RANK functions you can have Excel automatically sort a list of data into a specific order.

Views: 830 | | by Nick
MS Excel - Functions