Skip to main content

Microsoft Excel ExpertLaajuus (8 cr)

Code: TT00EW02

Credits

8 op

Teaching language

  • English

Objective

This is a comprehensive course that covers both the basic and advanced features and functions of Excel. Students will learn, practice, apply, and test their skills in real-world business scenarios, preparing them for certifications and professional careers.

Content

1. Course Overview
2. Common Office Features
3. Excel Basics
4. Formulas and Functions
5. Simple Data Analysis
6. MO-200 (Excel Associate) Practice Exams
7. Advanced Workbook Options and Settings
8. Advanced Data Formatting
9. Advanced Formulas and Macros
10. Advanced Charts and Tables
11. MO-201 (Excel Expert) Practice Exams

Assessment criteria, approved/failed

Pass/Fail.

You have two choices for completion. You can do couple of exercises from each module of you can do the test. Test can be found form the study environment.

Further information

Course is for Open UAS Students.

Timing

16.04.2024 - 31.12.2025

Number of ECTS credits allocated

8 op

Virtual portion

8 op

Mode of delivery

Distance learning

Unit

School of ICT

Campus

Karaportti 2

Teaching languages
  • English
Seats

0 - 5000

Degree programmes
  • Information and Communication Technology
Teachers
  • Virve Prami
Teacher in charge

Janne Salonen

Groups
  • ATX25TV_MAKSULLINEN_JÄRJESTELMÄ
    Open UAS 2025
  • ATX24TV_MAKSULLINEN_JÄRJESTELMÄ
    ATX24TV Open UAS

Objective

This is a comprehensive course that covers both the basic and advanced features and functions of Excel. Students will learn, practice, apply, and test their skills in real-world business scenarios, preparing them for certifications and professional careers.

Content

1. Course Overview
2. Common Office Features
3. Excel Basics
4. Formulas and Functions
5. Simple Data Analysis
6. MO-200 (Excel Associate) Practice Exams
7. Advanced Workbook Options and Settings
8. Advanced Data Formatting
9. Advanced Formulas and Macros
10. Advanced Charts and Tables
11. MO-201 (Excel Expert) Practice Exams

Location and time

100% online (Self-Study) course which can be done in own pace. Course environment is LabSim -portal.

Materials

Online.

Teaching methods

This course will have the same learning features and methodology found in TestOut Office Pro such as instructional videos, text lessons, demo videos, progressive labs, custom assessments, and practice tests. This all-in-one course is delivered on TestOut’s user-friendly and time-saving online learning platform, LabSim®. It’s easy-to-use and flexible for face-to-face, hybrid, and online learning environments. No additional textbooks, resources, or downloads are required.

Employer connections

N/A

Exam schedules

Online.

International connections

N/A

Completion alternatives

N/A

Student workload

Depends on the student's baseline.

Content scheduling

Up to student her-/himself.

Further information

Course is for Open UAS Students.

Evaluation scale

Hyväksytty/Hylätty

Assessment criteria, approved/failed

Pass/Fail.

You have two choices for completion. You can do couple of exercises from each module of you can do the test. Test can be found form the study environment.

Assessment methods and criteria

You have two choices for completion. You can do couple of exercises from each module of you can do the test. Test can be found form the study environment.

Further information

Course is for Open UAS Students.

Timing

01.01.2024 - 31.07.2025

Number of ECTS credits allocated

8 op

Virtual portion

8 op

Mode of delivery

Distance learning

Unit

School of ICT

Campus

Karaportti 2

Teaching languages
  • English
Seats

0 - 5000

Degree programmes
  • Information and Communication Technology
Teachers
  • Virve Prami
Teacher in charge

Janne Salonen

Groups
  • ATX24TV_MAKSULLINEN_JÄRJESTELMÄ
    ATX24TV Open UAS

Objective

This is a comprehensive course that covers both the basic and advanced features and functions of Excel. Students will learn, practice, apply, and test their skills in real-world business scenarios, preparing them for certifications and professional careers.

Content

1. Course Overview
2. Common Office Features
3. Excel Basics
4. Formulas and Functions
5. Simple Data Analysis
6. MO-200 (Excel Associate) Practice Exams
7. Advanced Workbook Options and Settings
8. Advanced Data Formatting
9. Advanced Formulas and Macros
10. Advanced Charts and Tables
11. MO-201 (Excel Expert) Practice Exams

Location and time

100% online (Self-Study) course which can be done in own pace. Course environment is LabSim -portal.

Materials

Online.

