 THE WAY IN WHICH THE GRADUATES OF HIGHER EDUCATION ECONOMIC USES MICROSOFT EXCEL IN THE MARKETING ACTIVITIES OF THE COMPANIES IN BIHOR COUNTYTarca Naiana ()
Annals of Faculty of Economics, 2015, vol. 1, issue 2, 627-633 Abstract: The multitude of the decision situations of the marketing activities, their complexity and particularities are assuming the organizing, processing, aggregating, modeling and analyzing of the great volume of information. By using Microsoft Excel which offers specialized instruments of aggregation, summarization, presenting and analyzing of data such as consolidation of multiple lists, filtering, sorting details in logical groups, subtotals, PivotTable, charts for estimating trends and relationships, Solver, the company management can achieve significant information about market, costs, prices, selling, promoting activities and market development related to different locations and consumer categories. Also overview of different aspects of marketing activities can be achieved. Microsoft Excel software provides efficient solutions to many situations for a marketing activity. Thus, PivotTables creating a dymanic summary data for effective analysis. PivotTable can be used to make a rapid synthesis of data about sales. Charts are used to calculate a trend series data, such as monthly sales over a period of time, and to predict future sales.Solver can be used to solve optimization problems. Based on these considerations we conducted a study in which we sought to obtain information on how instruments such as filtering, sorting, consolidation, subtotals, PivotTables, chart and Solver are used in the marketing activities of companies. From the survey it was noted that all the responders are familiar and use basic techniques of Microsoft Excel facilities in their marketing activity. Charts are also frequent used which means that the great importance is given to visual representation of data. Companies with over 50 employees are those which they attention to data consolidation and aggregating. Much too few are using solver instrument in marketing activities. Among them just a few are using GRG Nonlinear and Evolutionary algorithms. Therefore Solver is generally used for problems which need linear programming.By using in a greater extent PivotTable and Solver instruments in marketing activity significant information can be achieved in a quick way for decision-making activities. Collected and stored data would have been better used so that companies wouldn’t be deprived of information which can offer advantages on a continuous changing market. Keywords: data analysis; worksheet; economic analysis activity; working reports (search for similar items in EconPapers) Downloads: (external link) Related works: Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text Persistent link: https://EconPapers.repec.org/RePEc:ora:journl:v:1:y:2015:i:2:p:627-633 Access Statistics for this article More articles in Annals of Faculty of Economics from University of Oradea, Faculty of Economics Contact information at EDIRC. |
Is your work missing from RePEc? Here is how to contribute.
Questions or problems? Check the EconPapers FAQ or send mail to .
EconPapers is hosted by the
School of Business at Örebro University.