# Blog & Excel Tips

Blog entries covering the latest Excel tricks and tips based on queries from clients and practical knowledge from our consultants.

### Weighted average versus average in ExcelMar 25, 2022

A common requirement with Excel users is to calculate the average of a set of numbers. But it is important understand weighted average versus average in Excel. Which one are you being asked for?

### Finding protected sheets in ExcelMar 23, 2022

When working with Excel and using some of the tools or an add in, you may come across situations where your tool won't run because of protected sheets. If you have lots of sheets it can be quiet tedious to try and find the protected sheets manually. If sheets are hidden you may not even know that there is a protected sheet.

### Add tick/ cross into your Data Validation and use it in IFs and Conditional FormattingMar 21, 2022

To make your drop down lists more visually appealing you may want to use a tick or a cross to indicate acceptance (or not) or an item.

### Comparing 3 cells in ExcelMar 17, 2022

There will be times when you need to compare 3 or more cells in MS Excel to generate a desired outcome. So if I am comparing 3 cells in Excel in order to see whether we should immediately hire a candidate or interview them first we could make use of the AND and OR formula.

### Conditional formatting based on another sheetMar 16, 2022

Conditional formatting is a great tool for dashboards and data visualisation. A common query is whether you can have conditional formatting based on another sheet e.g. in Sheet 1 you want cells to black out based on what has been input on Sheet 2.

### Remove extra scroll bars in ExcelMar 15, 2022

How to remove extra scroll bars in Excel? If you find 2 scrollbars either vertically or horizontally (or both) you can easily switch them off.

### Green triangle in MS Excel cell- understand, control, removeMar 10, 2022

If you work with Excel regularly, you may notice a green triangle in excel cells and wonder what it does, if you can control it and how to remove it.

### Excel double click copy down not workingMar 10, 2022

Understand how double click copy down works and why the double click does not work sometimes.

## Consulting

We aim to provide the ultimate, one stop shop for all Excel users requirements, within South Africa and worldwide.

Find Out More

## Live Training

"Recently we had a most successful in-house training session at our company. I would like to extend my thanks and gratitude."

Find Out More