EDITIONS REMYLENT     REMYLENT@GMAIL.COM

Getting started with PROGRAMMING

Chapter 1 : A bit of hindsight

1.1 A slow evolution

1.2 What's in a computer?

1.2.1 The I/O architecture

1.2.2 Computer units

1.2.3 The languages

1.2.4 HTML

Chapter 2 : Analysis and algorithms

2.1 Thinking and analyzing before acting

2.1.1 The recipe analysis of a cheese soufflé

2.1.2 Sorting out numbers

2.1.3 The bubble sort moves numbers

2.2 Programming a sort

2.2.1 Bubble sort with Excel VBA language

2.2.2 Bubble sort with JavaScript for Google Sheets

2.3 Two algorithms for searching data

2.3.1 The sequential research

2.3.2 Programming with Excel VBA

2.3.3 Programming with Google Sheets JavaScript

2.3.4 The dichotomous research

2.3.5 Dichotomy with Excel VBA

2.3.6 Dichotomy with JavaScript

Chapter 3 : Getting started with VBA

3.1 The VBA environment

3.1.1 Tools for handling macros

3.1.2 Recording a macro

3.1.3 The XLSM file type and the macro security

3.1.4 Using relative references

3.2 Writing macros

3.2.1 A macro that empties cells

3.2.2 Running a code from a command button

3.2.3 Learning VBA by recording macros

3.3 VBA is an oriented object language

3.3.1 The Object Browser

3.3.2 Properties and methods

3.3.3 Events in a sheet

3.3.4 The component libraries

3.3.5 From Excel to Outlook

3.4 Calculations and formulas

3.5 Layout and printing

3.5.1 The layout menus

3.5.2 The Page Setup

3.5.3 Programming printing

3.6 Variables and loops

3.6.1 The variable declaration

3.6.2 The loops

The For...Next loop

For next and Select Case

For next and If..ElseIf

The Do While...Loop

The For each loop

3.7 Searching with the FIND method

Chapter 4 : HTML

4.1 A markup language

4.2 HTML is a scripting language

4.3 CSS styles sheets

4.3.1 The cascade

4.3.2 Inheritance