Concerned public
Trainees who have completed Module 1 or who already have basic Excel ® functionality
Goals
Complete the basic knowledge of the Excel spreadsheet.
- The customization of Excel ®.
- Advanced formatting.
- Formulas elaborated.
- Liaison and consolidation.
- Databases.
- PivotTables.
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 :
The customization of Excel ®
- Change default settings
- The status bar and the toolbar
- Define styles and themes
Advanced formatting
- Custom sizes
- Insert, move, and rename sheets
- Protect cells / sheets / binders
- Automatic formatting
- Conditional formatting
- Repeat titles for printing
- Use page breaks
Elaborate formulas
- Absolute, relative, and mixed addresses
- Use names
- The NB function
- The functions DATE, YEAR, LEFT, STXT, …
- The SUM.SI function
- Concatenation, rounded, whole
Liaison and consolidation
- Link cells together
- Link cells between different workbooks
- Consolidate data in a workbook
- Consolidate data from multiple workbooks
Databases
- Linear, geometric, chronological series
- The lists
- Multi-criteria sorting
- Automatic filters
- Advanced filters
- Duplicates
PivotTables
- Initiation to pivot tables
- Graphical representation and analysis
- Grouping of information
- Modify table consolidation
- Percentages and ratios
Duration: to define together, according to your needs.
Price:Contact us
Recent Comments