Uses of Microsoft Excel in Business: A Case Study of Google

This report explores the uses of Microsoft Excel in business with a case study of Google. It explains how Excel can be used for complicated calculations, data storage, and decision-making. The report also shows how to manipulate data with statistical tools and techniques to improve business performance. The data collected over 7 years is analyzed using SUM, COUNT, MINIMUM, MAXIMUM, and other commands to show fluctuations in revenue, number of users, and market capitalization rate.

DHCIT

INTRODUCTION
The report prepared under takes in account the uses of Microsoft office in a company and business
related activities (Dos Santos and et.al., 2019). It explains various points taken in account such as
Microsoft power point helpful in preparation of presentations, Ms word which helps to build thorough
reports, Ms excel which is helpful in carrying out complicated and complex calculations. It is used for
stocking data at a larger scale and is helpful in processing several decisions of the company. Such
report considers important information in context of Google, it also specializes in internet related
products and services. It includes online medium for developing advertisements, search engines and
cloud computing software as well. The research is conducted for the knowing about the improvement
of business performance of Google based on the data collected.

Choose any one research topic from
the list given.
In the laid down case organisation chosen is Google. The report carried out is all about
searching and finding several ways for sorting information. It serves as a guide for
computing market capitalisation, revenue generated by the firm and users linked with the
enterprise.
The research content for the finding is Google. It will describe whether the
technique would be helpful in improving business related results and performance. There
are various role performed by advanced technology in companies such as maintaining the
level of inventory. There must not be situations which leads to piling up of stock and
deficiency in available stock.

Continue…
Extracting information about number of users,
revenue and market capitalisation.
Information and useful data: It is stated as a raw
figure and facts that are important for providing
meaningful data about several prospects. The data
can be assembled in various structures:
 Primary data
 Secondary data

Collect information of Google and
sample.
Google
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

With the assistance of Excel manipulate data
with help of statistical tools and techniques.

Continue…
2015 2016 2017 2018 2019 2020 2021
0
50
100
150
200
250
300
Revenue

Concisely state and examine the
data accumulated.
 Revenue
 Mean
 Median
 Minimum
 Maximum
 Sum
 Count

Continue..
Interpretation: From the above collected data it can be concluded and interpreted that there are many functions
that help to prepare a research report of competitive companies in environment. It can be observed that the data
recorded is for 7 years and the commands applied in prepared sheet and report is SUM, COUNT, MINIMUM,
MAXIMUM. It has reported a fluctuation in sections such as revenue earned, Number of users linked, market
capitalisation rate as well. There have been a variation observed in case of number of users which started to rise
from 2759.3998 to 3363.7296 in year 2016. The company observed a hike of 492.20 in year 2017 which began
to increase up to a level of 3956.7462 in next year. It further recorded a balance of 4070.053 in year 2019 and
which kept on rising till 4738.1388 in year 2021.

CONCLUSION
From the above asserted report, it can be concluded and interpreted as well that Ms excel provides useful
guidance for performing various tasks assigned in a company. It helps in preparation of research reports, sorting
of data, reducing workload of researchers and minimizing tasks that count complicated tasks. The complex
calculations can be carried out in lesser duration. It takes in account charts, tables that help to understand what
has been rise and fall in number of users engaged & lined with the company. It takes data for over 7 years and
apply summation of data, its median and average as well. It further assist in choosing best decision from
available alternatives that would help in improving the finance based performance of the firm.

REFERENCES
 Mustafina, A.A., Kaigorodova, G.N., Alyakina, P.D., Velichko, N.Y. and Zainullina, M.R., 2020.
Digital technology in insurance. In Digital Transformation of the Economy: Challenges, Trends
and New Opportunities (pp. 678-685). Springer, Cham.
 Schmidt, P.J., Riley, J. and Swanson Church, K., 2020. Investigating accountants' resistance to
move beyond Excel and adopt new data analytics technology. Accounting Horizons, 34(4),
pp.165-180.
 Hong, A.J. and Kim, H.J., 2018. College students’ digital readiness for academic engagement
(DRAE) scale: Scale development and validation. The Asia-Pacific Education Researcher, 27(4),
pp.303-312.