Use INDEX and MATCH for simple database queries in Excel

12 Google Camera tips everyone can use • Email not displaying correctly? View it in your browser.

PCWorld Power Tips Mar 17, 2016 Use INDEX and MATCH for simple database queries in Excel The bigger your spreadsheet, the more you need INDEX and MATCH functions, which you can combine with SUM, AVERAGE, and MAX to refine your searches. Read More ▶ Your Must-Read Stories • 12 Google Camera tips everyone can use • How Cortana in Edge can help you find context for images • 3 note-taking app alternatives to Evernote and OneNote • Windows 10 picture password: Draw your own conclusions about its safety 12 Google Camera tips everyone can use Google's two-year-old Camera app boasts a bevy of handy features, from a self-timer and exposure settings to the ability to create a Street View-like photo sphere. Read More ▶ How Cortana in Edge can help you find context for images Microsoft recently added 'Ask Cortana' support for images in Edge. Here's how to use it. Read More ▶ 3 note-taking app alternatives to Evernote and OneNote Simplenote, Google Keep, and Apple Notes are simple apps that offer more productivity power than you'd think. Read More ▶ Windows 10 picture password: Draw your own conclusions about its safety Windows 10's picture password gives you an alternative to traditional passwords and PINs that could be easier to remember. Whether it's as safe is a good question--we go over the issues here. Read More ▶

You are currently subscribed to PCWorld Power Tips as messi1927@gmail.com. Unsubscribe from this newsletter | Manage your subscriptions | Subscribe | Privacy Policy Copyright (C) 2016 PCWorld, 501 2nd Street, San Francisco, CA 94107 Please do not reply to this message. To contact someone directly, send an e-mail to online@pcworld.com.