Concerned public
General public or professionals wishing to master the basic functionalities of Excel. A first approach of the computer tool is advised (keyboard, mouse, Windows, …).
Goals
Master the main features of the Excel spreadsheet.
- Presentation of the software.
- The binders.
- Basic notions on the tables.
- The impression.
- The formulas.
- Graphics.
Practical arrangements :
- Individual courses: in company, at home or in our premises
- Group lessons: in company or in our premises
Home classes can give you a tax reduction of 50% (according to the current finance law)
Training program :
Presentation of Excel ®
- Open, save, and close a workbook
- The status bar and the toolbar
- The binders
- Leaves
- Simultaneous change of leaves
Tables, basic concepts
- Enter and edit data
- Insert / delete rows / columns
- Cell formats
- Merge cells
- Fill function
- Shutters
- Hide rows / columns
The impression
- The print preview
- Pagination
- Layout
- Print a part of a sheet
The formulas
- The logical formulas (AVERAGE, MIN, MAX …)
- Conditions
- The dates
- Percentages and rates
- Absolute and relative references
- Copy formulas
- Linking data between tables
- Copy with binding
- Synthesize several tables in one
- Sort data
- Filter data
Graphics
- Create a chart
- The different types of graphics
- Source data
- Format a chart
Duration: to define together, according to your needs.
Price:Contact us
Recent Comments