Teaching methods

This course will have the same learning features and methodology found in TestOut Office Pro such as instructional videos, text lessons, demo videos, progressive labs, custom assessments, and practice tests. This all-in-one course is delivered on TestOut’s user-friendly and time-saving online learning platform, LabSim®. It’s easy-to-use and flexible for face-to-face, hybrid, and online learning environments. No additional textbooks, resources, or downloads are required.

Employer connections

N/A

Exam schedules

Online.

International connections

N/A

Completion alternatives

N/A

Student workload

Depends on the student's baseline.

Content scheduling

Up to student her-/himself.

Further information

Course is for Open UAS Students.

Evaluation scale

Hyväksytty/Hylätty

Assessment criteria, approved/failed

Pass/Fail.

You have two choices for completion. You can do couple of exercises from each module of you can do the test. Test can be found form the study environment.

Assessment methods and criteria

You have two choices for completion. You can do couple of exercises from each module of you can do the test. Test can be found form the study environment.

Further information

Course is for Open UAS Students.

Timing

01.01.2024 - 31.12.2025

Number of ECTS credits allocated

8 op

Virtual portion

8 op

Mode of delivery

Distance learning

Unit

School of ICT

Campus

Karaportti 2

Teaching languages
  • English
Seats

0 - 1000

Degree programmes
  • Information and Communication Technology
Teachers
  • Virve Prami
Teacher in charge

Janne Salonen

Groups
  • ATX24TV
    NonStop virtual studies year 2024

Objective

This is a comprehensive course that covers both the basic and advanced features and functions of Excel. Students will learn, practice, apply, and test their skills in real-world business scenarios, preparing them for certifications and professional careers.

Content

1. Course Overview
2. Common Office Features
3. Excel Basics
4. Formulas and Functions
5. Simple Data Analysis
6. MO-200 (Excel Associate) Practice Exams
7. Advanced Workbook Options and Settings
8. Advanced Data Formatting
9. Advanced Formulas and Macros
10. Advanced Charts and Tables
11. MO-201 (Excel Expert) Practice Exams

Location and time

100% online (Self-Study) course which can be done in own pace. Course environment is LabSim -portal.

Materials

Online.

Teaching methods

This course will have the same learning features and methodology found in TestOut Office Pro such as instructional videos, text lessons, demo videos, progressive labs, custom assessments, and practice tests. This all-in-one course is delivered on TestOut’s user-friendly and time-saving online learning platform, LabSim®. It’s easy-to-use and flexible for face-to-face, hybrid, and online learning environments. No additional textbooks, resources, or downloads are required.

Employer connections

N/A

Exam schedules

Online.

International connections

N/A

Completion alternatives

N/A

Student workload

Depends on the student's baseline.

Content scheduling

Up to student her-/himself.

Further information

Course is for Open UAS Students.

Evaluation scale

Hyväksytty/Hylätty

Assessment criteria, approved/failed

Pass/Fail.

You have two choices for completion. You can do couple of exercises from each module of you can do the test. Test can be found form the study environment.

Assessment methods and criteria

You have two choices for completion. You can do couple of exercises from each module of you can do the test. Test can be found form the study environment.

Further information

Course is for Open UAS Students.

Timing

06.01.2024 - 31.12.2023

Number of ECTS credits allocated

8 op

Virtual portion

8 op

Mode of delivery

Distance learning

Unit

School of ICT

Campus

Karaportti 2

Teaching languages
  • English
Seats

0 - 1000

Degree programmes
  • Information and Communication Technology
Teachers
  • Virve Prami
Teacher in charge

Janne Salonen

Groups
  • ATX22_SYKSY
    ATX22_Autumn

Objective

This is a comprehensive course that covers both the basic and advanced features and functions of Excel. Students will learn, practice, apply, and test their skills in real-world business scenarios, preparing them for certifications and professional careers.

Content

1. Course Overview
2. Common Office Features
3. Excel Basics
4. Formulas and Functions
5. Simple Data Analysis
6. MO-200 (Excel Associate) Practice Exams
7. Advanced Workbook Options and Settings
8. Advanced Data Formatting
9. Advanced Formulas and Macros
10. Advanced Charts and Tables
11. MO-201 (Excel Expert) Practice Exams

Location and time

100% online (Self-Study) course which can be done in own pace. Course environment is LabSim -portal.

Materials

Online.

Teaching methods

