1. Technology
Send to a Friend via Email

Advanced Topics in Excel Spreadsheets

Here you will find tutorials on some of Excel's advanced features such as macros, lookup functions, array formulas, pivot tables, and data management.

Creating a Drop Down List in Excel Part 1
Use a drop down list in Excel to make data entry easier or to limit what data can be added to a spreadsheet. This tutorial shows you how to create a drop down list in Excel.

Excel Drop Down List Pt 2 - Using Data From a Different Worksheet
A second option for a drop down list is to store the list data a separate worksheet. This can help protect the list from accidental changes.

Excel Drop Down List Pt 3 - Using Data From a Different Workbook
A third option for a drop down list is to store the list data in a separate workbook. This can be useful if the same list is used in more than one workbook and and by more than one person.

Excel Macro Tutorial
A macro is a series of commands that carry out a specific task in Excel. To save time when carrying out common operations you can create a macro using the macro recorder that can be run whenever you need to perform the task.

Excel 2003 Macro Tutorial
A macro is a series of commands that carry out a specific task in Excel. To save time when carrying out common operations you can create a macro using the macro recorder that can be run whenever you need to perform the task. This tutorial covers how to create simple macros in Excel 2003 using the macro recorder.

The Date in Excel
There are many ways of using dates in Excel. There are functions or formulas to add the current date to an Excel spreadsheet. You can also subtract one date from another or find out how many days between the start date and end date of a project. You can format the date in a variety of ways. The articles listed below include examples of...

Excel Conditional Formatting
Excel's conditional formatting features let you control how a cell is formatted - such as changing colors - depending on the data the cell contains. If the cell data meets the conditions you set, then the formatting is applied to the cell. The tutorials in this list cover a number of options for using conditional formatting in Excel and include...

Excel VLOOKUP Step by Step Tutorial
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.

Using Excel's Goal Seek Feature
Excel's Goal Seek feature allows you to alter data in formulas to get different results. Goal Seek can be useful in business when planning new projects. Cost projections for different scenarios can be quickly created and the results compared.

Excel Pivot Table Step by Step Tutorial
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.

Excel Random Number Functions
Generate random numbers in Excel.

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.

You can opt-out at any time. Please refer to our privacy policy for contact information.

©2014 About.com. All rights reserved.