Insert, rename, copy, move, hide and delete Excel worksheets
Inserting and organising data into multiple worksheets is a huge part of Excel. One Excel file can contain multiple worksheets. This allows…
-
-
How to copy and paste visible cells only in Excel (excluding hidden rows and columns)
Learn how to copy and paste, excluding hidden columns or rows in Excel. Ever tried to copy and paste data thinking you…
-
How to prevent a split Table in Word
Are you having trouble with your Word Table splitting? Are you wanting to prevent your Table breaking in between sentences and paragraphs…
-
How to Create a Formula in Excel
Being able to create a formula in Excel is fundamental to being able to use Excel well.Writing an Excel formula is much…
-
How to change date format in Excel 365 Online
Are you having trouble with date formatting in Excel 365 Online? It’s a common issue where dates might appear in an American…
-
Average formula in Excel – AVERAGE, AVERAGEIF, AVERAGEIFS function
There are many areas within business reporting where we are looking for the average of a selection of results. A good example…
-
Word – How to delete last page of Court Pleading document
Don’t you hate when you delete the last page within a court pleading document in Word, and your line numbers disappear? If…
-
HOW TO Join a Microsoft Teams Meeting from email invite – step-by-step
Follow the steps below to join a Teams meeting from an email invite, even if you don’t have a Teams account. Prior…
-
Word Tables allow rows to break across page
There are times when you find an entire Word Table or entire row move to a new page, leaving a large empty…
-
How to do a VLOOKUP with multiple criteria in Excel
There are times when you want to return a match for a VLOOKUP based on multiple criteria. For example, we may have customers…
-
How to check and remove document properties in Word
How often do you open a previously used document and do a File, Save As to save a copy of the original…
-
How to Freeze rows in Excel
Would you like to keep row headings in Excel when you are scrolling so that you can easily identify your columns? What…
