Browse All Articles

Or filter by News, Views or Tips.

Hot Tips

  1. Access: Input Masks

    Users of Access have probably used Input masks even if you haven't realised what they are called. The most common Input Mask is used in date fields to make sure you enter the date in the correct format. If you have moved to a date field and it displays something like this __/__/__ it is the Input Mask specifying that you must enter the date in three pairs of numbers ie. dd/mm/yy.

  2. Word: Removing Items from the Work Menu

    In the last Hot Tip we showed you how to add the Work menu to Word so that you can quickly get to documents you use regularly, but not necessarily recently.

  3. Word: Work Menu

    This Hot Tip looks at ways of quickly returning to existing documents in Word instead of having to go the long way through the Open command.

  4. Word: Quick Typing

    This month we are going to look at a quick way of using abbreviations to type phrases you commonly use.

  5. Microsoft Office: Flowcharts

    Welcome to this month's Hot Tip from Black Swan Training Solutions. This time we are going to look at creating flowcharts using the drawing tools in Microsoft Office.

  6. Parsing and Concatenation

    This time we are going to look at parsing and concatenating in Excel, but first we'll explain what these words mean.

    Parsing is used when you want to split some data into two (or more). The most usual use of this in Excel is if you have someone's full name in a cell, and you want to divide it and have the first name in one cell and surname in another.

  7. Access: Data Entry

    Welcome to the latest Hot Tip from Black Swan Training Solutions. This time we are going to look at how you can speed up your data entry in Microsoft Access.

  8. Excel: Custom Lists

    Today we are going to look at creating lists that you can then use with the AutoFill handle to quickly enter into your spreadsheet. This will save you having to type a list of customers, departments, towns that you use on a regular basis.

  9. Outlook: Tasks

    This month we are going to talk about the Tasks list in Microsoft Outlook and especially assigning tasks to other people.

    This is a less used area of Outlook compared to email and the calendar, but is very useful nonetheless.

  10. Word: Object Browser

     To start the year off we are going to look at a great way of scanning through your Word documents for particular things.

    To try this out open a long document (If you have one) that has some pictures, tables or you have used heading styles .

It’s Easy to Follow Us