Archives

Dreading spending hours typing new names and addresses into the same email? Did you know you can send Mail Merge messages directly through your email account from Word?

Cell/Range Names In Microsoft Excel, the Name Manager is used to name an individual cell or a range of cells. The Name Manager can be found on the Formulas Tab. These range names can then be used in formulas to make them easier to create and understand. Cell names are treated as absolute references and […]

What is a Style? A style is a set of formatting characteristics that a user can apply to paragraphs, characters, lists and tables. Styles allow users to format large documents quickly. For example, instead of taking three separate steps to format a title as 16 pt, Arial and centre aligned, a user could achieve the […]

Customise the Ribbon In Office 2013 you can tailor and personalise the ribbons so that they will appear exactly the way you want them. You can produce customised tabs and custom groups that will hold frequently used instructions. The user can add a command to an existing group or create a new tab and add […]

Working with large presentations in PowerPoint can be confusing and time consuming. Microsoft PowerPoint 2010 and 2013 has a new feature called “Sections” which will allow you to group your slides into different Sections like dividers in a folder. You can customise the name of each section, thus allowing easy navigation and organisation of different […]

PINNING WORKBOOKS AND PLACES More efficient file and folder location is now found in the Recent option in the File ribbon. Each file and location is listed here and has a Pin icon to the right of it. Click on the pin icon (it turns blue) and the file/folder will remain permanently on your list. […]

The New Fluent Interface The arrow at the top of the File tab returns you to your open file.  WHAT IS NEW IN MICROSOFT OFFICE 2013 New features in Microsoft Office 2013, compared to 2003 and earlier versions, include • Live View • Backstage • Collaboration facilities • New Template Library • Improved Graphics and […]

Slicers in Microsoft Excel   Microsoft Excel 2010 and 2013 introduces Slicers which helps the user to quickly and simply filter their data dynamically on a pivot table or chart. Slicers will appear on the users screen as a floating box which can be moved around the screen to suit the user.   • Create or […]

AutoFilter Filtering allows you to show only the records in a list that meet certain criteria. The AutoFilter feature creates a drop-down list for each field that displays all the options in that field. The list can be filtered by selecting any one of these options. Only the matching records will be displayed. • Click […]

Sorting a Database It is possible to organise information in a database by using the Sort feature. This feature can sort any field in the database alphabetically, by number or by date. It is possible to sort in ascending and descending order. It is also possible to sort by up to sixty four columns.   […]