This course will have the same learning features and methodology found in TestOut Office Pro such as instructional videos, text lessons, demo videos, progressive labs, custom assessments, and practice tests. This all-in-one course is delivered on TestOut’s user-friendly and time-saving online learning platform, LabSim®. It’s easy-to-use and flexible for face-to-face, hybrid, and online learning environments. No additional textbooks, resources, or downloads are required.

Employer connections

N/A

Exam schedules

Online.

International connections

N/A

Completion alternatives

N/A

Student workload

Depends on the student's baseline.

Content scheduling

Up to student her-/himself.

Further information

Course is for Open UAS Students.

Evaluation scale

Hyväksytty/Hylätty

Assessment criteria, approved/failed

Pass/Fail.

You have two choices for completion. You can do couple of exercises from each module of you can do the test. Test can be found form the study environment.

Assessment methods and criteria

You have two choices for completion. You can do couple of exercises from each module of you can do the test. Test can be found form the study environment.

Further information

Course is for Open UAS Students.

Timing

01.08.2023 - 31.12.2023

Number of ECTS credits allocated

8 op

Virtual portion

8 op

Mode of delivery

Distance learning

Unit

School of ICT

Campus

Karaportti 2

Teaching languages
  • English
Seats

0 - 1000

Degree programmes
  • Information and Communication Technology
Teachers
  • Virve Prami
Teacher in charge

Janne Salonen

Groups
  • ATX23TV_SYKSY
    Open UAS TestOut and Moodle courses

Objective

This is a comprehensive course that covers both the basic and advanced features and functions of Excel. Students will learn, practice, apply, and test their skills in real-world business scenarios, preparing them for certifications and professional careers.

Content

1. Course Overview
2. Common Office Features
3. Excel Basics
4. Formulas and Functions
5. Simple Data Analysis
6. MO-200 (Excel Associate) Practice Exams
7. Advanced Workbook Options and Settings
8. Advanced Data Formatting
9. Advanced Formulas and Macros
10. Advanced Charts and Tables
11. MO-201 (Excel Expert) Practice Exams

Location and time

100% online (Self-Study) course which can be done in own pace. Course environment is LabSim -portal.

Materials

Online.

Teaching methods

This course will have the same learning features and methodology found in TestOut Office Pro such as instructional videos, text lessons, demo videos, progressive labs, custom assessments, and practice tests. This all-in-one course is delivered on TestOut’s user-friendly and time-saving online learning platform, LabSim®. It’s easy-to-use and flexible for face-to-face, hybrid, and online learning environments. No additional textbooks, resources, or downloads are required.

Employer connections

N/A

Exam schedules

Online.

International connections

N/A

Completion alternatives

N/A

Student workload

Depends on the student's baseline.

Content scheduling

Up to student her-/himself.

Further information

Course is for Open UAS Students.

Evaluation scale

Hyväksytty/Hylätty

Assessment criteria, approved/failed

Pass/Fail.

You have two choices for completion. You can do couple of exercises from each module of you can do the test. Test can be found form the study environment.

Assessment methods and criteria

You have two choices for completion. You can do couple of exercises from each module of you can do the test. Test can be found form the study environment.

Further information

Course is for Open UAS Students.

Timing

15.06.2023 - 10.07.2023

Number of ECTS credits allocated

8 op

Virtual portion

8 op

Mode of delivery

Distance learning

Unit

School of ICT

Campus

Karaportti 2

Teaching languages
  • English
Seats

0 - 1000

Degree programmes
  • Information and Communication Technology
Teachers
  • Virve Prami
Teacher in charge

Janne Salonen

Groups
  • ATX23TV_KESÄLOMA
    Kesälomatuuraajan toteutukset

Objective

This is a comprehensive course that covers both the basic and advanced features and functions of Excel. Students will learn, practice, apply, and test their skills in real-world business scenarios, preparing them for certifications and professional careers.

Content

1. Course Overview
2. Common Office Features
3. Excel Basics
4. Formulas and Functions
5. Simple Data Analysis
6. MO-200 (Excel Associate) Practice Exams
7. Advanced Workbook Options and Settings
8. Advanced Data Formatting
9. Advanced Formulas and Macros
10. Advanced Charts and Tables
11. MO-201 (Excel Expert) Practice Exams

Location and time

100% online (Self-Study) course which can be done in own pace. Course environment is LabSim -portal.

Materials

Online.

Teaching methods

