Advanced Topics in Excel Spreadsheets
Advanced topics, such as working with scenarios, macros, lookup functions, pivot tables, and auditing formulas can be found in this category. These topics are explained and covered in a variety of ways including FAQs, tips, step by step tutorials, and general information articles on the topics.
Creating a Drop Down List in Excel 2007 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 article shows you how to create a drop down list in Excel 2007.
Use a drop down list in Excel to make data entry easier or to limit what data can be added to a spreadsheet. This article shows you how to create a drop down list in Excel 2007.
Creating a Drop Down List in Excel 2007 Part 2
This article continues Part 1 of this topic. In this article we cover how to create a drop down list in Excel 2007 with data located on a different worksheet.
This article continues Part 1 of this topic. In this article we cover how to create a drop down list in Excel 2007 with data located on a different worksheet.
Excel 2007 Macro Tutorial
This step by step tutorial covers how to create simple macros in Excel 2007 using the macro recorder.
This step by step tutorial covers how to create simple macros in Excel 2007 using the macro recorder.
Excel 2003 Macro Tutorial
This tutorial covers how to create simple macros in Excel 2003 using the macro recorder.
This tutorial covers how to create simple macros in Excel 2003 using the macro recorder.
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’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.
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.
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'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.
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.
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.
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.
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.
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.