This 1+1 day course focuses on Microsoft Excel and fundamental IT-competencies for Project leaders working for Swedish Transportation Administration (TRV). It provides the participant with structures, methods and tools so that they, after the course, will:

Be able to use Microsoft Excel efficiently in their work at the Swedish Transport Administration
Understand the Excel-structure and terminology, navigate and enter data correctly, use formulas, automate tasks and visualize data in an appropriate manner.

Content

The structure and terminology of Excel
Formulasyntax and how to manipulate large datasets
The fundamentals for text-and dataformulas as well as conditional fomating
Effective navigation and how to use short-cuts

Independently manage and analyze data by using Excel
Develop solutions to manage a large quantity of data and automate repetitive tasks
Entering data correctly and automating tasks
Applying the best praxis-formating and visualization of data

TRV Upskill Module 3 Excel

Brights

The world is changing faster than ever and the need to learn has never been bigger. Rapidly shifting skills-needs create a tremendous challenge for companies, individuals and society. At Brights, we rethink the ways we look at learning. We build solutions which start with motivation, put skills first, leads to return on learning and are better embedded into work life. To succeed we need to adapt, to adapt we need to change and to change we need to learn.