This course will have the same learning features and methodology found in TestOut Office Pro such as instructional videos, text lessons, demo videos, progressive labs, custom assessments, and practice tests. This all-in-one course is delivered on TestOut’s user-friendly and time-saving online learning platform, LabSim®. It’s easy-to-use and flexible for face-to-face, hybrid, and online learning environments. No additional textbooks, resources, or downloads are required.

Employer connections

N/A

Exam schedules

Online.

International connections

N/A

Completion alternatives

N/A

Student workload

Depends on the student's baseline.

Content scheduling

Up to student her-/himself.

Further information

Course is for Open UAS Students.

Evaluation scale

Hyväksytty/Hylätty

Assessment criteria, approved/failed

Pass/Fail.

You have two choices for completion. You can do couple of exercises from each module of you can do the test. Test can be found form the study environment.

Assessment methods and criteria

You have two choices for completion. You can do couple of exercises from each module of you can do the test. Test can be found form the study environment.

Further information

Course is for Open UAS Students.

Timing

01.01.2023 - 31.12.2023

Number of ECTS credits allocated

8 op

Virtual portion

8 op

Mode of delivery

Distance learning

Unit

School of ICT

Campus

Karaportti 2

Teaching languages
  • English
Seats

0 - 1000

Degree programmes
  • Information and Communication Technology
Teachers
  • Virve Prami
Teacher in charge

Janne Salonen

Groups
  • ATX23TV
    NonStop virtual studies year 2023

Objective

This is a comprehensive course that covers both the basic and advanced features and functions of Excel. Students will learn, practice, apply, and test their skills in real-world business scenarios, preparing them for certifications and professional careers.

Content

1. Course Overview
2. Common Office Features
3. Excel Basics
4. Formulas and Functions
5. Simple Data Analysis
6. MO-200 (Excel Associate) Practice Exams
7. Advanced Workbook Options and Settings
8. Advanced Data Formatting
9. Advanced Formulas and Macros
10. Advanced Charts and Tables
11. MO-201 (Excel Expert) Practice Exams

Location and time

100% online (Self-Study) course which can be done in own pace. Course environment is LabSim -portal.

Materials

Online.

Teaching methods

This course will have the same learning features and methodology found in TestOut Office Pro such as instructional videos, text lessons, demo videos, progressive labs, custom assessments, and practice tests. This all-in-one course is delivered on TestOut’s user-friendly and time-saving online learning platform, LabSim®. It’s easy-to-use and flexible for face-to-face, hybrid, and online learning environments. No additional textbooks, resources, or downloads are required.

Employer connections

N/A

Exam schedules

Online.

International connections

N/A

Completion alternatives

N/A

Student workload

Depends on the student's baseline.

Content scheduling

Up to student her-/himself.

Further information

Course is for Open UAS Students.

Evaluation scale

Hyväksytty/Hylätty

Assessment criteria, approved/failed

Pass/Fail.

You have two choices for completion. You can do couple of exercises from each module of you can do the test. Test can be found form the study environment.

Assessment methods and criteria

You have two choices for completion. You can do couple of exercises from each module of you can do the test. Test can be found form the study environment.

Further information

Course is for Open UAS Students.

Timing

01.01.2023 - 31.12.2023

Number of ECTS credits allocated

8 op

Virtual portion

8 op

Mode of delivery

Distance learning

Unit

School of ICT

Campus

Karaportti 2

Teaching languages
  • English
Seats

0 - 1000

Degree programmes
  • Information and Communication Technology
Teachers
  • Virve Prami
Teacher in charge

Janne Salonen

Groups
  • ATX23TV_KEVÄT
    ATX23TV_KEVÄT

Objective

This is a comprehensive course that covers both the basic and advanced features and functions of Excel. Students will learn, practice, apply, and test their skills in real-world business scenarios, preparing them for certifications and professional careers.

Content

1. Course Overview
2. Common Office Features
3. Excel Basics
4. Formulas and Functions
5. Simple Data Analysis
6. MO-200 (Excel Associate) Practice Exams
7. Advanced Workbook Options and Settings
8. Advanced Data Formatting
9. Advanced Formulas and Macros
10. Advanced Charts and Tables
11. MO-201 (Excel Expert) Practice Exams

Location and time

100% online (Self-Study) course which can be done in own pace. Course environment is LabSim -portal.

Materials

Online.

Teaching methods

This course will have the same learning features and methodology found in TestOut Office Pro such as instructional videos, text lessons, demo videos, progressive labs, custom assessments, and practice tests. This all-in-one course is delivered on TestOut’s user-friendly and time-saving online learning platform, LabSim®. It’s easy-to-use and flexible for face-to-face, hybrid, and online learning environments. No additional textbooks, resources, or downloads are required.

