Welcome to my Microsoft Tips & Shortcuts blog

Diana Angenent has been using the Microsoft suite of applications since they were first released over 25 years ago.  In a variety of capacities, she has entered data, prepared reports & documents, developed databases, prepared project plans & presentations, written VBA code, and now as a qualified trainer, is able to pass on her skills and the benefit of experience to users of the products.

We are looking forward to sharing these nuggets with you so you can Work Smarter, Not Harder.

Tips & Shortcuts

  • Why should I use MS Excel Tables?
    Why should I use MS Excel Tables? Excel Tables are more than just fancy formatting. The beauty of these tables is not the instant formatting but the power it gives you in being able to analyse the…
  • MS Word Tab Stop Tips
    MS Word Tab Stop Tips If your text look a little disorganised in your Word document, you may want to use Tab Stops to align the text into neat columns. You can use tabs instead…
  • MS Word Character & Paragraph Formatting Shortcuts
    MS Word Character & Paragraph Formatting Shortcuts Word also has loads of keyboard combos for applying character formatting. Applying Character Formatting You can use the shortcuts to apply formatting to selected text or to whatever you type…
  • Word General Shortcuts
    Word General Shortcuts There are many general program shortcuts in Microsoft Word that make it easier for you to do everything from save your document to undo a mistake. Ctrl+N: Create a new…
  • Word Text Navigation Shortcuts
    Word Text Navigation Shortcuts You can use keyboard shortcuts to easily navigate throughout your document. This can save time if you have a long document and don’t want to scroll through the entire thing,…
  • Word Text Selection Shortcuts
    Word Text Selection Shortcuts Utilise the Shift key to easily select text. You may have read a previous blog, that the arrow keys are used for moving your insertion point around, and the CTRL…
  • Word Text Editing Shortcuts
    Word Text Editing Shortcuts To start utilising shortcuts in Microsoft Applications, try just one to start with and introduce a new one each week. Before long you'll be using so many shortcuts you'll notice…
  • How to Create an Excel Macro Button
    How to Create an Excel Macro Button Create a button in Excel to move the user to another worksheet It is actually fairly easy to create a button on a worksheet that you can click to take…
  • Excel Worksheet Tab Navigation Tips
    Excel Worksheet Tab Navigation Tips Earlier this week I was asked a question that I’d like to share with you. The question was to do with Microsoft Excel and navigation in a workbook that has…
  • Check your Excel Formulae for Errors
    Check your Excel Formulae for Errors When using a spread sheet program it’s easy for errors to creep in if you are not vigilant. At this time of year when spread sheets are being used to…
  • Page Setup Options
    Page Setup Options You can change your page setup options on the Page Setup dialog box. Last week we looked at what you can do on the Margins tab of the Page Setup…
  • Excel Page Layout Tips
    Excel Page Layout Tips Don’t save a workbook with that annoying column stuck on page 2 or a lonely row left by itself again when you print it! Switch to Page Layout view in…
  • Excel Page Break Tips
    Excel Page Break Tips When you have too much to fit on one page, Excel inserts automatic page breaks. As a result, information that should appear together, may be forced onto different pages. To…
  • Insert Todays' Date, Don't type it in
    Insert Todays' Date, Don't type it in Need to enter the todays' date regularly but can’t always remember the date? Fingers not hitting the right keys every time?Have you been accidentally typing 2019 instead of 18? No…
  • Quickly Apply Formats to Text
    Quickly Apply Formats to Text Make text in your document stand out by applying Character Formats including fonts, font styles and size. Do it easily using your Format Painter and if you need to, you…
  • Paste Formats Explained
    Paste Formats Explained You can paste text or values within one application or from one application to another. The text you copy or cut may be formatted differently than your destination document. When…
  • How to get the most out of the new clipboard on Windows 10 (including October 2018 Update)
    How to get the most out of the new clipboard on Windows 10 (including October 2018 Update) The clipboard has been a feature within the Microsoft suite of applications from for many years. Some of us remember Mr Clippy popping up and giving tips as we worked.…
  • Colour your Worksheet tabs
    Colour your Worksheet tabs You could go wild colour coding your worksheet tabs creating a real kaleidoscope. But if you use the colours sparingly and allocate say two different colours to your main two…