In the field of information management, it is necessary to understand the various areas of public administration and Algorithm programming using Excel, within the professional field of systems and telematics. This course therefore aims to provide the necessary knowledge to Programming algorithms using Excel.
Cross-cutting
Digital Skills
2 pm
Algorithm Programming with Excel
Digital Skills
2 pm
Introduction
Objectives
-
To know the spreadsheet structure and the characteristics of the Excel programme.
-
Learn how to use Excel so that you can work with lists, carry out transactions mathematics, statistics, finance, etc.
-
Knowing how to use the tools required in order to carry out calculations, functions and formulas.
Table of Contents
TEACHING UNIT 1. MENUS
TEACHING UNIT 2. PREDEFINED FUNCTIONS: Power, Truncate, Round, Integer, ABS, ROOT, EXP, LN, LOG, LOG10, SUM, AVERAGE, MAX, MIN, COUNT
TEACHING UNIT 3. DATA GRAPHS
TEACHING UNIT 4. OPERATIONS REFERRING TO DIFFERENT SHEETS OR BOOKS
TEACHING UNIT 5. PIVOT TABLES
More related courses
Cross-cutting
Cross-cutting
Cross-cutting
Your questions answered
Why choose Educa.Pro?
Educa.Pro enables organisations to centralise training management, personalise learning and gain clear insights into the impact of training programmes. Thanks to its AI-powered technology, organisations can optimise their learning strategies, enhance talent development and make data-driven decisions.
Can the courses be taken at your own pace?
Yes. Most of the courses on Educa.Pro are self-paced and on-demand, allowing users to progress at their own pace without missing out on progress tracking or assessments, which makes it easier to fit them around work or study commitments.
What levels of security and compliance does the platform offer?
Educa.Pro complies with security standards designed to protect user and organisational data. Furthermore, it supports the traceability of certifications, digital signatures and the management of assessments, thereby ensuring regulatory and legal compliance in both educational and corporate environments.
What support and guidance does Educa.Pro offer?
The Educa.Pro team offers comprehensive support throughout implementation, roll-out and adoption, ensuring that organisations get the most out of the platform and achieve measurable results from day one.