Algorithm Programming with Excel

Cross-cutting
Digital Skills

Digital Skills

Duration

2:00 p.m.

PRESENTATION

In the field of information management, it is necessary to understand the various areas of public administration and Algorithm Programming with Excel, within the professional field of systems and telematics. Thus, this course aims to provide the necessary knowledge to Programming Algorithms with Excel.

Objectives

  • Learn about the spreadsheet structure and the characteristics of the Excel program.

  • Learn how to use Excel so you can work with lists, carry out transactions mathematics, statistics, finance, etc.

  • Knowing how to use the tools required to be able to carry out calculations, functions, and formulas.

Syllabus

TEACHING UNIT 1. MENUS TEACHING UNIT 2. PREDEFINED FUNCTIONS: Power, Truncate, Round, Integer, ABS, ROOT, EXP, LN, LOG, LOG10, SUM, AVERAGE, MAX, MIN, COUNT LEARNING UNIT 3. DATA CHARTS LEARNING UNIT 4. OPERATIONS USING REFERENCES TO DIFFERENT SHEETS OR WORKBOOKS LEARNING UNIT 5. PIVOT TABLES
Request for Information

Related MOOCs

Course
The Course on Workplace Risk Prevention, Ergonomics, and Mental Health addresses the growing need to ensure environments...
Course
In the age of remote work, hyperconnectivity has put companies under the scrutiny of the Labor Inspectorate....
Course
In a world of global digitization, hyperconnectivity has gone from being an advantage to becoming a challenge...

Are the Educa PHAROS courses eligible for credit?

Many courses can be credited toward the master's programs at Structuralia.

Facts about our area

+ 1.483

Hours

+88.999

Minutes

264

Courses

Educa PHAROS is a next-generation training model that places a company’s human capital at the forefront. Through a platform that adapts to each company’s corporate identity and offers a total of more than 900 courses, it provides tailored training for each organization. The unlimited flat-rate plan provides each company with the number of courses that best suits its needs, as well as the ability to determine which employees will have access.
Scroll to Top