Introduction to Computer Skills

Introduction to Computer Skills INTRODUCTION 1 TASK 11 Data of Monthly Sales by Employee 1 Formula view of Monthly sales by employees2 2.Data analysis and interpretation: 2 TASK 23 3. Benefits of Microsoft Office3 3.1 Benefits of Microsoft Word:3 3.2 Benefits of Microsoft Excel4 3.3 Benefits of Microsoft Power Point 4 4. Technological advancements for business5 4.1 Artificial Intelligence Technology 5 4.2 More fuel efficient rides 5 4.3 Business management applications 5 4.4 Implementation 6 CONCLUSION 6 REFERENCES 7 7

Introduction to Computer Skills

Table of Contents
INTRODUCTION...........................................................................................................................1
TASK 1............................................................................................................................................1
Data of Monthly Sales by Employee..........................................................................................1
Formula view of Monthly sales by employees...........................................................................2
2.Data analysis and interpretation:...................................................................................................2
TASK 2............................................................................................................................................3
3. Benefits of Microsoft Office........................................................................................................3
3.1 Benefits of Microsoft Word:.................................................................................................3
3.2 Benefits of Microsoft Excel..................................................................................................4
3.3 Benefits of Microsoft Power Point.......................................................................................4
4. Technological advancements for business...................................................................................5
4.1 Artificial Intelligence Technology........................................................................................5
4.2 More fuel efficient rides........................................................................................................5
4.3 Business management applications.......................................................................................5
4.4 Implementation.....................................................................................................................6
CONCLUSION................................................................................................................................6
REFERENCES................................................................................................................................7
.........................................................................................................................................................7

INTRODUCTION
Computer skills are those which enables an individual to utilize computer and related
technology in an efficient way. These skills includes Microsoft Office, Power Point, Quick
Books, Email, Spreadsheets, Microsoft Assess, Graphic and writing skills etc. Today, the
economy is technologically oriented and employees who have strong computer skills or
knowledge fare better in job market instead of their tech challenged counterparts (Campbell and
Wynne, 2011). This assignment is based on Car Dealership company which specialize in selling
of mid range second hand cars. In this report, data of motor vehicle firm is analysed so that
employee with highest contribution in sale revenue can be determined and appraised by bonus.
Apart from this, benefits of Microsoft Office and technological advancements in increasing
business productivity is defined in the project.
TASK 1
Data of Monthly Sales by Employee
1

Formula view of Monthly sales by employees
2.Data analysis and interpretation:
From the data worksheet of employee's monthly sales, it is analysed that car dealership
company earns good amount of sales revenue. As per the above data view sheet, contribution of
employee B and D is high towards company, i.e., £811000 and £631000 and they also earn
bonus. Maximum cost is involved by firm in month of June which is £230000 whereas in
January, involved cost is minimum, i.e., £165385. Five employees are working in car dealership
company named as A, B, C, D and E whose minimum contribution in sales are £2,00,000 per
month (Dorf and Bishop, 2011). Highest sales by all employees is earned in June month, i.e.,
£2,99,000.
For increasing motivation level of employees and encouraging them to work towards
attaining high productivity and profitability, firm provides bonus to them. Target sales of
£6,00,000 is achieved by employee B and D and earn bonus. At last, overall sales earned by
employees in year 2017 is £ 3001000 as well as total cost incurred is £2308462. It means, annual
profit earn by car dealership company is £6,92,540 which shows that firm is earning high
incomes and revenues.
2

TASK 2
3. Benefits of Microsoft Office
Microsoft Office refers as a server, client software and services that are developed by
Microsoft for satisfying informative technological needs of clients. In today's technological
scenario, constant challenges are face by businesses in order to increase their productivity and
profitability. This software administers new technology to company that helps in improving
business processes and earning high revenues (Khan and et. al., 2012). It also assists company in
increasing its data security. The main purpose of office suite is to maximize integration which
can assist in improving efficiency and effectiveness level of car dealership company. Various
applications and range of software of Microsoft Office involves Power Point, Word, Excel,
Outlook, One Note, Skype, Access, InfoPath etc. These application and software assists
company in creating presentations, documents and spreadsheets that are essential in day to day
business activities. Some benefits of Microsoft Office in increasing business productivity are
defined below:
3.1 Benefits of Microsoft Word:
It is the industry standard word processing program utilizing on computers. By this, car
dealership company prepare documents and complete various other functions concerned with
word processing. Some benefits of Microsoft Word are defined below:
Integration with office programmes:
The main benefit to firm of using Microsoft Word is that it integrates easily with other
Office programs. For instance: By spreadsheet, Microsoft Excel can easily be created and paste
into Word document (Ramdoss and et. al., 2012). Individual can work with Power Point program
as well. This makes it possible for car dealership company to complete broad array of computing
activities without spending time to convert files and documents so that they can use on other
programs.
Document Flexibility:
Microsoft Word helps in creating simple word processing documents such as reports and
letters and helps them as basic as individual wants. One can use clip art, borders, tables, add
colour, write in different sizes and variety of fonts, bullet formatting etc. It also provides
templates that helps in creating various other documents like greeting cards and calenders. Files
3

