14 Excel Shortcuts

In today’s email:

1. My favorite Excel keyboard shortcuts, from pivot tables to slicers.

AROUND THE WEB

• My newsletter in the mental health space is planning a book launch soon. If you or someone you know has been affected by addiction, it might be interesting to you.

• My product and software review channel just launched. If you, like me, enjoy tinkering with gadgets and software, this might be interesting to you.

Got Sheet is brought to you by beehiiv. Newsletters made simple.
Check them out for 20% off your first three months…try beehiiv now.

MAIN ARTICLE

Video training:

(shortcuts to the specific chapters are listed below)

I Love Shortcuts

Whether it’s Excel, Google Sheets, Gmail or Word, I love using keyboard shortcuts.

They’re the perfect geeky vice. You maximize productivity and speed while maintaining that beautiful sense of mastering the software.

Excel is special because there really is a shortcut for practically everything.

When you press the alt key, (Windows only) the Ribbon at the top gets littered with yellow boxes highlighting letters and numbers you can press in sequence to navigate quickly to almost all the operations and actions in the program.

Once you start learning some of the sequences that you use the most in your own workflow, you will be hooked, I guarantee it.

I hope the video training above is useful for you. You can skip to any of the chapters by using the links below as well:

1. 00:00:00 - setup

2. 00:00:24 - alt key

3. 00:01:30 - insert table

4. 00:01:49 - pivot table

5. 00:02:16 - autofit columns

6. 00:03:00 - format cells

7. 00:03:14 - centering cell contents

8. 00:03:26 - highlight cell

9. 00:03:52 - copy down

10. 00:04:32 - gridlines

11. 00:04:50 - show all formulas

12. 00:05:13 - navigation

13. 00:06:17 - autofilter menu

14. 00:06:34 - slicers

15. 00:06:58 - checkboxes

16. 00:07:23 - charts

Got Sheet is brought to you by Coursera. If you learn well with structured courses, check them out for 30% off Coursera Plus…try them now.

NEXT STEPS

Whenever you’re ready, here’s how I can help:

1. Business tech stack (FREE)
   My recommendations for software and tools I use to create content and run my online business.

2. Sponsor Got Sheet
   Got Sheet teaches business operators, teachers and entrepreneurs how to get good at spreadsheets. Interested in sponsoring an issue or a series of Got Sheet newsletters? Reach out to get more information.

3. Personal budget tool
   As a Got Sheet subscriber, I want you to have a 75% discount on the personal budget I built 10+ years ago and am still using to this day.

HAPPY SPREADSHEETING!

Enjoyed this issue?
Subscribe below or Leave a testimonial

Cheers, Eamonn
Connect on LinkedIn, YouTube & Twitter.