Employer connections

N/A

Exam schedules

Online.

International connections

N/A

Completion alternatives

N/A

Student workload

Depends on the student's baseline.

Content scheduling

Up to student her-/himself.

Further information

Course is for Open UAS Students.

Evaluation scale

Hyväksytty/Hylätty

Assessment criteria, approved/failed

Pass/Fail.

You have two choices for completion. You can do couple of exercises from each module of you can do the test. Test can be found form the study environment.

Assessment methods and criteria

You have two choices for completion. You can do couple of exercises from each module of you can do the test. Test can be found form the study environment.

Further information

Course is for Open UAS Students.

Timing

31.12.2022 - 31.12.2023

Number of ECTS credits allocated

8 op

Virtual portion

8 op

Mode of delivery

Distance learning

Unit

School of ICT

Campus

Karaportti 2

Teaching languages
  • English
Seats

0 - 1000

Degree programmes
  • Information and Communication Technology
Teachers
  • Virve Prami
Teacher in charge

Janne Salonen

Groups
  • ATX22TVS
    Open UAS: NonStop Autumn 2022

Objective

This is a comprehensive course that covers both the basic and advanced features and functions of Excel. Students will learn, practice, apply, and test their skills in real-world business scenarios, preparing them for certifications and professional careers.

Content

1. Course Overview
2. Common Office Features
3. Excel Basics
4. Formulas and Functions
5. Simple Data Analysis
6. MO-200 (Excel Associate) Practice Exams
7. Advanced Workbook Options and Settings
8. Advanced Data Formatting
9. Advanced Formulas and Macros
10. Advanced Charts and Tables
11. MO-201 (Excel Expert) Practice Exams

Location and time

100% online (Self-Study) course which can be done in own pace. Course environment is LabSim -portal.

Materials

Online.

Teaching methods

This course will have the same learning features and methodology found in TestOut Office Pro such as instructional videos, text lessons, demo videos, progressive labs, custom assessments, and practice tests. This all-in-one course is delivered on TestOut’s user-friendly and time-saving online learning platform, LabSim®. It’s easy-to-use and flexible for face-to-face, hybrid, and online learning environments. No additional textbooks, resources, or downloads are required.

Employer connections

N/A

Exam schedules

Online.

International connections

N/A

Completion alternatives

N/A

Student workload

Depends on the student's baseline.

Content scheduling

Up to student her-/himself.

Further information

Course is for Open UAS Students.

Evaluation scale

Hyväksytty/Hylätty

Assessment criteria, approved/failed

Pass/Fail.

You have two choices for completion. You can do couple of exercises from each module of you can do the test. Test can be found form the study environment.

Assessment methods and criteria

You have two choices for completion. You can do couple of exercises from each module of you can do the test. Test can be found form the study environment.

Further information

Course is for Open UAS Students.

Timing

01.08.2022 - 31.12.2022

Number of ECTS credits allocated

8 op

Virtual portion

8 op

Mode of delivery

Distance learning

Unit

School of ICT

Campus

Karaportti 2

Teaching languages
  • English
Seats

0 - 1000

Degree programmes
  • Information and Communication Technology
Teachers
  • Virve Prami
Teacher in charge

Janne Salonen

Objective

This is a comprehensive course that covers both the basic and advanced features and functions of Excel. Students will learn, practice, apply, and test their skills in real-world business scenarios, preparing them for certifications and professional careers.

Content

1. Course Overview
2. Common Office Features
3. Excel Basics
4. Formulas and Functions
5. Simple Data Analysis
6. MO-200 (Excel Associate) Practice Exams
7. Advanced Workbook Options and Settings
8. Advanced Data Formatting
9. Advanced Formulas and Macros
10. Advanced Charts and Tables
11. MO-201 (Excel Expert) Practice Exams

Location and time

100% online (Self-Study) course which can be done in own pace. Course environment is LabSim -portal.

Materials

Online.

Teaching methods

This course will have the same learning features and methodology found in TestOut Office Pro such as instructional videos, text lessons, demo videos, progressive labs, custom assessments, and practice tests. This all-in-one course is delivered on TestOut’s user-friendly and time-saving online learning platform, LabSim®. It’s easy-to-use and flexible for face-to-face, hybrid, and online learning environments. No additional textbooks, resources, or downloads are required.

Employer connections

N/A

Exam schedules

Online.

International connections

N/A

Completion alternatives

N/A

