The way of preparing documents in their electronic version has become an extension of their author. Therefore, this process should be taken quite seriously. In order to create a well-designed document that will be applicable also by other users, you need a decent knowledge of the whole suite of common office programs. The presented Microsoft Office suite has established a widely respected standard in this area through years. At the moment, it represents the widest and most purchased offer of software used in enterprise, education and households.
Office Suite 2013 Online Course
This library of interactive courses provides you the opportunity to familiarise yourself with five most popular applications of the Microsoft Office suite. Each set of courses begins with the basic notions concerning the program interface and its manipulation, followed by the creation of a specific type of documents and their editing, up to the use of more advanced tools that enable you to manage your files on a professional level. Each of the interactive lessons always tackles one specific issue. After getting acquainted with the tools and processes related to it, you can immediately practice the acquired knowledge in the real application. Several quiz questions included at the end then help you realise whether you have mastered the topic or you need to review the content.
MS Word 2013: Introduction – In this course, you will familiarise yourself with the program interface and the navigation in it. You will learn how to enter basic text properly and how to check spelling and grammar in it. You will examine the options of formatting text and the whole paragraphs. You will get to know the basic settings before printing a document, including page setup and inserting headers and footers into the document pages.
MS Word 2013: Intermediate – In this course, you will learn to adjust the program environment to your specific needs. You will try effective formatting of text by using styles. You will apply the templates offered by the program to create well designed documents. You will examine the creation and editing of tables in order to better arrange the data of a list of records. You will learn to insert various graphical objects to documents, including pictures, charts, SmartArt graphics and shapes and you will try out their further editing directly in Word.
MS Word 2013: Advanced – This course focuses on the tools used mainly for editing longer documents or for automating the work in the program. You will learn to split documents into sections, especially in order to insert various headers and footers into different pages. You will also insert a title page and set a watermark. You will learn to create a table of contents based on the document headings, to number inserted pictures and other objects and to create also their automatic list. You will further learn to use fields, hyperlinks and cross-references, footnotes and endnotes. You will also familiarise yourself with the tools used when multiple users work with the same document, such as making notes, tracking performed changes or creating subdocuments.
MS Excel 2013: Introduction – You will familiarise yourself with the Excel 2013 environment and its documents and you will learn to control them. You will learn in each lesson to create tables step by step. You will find out how to enter values correctly into the cells and how to set the cell formatting, including conditional formatting. You will learn to manipulate each cell and cell range, you will learn to work with worksheets and entire files. You will create a chart and learn to create calculations by basic arithmetic formulas.
MS Excel 2013: Intermediate – In this course, the presented interactive lessons focus mainly on performing various calculations. You will broaden your basic knowledge by the application of logical and text functions. You will get acquainted with the principles of referencing to the values in other cells. You will learn to fill cells with series of data. You will familiarise yourself with the advanced options of sorting and filtering data or searching for specific values in extensive tables. You will also examine how to split longer text entries in tables into individual data placed into several columns.
MS Excel 2013: Advanced – This course is focused mainly on the creation of charts and automation of the work in the program by using macros. Besides these main topics, you will also examine the insertion of various graphical elements into worksheets, such as shapes or SmartArt graphics. You will learn to prepare a table or the entire worksheet before printing and you will familiarise yourself with the options of protecting and sharing the workbook content. You will further familiarise yourself with the usage of macros, including their creation and editing and you will also examine the options of macro security.
MS PowerPoint 2013: Introduction – In this course, you will familiarise yourself with the user interface of the PowerPoint 2013 program where you will try various views of presentations. You will learn to enter text into presentations and insert graphical elements into them, including pictures, shapes, clip art, symbols or even equations. You will try to edit all the inserted objects and move them within or between slides. In case of text, you will apply the WordArt formatting. When inserting new slides into a presentation, you will learn to select a suitable layout of the predefined text placeholders. You will also try to change the selected layout as well as to restore the original one.
MS PowerPoint 2013: Intermediate – In this intermediate course, you will learn to insert additional objects into the slides of presentations, namely tables, charts, SmartArt graphics, sound and video, and to further edit them. You will learn to organise slides, split them into sections and move them even between presentations. You will examine the presentation themes in details, customising the properties of the previously selected one. You will learn to add a footer to the slides and customise the slide master. You will also compare two presentations and will take a look at the work with comments.
MS PowerPoint 2013: Advanced – You will learn to perform the last adjustments in a presentation before presenting it to an audience. You will learn to set the slides transition and assign animation effects to the different objects on slides. You will adjust the animation settings and set the slide show timing. You will also set the properties of the presented slide show and add speaker notes to the presentation. You will try the options of delivering the presentation included in the new Presenter view. You will create your custom template and will learn to print a presentation and save it in different file formats.
MS Outlook 2013: Introduction – In this initial course, you will familiarise yourself with the program interface and learn to send, receive, print and organise messages in it. You will also learn to work with message attachments, to create an automatic reply and to set rules for automatic processing of received or sent messages. You will send a message with a questionnaire to fill in. You will also get acquainted with a whole range of other tools, which will make your work with e-mails easier and more pleasant.
MS Outlook 2013: Intermediate -In this course will learn to use the Calendar folder to plan different appointments, the Tasks folder to monitor all your duties and the Notes folder to write down any ideas that come to your mind. In the Journal folder, you will record the details about various actions. You will also learn to manage your contacts and send message to them. You will work with address books and you will learn to print the individual items from the entire mail client.
MS Outlook 2013: Advanced – You will learn to organise your appointments by using the Calendar and assign tasks to your colleagues with the subsequent follow-up of their fulfilment. You will try out importing and exporting your Outlook data and sharing the information with other Outlook users. You will also get acquainted with data files and the creation of custom forms for the individual Outlook items.
MS Access 2013: Introduction – In this course you will familiarise yourself with the terminology concerning relational databases and with the basics of working in the Access program. You will try various ways of creating tables and setting the properties of their fields. You will learn to further analyse the data in tables through select queries, including the creation of calculated fields in them. You will set relations between tables and ensure their referential integrity. You will also familiarise yourself with an easy way of creating simple forms and reports.
MS Access 2013: Intermediate – You will learn to create calculated fields in queries that operate with functions. You will create totals queries and parameter queries. You will familiarise yourself with the properties of table joins and will examine how they can affect the result of queries. You will create forms in the Design view and will learn to insert calculated fields into them. You will also design and edit reports and will learn to perform various calculations in them. You will also learn how to insert controls into forms and reports, including subforms and sub-reports.
MS Access 2013: Advanced – Here you will familiarise yourself with action queries. You will examine different types of queries in the SQL view and will get acquainted with the essential clauses of this language. You will learn to create and use macros to automate your work with databases. You will explore importing and exporting of objects and their data. You will examine the printing options of different objects in details and you will familiarise yourself with normalisation of data. You will also examine the options of navigation in a database.