Home

Hot spots and animated gifs in PowerPoint

Leave a comment

This video explains how to add a hot spot and an animated gif to a Microsoft PowerPoint presentation. The tutor starts off by showing a completed example of a presentation with hot spots and animated gif. The tutor then recreates a flowchart and saves it as an animated gif. The tutor then inserts the animated gif into the slide master so that it will run on every slide. The tutor goes on to add a hot spot with a hyperlink to the index slide. The hot spot used is a rectangle shape without fill or lines showing. The tutor demonstrates how the features work in full presentation mode. This is a Microsoft PowerPoint tutorial covering, animated gifs, hot spots, hyperlinks, and flowcharts.

Delay an Email

Leave a comment

This video explains how to schedule an email in Microsoft Outlook. Delay emails. Schedule emails in the desktop or online version of Outlook. The tutor starts off by creating a new mail message and then moves the Options area on the ribbon. In options the tutor explains how to set the delay for the email. Once the delay has been set the tutor mentions that you should send the email as normal. The email does not send but sits in the Outbox until the delay date and time has passed, then it will send. In Outlook online, part of Office 365, the delay settings are found at the bottom of the new message area. In the online version of Outlook, the message sits in the Drafts area until the delay time and date has passed, then it will be sent. This is a Microsoft Outlook tutorial covering scheduling an email, delaying sending an email and Online scheduling. #msoutlook #schedule

Add Calculations to a pivot table

Leave a comment

This video explains how to add calculations into a Pivot Table in Microsoft Excel. Calculations in a Pivot table. The tutor starts off by creating a simple Pivot table, adding a few fields with numbers in. The tutor then covers how to add a calculated field to work out markup and then profit. The final part of the video uses the calculated Item option to demonstrate how to add formula on a calculated item. This is a Microsoft Excel tutorial covering pivot tables, calculated fields and calculated items.

Table of Contents in LibreOffice

Leave a comment

How to add a table of contents in LibreOffice Writer. Table of contents. The tutor starts off by explaining how to add a heading style to a document, and then, if required how to change the style. The tutor goes on to insert a table of contents which picks up all the heading styles and references them. The tutor explains how to update the table of contents if any pages are added or deleted. In the second part of the video the tutor covers how to add an index reference. The tutor mentions that you will have to select all the entries that you want to appear in the index. Once all the entries have been added the Index is inserted from the table of contents menu. The index style and layout can be changed if required. This is a LibreOffice Writer tutorial covering, table of contents, index references and styles.

Mail merge photos

Leave a comment

This video demonstrates how to use mail merge to merge photos into a Microsoft Word document. The tutor uses an Access database as the data source and explains that the database has file paths to photos. The tutor then starts the mail merge process by adding the database as the data source. The tutor then inserts the name and surname fields followed by the photo field. The tutor covers what happens if you just continue with the merge process, basically only the file path is merged. The tutor returns to the main document and inserts several merge fields around the photo field. When the merge process continues the photos appear and not the file path. This is a Microsoft Word tutorial covering mail merge, merge a photo, and merge fields. Merge images in Word. Advanced mail merge. The tutor uses the Ctrl key and F9 to activate merge fields.

Add a signature in Outlook

Leave a comment

This video explains how to add a signature in Microsoft Outlook. Signatures. The tutor demonstrates two ways to add a signature in Outlook. The first option in through options and then the mail option. This area gives access to the signature feature. The tutor focusses on the second way to add a signature, which is through the new mail dialogue box. The tutor explains how to attach a signature to a new message and a reply to a message. The tutor goes on to create a new signature and adds a business card with web addresses. The final part of the video covers how to add AutoText to Outlook, which some people use as signatures. This is a Microsoft Outlook tutorial covering signatures and AutoText.

What is a Baseline?

Leave a comment

This video explains what a baseline is in Microsoft Project. Baselines. The tutor starts off by explaining a small project plan with links and resources added. The tutor mentions that a baseline is a snapshot of the plan for a Project. The tutor covers how to save a baseline and how to update a baseline. The tutor also mentions that you can save up to 11 baselines. The tutor covers how to add the tracking table to the tracking view and use it to update tasks. The final part of the video covers how to view multiple baselines and slippages from each baseline. This is a Microsoft Project tutorial covering baseline, multiple baselines, and tracking.

What is Access

Leave a comment

This video explains how to use Microsoft Access for beginners. What is Access. Access is a relational database package. The tutorial covers how to create and import a table of data. The tutor then explains that the data can be interrogated via a filter or more likely a query. The tutor goes on to create a report based on the query results. The final part of the video covers how to create a form using the wizard and manually. This is a Microsoft Access database covering tables, queries, forms, and reports.

Pivot Tables in Libreoffice

Leave a comment

In this video the tutor demonstrates how to create two Pivot tables. One table using a named range and the second without using names. The tutor adds a chart to both Pivot tables. On the second example the chart displays on two axes. The tutor uses the options feature to activate the drill down feature. The tutor covers how to add and use filter within the Pivot table. This is a LibreOffice Calc tutorial covering Pivot tables and Pivot charts.

Insert files into Word

Leave a comment

The tutor covers how to insert files into a Microsoft Word document. Insert Objects. The tutor starts off by inserting a Word file into a word document using the Insert object feature. The tutor displays the files as an icon and then as an expanded object. The tutor goes on to insert an Excel file as an object and then expanded. Finally, the tutor uses copy and paste special with link, to insert Word and Excel elements into a document. This is a Microsoft Word tutorial covering, insert object, paste special and linking. How to insert an Excel file into Word. Excel to Word.

Older Entries