Excel’s PivotTable allows you to evaluate trends, comparisons, and patterns within datasets. Once a PivotTable is setup, you can filter “Drill down” into it to focus on key information. These days there are several ways to filter a PivotTable, Slicers (which Microsoft loves to boast about), AutoFilter and by Field List. All these options mean […]
Simple, easy and free ways to convert audio files like WAV, FLAC and many others into a format that PowerPoint or your smartphone prefers such as MP3, MP4 or AAC. The BBC Sound effect downloads are in WAV format. That’s a good, high-fidelity and uncompressed format that works in PowerPoint for Windows but it also […]
How to stop your Office Watch newsletters going to the Junk E-mail folder. To make sure your Office Watch newsletters don’t end up in your Junk Email folder you need to set us up as a ‘Safe Sender’. Here’s how to do that in Outlook. Keep in mind that Outlook software is NOT the primary […]
If you think font selection is hard, spare a thought for lawyers who have to deal with different official rules, recommendations and accepted practice for court submissions. Jason Steed at JDSupra sets out the complications for US lawyers. The D.C Circuit court started ‘discouraging’ use of Garamond font but no change in the actual rules. […]
Now you know how to insert checkboxes in Excel, here are some ways to use check box cells in Excel. Counting the checked/unchecked boxes, calculate percentage checked and even showing a separate list of items based on their checked status. A cell with a check box has two values: TRUE – checked FALSE – UNchecked You can use the values […]
