I always pride myself about reading the Microsoft prompts, but today I was not quite with it when I jumped into MS-Teams and just like that my Teams and Chats merged!

Now I did read Microsoft were merging Chat and Teams, but ….

Breathe, I said, and watch the screen I said to myself, and let's see what else they have to show me.  And I was directed to "Settings" and a new option called "Chats and Channels".  Phew, I could reverse what just happened and take a moment to see if this new style of "Chats in one location" is beneficial. I am undecided, but I will keep playing with it to see.

You have been given a list of over 900 guests who are departing your ship, and you need to develop a summary of how many people will be departing on what time and flight code.

To do this we will use the UNIQUE function, and then the IFCOUNTS function.  

While there are many options to hide information in Excel file, let's explore using

• N Function
• Data > (Outline) Group
• Hiding a column/row

Have you experienced something not quite showing up on the screen or it's not printing correctly? Word enables you to search for codes in your document.

Again another thing that has been niggling at my mind.  I recall when a range is selected you can move the cursor to the various corners of the selected range.  Today I found the answer:

• After selecting the range, press [Ctrl + .]  this will move you around the 4 corners of the selected range

Since getting my new laptop I have needed to press " twice to get a double quote displayed - very frustrating.  Today I decided to solve this problem so here goes... 

NB: My new laptop is Windows 11 which makes a difference to the instructions.  So best of luck ...

Search for Settings > Time and language > Language & region .. working with

:: English (Australia) click on ... (to select Language options)
Scroll down to find Installed keyboard and [Add a keyboard] and you are looking for US Qwerty
then REMOVE others (in particular "United States-International")

Now restart your computer and you will (hopefully) find all key functioning correctly. 

Exploring 3 techniques for fill a series of cells with values, using

• Autofill
• SEQUENCE function
• MOD function

PowerPoint has some cool Transition styles and Morphing is one of these.

Join me to see how to use this style to take an object from one side of a slide to another side while enlarging the object.

You are preparing for a meeting, and you need to:

• Get your content a little more organised – the quick way to create a table, and 
• You need to double check your calculations - OneNote to the rescue.

You may have used "Flying in" or "Bounce" but have you used "Custom Path"?  If not, this is a great way to add life to your presentation.  Remember the trick is not to overdo the Animation!