Getting started with programming
Professional Training
Published on 9. July 2021
115 pages
978-2-490275-55-7 (ISBN)
Description
This book is intended for anyone who wants to study the principles of writing code. The important thing is to think well before programming. After a brief history of the development of calculators and computers, you will learn how to design algorithms using everyday examples, such as a recipe of a cheese soufflé, a bubble sort, and a sequential and dichotomous method to sort out numbers in a list. You will discover how to program with Excel VBA and JavaScript adapted to Google Sheets. The objective of this manual is to help you understand how to automate repetitive tasks, while discovering the world of variables, loops, conditions, functions and procedures. Finally, because Internet pages are part of our daily lives, HTML and CSS will also be introduced.
ABOUT THE AUTHOR
Rémy Lentzner has been a computer trainer since 1985. Specialized in the mastery of office automation tools, he assists companies in the professional training of their employees. Self-taught, he has some fifteen computer books to his credit.
ABOUT THE AUTHOR
Rémy Lentzner has been a computer trainer since 1985. Specialized in the mastery of office automation tools, he assists companies in the professional training of their employees. Self-taught, he has some fifteen computer books to his credit.
More details
Content
- Intro
- Chapter 1A 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 2Analysis 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 3Getting 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 4HTML
- 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
