MS Excel – Show the active cell on a worksheet

Sometimes you have a worksheet open and the cursor is nowhere in sight:
  • You could consult the namebox to get the address
  • Alternatively you could press an arrow key to bring the cursor into view (this will move to a new cell at the same time)
  • But you can also just use Control + Backspace (Mac: Command + Delete) to automatically scroll the...
More info

Microsoft Office 365

There is a lot of confusion about the different versions of Microsoft Office. The most common software related question clients ask us is “what is Office 365”. Signing up for Office 365 software gives you on-line access to the Microsoft Office applications you are familiar with and have learned to love or hate (Word, Excel, PowerPoint and so on) plus some other cloud based applications designed...
More info

Good writing is becoming trendy

During the last few years our efforts to teach as many people as possible how to write faster and better have paid off. Learning how to write well for today’s business world has become rather trendy as organisations (and individuals) realise how good it is for business to write clearly and quickly. Most organisations have writing style guides to support the idea of writing clearly and...
More info

Writing for work in the 21st century

Pretty much everything has changed since the 1980s, right? And the style of business writing is no exception. So it’s really strange that some people still insist on writing the way they did in those days. Business writing then was very formal, often very wordy and generally not that easy to read. Now, professional writers know that they need to be clear and concise to get...
More info

Respect your readers

No matter what your readers did, when writing at work we always need to respect them and we need to word a difficult topic carefully. If you forgot to pay your council rates and received a letter saying things like “an irreversible detrimental notation will be recorded against each property owner/s Australian credit rating record” your first reaction might be: what the….. and you probably wouldn’t...
More info

Set tabs aside in MS Edge

While in Edge Browse you can "set aside" groups of tabs so you can restore them later. The benefit of using this feature is that it allows you to avoid visual clutter and save memory at the same time. Here's how to set aside and restore tabs in Edge Browser. The set aside feature works on all tabs in a window. Step 1 Click on the "set...
More info

Time-saving tools in Microsoft Office

TriCon have identified many time-saving tools we can teach you to use: Microsoft Word
  • Heading numbering
  • Styles
  • Automatic table of contents, list of tables or figures
  • Headers, footers and page numbers in different sections
  • Cross-referencing
  • QuickParts
  • Template development
  • Animating text or objects
  • Working with masters and slide layouts
  • Creating templates
  • Formulas and functions (for example, VLOOKUP and IF functions)
  • Inserting and modifying charts
  • Advanced searching for...
More info