Non-stop
Opintojakson nimi Excel Basics
Opintojakson ajankohta 14.02.2020 - 31.12.2021
Korkeakoulu Metropolia Ammattikorkeakoulu
Opintojakson kieli Englanti
Opintopisteet 3 OP

Opintojakson ala Tekniikan ja liikenteenala, Yhteiskuntatieteiden, liiketalouden ja hallinnon ala, Yrittäjyys
Opettaja Tapio Wikström
Email
Tarjotaan avoimen opiskelijoille Ei
Taso AMK

Ilmoittautumiskäytäntöihin liittyvät kyselyt
Ilmoittautumisaika 14.02.2020 - 31.07.2021
Opintojakson toteutussuunnitelma
Ilmoittaudu
Ilmoittautumistiedot

Excel Basics

14.02.2020 - 31.12.2021

Opintojakson kuvaus

Objectives Excel is included in the Microsoft Office suite of applications. Spreadsheets present tables of values arranged in rows and columns that can be manipulated mathematically using both basic and complex arithmetic operations and functions.

In addition to its standard spreadsheet features, Excel also offers programming support via Microsoft’s Visual Basic for Applications (VBA), the ability to access data from external sources via Microsoft’s Dynamic Data Exchange (DDE), and extensive graphing and charting capabilities.

Contents

  • Getting started with Excel 2013
  • 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

None

Arviointikriteerit

Approved/Fail

Theory The theory is studied at own pace using course books and training material. In addition other training material is available in the work space. The Rehearse section (Rehearse) contains multi-choice questions about course topics.

Laboratory exercises The course exercises are performed using the student´s own computer. The exercise instructions are in the text books.The files used in the exercises are downloaded from Moodle. The exercise reports are packed into one file, that is returned in the Moodle return folder.

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.

Opintojakson tiedot

Theory Using the course book Microsoft Excel 2013 Step by Step get acquainted with the topic. Perform the course book exercises. The exercises are contained in the text book. When finished take the rehearse test. The duration of the test is 180 minutes.

Exercises The laboratory exercises are performed using Microsoft Office 2013 containing Excel.Unfortunately the 2013 version is not avaiable as a download any more. The course should work on a newer version, but there can be some differences.

The laboratory exercise instructions are in the text book Microsoft Excel 2013 Step by Step chapters 1 – 14. The returnable files are marked in the textbook. Before you can complete the exercises in this book, you need to download the book’s lab files to your computer from Excel lab files.

  • The exercises are done by chapters and the exercise files are saved in the local workstation.
  • The workbooks to be returned are marked as ’Save the workbook (Save As) in local memory device for returning’
  • When all exercises are done, download a packed workbook Excel_Workbook.zip from folder Workbooks.

Ilmoittautumistiedot

Course is 100% Self-Study course and you can enroll it whenever it’s suitable for you 24/7. Timetable is totally up to Student her/-himself.