Office Software | The Place For Free Online Training Courses

Word Processing – Edit Content

Edit content by entering, removing characters, words within existing text, by over-typing to replace existing text. To edit content by entering or removing characters or words within existing text, select the text which you want to remove and replace. After this type the new text values. The new text will automatically take place of the…

Word Processing – Document Creation

Enter Text Switch between page-view modes. Writer has three ways to view a document: Print Layout, Web Layout, and Full Screen. To change the view, go to ‘View’ from the main menu bar and click on the required view from the resulting drop-down menu. Print Layout is the default view in Writer. Enter text into…

Word Processing Productivity

Set basic options/preferences in the application: user name, default folder to open, save documents. To set the basic options in the Writer 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 Data’…

Working with Documents

Open, close a word processing application. Open, close documents. To start Writer, 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 Writer’. This will start…

Preview a worksheet

To preview a worksheet, click on ‘File’ from the main menu bar and from the resulting drop-down menu, click on ‘Print Preview’. This will open the preview display of the worksheet as has been shown below. To close the preview, click on ‘Close Preview’. Print a selected cell range from a worksheet, an entire worksheet,…

Check and Print

Check and correct spreadsheet calculations and text. In order to check the spreadsheet calculations, we need to check the sheet for the error codes. These error codes have already been discussed. If error codes are present, this means that some errors exist in some of the calculations and we must check these calculations again. To…

Prepare Outputs

Setup Change worksheet margins: top, bottom, left, right. In order to change the worksheet margins, click on the ‘Format’ button from the main menu bar. Click on ‘Page…’ button from the resulting drop-down. This gives the ‘Page Style’ dialog box. Under the ‘Page’ tab, you can make the appropriate changes to the ‘Margins’ in order…

Changing The Spreadsheet Chart

Change the column, bar, line, pie slice colors in the chart. To change the column, bar, line, or pie slice color in a chart, simply double-click on the respective element for which you want to change the color. If it is a bar chart, double-click on the individual bar, and if it is a pie…

Edit Spreadsheet Chart Title

When a chart is created, then in the ‘Chart Wizard’, under the ‘Chart Elements’ tab, we have the option to add a ‘Title’ for the chart. Appropriate title can be added in this tab during the creation of the chart. Another way is to first create a chart, then select it by double clicking, and…

Create Spreadsheet Charts

Create different types of charts from spreadsheet data: column chart, bar chart, line chart, pie chart. In Calc, we can represent our data with the help of different graphical representations like column chart, bar chart, line chart, or pie chart. This makes the data more presentable and also easier to comprehend. To create the different…