• Facebook
  • Twitter
  • YouTube
  • LinkedIn

TECH TEACHERS

A Collaborative Site for CAT and IT Teachers

  • Home
  • About
    • About Tech Teachers
    • About Matthew Hains
    • Donate to Tech Teachers
  • Teacher Resources
  • Purchase CAT Resources
  • Contact
Homeexcel

excel

Matthew's Blog

My demo invigilation timetable

Nov 11, 2019 Matthew Hains

As requested, my invigilation timetable that I created in MS Excel. It is difficult to make one that would suit every school as every school is very different. This one works for my school. You […]

Matthew's Blog

Duplicate Excel worksheets from a list

Jun 1, 2019 Matthew Hains

I used to use a macro I found online to duplicate a worksheet based on a list of names. It is very easy to do, using a macro, but I found an even easier way! […]

Matthew's Blog

Create self-marking quiz with MS Forms

May 21, 2019 Matthew Hains

A great way to run a quick assessment or evaluation is to have your learners take a quiz that marks itself. You receive the marks immediately, can supply feedback and then release the marks for […]

Matthew's Blog

50 keyboard shortcuts for Excel

Mar 1, 2019 Matthew Hains

You can work even faster in Excel by making use of these keyboard shortcuts! There are some shortcuts here I didn’t even know about and I am going to be using them so much more […]

CAT

Password generator in Excel activity

Feb 23, 2019 Matthew Hains

Here is a great exercise to reinforce CONCATENATE, UPPER, RIGHT, LEFT, LOWER functions. Get your students to create their own password generator based on various factors. In the image below you can see how the […]

CAT

Macros in Excel – workshop

Feb 9, 2019 Matthew Hains

For those who could not attend the Macros in Excel workshop that I presented, you are in luck – I recorded the whole thing! The video and notes from the workshop are available to purchase […]

Excel

Secret Code messages in Excel

Feb 1, 2019 Matthew Hains

Here is an activity I made using a few of the skills our CAT learners need to know. It’s a secret message decoder! Basically, numbers correspond to letters based in two sets. The task is […]

Matthew's Blog

Awesome Excel tip #6

Jan 14, 2019 Matthew Hains

We often use absolute cell references or named ranges. I find it easier to teach my students to name their cells or use named ranges instead as it makes it much easier to understand and […]

Matthew's Blog

Awesome Excel tip #5

Dec 10, 2018 Matthew Hains

Moving data in Excel can happen in various ways. Sometimes we copy/cut and paste. Sometimes we move entire columns. Other times we just need to move a range of cells. The problem comes in when […]

Courses & Training

Macros in Excel Workshop

Nov 30, 2018 Matthew Hains

The workshop below has come and gone, but don’t despair! See this post—> A new addition to CAPS is the use of macros, specifically in Excel. I will be presenting a 1-hour workshop to familiarise […]

Posts navigation

1 2 … 8 »

Stay connected

  • Facebook
  • Twitter
  • YouTube
  • LinkedIn

Categories

  • Matthew's Blog
  • Claire's Blog
  • Microbit tutorials
  • Guest Blogs
  • Check this out
  • CAT
  • ICT
  • Information Technology
  • Word of the Week
  • Excel
  • Excel Functions
  • P.A.T.
  • PowerPoint
  • Courses & Training
  • OneNote
  • Little Bytes
  • Delphi
  • Posters
  • Videos
  • StudyOpps Module Tests
  • Tech-Time
  • Successful teacher
  • Microbit Coding (Series)
  • Blogging Course (series)
  • HTML
  • Resources
  • Programming
  • Delphi Training Videos
  • SQL
  • Python
  • Testimonials
  • Spotlight
My Tweets
My Tweets
My Tweets
  • T’s & C’s
  • Shop T’s & C’s

© Matthew Hains