Tips and Tricks
MrExcel shares details on the UNIQUE function to find distinct items within a list.
Engineer Excel wants to help you avoid frustration in Excel!
MrExcel shares some tips about how you can use picture transparency in Excel.
Oz responds to Excel Guru’s challenge with his own unique style.
Everyday Office shows you how to protect the integrity of your worksheets when other users need to enter data.
ExcelJet shows you a few ways to generate random values or text within Excel.
Newton Excel Bach shows you how to calculate the time between two dates.
Access Analytic helps solve a frustrating problem: when your data has leading apostrophes.
If you haven’t used Power Pivot yet, Excel Exposure has a great article to show you what you’re missing!
Excel Off the Grid shows you how to deal with forgotten or unknown passwords!