• Home
  • Hot Topics
    • AI
    • VR & AR
    • Cloud
    • IoT
  • Business
    • eLearning
    • Green Web Hosting Companies
    • Best Standing Desk Reviews
  • Software
    • HR Software Solutions
  • Data & Analytics
  • Tech Experts
  • About
    • Privacy & Cookies
    • Contact Us
Good Tech Guide
Good Tech Guide
  • Home
  • Hot Topics
    • AI
    • VR & AR
    • Cloud
    • IoT
  • Business
    • eLearning
    • Green Web Hosting Companies
    • Best Standing Desk Reviews
  • Software
    • HR Software Solutions
  • Data & Analytics
  • Tech Experts
  • About
    • Privacy & Cookies
    • Contact Us
Spreadsheet & Excel Expert Interview – Dr Chris Roast
Home
Spotlight

Spreadsheet & Excel Expert Interview – Dr Chris Roast

Business, Data & Analytics, Spotlight, Tech Experts

Here we talk to leading spreadsheet and Microsoft Excel expert – Dr Chris Roast, who is based at Sheffield Hallam University in the UK.

Given that there over 1.2 billion Microsoft Office users globally, and that 89% of companies use Excel, it’s clear that making good use of the world’s most popular spreadsheet software is important for business productivity.

Following his PHD in Computer Science, which had a focus on Human-Computer Interaction, Chris has gone on to hold several simultaneous senior lecturing, research and leadership roles, but his expertise and influence reach far beyond academia.

He has worked on a number of commercial projects to help take spreadsheets from being home to large data sets that can quickly become unmanageable to being powerful tools for commercial strategy, planning and operations. One of the more recent projects is EQUS – a useful Excel plugin that creates formula visualizations to help users identify and avoid potential errors.

We asked Chris a few questions about his approach to using spreadsheets and data visualization to help students, peers and businesses to find new ideas and efficiencies, and improve business performance.

 

How has your study of Human Factors in Computer Science influenced your understanding of how people use spreadsheets?

From a Human Factors perspective, spreadsheets are responsive and follow a simple logic which means they are easily adopted. However, as most people will know, they can quickly become unmanagable, and once you are faced with a complex spreadsheet there are few easy routes to understanding it or improving it. I’d describe this weakness as an information infrastructure that is intrinsically easy to mismanage.

In order to address this there is strong evidence of good spreadsheet quality being maintained by specific good practices. This can range from organisational ‘rules’ such as “never nest functions” or “never use conditionals”, through to demanding specific templates are used and never altered.

 

What do you do with spreadsheets on a day to day basis?

I’m often working on organising spreadsheets more effectively. Creating templates and usage patterns to speed workflow.

A lot of organising action lists, as well as making project estimates and helping to ensure planning and decision making is as error-free as possible.

What also requires brain-work alongside making good use of Excel functions is stretching what seem like hopelessly unrealistic budgets to meet challenging project goals – ie fitting square pegs into round holes!

 

So which are your favourite Excel functions?

I’d say:
– VLOOKUP (allows you to look up and retrieve information from a table column, including approximate and exact matches)
– and HLOOKUP (similar to VLOOKUP but retrieves from a row).

 

It’s clear that certain roles, such as accounting, require high-quality human-computer interaction. Have you helped people in any more unusual areas to benefit from this kind of design?

My work has involved working with Fine Artists developing immersive interactive art installations, and English Literature Researchers bringing the details of early modern poetry to life and in doing so helping challenge traditional assumptions.

I’ve worked on the evaluation of robotic systems designed to support Firefighters. Such work always throws up interestingly different values and perspectives. While we often aim to make systems easy to use and operate, this can result in a loss of detailed control. We found that Firefighters prefer to have technical control and are not put off by difficult-to-learn technology – they actually want and relish the challenge. This in fact reflects part of their professional traditions – learning to master new technologies.

More traditional interdisciplinary work has involved working with Library Managers, Healthcare Professionals, Manufacturing Companies and Service Designers.

To learn more about Chris Roast’s work, including details of the EQUS project and advice and resources he shares on spreadsheets, data, analytics and visualization, visit the VeryViz website at www.veryvizsolutions.com

  • Tags
  • Excel
  • Spreadsheets
Facebook Twitter Google+ LinkedIn Pinterest
Next article Data Science Tools from IBM Watson Studio
Previous article RFID Tracking Systems - Real Time Location

Related Posts

AI in 2023 - Definition, Benefits & Top Companies AI
January 3rd, 2023

AI in 2023 - Definition, Benefits & Top Companies

Contractor Management Software Software
July 20th, 2022

Contractor Management Software

Green Web Hosting Companies - the Top, Genuinely Eco-Friendly Website Hosts Green
November 11th, 2021

Green Web Hosting Companies - the Top, Genuinely Eco-Friendly Website Hosts

Leave a Reply Cancel reply

Popular Posts
Dec 26th 7:21 PM
Green

What is Green Technology in 2023? The Greentech, Climate Tech & Cleantech Guide

Nov 11th 6:22 PM
Green

Green Web Hosting Companies – the Top, Genuinely Eco-Friendly Website Hosts

Jun 19th 9:48 AM
Data & Analytics

Data Science Tools from IBM Watson Studio

May 21st 10:14 AM
AI

AI in Business – Top Companies, Uses & Tech Trends

Jan 7th 3:28 PM
Software

HR Software Solutions

Jun 20th 7:45 PM
AI

Autonomous Vehicles – Drive.ai Software for Self-Driving Cars

Jan 7th 3:12 PM
Finance

Top UK Fintech Companies

  • Home
  • Hot Topics
  • Business
  • Software
  • Data & Analytics
  • Tech Experts
  • About
  • Back to top
© Good Tech Guide 2022. All rights reserved.