The Duplicates option under conditional formatting is useful to identify when there are duplicate entries within a range. This requires you to review the range to see if there are any duplicates. You can use a formula to identify ranges that contain duplicates. (more…)
In November 2019 I re-ran my Excel Chart Tip sand Tricks session. The detailed pdf manual and example file can be downloaded using the button below. Content listed below the video. Download Materials CPD note - if you are claiming CPD for watching this recording you need to keep your own records. People who attend the live sessions receive an annual listing of attendances. https://vimeo.com/374068298 This webinar is focused on showing you how to create and modify charts in Excel…
Did you know that you can format individual words and letters differently within an Excel cell or text box? (more…)
If you have a system that uses initials to identify people then being able to extract initials from a first name and last name combination can be handy. A formula can automate the process and there is also a quick, manual way to do it. (more…)
When you create a top 5 sorted report with a PivotTable, the Pivot Chart isn’t always what you expect, there is an easy solution. (more…)