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.

26/02/2026 — Delete blank rows

19/02/2026 — Generate a Python heatmap

22/01/2026 — COPILOT function

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

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

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

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