MS Excel Functions for Industrial Management
Translated by
ScribdTranslationsMS Excel Functions for Industrial Management
Translated by
ScribdTranslationsNATIONAL SERVICE OF TRAINING IN INDUSTRIAL WORK
SERVICE
NATIONAL TRAINING IN INDUSTRIAL WORK
FIRST AND LAST NAME
CAREER: Industrial Management
2nd
INSTRUCTOR
Applied Computing
TOPIC: Functions of Ms Excel.
AÑO: 2021
FINAL COURSE PROJECT
TOPIC: Design a spreadsheet using the functions of MS Excel.
Objective of the Work:
With technological information and additional resources, students will be able to interpret
and apply spreadsheet functions to solve mathematical and financial problems using the
MS EXCEL tool; as well as manage your human resources, logistics and more, using the
SAP tool. No error.
Work Proposal:
The manager of a company observes difficulties in organizing data or information like a spreadsheet.
apply formulas to get results quickly, create graphs, generate more than one sheet in the same
file, among others. The tools that the Internet and technology provide us exceed what any
we imagined in global advances. Among the most well-known tools is Excel, recognized for
the strategies and solutions it provides. Excel is a tool to be able to do any type of
mathematical calculation on a sheet: spreadsheet. Mathematical operations can be performed and created
number tables to perform operations in an efficient and quick manner. It is required to design a sheet of
calculation applying the functions of Ms Excel clearly, orderly and through the presentation of
file.
STUDENT WORK PLAN
FINAL COURSEWORK
1. GENERAL INFORMATION
Last Name and First Name:
II
Zonal/CFP:
Degree: Applied Computer Science
Course/ Training Module: Planning/ Questionnaires.
Topic of the Work: Functions of Ms Excel
2. WORK PLANNING
ACTIVITIES/
No. SCHEDULE/ DELIVERY DATE
DELIVERABLES
01 Review of the Study Material 20/04 ------ ------- ------ ------ ----- -----
02 Design of Word sheets ------ 20/04 ----- ------ ------ ---- -----
03 First progress ------ ------ 20/04 ------ ------ ---- -----
04 Search for information ----- ------ ------ 25/04 ------ ----- -----
Answers to the questions of
05 ----- ----- ----- ----- April 27 ----- -----
Guide
06 Review of spelling errors ---- ---- ---- ---- ---- 29/04 .----
07 Delivery of Work 02 ----- ---- ----- ----- ---- 30/04 02/05
GUIDING QUESTIONS
3. During the study research, you must obtain the answers.
to the following questions:
NPREGUNTAS
º
Why are the functions of Ms Excel important in a guide sheet?
1 calculation?
2 What are the mathematical functions of Excel and how are they used?
3 How to use the statistical functions of Excel?
Average
4 [Link]. Mode. One, median?
What importance does Excel have in the workplace?
5
1. Why are the functions of Ms Excel important in a
Spreadsheet guide?
Mainly because it is a very versatile tool that helps in calculation tasks, processing of
data and allows you to connect with large enterprise applications, such as the well-known SAP. With Excel
you can perform multiple types of mathematical operations in the same spreadsheet.
Excel allows improving productivity by facilitating data processing with functions such as
sorting, filters, search, etc. It is widely used in data reporting to facilitate
Useful information for decision-making.[ CITATION FER17 3082 ]
2. What are the mathematical functions and how are they used?
Excel?
SUMsum of several elements.
SUMIFsum of several elements with a condition.
SUMIFSsum of various elements with various conditions.
MMULTmultiply two matrices. Matrix type.
TO COUNTcount the elements that are in a range.
COUNTIFScount the elements of a list depending on various conditions.
SHEET OF RESSETTING TO THE QUESTIONS
GUIDE
3. How to use the statistical functions of Excel?
Both Excel and spreadsheets in general offer a whole world of possibilities for processing
data, information, and numbers. And functions help us process that data and obtain answers to
questions of all kinds.
However, it is not always [Link] the functions of Excel, although the most recent versions
they are more intuitive. Nonetheless, it is advisable to know them well in order to put them into practice.
3082
4. Define the functions Average, max, min? Count, count. Yes,
Count. [Link]. Mode. One, median?
Average: it is used to obtain the average or arithmetic mean of a set of values. Like
arguments can have individual cells and/or ranges of cells with numeric values. Function
which will return the arithmetic mean of the numbers or the range enclosed in parentheses.
Max: Returns the maximum value of a set of values, the MAX function can be found within
Statistical functions. You can specify arguments that are numbers, empty cells, logical values.
or representations of numbers in text form. Arguments that are error or text values that
they cannot be translated into numbers cause errors.
Min: Returns the minimum value from a set of values, the MIN function can be found within the
Statistical functions. You can specify arguments that are numbers, empty cells, logical values or
textual representations of numbers. The arguments that are error values or text that cannot be
translating to numbers causes errors.
Count: Count the number of cells that contain numbers and the numbers in the argument list. Use
COUNT to get the number of entries in a numeric field of a range or an array
numbers.
COUNTIF: Counts the cells within the range that are not blank and meet the criterion.
specified.
It will count: counts the number of cells that are not empty and the values that are in the argument list.
Use COUNTIF to count the number of cells that contain data in a range or array.
Mode: Returns the value that occurs most frequently in an array or range of data. Just like
MEDIAN, MODE is a measure of position.
Median: Returns the median of the numbers. The median is the number that is in the middle of
a set of numbers, that is, half of the numbers is greater than the median and the other half is
younger.[ CITATION ABI12 l 3082 ]
5. What importance does Excel have in the workplace?
With this tool, you will be able to, among other things, create invoices and manage the company's accounting.
an easy and quick way. That's why employees from different departments of companies that
those involved in these activities must know how to handle Excel fluently. In addition,
You can also obtain graphs from the data entered in the spreadsheets, which will be useful to you.
very useful for conducting data analysis and interpreting it.[ CITATION IMP201 3082 ]
PLANNING SHEET
EXECUTION PROCESS
SECURITY / ENVIRONMENT /
STANDARDS - STANDARDS
OPERATIONS
1. Download the format and file of the work
[Link] delivery:
2.1 Provide general information: STUDY IN A FREE ENVIRONMENT
Fill in names and surnames. ACCORDING TO THE FORMAT
Zonal direction. ACCORDING TO THE FORMAT
Race. ACCORDING TO THE FORMAT
Course/[Link]. ACCORDING TO THE FORMAT
Work topic. ACCORDING TO THE FORMAT
ID. ACCORDING TO THE FORMAT
Semester. ACCORDING TO THE FORMAT
WITH THE RIGHT LIGHTING TO AVOID
2.2 Carry out the work planning. COMPLICATIONS IN VISION
3. Second delivery:
3.1 Write and analyze guiding questions. PAPER SAVINGS
3.2 Search for information about the topic: PAPER SAVING
Google TO HAVE INTERNET
Manual. FILE
3.3 Taking notes in my notebook. Proper posture
3.4 Collect data.
3.5 Answer the guiding questions. ACCORDING TO THE FORMAT
3.6 Add a related image to each question.
3.7 Execute the execution process. ACCORDING TO THE FORMAT
4. Third delivery:
4.1 Create the diagram, drawing or scheme: ACCORDING TO THE FORMAT
Find a drawing related to the topic.
Process Operation Diagram (POD)
4.2 Make the resource list. ACCORDING TO THE FORMAT
4.3 Read the objective of the final project.
4.4 Read the work proposal.
4.5 Develop the work that it asks us to:
State the necessary elements to develop a culture
of continuous improvement in the organization mentioning concepts
solids through an exhibition.
4.6 Verify and correct errors.
4.7 Save the work on my PC. ENERGY SAVING
4.8 Upload the final work on the platform.
Design a spreadsheet applying the functions of Ms Excel
1:1
DIBULJOIST/AESDQEUREEMCAU/RDSIAOGSRAMA
INSTRUCTIONS: complete the list of resources needed for the execution of the work.
1. MACHINES AND EQUIPMENT
Acer laptop
Windows 10
keyboard
mouse
3. TOOLS AND INSTRUMENTS
Notebook
Notes
pen
5. MATERIALS AND SUPPLIES
YOUTUBE
INTERNET
GOOGLE