Student workload

Depends on the student's baseline.

Content scheduling

Up to student her-/himself.

Further information

Course is for Open UAS Students.

Evaluation scale

Hyväksytty/Hylätty

Assessment criteria, approved/failed

Pass/Fail.

You have two choices for completion. You can do couple of exercises from each module of you can do the test. Test can be found form the study environment.

Assessment methods and criteria

You have two choices for completion. You can do couple of exercises from each module of you can do the test. Test can be found form the study environment.

Further information

Course is for Open UAS Students.

Timing

01.08.2022 - 31.12.2022

Number of ECTS credits allocated

8 op

Virtual portion

8 op

Mode of delivery

Distance learning

Unit

School of ICT

Campus

Karaportti 2

Teaching languages
  • English
Seats

0 - 1000

Degree programmes
  • Information and Communication Technology
Teachers
  • Virve Prami
Teacher in charge

Janne Salonen

Objective

This is a comprehensive course that covers both the basic and advanced features and functions of Excel. Students will learn, practice, apply, and test their skills in real-world business scenarios, preparing them for certifications and professional careers.

Content

1. Course Overview
2. Common Office Features
3. Excel Basics
4. Formulas and Functions
5. Simple Data Analysis
6. MO-200 (Excel Associate) Practice Exams
7. Advanced Workbook Options and Settings
8. Advanced Data Formatting
9. Advanced Formulas and Macros
10. Advanced Charts and Tables
11. MO-201 (Excel Expert) Practice Exams

Location and time

100% online (Self-Study) course which can be done in own pace. Course environment is LabSim -portal.

Materials

Online.

Teaching methods

This course will have the same learning features and methodology found in TestOut Office Pro such as instructional videos, text lessons, demo videos, progressive labs, custom assessments, and practice tests. This all-in-one course is delivered on TestOut’s user-friendly and time-saving online learning platform, LabSim®. It’s easy-to-use and flexible for face-to-face, hybrid, and online learning environments. No additional textbooks, resources, or downloads are required.

Employer connections

N/A

Exam schedules

Online.

International connections

N/A

Completion alternatives

N/A

Student workload

Depends on the student's baseline.

Content scheduling

Up to student her-/himself.

Further information

Course is for Open UAS Students.

Evaluation scale

Hyväksytty/Hylätty

Assessment criteria, approved/failed

Pass/Fail.

You have two choices for completion. You can do couple of exercises from each module of you can do the test. Test can be found form the study environment.

Assessment methods and criteria

You have two choices for completion. You can do couple of exercises from each module of you can do the test. Test can be found form the study environment.

Further information

Course is for Open UAS Students.

Timing

01.08.2022 - 31.12.2022

Number of ECTS credits allocated

8 op

Virtual portion

8 op

Mode of delivery

Distance learning

Unit

School of ICT

Campus

Karaportti 2

Teaching languages
  • English
Seats

0 - 1000

Degree programmes
  • Information and Communication Technology
Teachers
  • Virve Prami
Teacher in charge

Janne Salonen

Objective

This is a comprehensive course that covers both the basic and advanced features and functions of Excel. Students will learn, practice, apply, and test their skills in real-world business scenarios, preparing them for certifications and professional careers.

Content

1. Course Overview
2. Common Office Features
3. Excel Basics
4. Formulas and Functions
5. Simple Data Analysis
6. MO-200 (Excel Associate) Practice Exams
7. Advanced Workbook Options and Settings
8. Advanced Data Formatting
9. Advanced Formulas and Macros
10. Advanced Charts and Tables
11. MO-201 (Excel Expert) Practice Exams

Location and time

100% online (Self-Study) course which can be done in own pace. Course environment is LabSim -portal.

Materials

Online.

Teaching methods

This course will have the same learning features and methodology found in TestOut Office Pro such as instructional videos, text lessons, demo videos, progressive labs, custom assessments, and practice tests. This all-in-one course is delivered on TestOut’s user-friendly and time-saving online learning platform, LabSim®. It’s easy-to-use and flexible for face-to-face, hybrid, and online learning environments. No additional textbooks, resources, or downloads are required.

Employer connections

N/A

Exam schedules

Online.

International connections

N/A

Completion alternatives

N/A

Student workload

Depends on the student's baseline.

Content scheduling

Up to student her-/himself.

Further information

Course is for Open UAS Students.

Evaluation scale

Hyväksytty/Hylätty

Assessment criteria, approved/failed

Pass/Fail.

