> Advanced Excel

Excel Macro Tutorial
This tutorial covers how to create simple macros in Excel using the macro recorder. This tutorial does not cover creating macros using VBA.

Excel VLOOKUP
Excel’s VLOOKUP function is used to find specific information that has been stored in a spreadsheet table of data. This article covers how to create a VLOOKUP function in Excel, including an example.

Excel HLOOKUP
Similar to the above VLOOKUP function, Excel’s HLOOKUP function is used to find specific information that has been stored in a spreadsheet table of data. This article covers how to create a HLOOKUP function in Excel, including an example.

Create Excel Pivot Tables
A pivot table is a reporting tool that sorts, counts, and sums the data from a spreadsheet, database, or other external data source. The pivot table is a second table that displays the summarized data.

Microsoft Excel Sort Feature
Learn how to manage large amounts of data. Sorting data not only helps you to keep it organized, but it makes it easier to find exactly the data you are looking for.

Writing Macros in Microsoft Excel 2003
This article covers creating basic macros in Excel - those created using the macro options under the Tools menu. It also covers editing macros and introducing variables into macros using the Visual Basic editor. It does not, however, cover creating macros in VBA (Visual Basic for Applications). The instructions are clearly written, although they are not accompanied by very many screen captures.

Introduction to Using Macros in Microsoft Excel 2003
This 60 page PDF document covers creating macros in Excel in great detail. It begins with creating basic macros, but moves into an introduction to VBA (Visual Basic for Applications). The document covers using the Visual Basic editor to write your own macros, as well as VBA grammar, decision making structures, loops, error handling and more. This is a very good introduction to macros and VBA.