![](https://www.univ-catholille.fr/wp-content/uploads/2024/06/FGES-MASTERS-scaled.jpg)
Excel for databases
Année du cours : Aucune valeur renseignée
Etablissement : Faculté de Gestion, Economie & Sciences Licences
Langue : Français
Formation(s) dans laquelle/lesquelles le cours apparait :
Période : S4
Installing the English version of Microsoft Excel 2013 to date, Windows environment. The Apple environment is not known to me for Excel.
Use office tools on a daily basis
Be able to understand Excel’s environment using databases,
How to use keyboard shortcuts to increase efficiency
Quickly create excel tables and graphs
Use databases through dynamic Crossover functions and tools, sections, segments,
Vertical research and the art of allowing correspondence between two paintings and bases
Use drop-down menus and data tags to create select tables
At the end of the sessions the students will be able to be operational to work on Excel serenely on an English environment.
• QUICK BASICS REVIEW
Drop-down and custom menus
Recopy techniques
Automatic sums
Moves in the sheet
Cell selection
Keyboard shortcuts
Layout, header and footnote
Printing, printing area
Insert a page break
Properties of the spreadsheet
• BUILDING CALCULATION FORMULAS
Build a formula for calculation
Logical operators and conditional formulas
The function assistant
Optimized use of absolute and relative references
Use of names – data tags
Links between spreadsheets
Consolidation of spreadsheets
• REPRESENT A GRAPH
Objects
Different types of graphs
Changes in presentation
Printing the graph
Table of chart data
Fitness options
• WORKING ON A LIST OF DEALS
Use of databases
Simple and multiple tris
Search and replacement
Simple automatic filters
PARETO Suppliers or Customers
Create a dynamic crossover