MS-Excel: Data Analysis and Information Management Techniques

This report provides an overview of using MS-Excel for data management and analysis. It highlights the capabilities of Excel for organizing, formatting, and calculating data within spreadsheets. The report includes tasks such as sorting and listing employees based on specific criteria, calculating the difference in holidays taken by employees over a six-month period using formulas, and explaining the application of these formulas. The report emphasizes the importance of effective data and information management in business organizations and concludes that Excel is a valuable tool for managing data, performing calculations, and maintaining data security.

Using and Managing
Data and information

Contents
Contents...........................................................................................................................................2
INTRODUCTION...........................................................................................................................3
TASK 4............................................................................................................................................3
Part A...........................................................................................................................................3
Part B...........................................................................................................................................4
CONCLUSION................................................................................................................................4
REFERENCES................................................................................................................................5

INTRODUCTION
Excel is program which is available in the form of spreadsheet and is a part of Microsoft
office. It enables users to organize, format and calculate the data in the spreadsheet. In the
following report task is performed to sort list the employees whom fulfil the criteria. In the
second part, it states the difference between the number of holidays taken by the employees
within a period of six months. Also explain the concept with the formula.
TASK 4
Ms-Excel is used or organisation data and perform analysis based on the data provided. It is used
to perform small to large function. Main uses of excel includes:
 Data Management
 Accounting
 Data entry
 Customer relationship management (CRM)
 Time management
 Charting and graphing
 Anything that needs to be organized
 Programming
Ms-Excel is software which can modify data using various shortcuts functions and formulas
which enhances the
Part A
In this part it states about the selection of employees on the basis of the selected criteria
which is laid down in the question. In the following question, its condition is that if an employee
has taken more than 10 holidays and have taken training of less than 2 days. If the following
criteria is fulfilled, then the it will show ‘yes’ in the box against the value and if it does not fulfil
the condition then it will show ‘no’. First of all, the destination cell is selected in which the result
will be displayed. In this cell, first of all the formula he applied to determine the findings of the
formula (Bondielli and Marcelloni, 2019).
Part B
In this part, employees are entitled to take 15 days’ holiday in a period of six months.
Formula used in order to know the remaining leaves of the employee. The following formula is

used to calculate the remaining holidays of the employees. In the destination cell the formula is
applied to determine the balance of holidays remaining (Kiselev, and Hemberg, 2018).
CONCLUSION
From the above report it has been concluded that it is very important to manage the use
the data and information in an effective way. The excel can be considered as a tool in order to
mange the data of the business organisation. The excel is used for the various purposes where the
calculations can be made and the company can maintain the high amount of data secured. As
there is different task performed by the organisation and by using the different data sets from the
excel sheet it can be managed in an effective way.

REFERENCES
Books and Journals
Boehmke, B. and Greenwell, B., 2019. Hands-on machine learning with R. Chapman and
Hall/CRC.
Bondielli, A. and Marcelloni, F., 2019. A survey on fake news and rumour detection
techniques. Information Sciences, 497, pp.38-55.
Freudenreich, B., Lüdeke-Freund, F. and Schaltegger, S., 2020. A stakeholder theory perspective
on business models: Value creation for sustainability. Journal of Business
Ethics, 166(1), pp.3-18.
Helsel, B.C. and et.al., 2018. Telemedicine and mobile health technology are effective in the
management of digestive diseases: a systematic review. Digestive diseases and
sciences, 63(6), pp.1392-1408.
Iorga, M. and et.al., 2018. Fog computing conceptual model.
Jabbour, C.J.C. and et.al., 2019. Unlocking the circular economy through new business models
based on large-scale data: an integrative framework and research agenda. Technological
Forecasting and Social Change, 144, pp.546-552.
Kiselev, V.Y., Yiu, A. and Hemberg, M., 2018. scmap: projection of single-cell RNA-seq data
across data sets. Nature methods, 15(5), pp.359-362.
Lefebvre, C. and et.al., 2019. Searching for and selecting studies. Cochrane Handbook for
systematic reviews of interventions, pp.67-107.
Liu, C.L., Hsaio, W.H. and Tu, Y.C., 2018. Time series classification with multivariate
convolutional neural network. IEEE Transactions on Industrial Electronics, 66(6),
pp.4788-4797.
Lowry, G.V., Avellan, A. and Gilbertson, L.M., 2019. Opportunities and challenges for
nanotechnology in the agri-tech revolution. Nature nanotechnology, 14(6), pp.517-522.
Schjerning, A.M., McGettigan, P. and Gislason, G., 2020. Cardiovascular effects and safety of
(non-aspirin) NSAIDs. Nature Reviews Cardiology, 17(9), pp.574-584.
Sharma, P.K. and Park, J.H., 2018. Blockchain based hybrid network architecture for the smart
city. Future Generation Computer Systems, 86, pp.650-655.
Walter, S.L. and et.al., 2019. A tale of two sample sources: Do results from online panel data and
conventional data converge?. Journal of Business and Psychology, 34(4), pp.425-452.
White, A.H., Crowther, S.A. and Lee, S.H., 2019. Supporting rural midwifery practice using a
mobile health (mHealth) intervention: a qualitative descriptive study. Rural and remote
health, 19(3).
Yang, Q. and et al., 2019. Deep convolutional neural networks for rice grain yield estimation at
the ripening stage using UAV-based remotely sensed images. Field Crops
Research, 235, pp.142-153.