The Benefits of Microsoft Office to Business Productivity

This article discusses the benefits of using Microsoft Office applications like Word, Excel, and PowerPoint to increase productivity and enhance management quality in businesses. It explores features such as co-authoring, conditional formatting, and real-time collaboration. The article also covers technological advancements for business, including cloud computing, industrial internet, and mobility.

ICSK3005
INTRODUCTION TO COMPUTER SKILLS
SPRING 2019
Deadline for Submission: 2pm, 24th April 2019
(Google,2019)

Table of Contents
1.0 Introduction.....................................................................................................................................1
2.0 Presentation & Explanation of Business Data..................................................................................2
3.0 The Benefits of Microsoft office to Business Productivity................................................................3
3.1 Microsoft Word...........................................................................................................................3
Co-authoring..................................................................................................................................3
Tell me what you want to do box..................................................................................................3
Smart lookup.................................................................................................................................3
3.2 Microsoft Excel............................................................................................................................3
Conditional formatting...................................................................................................................3
Building Charts with Formulas.......................................................................................................3
Pivot table......................................................................................................................................4
3.3 Microsoft PowerPoint..................................................................................................................4
Presenter View..............................................................................................................................4
PowerPoint Designer.....................................................................................................................4
Real Time Collaboration.................................................................................................................4
4.0 Technological Advancements for Business......................................................................................5
4.1 Cloud computing..........................................................................................................................5
4.2 Industrial Internet........................................................................................................................5
4.3 Mobility.......................................................................................................................................5
5.0 Conclusion.......................................................................................................................................7
Bibliography...........................................................................................................................................8
Appendices........................................................................................................................................9
Appendix 1: Sources of Greenhouse Emission in the UK...................................................................9
Appendix 2: Percentages of Greenhouse Gas per Sector in Pie Chart...............................................9
Appendix 3: Percentages of Greenhouse Gas per Sector in bar Chart.............................................10

1.0 Introduction
A Computer is an advanced electronic machine that receives raw data inform of input
from an individual operating the machine or the user and converts these data using a control
set of commands also referred to as program and transmits the result also referred to as output
and stores the output for the future references or usage. A computer processes both numerical
and non-numerical calculations. Analytical engine were the first mechanical computers and
are attributed Charles Babbage (Crook, 2018). The first computers used Read Only Memory
(ROM) inform of punch cards. There are four basic types of computers based on their speed,
performance and data processing they include the super computers, mainframe computers,
minicomputers and microcomputers. A computer has hardware and software, where the
hardware are the physical elements of the computer which includes the mouse, monitor,
central processing unit, charging system among other components while the software is
referred to programs and applications that which has all the instructions coordinating with the
hardware in performing tasks (Crook, 2018). A computer has a volatile data storage for
instance, the Random Access Memory (RAM) that temporarily stores the data when a
computer is powered on by allowing multiple opening and access of files. Non-volatile
computer storage devices store the data even when the device is powered off they include the
hard disk drive (HHD) which permanently store the information stored on your device
(Crook, 2018).
1

2.0 Presentation & Explanation of Business Data
This analysis is on based on the data of 1990-2016 UK greenhouse gas emissions final
figures for 1990-2016 published in 2016. They are 1990-2016 UK emissions by end users
and fuel type, expressed in Metric tons of Carbon Dioxide Equivalent (MTCO2 e)
Judging from the findings of the spreadsheet of inputted data of 1990-2016 emissions, Energy
supply had the highest greenhouse gas end user emissions with 32 percent. While Transport
was second with 20 percent and Business came third on 16 percent. These were followed by
Residential 12 percent, Agricultural 8 percent, Waste Management 7 percent, Industrial
processes 4 percent, Public 2 percent, and finally, LULUCF had -2 percent greenhouse gas
emissions.
The current emissions trend in the UK based on the yearly total indicates a steady
decline from 1990 -2016. In 1990, the total greenhouse gas emissions were 794.2 (MTCO2e),
then the first drop in 1995 to 744.2. The year 2000 recorded another decline to 701.5 and this
was followed in 2005 by a smaller dip to 681.2. A significant plunge to 595.4 was recorded in
2010 and the highest slump margin occurred in 2015 with 492.3. The downward trend
continued with additional decrease in total emissions to 467.8 in 2016.
2

3.0 The Benefits of Microsoft office to Business Productivity
Microsoft Office is a collection of application software which consist of Microsoft
Access, Excel, Outlook, PowerPoint, Publisher, and Word. The group of software package
performs varied functions but are compatible with each other and have Windows and
Macintosh compatibility (Ose, 2016).
We will now discuss some of the ways Microsoft Word, Excel and PowerPoint could be used
to increase productivity and enhance the quality of management at Green Sustainability
Limited and in broader context, acceleration productivity in the business sector.
3.1 Microsoft Word
 Co-authoring
Co-authoring or real- time collaboration allows colleagues from different platforms and
location to work, edit and make changes on the same document in real-time resulting in
greater overall efficiency (Ose, 2016).
 Tell me what you want to do box
This productivity tool in Word is located at the top of the ribbon. This new feature saves
the user time by searching for a required function rather than the longer time-consuming
menu navigation (Ose, 2016).
 Smart lookup
The smart lookup feature allows for definition and meaning to words and phrases within
Microsoft Word. This facility prevents external search that could result in distraction and
time wastage (Ose, 2016).
3.2 Microsoft Excel
 Conditional formatting
Using conditional formatting support the identification of trends through targeted analysis
of data to detect key matters. Conditional formatting simplifies the process of forms
identification by visualising data with the use of colour scales, icon sets, and data bars
(Hiljazi & Curtis, 2018).
 Building Charts with Formulas
