Moving or swapping fields around in a PivotTable is both amusing and addictive at the same time. You cannot stop yourself from rearranging your data in different ways. Each time you move a field, the Pivot Table will restructure to the new field configuration and you see the same data in a different alignment. May […]
You will always find Excel either summarizing your data by adding the values together (SUM) or Counting the number of items. Nobody is stopping you from changing the type of calculation that your work demands to include averages, maximum, minimum, standard deviation and others. Change the calculation from the Value Field settings. Add a column […]
Apple has introduced a new image and video format for iPhone and iPad, here’s how to handle it in Microsoft Office documents. .HEIC image files are made by default in some Apple devices with iOS 11. Microsoft Office and Windows don’t support the new format yet but there’s workarounds available in the meantime. Automatic HEIC […]
A recent Office addition is ‘Shared with Me’, a list of the documents you’ve been invited to collaborate on with others. It’s available in Office 2016 Windows/Mac and the iPad, iPhone and Android Mobile apps. According to Microsoft ‘Shared with Me’ ” lets you see the files others have shared with you” Our checks show […]
It’s always been possible to email a document for reviewing or editing. Modern versions of Office make that easier by letting you email from the document directly, instead of an email program like Outlook. Instead of opening your email to send an attachment, click on Send as an attachment from your working document, to send […]
