Using MS Excel for Data Manipulation and Presentation: A Case Study of Google

This report explores the functions of Microsoft Office in relation to business, with a focus on using MS Excel for data manipulation and presentation. It includes a case study of Google, covering statistical tools and techniques, data sorting, and data presentation with charts and graphs. The report also provides an interpretation of the data and concludes with the importance of using such methods and tools in corporate business.

A1 MS EXCEL TASK
Table of Contents

INTRODUCTION.......................................................................................................................3
TASK........................................................................................................................................3
Select any research topic...................................................................................................................3
Sort the information related to case study.........................................................................................3
Statistical tools and techniques..........................................................................................................4
Data manipulation.............................................................................................................................4
Data presentation with the help of charts and graphs.......................................................................5
Interpretation of Data.............................................................................................................6
CONCLUSION...........................................................................................................................7
REFERENCES.....................................................................................................................................8

INTRODUCTION
The report developed as under takes in account the functions of Microsoft office in a
company and in relation with business as well (Fenech, Baguant and Ivanov, 2019). It makes
sense of various focuses being considered such as Microsoft power point supportive in readiness
of introduction, MS excel which would be beneficial in solving complicated and complex
situations. It is adapted for loading data at a bigger scale and level and would be more fruitful in
handling few preferences of the business. Such prepared reports consider relevant information in
development of Google, its further functions in web related administrations and items as well. It
also features online mechanisms for creation of notice, varied figuring program and web search
techniques as well. Significant viewpoints for instance, market capitalisation, revenue, income
and number of users is considered for the prepared report.
TASK
Select any research topic.
In the research the case investigation analysis of Google has been selected. The report did is
connected to looking and finding various ways for organizing information. It fills in as a helper
for enlisting market capitalisation, pay delivered by the firm and clients associated with the
endeavour.
The assessment content for the finding is Google. It will depict whether the technique would be
helpful in additional creating business related results and execution. There is different work
performed by pattern setting advancement in associations, for instance, staying aware of the level
of stock. There ought not be conditions which prompts piling up of stock and need accessible
stock. The condition of stock out will restrict the brand picture, and stacked stock would incite
mounting of conveying cost. For strong organization of resources there are a couple of
programming anticipated for example stock organization that help assignment of resources in a
suitable way (Foreman, 2019).
Sort the information related to case study.

Year Market Capitalization (in billion $) Revenue Number of users
2015 375 74.54 2759.3998
2016 530 89.98 3363.7296
2017 580 110.55 3855.9368
2018 720 136.36 3956.7462
2019 840 160.74 4070.0538
2020 745 181.69 4471.0083
2021 1425 256.74 4738.1388
Statistical tools and techniques.
Year Market Capitalization (in billion $) Revenue Number of users
2015 375 74.54 2759.3998
2016 530 89.98 3363.7296
2017 580 110.55 3855.9368
2018 720 136.36 3956.7462
2019 840 160.74 4070.0538
2020 745 181.69 4471.0083
2021 1425 256.74 4738.1388
Mean 745 144.37143 3887.859043
Median 720 136.36 3956.7462
Data manipulation
Year Market Capitalization (in billion $) Revenue Number of users
2015 375 74.54 2759.3998
2016 530 89.98 3363.7296
2017 580 110.55 3855.9368
2018 720 136.36 3956.7462
2019 840 160.74 4070.0538
2020 745 181.69 4471.0083
2021 1425 256.74 4738.1388
Sum 5215 1010.6 27215.0133
Count 7 7 7
Maximum 1425 256.74 4738.1388
Minimum 375 74.54 2759.3998
Google

Data presentation with the help of charts and graphs.

