Excel is Microsoft Office’s in-built spreadsheet package. Over the past 20 years, Office has become so ubiquitous that their “.xls” file format has almost become a byword for a spreadsheet. Just as Word documents are saved as “.doc”, so Excel files are saved as “.xls”

Except that hasnt been the case since the release of Office 2007. The default file type in Excel is now “.xlsx”. This is because Microsoft changed the underlying architecture of their sheets and you may notice large files are a little smaller once converted to the new file type.

Although “.xlsx” is the standard default file setting, more recent versions of Excel also offer you the “.xlsm” format. The “m” at the end indicates the presence of macros. Macros are scripts that allow Excel gurus to program their own spreadsheets. If you receive an “.xlsm” file from an Excel beginner, it is unlikely they wrote the code themselves, so it is important that you trust the files original creator. Thats because macros can be used to delete important system files and download viruses.

So by introducing a second standard file type, Microsoft has provided an advance warning that a file contains Visual Basic scripts. Of course, there are still a lot of older “.xls” files in existence but if you have a spreadsheet in everyday use, it should be one of those three formats.

Of course, you may wish to import data into Excel. Often this would come from another database and be stored in a text based format, the most common being the “.csv” file. “Csv” means comma-separated values. That is to say that a comma marks the end of each cell of data, and each new line is a new row. The key point is that the file will not have any formatting and will only consist of a single sheet. At least it is laid out like a spreadsheet.

You can open regular text (“.txt”) files that have nominally been laid out as a set of data, but each entry may be distinguished by some other character, or a tab. Excel will ask you how the data is separated upon opening. Occasionally you will want to open data that is not in spreadsheet form at all e.g. a list of names, but that you could manipulate into a meaningful form using a combination of macros and formulas. That may require the guidance of an Excel support team.

Other formats tend to be workplace specific e.g. the “.xml” format can be extremely useful, but only if you have other applications that use it. There is one exception. That is the Excel add-in. The add-in was formerly the “.xla” format but it has now been extended to “.xlam”. An add-in is simply some pre-written code that allows you to perform a required operation at the click of a button. You will notice an “m” has been added to the end of the file extension to indicate the inclusion of code.

Add-ins differ from macros because a macro is stored in a specific spreadsheet, whereas add-ins can be instructed to auto-load whenever you open Excel. That means an add-in is always available and the code can be accessed from any files. They are most useful if you are attempting to perform a common task for which Excel has no built-in function e.g. if you need to remove duplicates from lists.

The only list longer than the number of file types you can open in Excel, is the number of formats into which you can save your spreadsheet. This is to ensure your work is compatible with any other feasible database or software.

Article by Yana Botwa

Information about Archiving and How to Zip a File – Computers – Software

Search by Author, Title or Content

Article ContentAuthor NameArticle Title

Home
Submit Articles
Author Guidelines
Publisher Guidelines
Content Feeds
RSS Feeds
FAQ
Contact Us

Before any person gets to know the different methods concerning how to zip a file, he or she must first understand the idea of archiving as well as the explanations why compressing needs to be done. Computer file archiving works in the similar principle as how we do conventional or manual archiving of paper files and folders; that’s, keeping files more arranged for easy storage, transfer, or sending online. Archiving also reduces the entire file size making it faster to save, transfer, and consume less data space aside from keeping computer files and documents organized.

Probably the most commonly used archiving programs or systems these days would be the RAR and the ZIP. Each time a person is using later versions of os whether it be Linux, Windows, Mac, etc, he or she no longer need to search for archiving programs and get to understand details on the way to zip a file since both archiving programs are actually fully integrated with virtually all operating systems. A straightforward right click the targeted folder is all that is required in archiving files in a .zip file.

With regards to archiving as well as on how to zip a file, there are three common myths. First, that archiving is just applicable for files; second, it only serves the goal of decreasing file size; and third, it might bring unwanted effects to many audio, video, and other media files. Archiving applications are as much important to online video and audio streaming, website loading improvement, and mobile data handling, CD, DVD, along with other file systems and organization as well. It is not only limited to common computer files. Archiving is also the best manner to lessen source file fragmentation for most software and applications and it is not only performed to lessen file sizes.

The thought that archiving media files may affect the quality of the audio or video is only a typical understanding and it has long been disproved. All kinds of files should retain its quality even after RAR and ZIP archiving and extraction. Damages or problems will only occur if there has been errors encountered while archiving, downloading, and extracting, hence, it’s ideal a person should know the basics on how to zip a file.

When you’re utilizing a fairly old computer operating-system where no archiving program is set up, you can easily download a totally free zip archiving program from the web for free. Some deciding factors when choosing an archiving program and how to zip a file includes compression ratio or rate and possible supported file format restrictions. After setting up the .zip archiving program, you might already zip the file or group of files by right clicking the main folder and selecting “Add to archive”. Alternately, you can click “Compress and email” if you’re planning to send the zipped file via email.

About the Author

Yana Botwa has already been writing articles for 10 years. Her specialisation is qualitative software for personal usage. She also programs her own software and builds websites. One of them you can visit here rar extractor, free zip software or here free zip software

Use and distribution of this article is subject to our Publisher Guidelines

whereby the original author’s information and copyright must be included.

Yana Botwa

RSS Feed

Report Article

Publish Article

Print Article

Add to Favorites

Article Directory
About
FAQ
Contact Us
Advanced Search
Privacy Statement
Disclaimer

GoArticles.com © 2012, All Rights Reserved.