There’s a ton of things I really like about SharePoint, as well as a couple of things I don’t like so much – but I want to share with you the things I’ve noticed that I use over and over, so here are the 4 coolest features in SharePoint Online that I would go so far as to say I really love. Insert googly love heart eyes emoji here.
Tip for navigating quickly around multiple SharePoint sites and lists
This tip is useful for users of Internet Explorer or Edge. When you’re working in SharePoint (particularly as the Administrator or Developer) you often need to move between several sites and lists, which can be frustrating having to back your way out of a page to only a few minutes later realising that you need to open that same thing again.
What’s the difference between a site and subsite in SharePoint?
I often get asked this question, although it’s usually framed more like this: “when should I set up a site instead of a subsite?” or “Isn’t everything a site, anyway?” or “why should I care whether my site is a subsite or not?” The first thing to note is there is only one top level (root) site in SharePoint – that’s the Home site.
Read more
Make changes to a Design Ideas slide in PowerPoint
I’m loving using the new Design Ideas slide designs in PowerPoint. However, I found myself wanting to make changes to it and it took a bit of working out before I managed to do it. Read more
Creating a new Microsoft Account
If you don’t yet have a Microsoft Account follow the steps below to set one up.
- First head to account.microsoft.com and click ‘Sign in with Microsoft’. You will be presented with the screen below. Click ‘Create one!’.
Use Conditional Formatting to identify cells that are of interest
Learn how to use Conditional Formatting to identify cells that are of interest.
For example, you can apply a Conditional Format that checks to see a cell’s value is greater than $500. If it is the Conditional Format can change the Fill colour of the cell. Therefore making it really easy for you (and others using the file) to quickly identify any cell with a value greater than $500. Read more
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 it can be a bit of a pain.
A couple of challenges may come your way if you weren’t the creator of the workbook that contains links. One challenge is identifying where the linked data is within your workbook and another is actually breaking the link. Read more
Link cells in the same or different Excel worksheets
Learn how to link Link cells in the same or different Excel worksheets.
Linking saves a huge amount of time (and a huge amount of mistakes) in that it allows you to create connections from one cell to another.
Use the SUMIF function to total only the cells that match your requirement
Use the SUMIF function to total only the cells that match your requirement.
For example, if you wanted to know the total sales made by one of your sales team members you can use the SUMIF function to only add to the total the sales made by a certain member. Gold! This function saves you a lot of time.
Prior to learning this function most people filter their data based on their requirement, e.g. the team member’s name, and then copy and paste the info into another worksheet. Once in the new worksheet they then use the SUM function to create the total. Read more
Insert an Excel function into your workbook
Learn how to insert an Excel function into your workbook.
Excel comes equipped with a large number of pre-defined formulas. These are known as functions.
There is a great amount of functions available in Excel. Each created for a specific purpose. There are functions specific to Maths, Science, Finance, and Engineering to name a few. Read more