Excel can be an extremely important tool when it comes to crunching data and making it more presentable. It allows us to work
with many data sources and helps perform data analysis. This is extremely useful to know how to access, import, and convert the
data when potentially working with different departments or businesses that use different types of data sources. You will still be
able to compare the data and provide great analysis and insight to make informed business decisions. Some of the files that we can
import
are:
• Other Excel files - you can use data from other sheets or excel files for import
. CSV (Comma-Separated Values) - this is where the values in your data are separated by commas
.
Text Files - these are just plain text files that has rows and columns
other database files - common databases are like SQL Server, Access, and Oracle.
Reply