Office Skills Accelerator: Excel Pro

Opintojakson kuvaus

Excel is a tool that one cannot do without. Would you like to get the most out of it? Explore the course below, enroll, and stand out with your expertise.

In the Office Skills Accelerator: Excel Pro online course, you will learn the use of Excel in-depth. You will complete the course independently online using self-study materials and doing exercises. At the same time, you’ll receive personal support and feedback from the course instructors.

The course fits well to be taken alongside work or other studies: the segmented structure allows you to progress at your own pace.

Who it’s for:

• Everyone who uses Excel daily
• Those who truly want to be skilled and efficient in their work
• Everyone standing at the threshold of new challenges and wanting to ensure their competence

Our Promise

Our training has received excellent feedback from previous participants. Our promise for the Office Skills Accelerator training:

• Practical skills for everyday life – not just theory, but proven skills
• Confidence that shows in every click – with expertise, uncertainty becomes history
• At your own pace: Your life doesn’t have to stop – our flexible course modules fit even a busy schedule
• Diversity in focus: Practical examples, clear videos, and text sections – learning is lively, tangible, and engaging
• Deeper and further: No skimming the surface – you’ll dive deep into the software
• Support: Quick help – Knowledgeable and encouraging feedback

Support

During the training, you have access to a high-quality online learning environment. However, if you encounter problems, our course staff is here to support you:

• Online calls: You can schedule a Teams call for personalized instruction and support
• Email support: You can send us questions via email
• Discussion board: Seek advice from our forum

Content

The content is designed by Päivi Pylväläinen, one of Finland’s leading Office trainers, with over 35 years of experience teaching Office software. She has handpicked the software’s essential and job-relevant features for this course. Learning is supported by clear and comprehensive guidelines, images, and videos created by pedagogical professionals.

Prerequisites: User interfaces and basic functions

Spreadsheet basics: Input and data types; selecting and editing areas; table formatting; calculations and basic functions; relative and direct references; charts; printing in Excel

Advanced Excel use: Editing multiple sheets simultaneously and calculations across sheets; conditional formatting; mixed references; IF function; search functions; nested functions; formula review tools

Data analysis with Excel: Editing large datasets and autofill; table function and calculations in the table; summaries, sorting, filtering, and slicers in the table; pivot table and its formatting; subtotals, summaries, sorting, slicers, timelines, and grouping in a pivot table; multiple value fields in a pivot table; pivot chart.

Arviointikriteerit

Pass / Failed

Opintojakson työskentelytavat ja aikataulutus

Online course

The course is offered six times during year 2024:

• 16.1. – 29.2.2024
• 19.3. – 24.4.2024
• 21.5. – 27.6.2024
• 9.7. – 22.8.2024 (registration closes 13.6.)
• 3.9. – 10.10.2024
• 5.11. – 12.12.2024

When registering, please select the date you would like to take the course.

Ilmoittautumistiedot

Use the Email Address of your University of Applied Sciences in your Registration Information.