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.
Word uses the Developer tools to make forms and collect the data with ease. Here's how.
Excel 2016 gives you six new chart styles. The three we explore here make it easier to compare data and show hierarchies and other relationships.
Give your slides a new bag of tricks with PowerPoint 2016's changes, which range from subtle to truly cool.
Excel 2016 offers a compelling list of new features, from database enhancements to new charts and templates, even a tool for handwriting quations.
Make it easier to format and read long Microsoft Word documents (and shorter ones) with these tips.
Boolean logical operators in Excel formulas make searching easier, and you can apply the same methods in Internet or database searches.
PowerPoint's built-in templates are convenient, but everyone knows what they look like, and you look unoriginal if that's all you use. Try these tips to make something unique that will help your presentation stand out.
Photoshop's editing tools can help you transform your snapshots into studio-like portraits. We'll show you how to use the Magic Wand, the Lasso, and other features to clean up images.
Use these step-by-instructions to turn complex procedures into one-click wonders.
Excel does just as well as Word in creating and customizing these useful office supplies. Here's how.
Excel's formidable talents stretch into word processing and even graphics. Here's how to create a calendar, customized just the way you want it.
In part three, you're finally ready to use the data you exported from Outlook to Excel, to create a mail merge with a Word document.
Adobe Photoshop lets you use its deep toolbox to crop, resize, and edit photos, adjusting everything from proportions to image resolution and more.
We show you how to clean up and prepare your data for the big mail merge, everything from trimming unnecessary data fields to setting up record ID numbers.