Excel 365 BasicsLaajuus (3 op)

Osaamistavoitteet

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.

Sisältö

- 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

Esitietovaatimukset

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.

Arviointikriteeri, hyväksytty/hylätty

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.