Insert Data from Excel to SQL Server - Excel tutorial

Category: Excel tutorials > Macros - Difficulty:

Data Analysis With Charts

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

Whether you're creating Excel files from databases on an Apache server or you just want to present the information stored in a Java program to Excel users, there are a variety of packages out there that will enable you to create and access .xls files without actually using Excel.

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 sometimes need to go through all the VLOOKUP cells and change the column reference. Learn how to avoid this!

The Rank function allows you to rank a selection of cells in ascending or descending order automatically. Easier than using complex IF functions to achieve the same goal.

Ever notice how easy it is to navigate a book? That's because they have a table of contents. Learn how to add one to your excel workbooks.