What are the benefits of using excel with medical sales , computer sales , software sales ,web deveopment , till us from your experience by examples ?

For any sales job, reports are always required. Now, you can either fill out the data manually, or you can create a dump worksheet where you place all the raw data, configure Excel to understand the raw data (using equations and/or macros), and it would dynamically create a presentable/readable piece of information and/or charts/graphs -- which can then be used with upper management if needed.

Software sales, it could be used for lead generation, order follow up, where the sale is standing (in terms of percentage), expected closing date, etc.

Medical sales, depends if we're talking about software/hardware or medical supplies here. But if it's software/hardware, then it follows the same rule as software sales, but medical supply, you can use Excel to monitor your stock level and know when to order.

Also, for software/hardware sales, software renewal dates can be set as reminders, and hardware maintenance dates can also be set as reminders.

Finally, for web development, it can be used as a task management. Also, for bug-reporting and it's priority.

To help prevent you ever having to experience this situation here are five of the top features and benefits of Microsoft Excel:

Excel allows business users to unlock the potential of their data, by using formulas across a grid of cells. Data is inserted into individual cells in rows or columns, allowing it to be sorted and filtered, and then displayed in a visual presentation. Using pie charts, graphs and clustered columns adds meaning to data, which otherwise may just exist as row after row of numbers. These visualisations can add extra emphasis to business reports and persuasive marketing material.

Excel users can format their spreadsheets using different colours, bolds and italics, to differentiate between columns and bring the most important data to the fore. The vast number of tasks that can be achieved using this tool is impressive, here are just a few: Display simple icons which represent related data, Highlighting a row based on a single value, Comparing values, Comparing lists and Finding duplicates. Find out more about conditional formating. 

When presenting data in the form of charts or graphs, it can be helpful to include average lines, which explicitly detail the key trends emerging from the information. This may help demonstrate the key points to other users in a straightforward manner - for instance, an executive from a different department during a board meeting. Excel allows trend lines to be extended beyond the graph, to offer predictions of future activity - and such forecasts can help businesses develop their future strategy.

Excel can be used to bring information from various files and documents together, so that it exists in a single location. As well as raw data and information from other spreadsheets, it is possible to import text and images. Other objects can be added using the Insert tab, or additional spreadsheets can be added to the file.

Excel is available online as part of Microsoft's Office 365 productivity suite. This means business leaders and employees have access to the program from a range of devices, from almost any location. Providing they have a web-enabled PC, laptop, smartphone or tablet it should be possible to access Excel, making remote and mobile working viable.

Excellent question. thank you for invitation.

Basically, Microsoft Excel gives various kinds of businesses the tools they need to make the most of their data. And when it comes to making the most of resources, and maximizing return on investment, this is becoming increasingly important. Firms are collecting ever-greater volumes of data from multiple sources, including in-store-transactions, online sales and social media. They need to be able to collate and analyse this information quickly and effectively.

For instances, Excel spreadsheets are commonly used across business to display financial information and other data relevant to the running of the business. This could be information relevant to the customer relationship management department, sales, marketing or HR. With so many business functions now reliant on IT and the internet, Excel continues to be seen as a vital tool for administration and the effective running of a business.

Here are five of the top features and benefits of Microsoft Excel:

1-Build great charts

Excel allows business users to unlock the potential of their data, by using formulas across a grid of cells. Data is inserted into individual cells in rows or columns, allowing it to be sorted and filtered, and then displayed in a visual presentation. Using pie charts, graphs and clustered columns adds meaning to data, which otherwise may just exist as row after row of numbers. These visualisations can add extra emphasis to business reports and persuasive marketing material. Excel recommends charts most suitable for the type of data being presented on the X and Y axis.

2-Use conditional formatting

Excel users can format their spreadsheets using different colour shades, bolds and italics, to differentiate between columns and bring the most important data to the fore. This function could be useful when presenting accounting information, such as the pre-tax profit and the balance being carried forward by the company. Users can select an appropriate colouring scheme via the Quick Analysis button, and then by utilising the Formatting tab.

3-Help identify trends

When presenting data in the form of charts or graphs, it can be helpful to include average lines, which explicitly detail the key trends emerging from the information. This may help demonstrate the key points to other users in a straightforward manner - for instance, an executive from a different department during a board meeting. Excel allows trend lines to be extended beyond the graph, to offer predictions of future activity - and such forecasts can help businesses develop their future strategy.

4-Bring data together

Excel can be used to bring information from various files and documents together, so that it exists in a single location. As well as raw data and information from other spreadsheets, it is possible to import text and images. Other objects can be added using the Insert tab, or additional spreadsheets can be added to the file.

5-Online access

Excel is available as part ofOffice 365 business Premium . This means business leaders and employees have access to the program from a range of devices, from almost any location. Providing they have a web-enabled PC, laptop, smartphone or tablet it should be possible to access Excel, making remote and mobile working viable.

Thanks for the invitation,

I can´t tell how each specialist uses excel, because it differs from one user to another depending on the field of expertise. But in the field of web developement, I think every user goal is to display and auto-update Excel sheets on his web pages. I find this tool great for the task:

https://www.ipushpull.com/solutions/finance.html

KEEP ALL INFORMATION  FOR CUSTOMERS

You can use excel for all these fields for calculating and making charts --- etc

Thank for for the invitation. By using excel, will make your reports/inventory more faster and efficient.

Excel is used for all data tables and preparation of financial accounting system

Thanks

Fully agree with the answer given by colleague Ahmed Ali

agree with all expert answers above