You have two choices for completion. You can do couple of exercises from each module of you can do the test. Test can be found form the study environment.

Assessment methods and criteria

You have two choices for completion. You can do couple of exercises from each module of you can do the test. Test can be found form the study environment.

Further information

Course is for Open UAS Students.

Timing

01.08.2022 - 31.12.2022

Number of ECTS credits allocated

8 op

Virtual portion

8 op

Mode of delivery

Distance learning

Unit

School of ICT

Campus

Karaportti 2

Teaching languages
  • English
Seats

0 - 1000

Degree programmes
  • Information and Communication Technology
Teachers
  • Virve Prami
Teacher in charge

Janne Salonen

Objective

This is a comprehensive course that covers both the basic and advanced features and functions of Excel. Students will learn, practice, apply, and test their skills in real-world business scenarios, preparing them for certifications and professional careers.

Content

1. Course Overview
2. Common Office Features
3. Excel Basics
4. Formulas and Functions
5. Simple Data Analysis
6. MO-200 (Excel Associate) Practice Exams
7. Advanced Workbook Options and Settings
8. Advanced Data Formatting
9. Advanced Formulas and Macros
10. Advanced Charts and Tables
11. MO-201 (Excel Expert) Practice Exams

Location and time

100% online (Self-Study) course which can be done in own pace. Course environment is LabSim -portal.

Materials

Online.

Teaching methods

This course will have the same learning features and methodology found in TestOut Office Pro such as instructional videos, text lessons, demo videos, progressive labs, custom assessments, and practice tests. This all-in-one course is delivered on TestOut’s user-friendly and time-saving online learning platform, LabSim®. It’s easy-to-use and flexible for face-to-face, hybrid, and online learning environments. No additional textbooks, resources, or downloads are required.

Employer connections

N/A

Exam schedules

Online.

International connections

N/A

Completion alternatives

N/A

Student workload

Depends on the student's baseline.

Content scheduling

Up to student her-/himself.

Further information

Course is for Open UAS Students.

Evaluation scale

Hyväksytty/Hylätty

Assessment criteria, approved/failed

Pass/Fail.

You have two choices for completion. You can do couple of exercises from each module of you can do the test. Test can be found form the study environment.

Assessment methods and criteria

You have two choices for completion. You can do couple of exercises from each module of you can do the test. Test can be found form the study environment.

Further information

Course is for Open UAS Students.

Timing

01.01.2022 - 31.07.2023

Number of ECTS credits allocated

8 op

Virtual portion

8 op

Mode of delivery

Distance learning

Unit

School of ICT

Campus

Karaportti 2

Teaching languages
  • English
Seats

0 - 1000

Degree programmes
  • Information and Communication Technology
Teachers
  • Virve Prami
Teacher in charge

Janne Salonen

Groups
  • ATX22TV
    NonStop virtual studies year 2022
  • ATX23TV
    NonStop virtual studies year 2023

Objective

This is a comprehensive course that covers both the basic and advanced features and functions of Excel. Students will learn, practice, apply, and test their skills in real-world business scenarios, preparing them for certifications and professional careers.

Content

1. Course Overview
2. Common Office Features
3. Excel Basics
4. Formulas and Functions
5. Simple Data Analysis
6. MO-200 (Excel Associate) Practice Exams
7. Advanced Workbook Options and Settings
8. Advanced Data Formatting
9. Advanced Formulas and Macros
10. Advanced Charts and Tables
11. MO-201 (Excel Expert) Practice Exams

Location and time

100% online (Self-Study) course which can be done in own pace. Course environment is LabSim -portal.

Materials

Online.

Teaching methods

This course will have the same learning features and methodology found in TestOut Office Pro such as instructional videos, text lessons, demo videos, progressive labs, custom assessments, and practice tests. This all-in-one course is delivered on TestOut’s user-friendly and time-saving online learning platform, LabSim®. It’s easy-to-use and flexible for face-to-face, hybrid, and online learning environments. No additional textbooks, resources, or downloads are required.

Employer connections

N/A

Exam schedules

Online.

International connections

N/A

Completion alternatives

N/A

Student workload

Depends on the student's baseline.

Content scheduling

Up to student her-/himself.

Further information

Course is for Open UAS Students.

Evaluation scale

Hyväksytty/Hylätty

Assessment criteria, approved/failed

Pass/Fail.

You have two choices for completion. You can do couple of exercises from each module of you can do the test. Test can be found form the study environment.

Assessment methods and criteria

