Office Software | The Place For Free Online Training Courses

Understanding Presentations – Enhancing Productivity

Set user preferences in the application: user name, default folder to open and save files. To set the basic options in the Impress application, click on ‘Tools’ from the main menu bar. From the resulting drop-down, click on ‘Options’. This will open the ‘Options’ dialog box. In the ‘Options’ dialog box, under ‘LibreOffice’, in ‘User…

Switch between open presentations.

You can open multiple presentations at a time in Impress. In such a case, to switch between these presentations, just click on the ‘Impress’ icon on the task bar of your computer. This icon will always get displayed whenever you are running Impress on your machine. When this icon is clicked, then the names of…

Create a new presentation based on default template.

A default template is the one, which is used to create a presentation when any new presentation is created. This means that when we create a new presentation, it gets created based on the default template which has been set. We are going to learn how to set a default template in the subsequent chapters.…

Working with Presentations

Open, close a presentation application. Open, close presentations. To start Impress, click on the ‘Start’ button on your Windows machine. Click on ‘All Programs’ and then go to the ‘LibreOffice’ folder in the list of all programs which gets displayed. Click on the ‘LibreOffice’ folder and then click on ‘LibreOffice Impress’. This will start the…

Advanced Spreadsheets Quiz

Advanced Spreadsheets – Security

Add, remove password protection for a spreadsheet: to open, to modify. To add password protection for a spreadsheet, click on ‘File’ from the main menu bar and from the resulting drop-down, click on ‘Save As’. This will open the ‘Save As’ dialog box. In this dialog box, we have a ‘Save with password’ checkbox. Check…

Advanced Spreadsheets – Accept, reject changes in a worksheet.

When the spreadsheet in which the changes have been made is sent to someone else, then they can accept or reject the changes and keep only the ones which are required. To accept or reject changes, simply click on ‘Edit’ from the main menu bar. From the drop-down, click on ‘Track Changes’, and from the…

Advanced Spreadsheets – Collaborative Editing

Tracking and Reviewing Turn on, off track changes. Track changes in a worksheet using a specified display view. Whenever we make changes to any document and send that document to someone else, then it might be possible that some of those changes might not be required by the other person. In such a case, it…

Advanced Spreadsheets – Run a macro

To run a macro, click on ‘Tools’ from the main menu bar. From the resulting drop-down menu, click on ‘Macros’, and from the sub-menu which gets displayed, click on ‘Run Macro’. This will open the ‘Macro Selector’ dialog box. In this dialog box, in the ‘Library’ field, we have the list of all the libraries.…

Advanced Spreadsheets – Automation

Record a simple macro like: change page setup, apply a custom number format, apply auto formats to a cell range, and insert fields in worksheet header, footer. A macro is a saved sequence of commands or keystrokes that are stored for later use. The LibreOffice macro language is very flexible, allowing automation of both simple…