The Satchel Blog - Home to everything edtech
satchel: blog
The home of everything EdTech. Brought to you by the team behind Show My Homework.
< Back to all posts

Show & Tell Week 7: Simple Excel Hacks

For this week’s Show & Tell we heard from Danielle and Kieron in Account Management who talked us through some basic Excel formulas. As an Account Manager spreadsheets and numbers are a more than common occurrence in their work and as a result of this, they’ve become quite the Excel wizards. Although for some of the other teams, we handle Excel a lot less in comparison, it is never always avoided and we expect much the same can be said for most people. So we thought we’d share some of the more basic formulas we were taught:

IMG_0732.jpg

Addition formula: =SUM(number1,number2…)

This formula is to be used when adding multiple figures in cells together to find out of overall total.

Average formula: =AVERAGE(number1,number2…)

To be used when trying to formulate the average for a number of sums.

Duplicates: Highlight > Custom Sort > Sort by (DS) > Ok

This comes in useful when you have multiple cells and you want to eliminate any duplicate pieces of data. Before you start the process, be sure to copy and paste the cells you want to search through into a new sheet.

Concatenate: =CONCATENATE(A14:C14)

This formula combines a number of cells into a single cell.

These are some of the more basic Excel formulas you can use if you aren’t well versed and Danielle and Kieron will be coming back to teach us some more complex formulas.

 

Next: Show & Tell Week 6: Continuous Improvements


Merry Christmas from Show My Homework

SHARE THIS STORY | |

Search

Posts by Topic

see all

Subscribe to Blog