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.
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.
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 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.
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.