You have two choices for completion. You can do couple of exercises from each module of you can do the test. Test can be found form the study environment.

Further information

Course is for Open UAS Students.

Timing

01.01.2022 - 31.07.2023

Number of ECTS credits allocated

8 op

Virtual portion

8 op

Mode of delivery

Distance learning

Unit

School of ICT

Campus

Karaportti 2

Teaching languages
  • English
Seats

0 - 1000

Degree programmes
  • Information and Communication Technology
Teachers
  • Virve Prami
Teacher in charge

Janne Salonen

Groups
  • ATX22TVK
    Ope UAS: NonStop Spring 2022

Objective

This is a comprehensive course that covers both the basic and advanced features and functions of Excel. Students will learn, practice, apply, and test their skills in real-world business scenarios, preparing them for certifications and professional careers.

Content

1. Course Overview
2. Common Office Features
3. Excel Basics
4. Formulas and Functions
5. Simple Data Analysis
6. MO-200 (Excel Associate) Practice Exams
7. Advanced Workbook Options and Settings
8. Advanced Data Formatting
9. Advanced Formulas and Macros
10. Advanced Charts and Tables
11. MO-201 (Excel Expert) Practice Exams

Location and time

100% online (Self-Study) course which can be done in own pace. Course environment is LabSim -portal.

Materials

Online.

Teaching methods

This course will have the same learning features and methodology found in TestOut Office Pro such as instructional videos, text lessons, demo videos, progressive labs, custom assessments, and practice tests. This all-in-one course is delivered on TestOut’s user-friendly and time-saving online learning platform, LabSim®. It’s easy-to-use and flexible for face-to-face, hybrid, and online learning environments. No additional textbooks, resources, or downloads are required.

Employer connections

N/A

Exam schedules

Online.

International connections

N/A

Completion alternatives

N/A

Student workload

Depends on the student's baseline.

Content scheduling

Up to student her-/himself.

Further information

Course is for Open UAS Students.

Evaluation scale

Hyväksytty/Hylätty

Assessment criteria, approved/failed

Pass/Fail.

You have two choices for completion. You can do couple of exercises from each module of you can do the test. Test can be found form the study environment.

Assessment methods and criteria

You have two choices for completion. You can do couple of exercises from each module of you can do the test. Test can be found form the study environment.

Further information

Course is for Open UAS Students.

Timing

15.08.2021 - 31.07.2022

Number of ECTS credits allocated

8 op

Virtual portion

8 op

Mode of delivery

Distance learning

Unit

School of ICT

Campus

Karaportti 2

Teaching languages
  • English
Seats

0 - 1000

Degree programmes
  • Information and Communication Technology
Teachers
  • Virve Prami
Teacher in charge

Janne Salonen

Groups
  • ATX21TV
    NonStop virtual Studies year 2021

Objective

This is a comprehensive course that covers both the basic and advanced features and functions of Excel. Students will learn, practice, apply, and test their skills in real-world business scenarios, preparing them for certifications and professional careers.

Content

1. Course Overview
2. Common Office Features
3. Excel Basics
4. Formulas and Functions
5. Simple Data Analysis
6. MO-200 (Excel Associate) Practice Exams
7. Advanced Workbook Options and Settings
8. Advanced Data Formatting
9. Advanced Formulas and Macros
10. Advanced Charts and Tables
11. MO-201 (Excel Expert) Practice Exams

Location and time

100% online (Self-Study) course which can be done in own pace. Course environment is LabSim -portal.

Materials

Online.

Teaching methods

This course will have the same learning features and methodology found in TestOut Office Pro such as instructional videos, text lessons, demo videos, progressive labs, custom assessments, and practice tests. This all-in-one course is delivered on TestOut’s user-friendly and time-saving online learning platform, LabSim®. It’s easy-to-use and flexible for face-to-face, hybrid, and online learning environments. No additional textbooks, resources, or downloads are required.

Employer connections

N/A

Exam schedules

Online.

International connections

N/A

Completion alternatives

N/A

Student workload

Depends on the student's baseline.

Content scheduling

Up to student her-/himself.

Further information

Course is for Open UAS Students.

Evaluation scale

Hyväksytty/Hylätty

Assessment criteria, approved/failed

Pass/Fail.

You have two choices for completion. You can do couple of exercises from each module of you can do the test. Test can be found form the study environment.

Assessment methods and criteria

You have two choices for completion. You can do couple of exercises from each module of you can do the test. Test can be found form the study environment.

Further information

Course is for Open UAS Students.