contextures's profile picture. Excel website & blog by Debra Dalgleish @ddalgleish Excel MVP

Contextures

@contextures

Excel website & blog by Debra Dalgleish @ddalgleish Excel MVP

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 👉 lttr.ai/AkusK

contextures's tweet image. 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 👉 lttr.ai/AkusK

Excel HLOOKUP function examples ▸ lttr.ai/AgYwf


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

contextures's tweet image. Fictional insurance policy Excel data that you can download, to use for testing, training and demos.
Read more 👉 lttr.ai/AkryY

How to insert, hide, format Excel popup comments (old-style) Read more 👉 lttr.ai/Akrr9

contextures's tweet image. How to insert, hide, format Excel popup comments (old-style)
Read more 👉 lttr.ai/Akrr9

Contextures reposted

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. youtu.be/nWy5RMVoAwo?si…

borianapetrova's tweet card. Interview with Mike Koss - one of the Original Minds behind Microsoft...

youtube.com

YouTube

Interview with Mike Koss - one of the Original Minds behind Microsoft...


Contextures reposted

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/vancouver-powe…


Quickly hide specific items in a pivot table, or select a few items to keep visible pivot-table.com/2025/11/06/qui…

contextures's tweet image. Quickly hide specific items in a pivot table, or select a few items to keep visible
pivot-table.com/2025/11/06/qui…

See how to change an Excel formula result by clicking a worksheet check box. No macros required! Read more 👉 lttr.ai/AkpBz

contextures's tweet image. See how to change an Excel formula result by clicking a worksheet check box. No macros required!

Read more 👉 lttr.ai/AkpBz

Contextures reposted

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.

kpuls's tweet image. 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.

Show Excel data validation drop down items in a combo box, where you can change font size, and number of items ▸ lttr.ai/AgYvo


See how to set up advanced dependent drop-down lists in Excel. For example, show a short list or full list Read more 👉 lttr.ai/Akmnz


Instead of inserting comments in the pivot table, you could add a column to the source data, and enter brief comments there. Read more 👉 lttr.ai/Akmdr

contextures's tweet image. Instead of inserting comments in the pivot table, you could add a              column to the source data, and enter brief comments there.

Read more 👉 lttr.ai/Akmdr

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

contextures's tweet image. Create Excel custom icon sets in conditional formatting - choose icons, change number settings
Read more 👉 lttr.ai/Akjw3

Create multiple dependent drop down lists in Excel, based on named tables Read more 👉 lttr.ai/AkjnB

contextures's tweet image. Create multiple dependent drop down lists in Excel, based on named tables

Read more 👉 lttr.ai/AkjnB

In this free Excel calorie burn calculator workbook, select a weight range, food item and activity, and see approx how long it takes to burn those calories Excel Calorie Burn Calculator: lttr.ai/AkhOv

contextures's tweet image. In this free Excel calorie burn calculator workbook, select a weight range, food item and activity, and see approx how long it takes to burn those calories
Excel Calorie Burn Calculator: lttr.ai/AkhOv

How to copy and paste a pivot table, to keep its values and formatting, without the source data Read more 👉 lttr.ai/AkhHj

contextures's tweet image. How to copy and paste a pivot table, to keep its values and formatting, without the source data
Read more 👉 lttr.ai/AkhHj

Update Excel Slicers with Macro: lttr.ai/AkfXH

contextures's tweet image. Update Excel Slicers with Macro: lttr.ai/AkfXH

How to collapse and expand specific items in an Excel pivot field, or the entire pivot field Read more 👉 lttr.ai/AkfQE

contextures's tweet image. How to collapse and expand specific items in an Excel pivot field, or the entire pivot field
Read more 👉 lttr.ai/AkfQE

Compare yearly weather data in a pivot table, with conditional formatting, so it's easy to spot the hot and cold days. Read more 👉 lttr.ai/AkdTX

contextures's tweet image. Compare yearly weather data in a pivot table, with conditional formatting, so it's easy to spot the hot and cold days.

Read more 👉 lttr.ai/AkdTX

How to set up an Excel pivot table - beginner steps Read more 👉 lttr.ai/AkdM7

contextures's tweet image. How to set up an Excel pivot table - beginner steps
Read more 👉 lttr.ai/AkdM7

Loading...

Something went wrong.


Something went wrong.