The Simple Magic of Go To Special | ​​Alison Pollecutt

SESSION DETAILS

“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 does “Go To Special” even mean?
Alison is willing to bet that there are things you have already done manually that “Go To Special” could help you do a lot quicker.
Imagine this scenario. You’re checking a spreadsheet for errors and want to find all the cells with constants, in case someone has unhelpfully typed over a formula with a number.
Maybe you’re trying to spot any inconsistencies hidden in plain sight?
Or you’ve got to update all your formulas but they are in cells that are not next to each other so the “copy and paste” approach is one formula at a time.
“Go To Special” can help with all of these and more. It may not be the most flashy Excel tool but, when you know what’s possible, you’ll love its simple magic.

ABOUT THE SPEAKER

Alison has over 30 years of experience working with spreadsheets.
She is a big fan of showing people how spreadsheets can make mundane and repetitive tasks faster and less error prone. After all, less time wrangling data means more time being able to understand what it’s telling us.
What makes her happy? When someone who thought they hated Excel suddenly realises how much easier their life could be with the RIGHT spreadsheet.
And her best quick tip? Type today’s date into your spreadsheet using just Ctrl and semi colon.

Find more about Alison's work and connect with him:

Website: https://www.excelconfident.com/
LinkedIn: www.linkedin.com/in/alison-pollecutt/
Facebook: www.facebook.com/ExcelConfident
Instagram: www.instagram.com/excelconfident/

AGENDA (Eastern Time)
5:30 PM - 5:45 PM - Introduction by Celia Alves
5:45PM - 6:15 PM - "​The Simple Magic of Go To Special" by ​​Alison Pollecutt
6:15PM - 6:30 PM - Q&A + Closing by Celia Alves

REGISTRATION
This session will be hosted on Microsoft Teams and recorded to share with others who could not attend live. You must register for the event to access the Teams Meeting link, which will become visible after you RSVP Yes.

JOINING THE EVENT
The link will be visible only if you RSVP beforehand.
During the speaker's presentation, we ask that attendees ensure they are on MUTE to avoid background noise and distractions.
Attendees can type questions and comments into the chat, which will be monitored by the event hosts.
At the end, there will be time for Q&A, where attendees can unmute their mic and even share their video to ask questions.

**NOTE: As mentioned, this event will be recorded and shared on YouTube and other social media platforms; therefore, attendee information may be visible in the recording.

We are looking forward to meeting you there!

A SPECIAL THANK YOU note to our lead sponsor: Sheetcast