Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

Do you use tables in Excel? In which part of your work do you use it?

Microsoft Excel made tables better in each release, I just want to know how Excel specialists are using this feature.

user-image
Question added by Mike Emerson Pasaron , Safety Officer , Arabian Petrochemical Co. (PETROKEMYA)
Date Posted: 2013/07/24
Lubna Al-Sharif
by Lubna Al-Sharif , Medical Laboratory Technician , Nablus Specailized Hospital

= Generally, excel spreadsheet allow users to produce tables containing calculations and graphs.
The purpose of any table we design by excel spreadsheet is to study the correlation between TWO variables over a range of inputs, and this can be clearly emphasized by studying the rates of revenue, advert costs, payroll, statistical correlations and other uses in scientific, mathematical and financial estimations.
= According to me, my recent efforts are focused on designing tables to study the correlation between monthly expenses and items used to spend money on.
While in my previous careers, I worked on involving the statistical analysis within my work at medical, analytical, pharmacological or food manufacturing processes.
How much efforts you spend in data analysis correctly, and finding much in common within those correlations, how faster you could elucidate the proper solutions for such case and easily handle that situation in beneficial manner.

Mohammed Yaseen MBA  PMP®
by Mohammed Yaseen MBA PMP® , Commercial Officer , Hayat Communications

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.

michael Gerges
by michael Gerges , Accounting specialist , Edita Foods industries

Sure, tables are so important in Excel & Databases

Jasmin Mathai
by Jasmin Mathai , Executive / Administrative Assistant to Assistant Vice President , United Arab Shipping Co.

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......

Mohammed Salim Allana
by Mohammed Salim Allana , Compliance and Assurance Manager , United Arab Bank

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.  

Saman Jayasekara
by Saman Jayasekara , Regional Finance Manager , Tappoo Group of Companies

Tables are useful when your data needs to present in more columns & rows.
I use it more frequently monthly budget & performance presentations

Ahmed ASKAR
by Ahmed ASKAR , top man , Norwood IT Communication

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.

  

Grant Angus
by Grant Angus , General Manager , Doha Business Consulting llc

The simplest use of tables in excel is to sort, filter, add formulas and connect data

Deleted user
by Deleted user

i am using the tables for my mathematical calculations and progress report

Deleted user
by Deleted user

Excel is already given in table format so we don't have to make any table and yet i haven't made any table in Excel

ALIREZA DAVATGAR
by ALIREZA DAVATGAR , Product Excecutive IT Product manager , SAMSUNG Electronics Tehran Liaison Office.

Hi Table and using a suitable one is a very comfotable way for Data Entry.
Even if you dave a amount of Data you could manage it (in Data Entry time ) with a Table.
Alireza Davatgar

More Questions Like This