Learn the BEST Excel keyboard shortcuts. Perfect for Beginners and for those who want to save time and work smarter.
It doesn't matter if I'm delivering a Stage 1 or a Stage 3 Excel training course - when I'm demonstrating to the class I whip around the screen, format, select and modify and update using shortcut keys.
If you share Excel files outside of your organisation you’ll enjoy this post where I share with you how to remove Excel formulas and keep the results so that you can confidently send a file knowing you aren’t disclosing confidential information inside of your formulas.
If you send emails to a group of people who don't know each other you might like to ensure you keep each recipient’s email address private from the other recipients. This is commonly known as emailing to ‘undisclosed recipients’.
A good example could be when you are sending your clients a company newsletter or invites to a company event.
If they don’t know each other you could upset a few people if you share their information without their prior agreement.
In this post I'm going to share with you how to make sure you don't upset anyone by sharing their private information with all of the recipients of your email.
I hear way too often, people telling me that they've done this and they've gotten into trouble and I don't want it to be you!
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.
Continue ReadingThis 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.
Continue ReadingI 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.
Continue Reading
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. Continue Reading
If you don’t yet have a Microsoft Account follow the steps below to set one up.
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
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. Continue Reading
