Excel, spreadsheets and databases: Intermediate Excel

Tous publics

• Consolidate skills in Excel software (Microsoft Office suite).
• Use and link multiple sheets from the same workbook or link cells from different sheets and different workbooks.
• Create summary tables (summaries).
• Exploit and organize lists of information, synthesize them, obtain statistics.
• Learn to communicate and value data and figures.

1. Evolve to more complex tables:
Displaying multiple rows in a cell / Absolute reference in a formula / Copying values, copying with link or transposition / Namely: Entering calculation functions / System date and date format / Simple condition / Custom format / Formatting conditional / Managing conditional formatting / Name of a range of cells / Validation criterion / Range of cells in a function

2. Present numbers on a graph:
Namely: Charts / Creating and moving a chart / Managing a chart / Selecting chart elements / Adding and removing elements / Formatting chart elements / Modifying chart text elements / Legend and Plot Area / Printing and Layout of a Chart

3. Improve Graphics Presentation:
Modifying data labels / Data series and axes of a chart / Managing series / Chart type options / Managing chart templates / Creating a 2D Map type chart / Creating sparkline charts / Managing sparkline charts

4. Decorate your paintings:
Creating graphic objects / Selecting and deleting objects / Copying and moving objects / Sizing a graphic object / Modifying a text box / Modifying a drawing / Formatting drawing objects / Inserting of an image / Managing images / Rotating and aligning objects / Layering and grouping objects

5. Leverage Data List Tables:
Namely: Instant filling / Calculating subtotals / Creating and managing a data table / Presentation and sorting of data in a data table / Adding a calculation to a data table / Automatic filter / Custom filters / Empty values and duplicates / Namely: The criteria area / Using a criteria area / Filtering and copying rows by criteria area / Statistics with criteria area

6. Create and use PivotTables and PivotCharts:
Creating a pivot table / Modifying and adding calculations in a pivot table / Modifying the source of a pivot table / Selecting, copying, moving and deleting in a pivot table / Structure and printing a table PivotTable / Formatting a PivotTable / Filtering a PivotTable / Filtering using Slicers / Creating a PivotTable based on multiple tables / Adding fields or calculated items / Grouping Data / Creating a PivotChart

Méthode active à travers l’articulation de techniques pédagogiques multiples et de situations d’apprentissage.
Support de cours papier ou numérique remis à chaque participant.
Séances de réflexion sur des projets personnels avec échanges collaboratifs.

Test de positionnement en début de formation

Certification internationale ENI

Livres numériques