Contextures

How to fix duplicate items in an Excel pivot table lttr.ai/Arphy

Use formulas in Excel to create HTML or IFRAME code, then add to a web page or blog post, to show links or embedded videos. Read more 👉 lttr.ai/AroFy

Fictional insurance policy Excel data that you can download, to use for testing, training and demos. Read more 👉 lttr.ai/Arl7x

Show or hide grand totals in an Excel pivot table, change some headings, and a workaround to show them at the top! Read more 👉 lttr.ai/ArhXt

Use this Excel UserForm to add, view, edit and search transaction records Read more 👉 lttr.ai/Arb4x

Use Excel color scales to spot months with lowest sales, or days with highest temperatures Read more 👉 lttr.ai/ArYEb

Create Excel custom icon sets in conditional formatting - choose icons, change number settings Read more 👉 lttr.ai/ArX76

Create a Data Validation drop down list that lets people add new items, when needed! Read more 👉 lttr.ai/ArVrC

See how to troubleshoot and fix the Excel error message, "Reference isn't valid" Read more 👉 lttr.ai/ArSzo

Summarize data, based on one or more criteria, using Excel database functions, like DSUM, DGET, or DCOUNT Read more 👉 lttr.ai/ArMjD

Here's my guide to Excel's counting functions and formulas, to help you find what you need Read more 👉 lttr.ai/ArIj1

Click a Slicer, to quickly show and hide groups of values in a pivot table. Click the Function slicer to change summary function and headings Read more 👉 lttr.ai/AfBvI

Use the Excel EXACT function to compare text strings for an exact match, including upper and lower case Read more 👉 lttr.ai/ArGQq

To test Excel's CONVERT function, get my CONVERT Made Easy sample file. Read more 👉 lttr.ai/ArDyU

While you work in Excel, save time with these Excel Ribbon tips Read more 👉 lttr.ai/Aq73A

Why isn't the pivot table sorting that one name with the others? lttr.ai/Aq6jA

See 2 tricks for Excel weekday lists – only Monday to Friday dates, no weekend dates lttr.ai/Aq4bo

Make a pivot chart's title change with its filters Read more 👉 lttr.ai/Aq4SU

How to fix worksheet cells that look blank, but Excel COUNTA function counts them Read more 👉 lttr.ai/Aq35s

If you don't specify which days are the weekend, the WORKDAY.INTL function automatically excludes Saturday and Sunday as weekend (non-working) days. Read more 👉 lttr.ai/Aq1ug