When you input data into Excel it is initially a 'data array' and although it is perfectly fine to leave data in this format it is sometimes easier or better to convert it to Table for the following reasons;
Search results
Creating a TableTable data can be sorted and filtered faster and at the table...
What is a Mathematical operator?
This page will guide you through using Excel to create basic mathematical operations. This is very similar to creating a function or formula except that we are not using the function's operative such as (=Sum) or (=Average) or...
Wrap Text & Merge and CentreWrap Text
Microsoft Excel can wrap text so it appears on multiple lines in a cell. You can format the cell so the text wraps automatically, or enter a manual line break. But this will prevent you from a cell potentially taking up...
How to Add Notes to your Presentation (Presenter View)
While giving a PowerPoint Presentation you can make use of something called Presenter view, this mode allows the projector* to display your presentation full screen without your notes showing to the audience. The second monitor* will show a ...
Animation Pane
The Animation pane allows you to change the order objects animate in, without needing to remove and reapply animations.
The Animation pane can be found in the Animations tab of the ribbon:
When selected the animation pane open in the sidebar and will...
Adding an audio file to your presentation
There are two ways to add audio to a presentation:
1. Adding Audio already on your PC (saved)
2. Record Audio (record live)
To add a clip from your computerHave the audio file saved to the computer locally as an MP3 file - (if you have...
How to create a text box
PowerPoint will generally create placeholders for text and images on each new slide unless you choose a blank slide specifically. However, sometimes you will want to create your own. The insert text-box tool is available for this situation.
In the 'Insert' tab of...
What is recording in Powerpoint?
In PowerPoint 2019 and onwards you can record a Presentation. This will save your narration of the slides (audio or video) and the timings of your slide changes and animation triggers. Once the presentation recording has been complete. The video/audio will be...
PowerPoint - Zoom Slides
PowerPoint has a new feature which mimics the style of presentation of Prezzi, using one large slide to place all of the subsequent slides on. Throughout the presentation, these slides will be zoomed into when that slide is reached, giving the impression that the whole...
Footnotes and Endnotes in Microsoft Word
Footnotes and endnotes are useful tools for adding citations, comments, or explanations to your text.
This guide will walk you through the steps to insert and manage footnotes and endnotes in Microsoft Word.
Footnotes and...