OBJECTIVES
Master the functionalities of cell links, tables and workbooks in Excel
Be able to consolidate data in a summary table
PUBLIC
Anyone with links to establish between different Excel tables
REQUIREMENTS
Knowledge of the basic features of Excel
PROGRAM
Excel bindings
Relationship between cells
Relationship between worksheets
Relationship between workbooks
Table / chart relationship
Update of the links: at the opening of the binder, manual
consolidations
Consolidation of data from: multiple tables, multiple sheets
Word and Excel links
The different methods for integrating an Excel table into Word.
Hypertext links
Defining links to: the web, a file, a bookmark, a workbook location
EDUCATIONAL TOOLS
Presentations
Exercises
Practical cases
Good to know
DURATION
0.5 days
Organizer
Reval
You could like it :
find out about all the networking events and trainings tailored for you!
find out about all the networking events and trainings tailored for you!
