Connecting Data Sources in Excel
Using VLOOKUP data from Access and SQL Server databases
top of page
Search
Kimberlee Martin
Jan 20, 20234 min read
Connections: Bringing SQL Server data into Excel
Add a link to SQL server data to your Excel worksheet.
21 views0 comments
Kimberlee Martin
Jan 9, 20234 min read
Connections: Bringing Access Data into Excel
Creating links to Microsoft Access data in your Excel worksheet.
27 views0 comments
Kimberlee Martin
Dec 28, 20225 min read
Connections: Importing CSV Data from your Software Package into Excel
Use Excel tools to report and analyze data in your software package. This post examines the process of importing a CSV or TXT file.
17 views0 comments
Kimberlee Martin
Dec 16, 20224 min read
Double Trouble
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...
15 views0 comments
Kimberlee Martin
Dec 2, 20224 min read
Validating Numeric Fields in Excel
Use Excel's Data Validation feature, in conjunction with Excel functions, to validate numeric data.
22 views0 comments
Kimberlee Martin
Nov 23, 20226 min read
Validate Phone Numbers in Excel
Use Excel's formatting and data validation features to validate phone numbers
25 views0 comments
CATEGORY
ARCHIVE
bottom of page