The course MS Excel 2019: Advanced 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 ...

In the course MS Excel 2019: Expert Tools you will familiarise yourself in detail with various options of external data import from other formats compatible with Excel. You will also learn how to export data from Excel to these formats. The course later focuses on pivot tables and pivot charts, covering also their ...

In the course MS PowerPoint 2019: Introduction, you will familiarise yourself with the user interface of the PowerPoint 2019 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 ...

In the course MS PowerPoint 2019: Intermediate, 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 ...

In the course MS PowerPoint 2019: 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 ...