• 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
  • Buy stuff!
    • Digital Classroom Resource
    • View the Store
    • Account
    • My orders
    • Checkout
  • Contact
  • 0 items
Homeexcel functions

excel functions

CAT

Password generator in Excel activity

Feb 23, 2019Matthew 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

Excel Function of the Month – LEN

Dec 6, 2017Matthew Hains

The Excel Function of the month is LEN

CAT

Excel Function of the Month – TIME

Nov 6, 2017Matthew Hains

The Excel Function of the month is TIME

CAT

Excel Function of the Month – AND

Oct 6, 2017Matthew Hains

The Excel Function of the month is AND

CAT

Excel checklist for your students

Sep 13, 2017Matthew Hains

Well, it’s that time of year…EXAMS! I’m sure your students want to know what they need to know for the various applications. In addition to the CAPS skillset layout I created earlier this year, I […]

CAT

Create a password generator in Excel

Sep 12, 2017Matthew 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

Excel Function of the Month – SUMIF

Sep 6, 2017Matthew Hains

The Excel Function of the month is SUMIF

CAT

Excel Function of the Month – ROUND

Aug 6, 2017Matthew Hains

The Excel Function of the month is ROUND

CAT

Using the Excel RANK function

Jul 17, 2017Matthew Hains

I devised a worksheet to automatically calculate the points of our school ‘houses’ as part of a quiz competition we were having. Getting the results to tally was easy. Figuring out 1st, 2nd and 3rd […]

CAT

Excel Function of the Month – RANDBETWEEN

Jul 6, 2017Matthew Hains

The Excel Function of the month is RANDBETWEEN

Posts navigation

123»

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
  • T’s & C’s
  • Shop T’s & C’s

© Matthew Hains