How to Create Pipe Delimited Files in Excel 2010. Microsoft Excel allows you to export spreadsheet data to a number of common formats for use with other applications. If you need to export data to ...

For many, the INDEX-XMATCH combination in Excel is the go-to method for retrieving a value from a dataset. However, you can also use this dynamic duo to perform two-way lookups, returning a value at ...

How to Create an Excel File Using Visual Basic 6.0. Microsoft announced in early 2012 that it would extend support for aging Visual Basic 6 runtimes and code syntax for the entire life cycle of ...

Here's a quick tip for creating a Microsoft Excel drop down list from another tab.