Global Excel Summit Portfolio

ByAndrew Moss Hours
Comments 0 Comments

This page contains a collection of work I’ve created for the Global Excel Summit.

To jump to an item from the Table of Contents, expand its drop-downs first.

26/02/2026 — Delete blank rows

19/02/2026 — Generate a Python heatmap

22/01/2026 — COPILOT function

20/03/2026 — Do you like gridlines?

06/03/2026 — Saving as a CSV file

26/06/2025 — Convert units

01/04/2025 — Remove worksheet and workbook protection

25/03/2025 — Calendar template

21/03/2025 — Task scheduler template

11/03/2025 — Highlight current week

04/03/2025 — 4 ways to calculate percentages in Excel

24/02/2025 — Generate random numbers

18/02/2025 — Analyse text using Copilot in Excel

11/02/2025 — Create a word cloud in Excel

28/01/2025 — Excel gets Dark Mode

14/01/2025 — Split text with line breaks

06/01/2025 — Generate text staircase

28/03/2025 — Underpowered office laptops

21/03/2025 — Font evolution

07/03/2025 — Formula construction is easier now

21/02/2025 — Cringing at old Excel workbooks

31/01/2025 — Blame the user

17/01/2025 — Why your laptop gets loud

10/01/2025 — Keep formulas short and simple

31/12/2024 — Fill blanks with value from above

17/12/2024 — Delete blank rows

03/12/2024 — New decimal buttons

25/11/2024 — Convert itemised list to simple list

18/11/2024 — Open new Excel instance

12/11/2024 — New Python templates

05/11/2024 — Insert current date & time

29/10/2024 — Be careful summing!

22/10/2024 — Create a word cloud

03/10/2024 — Focus Cell

24/09/2024 — Generate text staircase

17/09/2024 — Generate random numbers

10/09/2024 — Trim ranges and references

04/09/2024 — In-cell bar charts

29/08/2024 — Hide worksheet tabs

20/08/2024 — How to play sounds

13/08/2024 — Time in real time

09/08/2024 — Send emails from Excel

06/08/2024 — CONCAT vs CONCATENATE

29/07/2024 — How to freeze panes

25/07/2024 — Intro to REGEX

23/07/2024 — How to translate text

05/07/2024 — Intro to REGEX

02/07/2024 — Identical values that aren’t

28/06/2024 — Fix incorrect percentages

25/06/2024 — XLOOKUP or FILTER?

20/06/2024 — Build a star rating system

14/06/2024 — Highlight active row and column

11/06/2024 — Wildcards in XLOOKUP

07/06/2024 — Running counts

04/06/2024 — Intro to cell modes

31/05/2024 — Count characters and words

29/05/2024 — Exceleration eBook

24/05/2024 — Combine multiple files

21/05/2024 — How to extract substrings

17/05/2024 — Keep leading zeros

14/05/2024 — Combinations and permutations

09/05/2024 — A guide to calculating percentages in Excel

03/05/2024 — Sync worksheet title with tab name

30/04/2024 — Intro to Sparklines

26/04/2024 — Emojis in Excel

19/04/2024 — Excel’s new checkboxes are set to enjoy a popularity surge

16/04/2024 — Send emails from Excel

08/04/2024 — Shortcuts for Excel tables

25/03/2024 — Create folders in File Explorer

18/03/2024 — Numbered lists

12/03/2024 — Data entry made easy

06/03/2024 — Find and remove duplicates

04/03/2024 — Convert units

19/02/2024 — Highlight row blocks

29/01/2024 — Stop using SUMIF

22/01/2024 — Count characters and words

15/01/2024 — Exceleration eBook

08/01/2024 — In-cell bar charts

20/12/2024 — Can’t open identically-named workbooks

13/12/2024 — If only maths were taught in Excel

06/12/2024 — Formula bar indentation trick

22/11/2024 — Decimal buttons fixed in Excel web

08/11/2024 — The double clickability of Format Painter

25/10/2024 — Mastering nested IF functions

27/09/2024 — Time to move on from VLOOKUP

13/09/2024 — Excel as a database?

30/08/2024 — Most-used keyboard shortcut

16/08/2024 — Do you love or loathe Excel?

09/08/2024 — Comparing AutoSave to manual saving

02/08/2024 — Excel vs Google Sheets

12/07/2024 — Excel formula critique

05/07/2024 — Is AR the future of Excel?

28/06/2024 — Are absolute references dying?

21/06/2024 — Are you really advanced in Excel?

31/05/2024 — The easy way vs the hard way

24/05/2024 — Managing worksheet tabs

17/05/2024 — Decimal button order

10/05/2024 — Excel templates for everything

03/05/2024 — From VLOOKUP to XLOOKUP

19/04/2024 — Consistent spreadsheets

12/04/2024 — Workbook overload

22/03/2024 — Merge & Center: friend or foe?

23/02/2024 — Hard-coded values: help or hindrance?

27/01/2024 — Format Painter tips & tricks

12/01/2024 — Excel as a database?

19/12/2023 — Paste without formatting

12/12/2023 — Copy values from status bar

05/12/2023 — Excel gets date picker

28/11/2023 — Calculate percentage of total

21/11/2023 — GROUPBY & PIVOTBY

