Quick Bytes:- short video clips with audio showing you how to perform tasks in Microsoft Office. Quick Notes:- instructions with screen captures in pdf format for you to read if you don't want to watch the video. We intend to publish new items each week and hope you find them useful. If you want to be notified when new Quick Bytes are published please email IT Skills asking to be added to the distribution list.
If you have a suggestion for a Quick Byte please email IT Skills.
Click on the links to take you to the full listings for each topic.
|Office 2010||Microsoft Word|
|Microsoft Excel||Save time|
|Microsoft Outlook||Microsoft PowerPoint|
|Short cut keys|
The difference between 2010 and 2007 is minimal. In 2010 there is now a File tab. Apart from that these videos will work for either version.
Some new features in Office 2010.
|The NEW File tab||Quick Byte - The File tab|
|Command||Short Cut Keys|
|Open an Explorer window||Windows key + E|
|Go to the desktop||Windows key + D|
|Display open items||Alt + Tab or Windows + Tab|
|Close the current window||Windows key + M|
|Snap an open window to the right||Windows key+ Right Arrow key|
|Snap an open window to the left of the screen||Windows key + Left Arrow key|
|Open a New Internet Explorer Window||Point mouse at IE button and the Task Bar and press the scroll wheel down|
|Commands in Word||Short Cut Keys|
|To make text Superscript||Ctrl + plus sign (+)|
|To make text Subscript||Ctrl + equal sign (=)|
|Centre text||Ctrl + E|
|Justify text||Ctrl + J|
|Commands in Excel||Short Cut Keys|
|Move down or up to last empty or non-empty cell||Ctrl + Shift+ Down Arrow or Up Arrow|
|Move to the last empty or non-empty cell to the right or left||Ctrl+Shift+Right Arrow or Left Arrow.|
|Insert a return within a cell||Alt + Enter|
|Advance to the next worksheet||Ctrl + Page Down|
Some short video clips on how to use different features in Office 2007/2010.
|Creating headers and footers||Quick Byte - Headers and Footers|
|Using Text Boxes and Word Art||Quick Byte - Using Text Boxes and Word Art|
|Using Page and Section Breaks||Quick Byte - Using Page and Section breaks to improve document layout in Word|
|Inserting text||Quick Byte - How to insert text from other files into another file|
|Using the Navigation Pane||Quick Byte - Using the Navigation Pane in Word|
|Track changes||Quick Byte - How to master track changes|
|Quick contents pages||Quick Byte - How to quickly create a contents page
Quick Note - Quick contents pages - instructions in pdf (125Kb)
|Adding hyperlinks||Quick Byte - Adding Hyperlinks in a document
Quick Note - Using Hyperlinks in Word - instructions in pdf (50Kb)
|Using Format Painter in Word||Quick Byte - Using Format Painter in Word
Quick Note - Using Format Painter in Word - instructions in pdf (131Kb)
|Using Outline view in Word||Quick Byte - Using Outline view in Word
Quick Note - Using Outline view in Word - instructions in pdf (140Kb)
|Using Tables in Word||Quick Byte - Using Tables in Word
|Spark lines||Using Spark lines in Charts|
|Using Format Painter||Using Format Painter|
|Charting||A Selection of Charting Examples including adding a secondary axis, creating a time line|
|Using Function COUNTA||To count the number of cells in a range that are not empty|
|Using Function COUNTIF||To count a series of items in a range that meet the given condition|
|Using Function COUNT||To count the number of cells in a range that contain numbers|
|Using Function COUNTBLANK||To count the number of empty cells in a specified range|
|Conditional Formatting||Setting cells to change their look dependent on their content|
|Multi category axis||How to create a chart with a multi category axis|
|Irregular dates in axis||How to create a chart with irregular dates in the axis|
|Using axis options||How to use some of axis options available|
|Creating a secondary axis||How to create a chart with a secondary axis|
|Create a chart with horizontal lines||How to create a chart with a horizontal lines|
|Creating a Gantt chart||How to create a Gantt chart|
|Absolute Cell References||What is an absolute cell reference?|
There are features that are the same in both versions of Outlook. We are currently using Exchange 2007.
|Overlay another calendar||How to overlay another calendar onto your calendar|
The difference between 2010 and 2007 is minimal. There is now a File tab in Office 2010. Apart from that these videos will work for either version.
|Creating PowerPoint from Word||How to create PowerPoint slides from a Word document|
|Tools to use in a presentation||Quick Byte - Tools to use in a presentation|
|Embedding a YouTube video||How to embed a YouTube video into PowerPoint|
|Create an interactive text box in your PowerPoint slide show to enable you to record data whilst the show is on screen||How to create and use an interactive text box during your PowerPoint show|