- December 2024
- November 2024
- October 2024
- September 2024
- August 2024
- July 2024
- June 2024
- May 2024
- April 2024
- March 2024
- February 2024
- January 2024
- December 2023
- November 2023
- October 2023
- September 2023
- August 2023
- July 2023
- June 2023
- May 2023
- April 2023
- March 2023
- February 2023
- December 2022
- November 2022
- October 2022
- September 2022
- August 2022
- July 2022
- June 2022
- May 2022
- April 2022
- March 2022
- February 2022
- January 2022
- December 2021
- November 2021
- October 2021
- September 2021
- August 2021
- July 2021
- June 2021
- April 2021
- March 2021
- February 2021
- January 2021
- December 2020
- November 2020
- October 2020
- September 2020
- July 2020
| ID | Title 1 | Title 2 |
|---|---|---|
| Sample #1 | Row 1, Content 1 | Row 1, Content 2 |
| Sample #2 | Row 2, Content 1 | Row 2, Content 2 |
| Sample #3 | Row 3, Content 1 | Row 3, Content 2 |
I didn’t just go to Global Excel Summit 2024 as a mere employee
I’ve been to all four Global Excel Summits now, stretching back to the inaugural edition in 2021. I wasn’t an employee for the first two. However, I was delighted to become part of the setup in 2022, in prep for the…
Why is it still a pain to make table column references absolute?
Switching a cell reference from relative to absolute is ideal when you don’t want it shifting in a formula after you copy and paste elsewhere or use the fill handle to populate adjacent cells. Using A2 as an example, you…
Global Excel Summit 2024 starts in a couple of hours — and I’m sleep-deprived
Quick gripe to start the morning with: pillows. It doesn’t seem to matter whether I’m in a budget Travelodge or an expensive hotel in West London — the pillows are never up to standard. At home, I have a memory…
When will Excel get Sheets-esque drop-downs?
Excel has options allowing you to restrict cell entry so data is kept accurate and consistent. The Data Validation button is found on the Data tab. Selecting it brings up a window letting you limit the active cell or range…
What’s the maximum number of rows the SEQUENCE function allows?
In a new Excel worksheet, I enter this formula in A1: After waiting 12 seconds, a spilled sequence is generated from 1 in A1 to 53673984 in XFD3276. XFD is indeed the 16384th column of a worksheet — the very…
Great words that aren’t (Excel edition)
English is an ever-evolving language, with most dictionaries welcoming 500–1,500 new words every year. The job of a lexicographer is to compile dictionaries, adding and editing entries as they monitor what and how words are used in everyday life. Lexicographers…
I’ve been to all four Global Excel Summits now, stretching back to the inaugural edition in 2021. I wasn’t an employee for the first two. However, I was delighted to become part of the setup in 2022, in prep for the…
Switching a cell reference from relative to absolute is ideal when you don’t want it shifting in a formula after you copy and paste elsewhere or use the fill handle to populate adjacent cells. Using A2 as an example, you…
Quick gripe to start the morning with: pillows. It doesn’t seem to matter whether I’m in a budget Travelodge or an expensive hotel in West London — the pillows are never up to standard. At home, I have a memory…
Excel has options allowing you to restrict cell entry so data is kept accurate and consistent. The Data Validation button is found on the Data tab. Selecting it brings up a window letting you limit the active cell or range…
In a new Excel worksheet, I enter this formula in A1: After waiting 12 seconds, a spilled sequence is generated from 1 in A1 to 53673984 in XFD3276. XFD is indeed the 16384th column of a worksheet — the very…
English is an ever-evolving language, with most dictionaries welcoming 500–1,500 new words every year. The job of a lexicographer is to compile dictionaries, adding and editing entries as they monitor what and how words are used in everyday life. Lexicographers…