@contextures profile picture
Contextures @contextures

Excel website & blog by Debra Dalgleish @ddalgleish Excel MVP

Joined November 2008
  • Tweets 3,770
  • Following 104
  • Followers 4,640
2,114 Photos and videos
These Excel macros will help you work with a pivot cache - a special memory area where pivot table records are saved Read more 👉 lttr.ai/AsI6n
43
If people enter their names in a sign-up form, you might end up with a mixture of upper and lower case letters. Read more 👉 lttr.ai/AsIoc
38
In Microsoft Excel, you can pull data from another sheet, based on criteria, with an Advanced Filter, an Excel macro, or the Excel FILTER function. Read more 👉 lttr.ai/AsHOV
1
61
Use Excel conditional formatting to highlight the top few numbers, to see what's going well Read more 👉 lttr.ai/AsG3i
3
60
See 3 ways to select and copy numbers only, in Excel. Then, paste them in a consecutive block of cells Read more 👉 lttr.ai/AsEr2
38
The Excel FIND function looks for a case-sensitive text string, within another text string, and returns its position, if found. Read more 👉 lttr.ai/AsEnS
1
57
Sometimes, a pivot table is all alone on a worksheet, but Excel shows you that pivot table overlap error message. Read more 👉 lttr.ai/AsCs2
1
60
Use the Excel Status Bar for quick calculations, or to troubleshoot problems Read more 👉 lttr.ai/Ar96z
1
64
Use the Excel COLUMNS function to count table or worksheet columns Read more 👉 lttr.ai/Arpij

Excel COLUMNS Function Examples and Workbook

Excel COLUMNS function examples show how to make the best use of this function, which returns the count of columns in an array or reference.

contextures.com
3
116
Select a region name from one drop down, and the FILTER function creates a dynamic list of cities from that region. Read more 👉 lttr.ai/Arpig
1
2
58
Use this Student Time Tracker to keep track of your lecture hours, and course work hours, to see what the weekly totals are. Read more 👉 lttr.ai/Arpie
1
1
134
If Yes is in cell E2, the second question appears Read more 👉 lttr.ai/Arpic
1
38
Limit the choices in Excel drop down lists, based on the selections made in other drop downs Read more 👉 lttr.ai/ArpiY
1
64
Get the Calorie Burn Calculator workbook, and other related Excel workbooks, for health and fitness tracking Read more 👉 lttr.ai/ArpiV

Excel Calorie Burn Calculator Food Activity Free Workbook

Get this free Excel calorie burn calculator workbook. Select weight range, food item and activity, and see how long it takes to burn those calorie.

contextures.com
4
303
Pick a region from an Excel drop down list, and see a list of employees from that region Read more 👉 lttr.ai/Arph1

List Matching Items for Selection

Pick region from drop down list. Excel table lists employees from that region. INDEX/MATCH formula, no macros. Free workbook, easy steps, screen shots.

contextures.com
2
94
How to fix duplicate items in an Excel pivot table lttr.ai/Arphy
1
3
105
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
1
72
Fictional insurance policy Excel data that you can download, to use for testing, training and demos. Read more 👉 lttr.ai/Arl7x
44
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
1
81
Use this Excel UserForm to add, view, edit and search transaction records Read more 👉 lttr.ai/Arb4x

Excel UserForm Search Add Edit

Excel UserForm for transaction record data entry. Add new records, or use Search criteria to find existing records, and view, edit or delete them..

contextures.com
2
104
Load more