Getting started with programming: Professional Training
- Length: 52 pages
- Edition: 1
- Language: English
- Publisher: Remylent
- Publication Date: 2021-07-09
- ISBN-10: B09928FLHQ
- ISBN-13: 9782490275557
- Sales Rank: #0 (See Top 100 Books)
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.
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
Donate to keep this site alive
1. Disable the AdBlock plugin. Otherwise, you may not get any links.
2. Solve the CAPTCHA.
3. Click download link.
4. Lead to download server to download.