Everything you need to know to successfully transfer your contacts, music, photos, and apps from one iOS device to another.
Windows
How to return the top or bottom n records without a filter or PivotTable in Excel

There are lots of ways to return the top or bottom n records from a data set in Microsoft Excel, but the new dynamic array functions make doing so easier than ever.
New Microsoft analytics tools help identify and understand trends without compromising privacy

Developed to help policy-makers research human trafficking, these techniques for synthetic privacy, casual inference and visualizing complex graph statistics could be useful for many other problems.
How to use vector graphics to create cool custom graphics in PowerPoint

Free graphics aren’t written on stone in Microsoft PowerPoint. Many will allow you to ungroup all the pieces, use what you want and delete what you don’t.
16 Deals to Help Deck Out Your Home Office

Is your work space lacking in form and function? Some of our favorite desks, webcams, and keyboards are discounted right now.
Everything Microsoft Announced, Including a Wacky Laptop

The new hardware includes an updated Surface Duo 2, which you can finally call a phone, and a cute eco-friendly mouse.
How to use the FILTER() dynamic array function in Excel

Microsoft Excel’s new FILTER() function is a great tool for reporting and dashboards. We’ll show you how to use it to get more done.
How to automate entering dates with VBA in a Word document

Using VBA makes quick work of entering dates into the future or past into a Microsoft Word document. Here’s how to use it.
How to use a VBA procedure that deletes the current page in a Word document

If you work with long Microsoft Word documents and frequently have to delete pages, you’ll appreciate this simple VBA procedure.
Windows 11 prep: How to convert MBR hard drive partitions to GPT

For added security, Windows 11 will forgo the older MBR partition scheme and use GPT instead. That may require users to convert their older hard drives. Here is how to do it.