* Prices may differ from that shown
When my children were very small I used to work my shifts Friday to Sunday, as had 3 under 3 and half and so childcare was quite challenging and we lost £5 in wages if my husband stopped working Fridays rather than pay for childcare, so we worked opposite each other for several years.
During this time I was conscious of the arrival of internet into my workplace and felt that I clearly needed to develop my skills. I remember on one occasion ringing up the work helpdesk and the guy saying "click on the icon" I replied "what Icon?" he described and I replied "Im really sorry but I have absolutely no idea what an icon is." Anyway I decided to invest some time in changing this and went to my local learn@ centre, which at that time boasted a free crèche for certain classes... Not sure what I enjoyed more, learning new skills or 2 hours peace but in those few years I did many City and Guilds certificates in all computer related courses.
Excel was something I particularly enjoyed and I feel its something that I use more at home than at work. Excel is a Microsoft application and allows mathematical calculations. It uses cells, and these are in rows and columns. Now days you can create graphs and pivot tables but I prefer basic spread sheets for practical problems. Having taught colleagues the basic principles of spread sheets, I believe it is very easy to pick up and I am sure there are many exciting things you can do with it, however my use and knowledge levels are fairly average.
My love of excel spread sheets started with our first extension, I plotted estimates, money available, money spent etc, I even had the cells changing colour when paid. It was a major piece of art work and really kept us on track with spending and knowing exactly whereabouts we were on budget. Our recent renovation and extension was even more detailed, with each aspect of the work linking in to different parts of the spread sheet and allowed really careful monitoring and prevented us from going to far over budget. Calculations showing how many tiles needed x price of tile - discount percentages made me all happy and smiley. I was religious about entering pennies paid after every purchase.
My current spread sheet is my biggest addiction, I have been told by friends I do tend to find a new project and then I'm fully focused and OTT. This one is my desire to be mortgage free. I have 3 mortgage accounts therefore 3 spread sheets with a 4th containing all 3. I have interest rates, overpayment columns and interest saved and it in my opinion is a thing of beauty. Anyone interested in a similar spread sheet can do as I did, and go on MSE website, on the Mortgage Free Wannabe forum and download your own for free. I have found it very motivating to physical see the money saved.
Anyway I like spread sheets, I am not a mathematic type of person but I do like budgets and this is basic enough even for me. I'm giving excel spread sheets a 5 Doo Yoo score because I love mine!
MY GOAL IS TO EXCEL (EXCEL 2003)
This is a Review of Excel a component of Microsoft Office, I am told by Anuj-Bhatnakar that I Should not write about menus and the commands under them. If I write about those things my review Will be called a help file not a review of Software.
I take his advise, because it is him I want to benefit and those like him, I begin at the
Beginning EXCEL-4 that was the first version I worked on this software, my word processor was
WRITE program and I had EXCEL I dont remember it was called office those days, it was simply EXCEL, I am in love with this program. Till now my greater amount of work is done on EXCEL, I Have office 2003, the basic skeleton of excel is the same since EXCEL-4.
There are 3 sheets in a workbook, each sheet has 256 Columns and 65,536 rows, the width of a Column can be 255 characters and 409 points row height, a cell can hold 32,767 characters, can Display 1024 is displayed and all can be displayed in formula bar.
All new versions of office has more web compatible functions, there are standard menus like file,
Edit, view, insert, format, tools, data, window, help, in the about excel tab you can see system Information, under this you can see, hardware resources and see the memory tab to get the whole Picture of your computer resources, you can find out about all software environment, drivers, Signed drivers and system drivers, Internet settings and all information related to browser and Protocol etc., then you have office applications and a vast amount of information relating to all Office applications, there is application fault entries. Can you imagine this is the place to? Shoot for troubles for your whole computer; this is a very very useful thing for system Administrators, just go to help menu of EXCEL and in about excel tab you get everything, instead Of opening many small programs, you can even take a look at NETWORK information and other details
Under System Information VIEW menu you can see Remote Computers connected to your network, you Can see System History what all changes took place on your computer, under TOOLS menu you have Net Diagnostics, System Restore,DirectX Diagnostic tool, there is Dr.Watson, you can run it from
There and use it. There Tech support tab, where you will find the surface address and net address Of support people of Microsoft. There is Disabled items tab.
Excel is a multipurpose program and usually believed to be a DATABASE program, there are no WIZARDS in EXCEL like we have in ACCESS, but excel is so beautifully assembled, each cell can be As a complete different file by itself. Formats are easy drag and drop works smoothly in excel, The tables are very flexible in this program; you can arrange to format it to fill your bank Forms, invoices, L/C applications, Loan applications or any other thing you desire to work with
EXCEL is fantastic.
Drawing tools, Mathematical functions, Interest Calculations, Statistical Calculations,
Progression Calculations, Forecasting, Logical Calculations are made a Child's play in EXCEL, I Have seen people experiment with this program, I have seen a friend require regularly putting Serial numbers in a table 50 Rows in Column A and 50 Rows in Column D, the numbers must be new
Every time the file opens, he made a macro which opens a dialog box and gives the first number in The dialog box, it fills up all the succeeding numbers by itself, it saves him in typing 100 Cells every time, I know AUTOFILL tool can do this but, it looks like Aladdin asking "Please put The required number my master" this message is arranged by him and it pleases me to see it Every time.
Excel can be a database for Customer Address, Telephone Numbers, Accounts Payables, and Accounts Receivables anything you can think of. We can link its every cell to another excel sheet or Word, access, internet etc., this program is powerhouse of in built functions and commands, you Can use pre supplied functions or make your own functions; you only need to know how to write Arguments to suit your needs. It has a macro recorder an Editor for EXCEL VB a little editing to Your recording can be an everlasting tool with you. I subscribe to PCMAG which has EXCEL tutorials And email updates, they inform about new functions and new use of excel, this is to help your Ever evolving excellence.
I have seen courier companies using excel sheets to update their branch records to mainframes, Courier companies are pioneer in providing tracking packages on the net or thru emails, they Update their mainframes from branches via excel sheets. I have seen real estate giants keep track Of their 100,000 flats progress, integrating the consultant comments, as built deviations and as As drawn records on excel database. Inspectors update their reports thru excel.
Auto calculate is a very powerful function, you can open 1 Excel file on 100 workstations, excel Can serve as a useful graphic editor, the grouping function under the drawing tool can bring Eiffel tower beside Qutub Minar, the completeness of EXCEL is so good only hindrance to excel Work is the memory and our own ability and imaginations.
The 3D drawing tools can create a auto shape or a callout on a sheet and click word art write your Words format drag them on the callout, format lines and background, copy the cells holding the Drawings, go open your graphic editor, paste the picture, save as 1.gif and come back to excel Change the color and past picture, save as 2.gif and feed it thru animation program as frames and You are in the business of banner making. Sell them give me 50% of your earnings.
I mean no one thinks about EXCEL in these terms, open your mind to EXCEL and you will excel, I Make multi lingual documents, I write English sentence and translated sentence, paste them in 2 opposite cells and you have in one row 2 language sentences, I bet you 100 bucks you cannot do
That in any word processing program.
Yo world ! EXCEL was made for you to excel.
More than just a spreadsheet! Personally I think Excel is currently the most functional spreadsheet around. Excel certainly dominates the market in this type of software; however there is currently a good spreadsheet known as Calc from Open Office, which is totally free!
I have used Excel a great deal over the last 8 years. I think that almost everybody could find a use for Microsoft Excel either at work or at home to make life easier.
Excel could be used by students both at school and university, to produce project work in a professional style. Teachers and Lecturers who wish to keep track of student performance could also use Excel.
My favourite use for Excel is as a tool to manage my own personal finances. Excel could be used to keep track of bills, debts and investments. If you have problems with being in debt, learning to use Microsoft Excel could be invaluable; you could get an overview and analysis of all your debts and tackle the problem more effectively.
The 2003 version of Excel can be purchased on its own for between £100 - £200. On Amazon the price of Excel is around £170. You can also buy Excel in the Office XP bundle, which is more cost effective, when you get Word, Powerpoint and Outlook as well for around £320. The cost of MS office software seems to be gradually coming down in price.
Excel is highly compatible with other software such as Word, Powerpoint and Internet Explorer. I have found that Excel works particularly well with Powerpoint, for example if you have a large amount of data that needs to be crunched and presented in a graphical format for a presentation. Excel works very well with Internet Explorer, data can be downloaded from the Internet and put in Excel format, hyperlinks can be pasted into Excel and a Web toolbar exists which links to Microsoft Internet explorer.
Microsoft Excel is the standard industrial package in the accountancy profession and is therefore highly compatible with finance software packages such as Sage and Sun Systems.
I say that Excel is more than just a spreadsheet because it can function like a database. Using Excel in a database style would not give such a powerful database as you could create on Access or Oracle. But Excel would be good for creating a small database such as names and addresses of clients of a small company or a school database. I think the possibility exists to set up an invoicing system for a small company using just Excel.
I find the Data menu on Excel has many useful commands such as Sort and Filter, these two commands can be very useful when analysing large amounts of data. The Pivot table command is also very useful, but difficult to get to grips with.
Excel can also be used as a graphics package. A drawing toolbar exists which allows two-dimensional drawing to be carried out. A friend of mine who worked in engineering in the oil industry told me Excel is the main package used for two-dimensional design.
As I am a keen investor in financial markets I find that Excel helps me to keep track of and analyse my investments. Using the chart toolbar, I can produce charts for investments I own. I find that using the chart wizard in combination with the filter and sort commands I can get a good overview of investments that are doing well and those that are not doing so well.
Excel has many functions to use, the SUM function is probably the most well known. The functions can have specific uses for a certain profession like the financial functions, or some can allow you to handle data with greater ease. There are so many functions that no one person can know all of them, I think I only know about 15 functions at the most. Once you get the hang of using the functions you will find yourself using them to manipulate data like you are a professional.
If you are really keen on computers you can even get into programming on Excel. The easiest way of writing a program on Excel is to record a Macro. I record Macro's to save time on routine tasks; you can assign a macro to a button, which you just click. A button can be created using the control toolbox. Programming on a deeper level can be carried out using the Visual basic toolbar, this uses the language visual basic for applications, I have not done much VBA myself but you have the potential to create your own menus with your own commands.
The very basics of Excel are not difficult to use, you could learn this from the Excel manual or from an Excel Internet site. I have been on a few training courses for Excel which were very helpful but costly. If you want to learn I think the best thing to do is learn from one of the Excel dummies guides. A dummies guide for Excel exists for beginners and costs around £10.00. A dummies guide to Excel programming also exists if you are really keen.
I should think that quite a few people exist who have some version of Excel on their computers and have never used it before (for example, it came in a software bundle when they bought their PC). If you are one of these people I definitely think you should explore the software at least, start off with something easy such as creating a shopping list. If Excel or the office suite did not come with your PC when you bought it, I think you should consider the minimum cost of £170 you will have to pay to acquire the software and if Excel will actually be of any benefit to you. If you cant afford this software or dont need a particularly high functioning spreadsheet, download some free software from Open Office (www.openoffice.org). (The spreadsheet from Open Office allows you to view files that have been created in Excel).
When it come to creating tabels and graphs I am stuck! However, Microsoft Excel is a great piece of software that makes collecting data into tables and working out complex maths easy!
Microsoft is easy to use from the beginning! Layed out as a grid, the only work you have to do is enter the data you want where you want it. This is made easier with the instruction booklet, that also gives you guidance and advice over the formulas and graphs that would be suitable for what you are aiming to accomplish.
Microsoft Excel makes jobs easier for the user by providing interactive help by simply clicking a button that will help you will all functions of the spreadsheet.
By providing many font formats and graph designs, Microsoft Excel can give that professional edge to spreadsheets that can be printed for presentations or business porfolios. This software is ideal for those who run businesses by giving a way to record huge quantities of data without having to have huge filing cabinets.
This software doesn't have to be used solely by those businesses that use large amounts of numerical data, but also those that may need to keep personal records such as libraries and doctors surgeries.
This software is a great piece to have and is reasonably priced and which is easy for all to use, even those who are not strong with computers. In the long term it can help you save large amounts of money by cutting down on storage facilities and also by saving you valuable time!