Translated by Google
spreadsheet courses: Excel and / or Libre Office calculations
From 69.98 C$ /h
Learn to use Excel or LibreOffice calculations, in a simple way by resorting to logic rather than memorization. A la carte or an evolving program
- sheet management
- formatting
- automatic lists
- different number formats
- arithmetic formulas
- essential functions (min, max, sum, average, nb, if, sum.si, recherchev, date formulas, concatenate etc ...)
- different collages: values, formula, format, incl. transposition
- sort and filter
- different types of graphics
- layout and printing
- etc ...
- sheet management
- formatting
- automatic lists
- different number formats
- arithmetic formulas
- essential functions (min, max, sum, average, nb, if, sum.si, recherchev, date formulas, concatenate etc ...)
- different collages: values, formula, format, incl. transposition
- sort and filter
- different types of graphics
- layout and printing
- etc ...
Extra information
by webcam or at home
Location
At teacher's location :
- Rue Capouillet, 1060 Saint-Gilles, Belgique
Online from Belgium
About Me
I have a good experience of everything related to IT, I work as a freelance graphic designer, am in charge of IT and network administration and maintenance in an asbl and have been training for 20 years (office automation and multimedia , Desktop publishing, video editing, photo processing, etc.)
Education
Master in pedagogy at the Free University of Brussels + certificate of PC technician + networks for SMEs + training in computer graphics + various training in programming
Experience / Qualifications
networks, troubleshooting, maintenance, desktop publishing, office automation, Access databases, video editing, photo processing .... I work as a computer scientist in the voluntary sector, as a freelance graphic designer and as a computer teacher in secondary education
Age
Teenagers (13-17 years old)
Adults (18-64 years old)
Seniors (65+ years old)
Student level
Beginner
Intermediate
Advanced
Duration
60 minutes
120 minutes
The class is taught in
French
English
Dutch
Skills
Reviews
Availability of a typical week
(GMT -05:00)
New York
Mon
Tue
Wed
Thu
Fri
Sat
Sun
00-04
04-08
08-12
12-16
16-20
20-24
Learn how to use and create a database with Access in a simple way using logic rather than memorization.
- creation of tables
- the different types of controls with their properties and their input masks
- choice lists
- the 1st and 2nd keys
- creation of relationships between tables
- referential integrity
- filtering and sorting
- creation of queries (selection, table addition, update, deletion, table addition, cross analysis)
- calculated fields
- different displays (creation mode, data mode to be encoded, personalized displays, adding to groups ...)
- creation of forms
- creation of reports
- external data (import and export)
- compaction
- linked source tables
- etc ...
- creation of tables
- the different types of controls with their properties and their input masks
- choice lists
- the 1st and 2nd keys
- creation of relationships between tables
- referential integrity
- filtering and sorting
- creation of queries (selection, table addition, update, deletion, table addition, cross analysis)
- calculated fields
- different displays (creation mode, data mode to be encoded, personalized displays, adding to groups ...)
- creation of forms
- creation of reports
- external data (import and export)
- compaction
- linked source tables
- etc ...
The Wordpress dashboard,
the essential and most important plugins,
the themes: choice and installation,
work with Elementor,
in personalized headers and footers,
action buttons and links,
use sections,
pages and articles,
personalize the typography and colors, personalize the design,
add multimedia files (images, videos, sounds),
work the menus,
contact and search forms,
manage newsletters,
add several languages (multilingual site),
use keywords and categories for a start on SEO,
natural referencing (the essentials)
choose your host,
putting the local site online etc.
No programming
the essential and most important plugins,
the themes: choice and installation,
work with Elementor,
in personalized headers and footers,
action buttons and links,
use sections,
pages and articles,
personalize the typography and colors, personalize the design,
add multimedia files (images, videos, sounds),
work the menus,
contact and search forms,
manage newsletters,
add several languages (multilingual site),
use keywords and categories for a start on SEO,
natural referencing (the essentials)
choose your host,
putting the local site online etc.
No programming
Show more
Good-fit Instructor Guarantee








