Microsoft Excel Formulas: LEN

2 April 2017 in Excel Basics, Formula
0 comments 2 minutes 1,097 views

LEN is a simple formula that is not often used, however, used correctly it can be used to simplify your workbooks More...

Tags: , , , ,

Microsoft Excel Functions: SUBTOTAL

14 March 2017 in Analysis, Formula
0 comments 2 minutes 1,263 views

The SUBTOTAL function returns the subtotal from a list or database in Excel. SUBTOTAL will give you instant answers for your filtered data More...

Tags: , , , , ,

Microsoft Excel Tip: Watch Window

8 March 2017 in Excel Basics, How To
0 comments 2 minutes 1,321 views

A watch window will allow you to view the value within defined cells within your workbooks More...

Tags: , , , ,

Microsoft Excel Formulas: SUMIFS

6 March 2017 in Formula, Powerful Formula
0 comments 2 minutes 893 views

The SUMIFS function adds all the arguments that meet certain criteria More...

Tags: , , , ,

Microsoft Excel Functions: SUMPRODUCT

19 February 2017 in Formula, Powerful Formula
0 comments 2 minutes 833 views

SUMPRODUCT is a function which multiplies the corresponding components in selected arrays, and returns the sum of those calculations More...

Tags: , , ,

Microsoft Excel Functions: HLOOKUP

13 February 2017 in Formula, Powerful Formula
0 comments 2 minutes 1,080 views

HLOOKUP is the lesser used cousin of VLOOKUP, but can be just as useful. Learning how to use HLOOKUP can help in situations where VLOOKUP will not work More...

Tags: , , , ,

Never Suffer from Print Area Error Again

8 February 2017 in Excel Basics, How To
0 comments 2 minutes 867 views

It is insanely annoying when printing someone else’s Excel file only to find that it isn’t formatted correctly and prints across multiple pages More...

Tags: , , , ,

Microsoft Excel Formulas: CHOOSE

29 January 2017 in Excel Basics, Formula
0 comments 2 minutes 787 views

The CHOOSE function can return a value from a list of up to 254 arguments. It can also be a good alternative to a nested IF statement More...

Tags: , , ,

Basic Microsoft Excel Functions: COUNT

19 January 2017 in Excel Basics, Formula
0 comments 2 minutes 858 views

The COUNT function counts the number of cells in a range that contain a number More...

Tags: , , ,