Business users of Excel application software can explain the potential of data by using
formulas across a grid of cells to create charts, graphs and clustered columns. The
visualisation of data helps to give clarity to business reports, marketing campaigns, among
other (Hiljazi & Curtis, 2018).
3

 Pivot table
Pivot table is use to condense and summarise large volume of data across Excel
Spreadsheets for easier and pinpointed interpretation. The ability of the Excel business user to
utilise pivot table in organising and summarising large data could greatly enhance decision
making process leading to increase efficiency in the workplace (Hiljazi & Curtis, 2018).
3.3 Microsoft PowerPoint
 Presenter View
Presenter View enables the user to stay focus and connected to their audience by
displaying the speaker notes, current and subsequent slides at the ready in the deck. Also, the
slides always emerge in the right screen with the help of auto-extend (Kivimäki, et al., 2018).
 PowerPoint Designer
PowerPoint Designer creates ideas automatically for the user to choose from in order to
achieve better looking slides. Also, Designer modifies text to SmartArt graphics for easier
readability, inserts style to slides that are already with photographs as well as harmonisation
of contents to expertly constructed layouts (Kivimäki, et al., 2018).
 Real Time Collaboration
Real time collaboration with colleagues greatly improves the overall quality of a
presentation. This feature requires user to save their presentation to OneDrive of SharePoint
online for collaboration, editing and review. The user has the ultimate option to choose which
changes to include in the presentation (Products.office.com, 2019).
4

4.0 Technological Advancements for Business
There is a current trend around the world especially in developed nations like the
United Kingdom of the need to mitigate against long-term dangers of climate change.
Various aspects of society are embracing new technological advancements in a collective
drive towards carbon footprint reduction. This report will now discuss three of these recent
technological advancements highlighting their benefits and limitations.
4.1 Cloud computing.
Cloud computing is a common term used for anything that comprises transmitting
accommodated services over the Internet. These services are largely separated into three
categories: Infrastructure-as-a-Service, Platform-as-a-Service and Software-as-a-Service. The
term cloud computing was stimulated by the cloud symbol that is frequently used to
characterize the Internet in flowcharts and diagrams. A cloud facility has three separate
features that distinguish it from traditional web hosting (Stergiou, et al., 2018). It is sold on
demand, characteristically by the minute or the hour, it is elastic in the sense that the
individual operating it can have as much or as little of a package as they need at any given
time and the facility is fully operated by the supplier. Important inventions in distributing
computing as well as better right to use fast speed Internet have enhanced attention in cloud
computing.
4.2 Industrial Internet
Connection to computers and all individual conveys better understanding, appreciated
data and the ability to make quicker and an informed decision. Industrial internet is expected
to transform how to strategize, organize, create and service products. Technological
improvement which include sensors connections, smart devices, Internet-connected devices,
and machine learning within the plant offer data used to develop apparatus and
manufacturing process performance. Post production in industrial internet offers closed-loop
product feedback allowing businesses to collect usage data from products in the ground to
fast track prospective design and development. Industrial internet is already making a seismic
shift in the way prosperous companies distinguish themselves (Stergiou, et al., 2018). An
individual can open a manufacturing technology journey now by taking a convincing and real
approach by ascertaining how these technologies can address various businesses and effective
challenges.
5

4.3 Mobility.
The capacity to access data and functionality through mobile phones offers a freed
working environment where facts and information is obtainable at the owners or individual
fingertips from any place as long as he or she can access the internet at any time.
Furthermore, developments in industrial internet gadgets like smart glasses offers a
reasonable, hands-free knowledge to workers in the factory. Mobile ERP offers faster
decision making processes, greater operational efficiencies, they also provide improved
communication and collaboration anytime access to enterprise, business and manufacturing
intelligence and instant access to work center productivity including current production
efficiency. They go beyond the user mobile device. The production environment is
progressively being armed with sensors, Bluetooth, and other communication technologies
that improve data sharing wirelessly and offers an improved distinguishability into operations
like production status and machine efficacy. In a nutshell, these technological advancements
assist companies do their jobs more successfully and they are becoming more common in
production environments.
6

5.0 Conclusion
7

Bibliography
Crook, C., 2018. Computers and the Collaborative Experience of Learning (1994).
s.l.:Routledge.
Hiljazi, S. & Curtis, T., 2018. Developing an Introductory Class in Business Intelligence (BI)
Using MS Excel PowerPivot.. Association Supporting Computer Users in Education..
Kivimäki, J. et al., 2018. Design guidelines for multiloop perturbative maximum power point
tracking algorithms. IEEE Transactions on Power Electronics, 33(2), pp. pp.1284-1293.
Ose, S., 2016. Using Excel and Word to structure qualitative data. Journal of Applied Social
Science, 10(2), pp. 147-162.
Stergiou, C., Psannis, K., Kim, B. & Gupta, B., 2018. Secure integration of IoT and cloud
computing. Future Generation Computer Systems, Volume 78, pp. 964-975.
8

Appendices
Appendix 1: Sources of Greenhouse Emission in the UK
9

8%
15%
31%
4%
2%
2%
12%
19%
7%
Percentage of
Greenhouse Gas
per Sector
Agricultural Business Energy Supply
Industrial Processes LULUCF Public
Residential Transport Waste Management
Appendix 2: Percentages of Greenhouse Gas per Sector in Pie Chart
Agricultural
Business
Energy Supply
Industrial Processes
LULUCF
Public
Residential
Transport
Waste Management
8%
16%
32%
4%
-2%
2%
12%
20%
7%
Percentage of
Greenhouse Gas
per Sector
Appendix 3: Percentages of Greenhouse Gas per Sector in bar Chart
10