Additional Features Of Microsoft Excel

Published Date: 02 Nov 2017

Cloud-computing-iStock_000019699956XSmall.jpg

VIRAJ PATEL

STUDENT ID: 12031010

TABLE OF CONTENTS

NEW ZEALAND INSTITUTE OF MANAGEMENT (NZIM)https://si0.twimg.com/profile_images/640763080/NZIM_Logo.jpg

Regional Numbers: Northern: 0800 800 694, Central: 0800 373 700, Southern - Canterbury: 03 379 2302, Otago: 03 455 5165, Southland: 03 218 7451 National Office Phone: +64 4 473 0470.

Email: [email protected] Webmaster: Optimum Websites

NZIM (New Zealand Institute of Management) – has been established to develop New Zealand management and leadership through scholarships and study programmers. Scholarship provides individuals with the opportunity of a rewarding and practical experience that will be benefit to them individually and to New Zealand. Here you will find the resources, networking opportunities and interactive tools to help you enhance your role, business and professional development. NZIM relates to a number of organizations to educate the development of management skills and business capability. Their aim is to support the development of managers in which it leads the economy and quality New Zealand country by through encouraging organizations to build their management competencies to the best practical levels.

NZQA – aim to increase the confident and the quality of the tertiary education sector and also make sure that New Zealand qualifications are regarded as well adverse in which nationally and internationally, to help learners succeed in their chosen endeavors and contribute to New Zealand society. There is wide range of programmers offered by New Zealand to get good qualifications and knowledge. All education can be credible to assess the international and national qualification

Auckland Goldstar Institute (AGI) - mostly relay on the international students. New Zealand ministry of education has a code of practice of the recruitment, welfare to support the international student. They came under (NZQA) in the provision of the education act 1989.

AUCKLAND GOLDSTAR INSTITUTEhttp://www.newzealandeducated.com/admin/uploaded_images/776-logo_AGI%20Small%20Logo.jpg

BUSINESS COMPUTING (550) outline:

In nowadays the usage of computers in industries is quite common, the fast processing of information has lead to significant role that computers play in the business. People should seriously concentrate on learning the basic use of computers, because in future the computers impact will be more in our workplace, at home and in the business. Computer training is now more widely than ever before and making it available to more people is a beneficent start to what should be a very interesting and educational century. Auckland Goldstar Institute will gave the knowledge and understanding of the potential use of modern software packages and know how to apply them to specific business operations and you will have the confidence not only to use information systems but also the knowledge to support the development in business sector. Learning outcomes of Business Computing (550):

Key elements of Information system to meet business requirements.

Secondary Storage

Input and Output Devices

Evaluating communication technology

Communication Channels( Wireless, Physical, Bandwidth)

Communication devices

networks

Internet technology

Recommended actions to be minimize the impact in regards to computer usage

Ethical and legal compliance requirements

Security

Health

Effectively use of software function to produce information

Word processing functions(Mail merge, table of contents, tables, chart etc)

Microsoft Excel functions(formulae, graphs)

Data validation tools

Data analysis tools

Database functions

Field structure

Table relationship

Queries

Email functions

File converversions

Using multimedia tools

Trouble shoot software problems

Utilities ( Virus scan, firewall, file compression, backup, system maintenance)

MICROSOFT WORDhttp://cdn.thetechjournal.com/wp-content/uploads/2012/04/word-2007-logo.jpg

Word Document toolbar.gif

Microsoft Word is where you create documents just like letter which helps to be correct by checking your grammars and spelling and also helps to organize to work efficiently. It’s a very important tool for students, business owners and even working personally to have on their computers.

Two things which increase accessibility of word documents are:

Improve the original word life

If word document is export to another format, it is accessible

Some of the features of Word Document:

Open file

Bold Underline, and Italicize

Highlighting Text

Changing Font Color

Cut and Paste

Inserting Text

Cutting and Pasting by Using the Standard Toolbar

MICROSOFT EXCELhttp://t3.gstatic.com/images?q=tbn:ANd9GcTu9_L1uxM1KqUdrEApnWeFXl0VkRavvfmJPtN81jYWC5Ppq6_B

openXLS.jpg

Microsoft Excel is a basic feature with the use of grid of cells alien with numbered rows and alphabetic columns to organize data and calculating formulas easily (refer to the example above). Spreadsheet is normally used in numeric data stored. Mostly excel are used in business sector in which the work become easier and also in an organize manner.

Additional Features of Microsoft Excel:

Function Tab – mathematical add, subtract, divide, multiply, average, sum

Clip art – we can use images, audio and graphs

Sorting and Filter – in sorting and filtering data by numeric and alphabetic way

Grouping - for Subtotals and ungroup things

Hyperlink – can link one file to another file or page with use of excel

Access-icon.png

MICROSOFT ACCESS

Access 2007 1.jpg

Microsoft Access – is a popular database which allows users to create custom databases that stores information in an organized structure. Users also can create tables, queries, forms and reports that connect them together with macros; it is a powerful database and data manipulation tool that is also widely used in many small businesses. These are some of the data source in which access report are created:

Benefits of using Microsoft Access:

Con-current User – initially designed to operate on a network, it is wiser to select when there will be 15 to 20 users.

Unique Identifier – its importance is to evaluate the information which is entered once and minimize people errors.

Custom Design – it can be created that will make it easier for you to enter the information

Reporting Structure - quickly creates a proper report which is useful data that can help business to run smoothly.

TIMETABEL

NZIM DIPLOMA IN BUSINESS MANAEGMENT (LEVEL 5) 2013

Monday

Tuesday

Wednesday

Thursday

Friday

9am - 3pm

8am - 1pm

9am - 3pm

Free Time can study our

own

Free Time can study our own

 

 

 

530

550

560

Organization & Management

Business Computing

Business Communication

Room: 12

Room: 10

Room: 9

ABOUT US:

Our Mission and Purposes:

To provide personalized interactive quality perfection programs in a caring with friendly environment in line with "Code of Practice" that provides student excellent.

To be perfect in learning quality and teaching facilities for students and staff

To employ the best teachers by supporting them professional and developed with specialized skills for all teaching programs delivered by Auckland GoldStar Institute

Auckland Goldstar Institute is an efficient quality management system is implemented to comply with legislation and standards. A student is well supported and guided in accordance with the code of practice and also ensures that development and learning of student is having highly qualified and smart teachers, where we believe that the most important person is who stand in front of the student and delivers the correct lesson. That how we access our teachers and pick the best experienced and knowledgeable. Our believe in primary focus is to act as mentors in order to assist students to achieve their study and career goals.

Level 5, 75 Karangahape Road, Auckland City, New ZealandContact Us

Level 5, 75 Karangahape Road, Auckland City, New Zealand

Phone:

+ 64 9 3796628

Fax:

+64 9 3091189

Email:

[email protected],[email protected]