|
Quick tips for migrating & using Excel!
|
Posted On :
Oct-06-2011
| seen (516) times |
Article Word Count :
595
|
|
One of the main changes that has occurred in the last few years with Microsoft Excel is the fact that they changed from .xls to .xlsx to add new features and functionality into the later generations of software that they have produced.
|
Introduction
In this article I shall be covering a brief guide on some tips for using Microsoft Excel!
File Types
One of the main changes that has occurred in the last few years with Microsoft Excel is the fact that they changed from .xls to .xlsx to add new features and functionality into the later generations of software that they have produced. In doing this problems arose from systems that had the older generation of Excel installed but were trying to open new (.xlsx) workbooks on their systems. Microsoft arranged for a software previewer to be installed shortly after release allowing users to open and do some very basic amends to the new generation spreadsheets even if you didn’t have the full Excel 2007 or later program installed
Excel 2007 Commands
If you are used to Excel 2000 or 2003 then upon installing Excel 2007 you will notice that all of the GUI has changed and that a lot of the functions that you performed in 2k or ’03 have moved or changed.
Top help aid in your migration over to Excel 2007 Microsoft produced a excel spreadsheet to help users find all the commands that they used to use daily. This can be found at officeimg.vo.msecnd.net/en-us/files/574/020/AF010186429.xls (copy and paste the link into your browsers address bar to download).
Within this document there is a tab for every excel 2003 menu and toolbars and a insight into all the different tools and commands on the left, on the right there are the commands on how to accomplish the same task within 2007.
Formulas
Within Excel 2007 there are many different ways to give commands and input formulas; one of the quickest ways of doing this is by using keyboard commands and
shortcuts.
The simplest way to add a selection of numbers rather than going “= then clicking a2 then + a3 + a4 + a5 + a6 + a7” would be to shorten it down to “=SUM(a2:a7)”, this does the exact same calculation but is quicker than selecting each cell individually and with practice you can do it all based on just keyboard commands on the fly!
In excel you can now not only just add numbers but can also add and join text together to offer more flexibility and functionality for users. This function is called Concatenate; its technical use is it allows you to merge values from multiple cells into a single string within a cell.
System editorial changes within Office 2010
If you run a SMB network or are part of a large scale LAN then you have probably had the problem before of “This file is in use by another user, open as read only or save to another location” this is because up until Office 2010 was released the files that are used by Excel were locked down for single use editing only.
As one of the main features and software upgrades to occur to Office 201 this feature would allow for example teachers to all be able to input grades onto one singular spreadsheet at once. This allows for multiple users to work on the same file and there not be multiple files involved in the process.
If this function is used it not only will allow an increase in productivity but will also allow for you to save your own personal valuable time as you will not have to merge or consolidate the files together at a later time/date as you have been able to edit them simultaneously.
|
|
Article Source :
http://www.articleseen.com/Article_Quick tips for migrating & using Excel!_89132.aspx
|
Author Resource :
Dave Williams is the author of this article. Learn more about Microsoft Excel Training From Melton IT. Please visit their website: www.meltonit.co.uk
|
Keywords :
Microsoft Excel Training, Melton IT, Microsoft Office Training Courses,
Category :
Computers
:
Software
|
|
|
|