Register now or log in to join your professional community.
Microsoft Excel made tables better in each release, I just want to know how Excel specialists are using this feature.
Yes, Tables can be used for multiple purposes,
There are a number of date functions available in Excel. Depending on your needs, you can use a date function in Excel to return the current date, the current time, or the day of the week. This article covers the most commonly used date functions used in Excel.
Tables can be used for any kind of data analysis, preparing of various reports, graphical representation, collection of small information out of a huge data, simplification of complication data etc......
My favorite application which is called MS Excel now, I was using the father of spreadsheet applications called Lotus Symphony. Lotus123 then MS Excel since1994.
In Finance, we used to collect information, process, assessed and present to the management.
I have used excessively Excel and created macros using Visual Basic to work along with other applications like running queries in foxpro, collect information in excel, manipulate the data using pivot tables and send emails on daily basis from Excel itself by using call other applications.
I think we can use table in(excel) to display the information in more details and help you to analysis your work data easily. And also you can show in different format as you want. such graph but Database term we can use the table to analysis the data modify, delete and manipulate. be able to retrieve the details from DBMS.
Table can be entity name as student and has attribute as name, age and address.