ISEP

 José Marinho

Em@il 

 

Algorithmics & PROGramming
Mechanical Engineering  edition 2017-18


Important Information


Lessons
   class:
      1DM_E

 

Theoretical:

T0-Assessment&Program

T1-Introduction2EXCEL  

T2.1-Automations  

T2.2-Charts

T3-Functions

T4-Matrix Formulas & Data Validation & Pivot Tables

T5-Lookup & Reference Functions

T6.1-Macros

T6.2-Excel’s Objects

T6.3-Variables & DataTypes

T6.4-Operators & IO

T7.1-Algorithms

T7.2-Conditional Structures

T8-Conditional Loop Structures

T9-FOR Loop Structures

T10-Functions&Subroutines

T11-Indexed Structures

 

 

Practical:

PL1- Excel - Basic Concepts and Formatting

PL1- work file

PL2- Excel - Formatting, Sorting, Filtering and Charts

PL2- work file

PL3- Excel – Functions & Formulas

PL3- work file

PL4- Excel - Data Validation & Pivot Tables & Matrix Formulas

PL4- work file

PL5- Excel – Lookup & Reference Functions

PL5- work file

PL6- VBA – Macros/Procedures/Programs

PL6- work file

PL7- VBA - Conditional Structures

PL7- work file

PL8- VBA – Conditional Loop Structures

PL8- work file

PL9- VBA – FOR Loop Structures

PL9- work file

PL10- VBA – Functions & Subroutines & Arguments

PL10- work file

PL11- VBA - Indexed structures

PL11- work file


Useful
Links

 

Code Studio


(portuguese)


 

«--

December 2017