Hiding and protecting an Excel worksheet is NOT the same as full encryption. Protected workbooks can be encrypted and not available without the right password. Worksheets protected or hidden with a password are absurdly easy to view whether you have the password or not. Excel has long had the ability to hide a worksheet (tab) […]
Calculating the ‘Standard Error of the mean’ or SEM is simple using Excel’s in-built functions. Understanding ‘Standard Error of the mean’ isn’t hard either. We’ll explain the formula and what it all means. To calculate standard error of the mean get the Standard Deviation of a sample (STDEV.S() or STDEV()) then divide by the square […]
Understanding Standard Deviation isn’t hard, especially with Excel’s help. This quick guide shows the difference between sample and population functions so you can choose the right one and get accurate, informative results every time. Standard Deviation in Excel The standard deviation measures the variation from the average or mean of a sample set of values. A […]
How did we make a Word table with a picture background for a recent article – asks an Office Watch friend? She meant this table of Zoom shortcuts for toggling audio and video . There’s a similar table for Teams shortcuts. The quick answer is … we cheated! Word can’t have a table with a […]
Miss the classic WordArt from Word’s glory days — the arched text, the rainbow slopes, the wavy headlines that screamed “1990s”? Those old gallery styles are still alive inside every modern version of Word, including Word 365 and Word 2024. They’re just well hidden. Here’s the simple compatibility mode trick that unlocks all the retro […]
