Bute Tipster is a Knowledge Database giving information, hints and tips on Microsoft Office applications and Personal Skills. Bute Tipster is regularly updated   and you can follow the entries on Twitter , Facebook and LinkedIn .

To review the database by topic, click on Table of Contents .

Microsoft 2010 upgrade

Interacting with Excel 

 

 

 

 

 

 

 

1. Quick Access Toolbar
Customise this toolbar with commonly-used commands.

2. Tabs
Name for each category of commands in Excel.

3. Ribbon commands
Commands for each tab are displayed here.

4. Name Box
Shows name/cell reference of currently selected cell; active cell.

5. Formula Bar
Enter formulas or change cell content.

6. Working Area
The cells that make up the current worksheet.

7. Workbook Tabs
Name for each worksheet in a workbook file.

8. Status Bar
Shows vital statistics about file or selected range of data.

9. Scroll Bars
Scroll horizontally or vertically through your data here.

To review workshop: Click here

Changing the Theme in PowerPoint
 
By default, all blank presentations use the Office theme. (Templates may use different themes, or even a custom theme.) To change the theme, click a thumbnail in the Themes gallery. Or, click the More arrow to view the entire collection of themes. Each theme is customizable with the drop-down menus to the right of the gallery. The Colors, Fonts, and Effects commands each open a drop-down menu, allowing you to choose a style for that element. 

To review workshop: Click here  

New Features in Word 2010

Expanded SmartArt
SmartArt lets you create professional-looking diagrams very easily. There are many new types of SmartArt in Word 2010.

Navigation Pane
Word 2010 includes a new feature called the navigation pane. This is a special task pane that appears on the side of the screen. It lets you quickly navigate through your document, rearrange content by dragging and dropping, view each page of the document as a thumbnail  (small image), and search the document.

Simultaneous Online Editing
Many programs in Office 2010, including Word, are capable of using an online collaboration tool called SharePoint. In a nutshell, SharePoint allows you to share documents and information with coworkers via a central server, usually set up by your IT department. Word 2010 uses this to allow many people to work on the same document at the same time.

Backstage
In the upper left-hand corner of the screen, you will see a tab marked File. Click this tab to view the Backstage menu. This menu gives you quick access to management commands for your document. You can save, print, share, and modify background properties of your document all in one place. 

Streamlined Printing
Printing in previous versions of Word required opening a separate dialog box in order to change features like paper size, collation, number of copies, etc. Now all print commands and a true-to-scale preview are accessible in the Backstage menu.
 
PDF  Support
Word 2010 has native save support for PDF files without needing to download any additional software.
 
Integrated Screen Capture
Word 2010 gives you the option to insert an image of any open window or a rectangular screenshot that you define by clicking and dragging. 

To review workshop: Click here

Understanding Conversations in Outlook
 
Conversations are a new way of looking at messages in Outlook 2010. They group messages together by subject, even if different people are involved in the conversation. Conversations can be identified by the small triangle at their top level. You can use this triangle to expand or collapse the conversation.

Conversations organize messages even if those messages are in different folders. (The message we sent, for example, is in the Sent Items  folder.)

You can toggle conversation  grouping on or off with the Conversations group on the View tab and the Arrange By  menu. And, the Conversation Settings menu on the View tab allows you to customize how conversations are displayed.

To review workshop: Click here