#column

Note: screenshots and examples were taken using Microsoft Excel 2013, however older versions can be used.

Tags

No tags yet.

Adding 2 or more COUNTIF formulas

Did you know that you can add the result of multiple COUNTIF formulas? COUNTIF is normally used on it’s own as several entries and then adde

Stop Moving! - Absolute Cell Reference

Copied a formula to another cell and noticed the result is not the same as the cell that you just copied? Read on to see how $ signs can pre

Mastering VLOOKUP

VLOOKUP is probably one of the most commonly used but hated formulas. Having broken down the formula for you, let's learn it right for o

Freeze right there! - Freeze Panes

Freeze panes enables you to “freeze a portion of the sheet to keep it visible while you scroll through the rest of the sheet."

Combining & Splitting Text

Knowing how to combine two columns into one and vice versa quickly is so helpful. Read on and learn how to do it quickly!