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!
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
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. Read more
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.
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
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
Learn how to insert subtotal rows into sorted data without having to spend time doing it manually.
Recently I ran a training session for an Accounts Manager and her staff. They spent a lot of time pulling data out of their in-house computer system, sorting it by customer and then inserting a new row at every change in the customer name. This was so that they could place a SUM into the row to total what the customer had spent with them.
Using the Subtotals feature I showed them a quick and effective way in which to summarise their data. And yep! They were pretty impressed! Read more