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)…
Excel – Retaining a leading 0 (zero) when entering Post Codes – great for mail merging
PROBLEM: retaining a leading 0 (zero) when entering Post Codes. When you enter a post code that has a leading 0 (zero), e.g….
Excel – How do I merge cells within a range that is formatted as a Table?
Question: When I use Excel “Format as Table” to format a range, the Merge & Center button is greyed out and becomes…
How to create a list of Working Days – Excel WORKDAY function
This post has been updated and added to by Sharyn, November 2020. Need a list of weekdays or workdays only? Let’s look…