Excel 365 Basics

Opintojakson kuvaus

Objectives

Microsoft 365 is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line. Office 365 contains the same core applications as traditional versions of Office, including Excel, Word, and PowerPoint.

Microsoft Excel 365 is a full-featured spreadsheet program that helps you quickly and efficiently develop dynamic, professional workbooks to summarize and present your data.

In this Excel 365 Basics course, students will create and edit basic worksheets and workbooks.

This course is designed for students who want to gain the necessary skills to create, edit, format, and print basic Microsoft Excel 365 worksheets.

Content

• Getting started with Excel 365
• Working with data and Excel tables
• Performing calculations on data
• Changing workbook appearance
• Focusing on specific data by using filters
• Reordering and summarizing data
• Combining data from multiple sources
• Analyzing data and alternative data sets
• Creating charts and graphics
• Using PivotTables and PivotCharts
• Printing worksheets and charts
• Working with macros and forms
• Working with other Office programs
• Collaborating with colleagues

Edeltävyysehdot

This course is intended for students who have little or no familiarity with Microsoft Excel or more experienced Excel users who want to learn the topics covered in this course in the Excel 365 interface.

Arviointikriteerit

Approved/Fail

Theory The theory is studied at own pace using training material in Metropolia Moodle. In addition other training material is available for download in the work space.

Laboratory exercises The course exercises are performed using the student´s own computer. The workbook files used in the exercises are downloaded from Metropolia Moodle.

Final test The final exam must be done remotely.

Opintojakson työskentelytavat ja aikataulutus

Course is 100% self-study course and has not official timetable. Study time and place is totally up to student her-/himself.

Theory Using the course material in Moodle get acquainted with the topic. Perform the exercises.

Exercises The laboratory exercises are performed using Excel 365 or Excel 2021. The exercises can also be done using older Excel versions.

Opintojakson tiedot

Theory Using the course material in Moodle get acquainted with the topic. Perform the exercises.

Exercises The laboratory exercises are performed using Excel 365 or Excel 2021. The exercises can also be done using older Excel versions.

Ilmoittautumistiedot

• Course is 100% online self-study course.
• You can enroll this course whenever it’s suitable for you and start it at once you have enrolled it.
• Course can be done in own pace.
• Credits will be putted into our Student register as soon as student has done this course.