­
Review of ASAP Utilities for Excel — ICT & Computing in Education
  • Front Page
  • Search
    • Digital Education
    • Terry Freedman's Books Bulletin
  • RSS
    • Welcome
    • The "About" Page
    • Testimonials
    • CV/Resumé
    • My Writing
    • Published articles
  • Corrections Policy
Menu

ICT & Computing in Education

Articles on education technology and related topics
  • Front Page
  • Search
  • Newsletters
    • Digital Education
    • Terry Freedman's Books Bulletin
  • RSS
  • Info
    • Welcome
    • The "About" Page
    • Testimonials
    • CV/Resumé
    • My Writing
    • Published articles
  • Corrections Policy
asap1.jpg

Review of ASAP Utilities for Excel

November 16, 2017

Someone just had to go and do this, didn't they? One of my sole pleasures in life (cue violins) has been pitting my wits against the spreadsheet application Excel. Against the odds, I have devised formulae and functions, and code, to push Excel into doing things it was probably never designed to do.

Many of these were useful, like a staff rota and a technical support reporting system. Others were simply for the heck of it, like my (in)famous Homework Excuse Management System, which will tell you instantly if a pupil has used the same excuse before for not handing in their homework.

I even have a folder on my computer labelled 'Useless Utilities', which houses the results of my experiments. For example, there's the one that will create an index sheet from all the worksheets in a workbook. And there's one that does the opposite, that is creates separate worksheets from a list of titles in a single worksheet.

In other words, that folder, together with the other applications I've mentioned, and more, represent my lifelong quest to challenge myself to ever greater heights of spreadsheet brilliance.

But as far as formulae are concerned, none of that burning the midnight oil, searching forums for advice, poring over tomes with such enchanting titles as 'Advanced Functions and Formulae for Excel' is necessary. How come? Because ASAP Utilities has it nailed.

I haven't counted them all, but there must be scores, if not hundreds, of ready-made formulae that can be applied immediately. As if that wasn't bad enough, the program is free for non-commercial use, and it seems to work with any version of Excel.

The screenshot shows just a few of ASAP's utilities...

The screenshot shows just a few of ASAP's utilities...

... as does this one.

... as does this one.

So, my days of tweaking Excel are over, apart from fiddling with bits of code now and again. Still, I haven't done much with Microsoft Word for a long time....

To download the program, go here: ASAP Utilities

In Computing, Reviews Tags ASAP Utilities, Excel, spreadsheets
← Two cheers for the internet of things11 tips for organising an education conference →
Recent book reviews
Backlist: The Written World
Backlist: The Written World

Writing was invented ‘only’ a few thousand years ago. It’s a fascinating story.

Read More →
Backlist: What I'm reading: Bounce
Backlist: What I'm reading: Bounce

What does it take to become an expert? And what can the Computing teacher do about it?

Read More →
Backlist: The Fourth Education Revolution
Backlist: The Fourth Education Revolution

The title of this book invites curiosity: what were the other three ‘revolutions?

Read More →
A book review for your English department colleagues perhaps
A book review for your English department colleagues perhaps

Some of these stories are so richly told, it can almost seem as though you’re right there with him.

Read More →
Review: Pen Names
Review: Pen Names

OK, so this has nothing to do with education technology, but we all read (I hope!). A very interesting examination of the pen names some authors have adopted, and why.

Read More →
Review: The Library of Ancient Wisdom: Mesopotamia and the Making of History
Review: The Library of Ancient Wisdom: Mesopotamia and the Making of History

There's a really interesting section in this book about how ceramic storage of data and information is probably the most likely medium to stand the test of time.

Read More →
A book review for your biology colleagues perhaps
A book review for your biology colleagues perhaps

The subject under discussion here is how human physiology has developed in different ways, in response to different conditions around the world.

Read More →
Review: Social Media for Academics
Review: Social Media for Academics

This book is very readable, and if I sound surprised that is because it’s not always true of academics!

Read More →
Quick looks: VIBE Coding by Example
Quick looks: VIBE Coding by Example

For the time being, this book is free in Kindle format.

Read More →
Review: The Game Changers: How Playing Games Changed the World and Can Change You Too
Review: The Game Changers: How Playing Games Changed the World and Can Change You Too

Despite the relative paucity of immediately obvious National Curriculum links, teachers will find several of sections of this book to be highly engaging.

Read More →
Dig+Ed+Banner.jpg

Contact us

Privacy

Cookies

Terms and conditions

This website is powered by Squarespace

(c) Terry Freedman All Rights Reserved