Menu
Log in


Smart Learning Tips

Insights and learning – shared for free!

This is where you’ll find all our blog posts filled with free tips and useful guidance to get the most from your Microsoft 365 apps plus common-sense ideas, useful links, business book reviews and more.

To find posts about a specific app, look for the app name in the blog title.



  • 6 Jul 2023 2:24 PM | Michelle Hamer (Administrator)

    Inside of using the CONCAT function or writing a formula joining cells together with the & symbol, try using Ctrl + E.

    Insert the pattern you want Excel to use from your data, and then press [Ctrl + E] 

  • 4 Jul 2023 2:22 PM | Michelle Hamer (Administrator)

    There are several ways to create tasks for yourself, yes, I know it can get confusing each of these ways!  And if you are wondering what the different ways are, well there is:

    • To Do 
    • Outlook
    • (MS-Teams) Planner [on a channel] 



  • 27 Jun 2023 2:35 PM | Michelle Hamer (Administrator)

    How many times have you requested information only not to receive this info in time to complete your project?


  • 15 Jun 2023 2:30 PM | Michelle Hamer (Administrator)

    Photos tell a story, so let’s improve your story with 2 tips for making photos great in your presentation.

    1. Removing the background, and
    2. Neat tricks you can do with cropping. 
  • 15 Jun 2023 2:28 PM | Michelle Hamer (Administrator)


    You have seen how Excel autofills the months of a year, well you can create your own custom lists which is a lot more productive than typing a list over and over again.  

  • 1 Jun 2023 3:26 PM | Michelle Hamer (Administrator)

    For whatever reason, your Microsoft apps may not have the Dictation function installed.

    And if this is the case, then you can use the Windows 11 App in Word, Outlook and in other window applications such as Notepad.  

  • 18 May 2023 3:23 PM | Michelle Hamer (Administrator)

    The most common method of selecting (or highlighting) text is to drag over the text.

    In this video we will use several different methods of selecting text to increase your productivity, including:

    • Click, hold down the Shift key, Click – selecting any text
    • Double click – selecting a word
    • Triple click – selecting a paragraph
    • Using the Ctrl key and clicking – selecting a sentence
    • Using the Alt key and dragging – selecting vertical text  


  • 12 May 2023 3:07 PM | Michelle Hamer (Administrator)

    Excel's Conditional Formatting enables you to format a cell (or a range of cells) based on a test.

    But there is a case when you may want Excel to highlight the row instead of just getting a cell highlighted.  

  • 5 May 2023 4:26 PM | Michelle Hamer (Administrator)

    Consider you are in a workshop and the presenter has invited you to take a photos of any slides he/she is presenting. You have taken a photo and now you want to make some notes on this image.

    Let's show you how to put the image into OneNote and then send the image to the background so you can make notes anywhere on the image.  

  • 5 May 2023 4:04 PM | Michelle Hamer (Administrator)

    You have an email that requires time to get done, and you never seem to find the time. 

    As Andy Stanley says "Let me take some pressure off.  Your problem is not discipline. Your problem is not organization. Your problem is not that you have yet to stumble upon the perfect schedule ...  

Site Map | Privacy Policy | Disclaimer | Terms & Conditions | Refunds & Cancellation Policy

© 2023 Smart Advice Pty Ltd

Powered by Wild Apricot Membership Software