Microsoft Excel Formulas: LEN

2 April 2017 in Excel Basics, Formula
0 comments 2 minutes 1,064 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,233 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 Formulas: SUMIFS

6 March 2017 in Formula, Powerful Formula
0 comments 2 minutes 876 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 815 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,059 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: , , , ,

Microsoft Excel Absolute and Relative Cell References

6 February 2017 in Excel Basics, Formula, How To
0 comments 2 minutes 1,237 views

Cell references in Excel are a big deal, getting them correct can mean the difference between time saved and time lost scratching your head. More...

Tags: , , , , , ,

Microsoft Excel Formulas: CHOOSE

29 January 2017 in Excel Basics, Formula
0 comments 2 minutes 766 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: COUNTA

25 January 2017 in Excel Basics, Formula
0 comments 2 minutes 776 views

The COUNTA function counts the number of cells that are not empty in a range More...

Tags: , , ,

Basic Microsoft Excel Functions: COUNT

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

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

Tags: , , ,

Basic Microsoft Excel Functions: ROUNDDOWN

17 January 2017 in Excel Basics, Formula
0 comments 2 minutes 634 views

This article describes the =ROUNDDOWN formula and how to use it to round-down a set number of decimal places More...

Tags: , , ,

Basic Microsoft Excel Functions: ROUNDUP

15 January 2017 in Excel Basics, Formula
0 comments 2 minutes 653 views

This article describes the =ROUNDUP formula and how to use it to round-up a set number of decimal places. More...

Tags: , , ,

How To: Shade Alternate Rows in Excel

2 January 2017 in Formula, How To
0 comments 2 minutes 726 views

Help make your long data lists easier to read by shading alternate rows Below are two quick and easy methods to allow you to do just that which don’t involve manually shading the rows More...

Tags: , , , , ,

Top 3 Articles From the Last 30 Days

31 December 2016 in Excel Basics, Formula, How To, List, Top 3
0 comments 2 minutes 498 views

Below are links to the Top 3 most read articles on the website over the last 30 days If you would like an article writing, please get in contact More...

Tags: , , , , , ,

How To Use IFERROR

29 December 2016 in Formula, How To
0 comments 2 minutes 660 views

Do you get fed up when your formulas return #N/A when performing a VLOOKUP calculation? Learning to use =IFERROR can help solve that More...

Tags: , , ,