Using VLOOKUP data from Access and SQL Server databases

Add a link to SQL server data to your Excel worksheet.

Creating links to Microsoft Access data in your Excel worksheet.

Use Excel tools to report and analyze data in your software package. This post examines the process of importing a CSV or TXT file.

Today we’ll be looking at preventing duplicate values from being entered into your Excel sheet. This is the final entry in a series that...

Use Excel's Data Validation feature, in conjunction with Excel functions, to validate numeric data.

Use Excel's formatting and data validation features to validate phone numbers