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 don’t 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 From here. 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.
- Thank You! We appreciate your effort.
