Contextures
@contextures
Followers
5K
Following
199
Media
2K
Statuses
3K
Excel website & blog by Debra Dalgleish @ddalgleish Excel MVP
Canada
Joined November 2008
Use the Excel IF function when you want to test something, and show one result if the test result is True, and a different result for False Read more 👉 https://t.co/DYX6300HBf
0
0
2
Filter a list based on criteria, and use wildcards, like asterisk (*) or question mark (?) Read more 👉 https://t.co/0T2gdXf72w
0
0
2
See how to calculate distance in Excel, using Latitude and Longitude Read more 👉 https://t.co/OSCL7YffT5
0
0
2
Here's my guide to Excel's counting functions and formulas, to help you find what you need Read more 👉 https://t.co/8JJiG6nl32
0
0
1
Use a worksheet form for Excel data entry, and the VBA code automatically saves the entry to a list on a different worksheet in the same workbook Read more 👉 https://t.co/FRBVvMhVGU
0
0
1
This video shows the steps for creating a line panel chart, using a Line Chart, and adding error bars and formatting, to separate the data into panels. Read more 👉 https://t.co/X9gX3rgcgQ
0
0
0
Excel CONVERT function examples - change kms to miles, and more! Read more 👉 https://t.co/6abjuOfbYY
0
0
1
The Fields Section and Areas Section Stacked layout is best if the pivot table has long field names, or a short list of fields Read more 👉 https://t.co/RKzZJKYKis
0
1
2
Fictional insurance policy Excel data that you can download, to use for testing, training and demos. Read more 👉 https://t.co/mPE7o23fCY
0
0
1
How to insert, hide, format Excel popup comments (old-style) Read more 👉 https://t.co/GjRED4t2SB
0
0
1
I have pleasure to share with you the interview we made with Mike Koss - one of the Original Minds behind #Microsoft #Excel creation, part of the first team of programmers developed Excel 1.0 in 1985 He was the Honorary Guest of Bulgaria Excel Days 2025. https://t.co/wbW0PtM0Hc
1
2
5
An hour to go until today's Vancouver #PowerBI and Modern #Excel meet-up gets underway! Spreadsheet enthusiast Alison Pollecutt is willing to bet that there are things you're doing manually that "Go To Special" could help you do a lot quicker. 😲 RSVP at
meetup.com
**SESSION TRACK:** Excel **SESSION OUTLINE:** “Go To Special” is a tool that you might easily miss amongst the many other options on the Excel ribbon. Let’s face it, what
0
2
2
Quickly hide specific items in a pivot table, or select a few items to keep visible https://t.co/VPn9SPpErM
0
1
2
See how to change an Excel formula result by clicking a worksheet check box. No macros required! Read more 👉 https://t.co/nviw3w8h0r
0
0
2
A new student joined my last AKA session with a familiar #Excel headache: “Every month I download new CSVs from our billing system – and every month I spend hours cleaning them up.” 😭 I walked her through how #PowerQuery can automate every step in a single refreshable query.
0
1
2
Show Excel data validation drop down items in a combo box, where you can change font size, and number of items ▸
contextures.com
Excel data validation using programming and a combo box, to allow autocomplete and font formatting..
0
0
2
See how to set up advanced dependent drop-down lists in Excel. For example, show a short list or full list Read more 👉
contextures.com
How to set up advanced dependent drop-down lists in Excel. Show a short list or full list. Prevent invalid selections,. Fix OFFSET list problems.
0
0
3