14/11/2023 — Optimise your workbook

07/11/2023 — Better web scraping

30/10/2023 — Create folders in File Explorer

24/10/2023 — Convert UTC to local time

17/10/2023 — Hide worksheet tabs

10/10/2023 — Excel gets new checkboxes

03/10/2023 — Open new Excel instance

26/09/2023 — Generate QR codes

19/09/2023 — In-cell bar charts

12/09/2023 — Waffle charts

08/09/2023 — Keep leading zeros

04/09/2023 — Custom formatting

31/08/2023 — Itemised list to simple list

24/08/2023 — FILTER with AND criteria

22/08/2023 — Comments in formulas

08/08/2023 — Scrape data from the web

01/08/2023 — Place picture in cell

25/07/2023 — New Office theme

17/07/2023 — New Microsoft 365 font

13/07/2023 — Convert units

11/07/2023 — Data entry made easy

07/07/2023 — 4 ways to calculate percentages

04/07/2023 — Find and remove duplicates

30/06/2023 — Convert text to date

27/06/2023 — Count characters and words

22/06/2023 — Insert data from picture

16/06/2023 — Activate dark mode

13/06/2023 — Highlight row blocks

08/06/2023 — Stop using SUMIF

06/06/2023 — Visualise data with sparklines

02/06/2023 — Backsolve with Goal Seek

29/05/2023 — Display function arguments as text

25/05/2023 — Create folders in File Explorer

23/05/2023 — 4 ways to combine text values

18/05/2023 — Insert a date picker

16/05/2023 — Spot the difference

12/05/2023 — Extracting text

05/05/2023 — Difference between two dates

01/05/2023 — Strikethrough text

28/04/2023 — Custom formatting

24/04/2023 — Extract sorted rows from table

17/04/2023 — 5 handy keyboard shortcuts

13/04/2023 — Sum multiple rows/columns individually

10/04/2023 — Hide cell values

07/04/2023 — Combine tables with VSTACK

04/04/2023 — Insert images into cells

31/03/2023 — Numbered lists

28/03/2023 — Build a star rating system

23/03/2023 — FILTER with AND criteria

21/03/2023 — Calculate running totals

17/03/2023 — Hidden rows v unfiltered rows

14/03/2023 — Generate formulas automatically

10/03/2023 — Highlight active row and column

07/03/2023 — Fix incorrect percentages

02/03/2023 — Why FILTER instead of XLOOKUP?

28/02/2023 — Generate random numbers

23/02/2023 — Row and column limits

16/02/2023 — Center text across cells

02/02/2023 — Evaluate formula parts

26/01/2023 — Analyze Data

19/01/2023 — 5 must-know finance functions

12/01/2023 — Excel names

05/01/2023 — Paste without formatting

08/12/2023 — Excel proficiency

01/12/2023 — VLOOKUP’s remarkable resistance

10/11/2023 — Gridlines: yay or nay?

03/11/2023 — The bane of being an Excel whizz

27/10/2023 — The Excel rabbit hole

20/10/2023 — The Dunning-Kruger effect

13/10/2023 — Excel habits that irk us

06/10/2023 — How would you cope without a mouse?

22/09/2023 — Why did Excel have three sheets by default?

08/09/2023 — A1 or B2?

25/08/2023 — Unvoidable vs unnecessary megaformulas

11/08/2023 — Is printing worksheets obsolete?

28/07/2023 — Spreadsheet design

14/07/2023 — Find and Replace window

30/06/2023 — Graphical glitches

16/06/2023 — Border styles

02/06/2023 — Collaboration chaos

19/05/2023 — Source formatting is annoying

28/04/2023 — 1M row limit myth

14/04/2023 — Furby was the 90s ChatGPT

31/03/2023 — Deal with errors the proper way

17/03/2023 — Excelifying movies

03/03/2023 — Best way to use Format Painter

17/02/2023 — What’s your monitor setup like?

20/01/2023 — Excel killers

04/08/2023 — Copilot in Excel

21/07/2023 — Writing poems in Excel

07/07/2023 — Excel in Education

23/06/2023 — Excel as graphic design software

09/06/2023 — How PerfectXL can improve workbooks

26/05/2023 — INDZARA Excel templates

12/05/2023 — Financial Modelling Podcast

05/05/2023 — AC/DC’s Excel music video

07/04/2023 — Excel’s Easter eggs

24/03/2023 — Largest spreadsheet software collection

10/03/2023 — Train timetables created in Excel

24/02/2023 — Functions beginning with ‘J’

22/12/2022 — Excel’s leap year bug

15/12/2022 — You think Excel is boring?

08/12/2022 — Excel vs Power BI

01/12/2022 — 3 ways to automate your workflow

24/11/2022 — Rethinking Excel skill levels

17/11/2022 — The Power Stack Track explained

10/11/2022 — High-profile Excel disasters

03/11/2022 — Flash Fill

04/11/2022 — Excel is overwhelming

09/12/2022 — Insane Excel challenge

Excel Aficionado

Andrew is a technical writer who specialises in Excel and data analysis. He has published hundreds of articles and social media posts aimed at helping people enhance their skills and spreading good practices.

Subscribe
Notify of
guest

0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments