#number

top of page

This site was designed with the

website builder. Create your website today.Start Now

Untitled

Excel in Excel

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

Recent Posts

Rows to Columns, Columns to Rows

Rows to Columns, Columns to Rows

2 Ways to Reverse Number Signs

2 Ways to Reverse Number Signs

AVERAGEIFS

Archive

Tags

No tags yet.

COUNTIFS

COUNTIFS

Learn how to COUNT the number of cells that meet multiple criteria using the COUNTIFS formula.

EDATE & EOMONTH

EDATE & EOMONTH

Learn how to use EDATE and EOMONTH functions to add & subtract months from a starting date.

Adding 2 or more COUNTIF formulas

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

SUM VS COUNT

SUM VS COUNT

What's the difference between the two? Read on to learn when to use SUM and COUNT.

Mastering VLOOKUP

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

Did you know Excel can generate random numbers?

Did you know Excel can generate random numbers?

Let Excel do the work for you - generate random numbers!

bottom of page