Si vous souhaitez un programme de formation sur-mesure sur cette thématique, merci de nous interroger.
Programme :
- Session – 1-- EXCEL-
- Objectives: Refresh and Intermediate functions
- Based on an exercise, Excel foundations (format, calculation, style, tips, etc…)
- Select, copy, automatic filling.
- Relative reference ($)
- Charts, geographical data, sparklines
- Break
- Foundations of dates and Time in Excel
- IF, complexes conditions
- Specific topics / Questions – Exercise for the following course
- Session – 2 - EXCEL:
- Objectives: Lookup and investment calculation
- Review of the exercise
- Lookup function
- Pivot table
- Conditional Formatting
- Break
- Data validation, Excel sheet protection.
- Investment calculations (FV, PV, PMT)
- Specific topics / Questions
- Session 3 - WORD –
- Objectives: Improve document layout to make documents as professional as possible.
- Based on an exercise, Tab stop, leader, Styles, Numbering
- Image integration, column
- Cover Page
- Voice Dictation
- Break
- References objects: footer, header, automatic insertion,
- bookmark, footnotes, endnote, citation, table of content, index, etc…
- Incorporate / Link Excel objects within Word document
- Specific topics / Questions