Excel - Prise en main
This training is based on Excel 2013 (but any newer version could be used or also on Mac).
This training teaches you basic concepts of doing calculations & formula.
Duration
.
Audience
Any person with limited Microsoft Excel knowledge.
Prerequisite
None.
Objectives
- Use the basic Excel functions.
- Create a simple calcul sheet with figures, texts & formulas.
- Filtering & Sorting data.
- Create & arranging simple graphs
Information
This training can be provided on-site, in -class or remotely.
Detailled program
General information
Pre-requis
No particular knowledge is required.Detailled Program
Introduction
- Présentation
- Installation
- Démarrage
- Interface
- Excel sous Mac
Workbooks
- Create your first workbook
- Fill this first workbook with data
- Grammatical & linguistical validations
- Save the workbook
- Print the Workbook
Cells
- Select cells
- Input some data
- Formatting & presenting data correctly
- The handle & updating data automatically
Input data faster
- Create personnalized lists.
- Real data lists
- Avoiding errors
Formulas
- Really really a master of Calculations
- Adding conditions
- Transmitting data across sheets
- Where does my formula comes from & where does it goes ?