Searching in Microsoft Teams
There’s lots of reasons to use Search in Teams. Sometimes you’ll want to find something you (or someone else) posted, but you…
-
-
Best Keyboard Shortcuts for Excel Beginners | Tips and Tricks
Learn the BEST Excel keyboard shortcuts. Perfect for Beginners and for those who want to save time and work smarter. It doesn’t…
-
How to Make changes to a Design Ideas Slide in PowerPoint
Let’s look at how to edit Design Ideas in PowerPoint. If you’re like me, you probably love the Design Ideas slides in…
-
Find, modify and break links to an Excel workbook
Learn how to find, modify and break links to an Excel workbook. Linking is great, until you no longer need it. Then…
-
Save an Excel workbook, including save a copy and save as PDF
Being confident in how to save an Excel workbook, including save a copy and save as PDF, is a fundamental skill in…
-
How to total a range of cells in Excel
The quickest way to total a range of cells in Excel is to use the SUM function. The Sum function is one…
-
How to Sum only visible cells in Excel when using Filter
A common question I get asked when I’m teaching people how to filter data is “how do I sum only the visible…
-
Filter data in Excel
Learning how to filter data in Excel enables you to find and work with just a subset of a larger list or…
-
Excel – Using VLOOKUP to compare two lists
If you want to save yourself a huge amount of time when reconciling data, learn how to use VLOOKUP to compare two…
-
Excel – Restricting editing in worksheets and workbooks
Needing to create a single worksheet, or an entire workbook, where you do not want other users to be able to make…
-
Excel – Paste a link and Paste Special transpose your data
Without a doubt ‘Paste Link’ is one of the best time-saving features in Excel. Linking information from one cell to another saves…
-
Excel – How do I sum a range of cells that include #N/A or #DIV/0! errors?
Most of us will agree that error values can be helpful and sometimes extremely unhelpful. For example, the #N/A (Value Not Available)…
