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