can be save in different formats including Web page. All this will help car dealership company in
creating and saving documents that contains necessary information.
3.2 Benefits of Microsoft Excel
It provides the tools to businesses which they require in making most of their data.
Microsoft Excel is becoming increasingly important in making resources and increasing return
on investment. Some benefits of Excel in increasing productivity of business of car dealership
company are defined below:
Easy to store data:
Use of Excel makes it easy for car dealership company to store their data, format cells,
perform calculations, report to share with others and adjustments in layouts to create the output.
Some of the templates makes it simple for firm to attain wide range of activities (Benefits of
Microsoft Excel, 2013).
Graphical representation of data:
It enables firm to develop visual representation of information or data. It makes easy for
others to clearly understand all the information in the form of graphs, column and bar charts.
Visual display of data helps the manager of car dealership company in providing all the data in
better manner which assists in increasing its productivity.
3.3 Benefits of Microsoft Power Point
Easy to make professional looking presentations:
This software helps manager of car dealership company in making effective presentations
that can help in improving focus of other people. Use of Power Point allows them to add video,
audio and images in presentations to have a great visual impact. These video and audio cues
might assists a presenter to be more interactive with audience. By the assistance of effective
presentations, manager is able to express their points in more better and clear manner which
ultimately helps in improving productivity of business (Ramdoss and et. al., 2011).
Collaboration:
Power Point enables an individual to work with others in collaborative manner.
Especially, it is very useful in businesses where team work is key. Many people can contribute
and collaborate on to a presentation. At the top of program, by going to review tab and clicking
on new tab button, presenter can leave notes as well as reposition them on screen to view by
other members. This will help manager of car dealership company in explaining all the things
4

clearly to team members which enables them to work in proper manner and attaining high
productivity.
4. Technological advancements for business
In present scenario, technology plays crucial role in growth and success of business. So,
firms are require to be aware of technological advancement so as to enhance efficiency of an
organisation. Main purpose of these up gradations is to enhance operational capabilities of
business and improve customer experience (Mayer, Borges and Simske, 2018). Car dealership
company deals in automotive sector which is the growing one. So, for gaining high competitive
advantage in market, firm must implement technological advancements in its processes which
are defined below:
4.1 Artificial Intelligence Technology
Use of artificial intelligence technology proves to be beneficial for car dealership
company as it helps providing personalized experience. By the assistance of this technology, an
informative system is provided in vehicles which will benefit customers by user interface and
application preferences. Artificial intelligence technology plays crucial role in future of
automotive sector as cars with predictive capabilities are becoming much prevalent,
personalizing driving experience.
4.2 More fuel efficient rides
Now a days, it is very essential to conserve fuel resources and save fuel. So, in forefront
of fuel efficiency movement, many organisations introduced electric and hybrid vehicles. Car
dealership company should also sell cars with fuel efficient technology so that more fuel can be
save. These vehicles are becoming more affordable as it may soon be adopted widely all over the
globe. Implementation of this technology helps firm in increasing its productivity and
profitability in efficient way (Taylor, Fritsch and Liederbach, 2014).
4.3 Business management applications
These are user friendly applications that assists individual in managing its business
operations effectively. As car dealership company deals in automotive business, so various
operations are require to be manage properly. Cloud computing, internet etc. are the technologies
included in it. Cloud computing assists in storing large amount of data and internet provides
various cost effective tools that helps in increasing productivity.
5

4.4 Implementation
Above mentioned points shows some technological advancements that should be adopted
by car manufacturing company in order to enhance their productivity and profitability (Vigdor,
Ladd and Martinez, 2014). Implementation of these technologies helps firm in reducing cost,
improving business operations, providing effective services to customers and so on. Some other
advancements like self driving technology, car as a service etc. can also be utilize for improving
business productivity.
CONCLUSION
As per the above mentioned report, it has been concluded that technological
advancements and computer skills play crucial role in increasing productivity of firm. Microsoft
Excel helps in graphical representation and easy storage of data. There are various technologies
such as artificial intelligence, fuel efficient technology and businesses applications like internet
and cloud computing are available. Implementation of these technologies provides competitive
edge to company and improves productivity as well in an effective manner.
6

REFERENCES
Books and Journals:
Campbell, J. B. and Wynne, R. H., 2011. Introduction to remote sensing. Guilford Press.
Dorf, R. C. and Bishop, R. H., 2011. Modern control systems. Pearson.
Khan, M., and et. al., 2012. Barriers to the introduction of ICT into education in developing
countries: The example of Bangladesh. Online Submission. 5(2). pp.61-80.
Ramdoss, S., and et. al., 2012. Computer-based interventions to improve social and emotional
skills in individuals with autism spectrum disorders: A systematic review.
Developmental neurorehabilitation. 15(2). pp.119-135.
Ramdoss, S., and et. al., 2011. Use of computer-based interventions to improve literacy skills in
students with autism spectrum disorders: A systematic review. Research in Autism
Spectrum Disorders. 5(4). pp.1306-1318.
Mayer, J., Borges, P. V. and Simske, S. J., 2018. Introduction. In Fundamentals and
Applications of Hardcopy Communication (pp. 1-5). Springer, Cham.
Taylor, R. W., Fritsch, E. J. and Liederbach, J., 2014. Digital crime and digital terrorism.
Prentice Hall Press.
Vigdor, J. L., Ladd, H. F. and Martinez, E., 2014. Scaling the digital divide: Home computer
technology and student achievement. Economic Inquiry. 52(3). pp.1103-1119.
Online
Benefits of Microsoft Excel, 2013. [Online]. Available through: <https://www.quora.com/What-
are-the-advantages-of-Microsoft-Excel>
7