Interpretation of Data.
Mean: Represented as an instrument is valuable in computation of typical so far in a data series
laid as under by any firm, attempt and business. It will in general be still up in the air by
separating summation of judgement by hard and fast no. of insightful. Along these lines in above
put down case mean came to fruition as 745 in section of Market capitalisation of Google
association. It included 144.371 in pay area and in the occasion of number of clients associated
with the enterprise it recorded to be 3887.859. Consequently, one could express that there is
various instability found in case of clients, pay portion. The information given is addressed year
2015-2021 likewise it would be useful for social event data at one spot and interpret the data
through less troublesome and clear techniques (Guo, Bao and Wang, 2018).
Revenue: It might be nicely communicated as the advantage that is being secured by an
association over the course of time span by playing out a couple of exercises-based practices and
learning typical cost of selling. It can likewise be denoted as Sales on pay pronouncement or
records. It further goes about as a technique which assess the endlessly working of association's
advancing and bargain however hold stream is viewed as an indication of liquidity stayed aware
of up until this point.
Count: The COUNT work helps with enrolling indisputably the no of insight and it is studied as
a critical mechanism in succeed. The hard and fast no. of mindful in setting of number of clients,
pay and market capitalisation is reflected as seven. The recipe used in such areas is =count
(proportion of cells for which the count is necessary).
Sum: The SUM work is normal for development of complete digits that are available in a series
outlined. Such kind of limits can be performed with the help of sign, for instance, "=" and
picking the segment on which request ought to be applied. The summation of pay is reflected as
1010.6, market capitalisation rate is 5215 and remembering that assuming there ought to emerge
an event of number of clients attracted it mirrored a balance of 27215.0133 in Google firm
(Liebowitz, 2019.
Maximum: Such orders are useful to track down most critical total or sum from the available
instructive assortment or recorded discernments. The best digit presents in pay portion a worth of
256.74 total. The most raised unequivocal measure of clients has all the earmarks of being of
4738.1388. It is expected to be recorded with the help of implementation of =max ().

Minimum: The gadget, for instance, MINIMUM would be significant in impression of least
figure possible from a movement of data up until this point recorded by the affiliation. The limit
is performed by execution of recipe which is = MIN (). The base incorporate figure found in case
of Market capitalisation is 375 and in areas of pay it tended to worth as 74.54. It reflected a
balance of 2759.3998 in case of Users being associated with the firm (Panescu and Manta, 2018).
Median: It tends to be portrayed as figuring out Mid-point or mid advantageous coordinating of
data is worked with from lower to higher units. It helps with learning plans that are being
followed and focus worth at the hour of information variety that has damaged sum. Centre came
about to be 720 for a period length of 7 years in Market capitalisation and in piece of count of
clients it recorded as 3956.7462. It while reflected a balance of 136.36 in pay region.
CONCLUSION
From the above prepared report, it can be explained that it tended to be finished up and
deciphered as well which succeed and serves as a fruitful direction in performing various
undertakings doled in a company. It would be helpful in exploring reports, arrangement of data,
minimizing the responsibility of analysts and also setting limited assignments which can be
counted confused tasks. The complex calculations can be performed in a limited and minimum
time span. It also takes in account development and preparation of tables and graphs that would
be providing proper guidance and assistance in figuring out and finding out what has been
decline and rise in quantity of users drew in and fixed with the business. It takes data for more
than 7 long years and apply summation of data, its normal and middle as well. It further would
be helpful in picking best preferences from chosen options which would help in further
development of monetary base which would be based on execution of the enterprise. The report
is more likely to have charts and graphs present the reason being to have a clear and transparent
picture for designing their activities and assess in right manner. It in addition would be providing
guidance by performing various roles such as arranging data in a simpler and better manner for
longer time duration in a corporate business. Hence it is necessary for every company to zero in
such methods and devices.

REFERENCES
Books and Journals
Fenech, R., Baguant, P. and Ivanov, D., 2019. The Changing Role Of Human Resource
Management In An Era Of Digital Transformation. Journal of Management Information
& Decision Sciences, 22(2).
Foreman, P., 2019. Vulnerability management. Auerbach Publications.
Guo, J., Bao, Y. and Wang, M., 2018. Steel slag in China: Treatment, recycling, and
management. Waste management, 78, pp.318-330.
Liebowitz, J., 2019. Building organizational intelligence: A knowledge management primer.
CRC press.
Panescu, A.T. and Manta, V., 2018. Smart contracts for research data rights management over
the ethereum blockchain network. Science & Technology Libraries, 37(3), pp.235-245.
Pirson, M., 2019. A humanistic perspective for management theory: Protecting dignity and
promoting well-being. Journal of Business Ethics, 159(1), pp.39-57.
Van den Bosch, F. and Coates, L., 2018. Clinical management of psoriatic arthritis. The
Lancet, 391(10136), pp.2285-2294.