xlconsulting Cambodia - Simple IT solutions for SMEs
  • Socials
  • Blog
  • Solutions
    • NGO and Not for Profits
    • Data Analysis
    • Training for Your Staff
    • App Development
    • Accounting Software
  • About Us
    • The Team
    • Client List
  • Contact Us
  • Play with data
    • COVID 19 data
    • Xlconsulting clients
    • Wildlife populations
    • Impact Hub Survey
    • Nerd night data
    • Environment
    • Tech stocks
    • Casualties by selfie
  • Test Drive
    • Microsoft Teams
    • QuickBooks Online
    • Microsoft 365 Business
    • Agile CRM
    • Microsoft 365 Education
    • Excel learning docs
  • Free Stuff !
  • Learnshortcuts

The Spreadsheet Shortcut Scavenger Search

​You have scanned the bonus poster number 8 of 7 (there is no letter on this poster, but the shortcut F12 is useful), your challenge here is to take a video of you singing the following song with an Air Guitar to the tune of Justin Beiber's "love yourself". Take a video of it with the poster in the background.
If your numbers don't add up
Just try using SUM
And I really like to teach Excel through a song
You've been so caught up in your job
That the data is all wrong
But did you know
It's safer with validation
Cos if we like spreadsheet scavenger hunts
Then really we should say we love Excel

Shortcuts in action
F12 is the shortcut for Save as on Excel, Word and PowerPoint. I assume you get annoyed that to Save As via clicking you must click 5 or so times to get to the folder picker. This shortcut has a single step to bypass all those clicks. Note that on certain laptops you will have to click Fn and F12 together.
Picture

Find more posters on the Spreadsheet Shortcuts Scavenger Search around Edinburgh.

Picture
Picture
Picture