Quick Bytes

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.

Topics

Click on the links to take you to the full listings for each topic.

List of topics:

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.

Office 2010

Some new features in Office 2010.

Feature How to
The NEW File tab Quick Byte - The File tab
Back

Items to save you time

Items that could save you time or effort or money Back

Short cut keys

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
Back
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.

Word 2010/2007

Feature How to
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
Back

Excel 2010/2007

Feature How to
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?
Percentages Percentages
Back

Outlook 2010/2007

There are features that are the same in both versions of Outlook. We are currently using Exchange 2007.

Feature How to
Overlay another calendar How to overlay another calendar onto your calendar

Back

PowerPoint 2010/2007

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.

Feature How to
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